Where is parameter file in oracle

If a special character must be treated literally in an initialization parameter file, then it must either be preceded by the backslash character, or the entire string containing the special character must be enclosed in quotation marks. If the backslash is followed by an alphanumeric character, then the backslash is treated as a normal character in the input. If it is not followed by an alphanumeric character, then the backslash is treated either as a backslash or as a continuation character.

Quotation marks can be nested in one of two ways. The first method is to double the quotation marks in the nested string. Parameter Files A parameter file is a file that contains a list of initialization parameters and a value for each parameter.

Oracle supports the following two types of parameter files: Server Parameter Files Initialization Parameter Files Server Parameter Files A server parameter file is a binary file that acts as a repository for initialization parameters. Initialization Parameter Files An initialization parameter file is a text file that contains a list of initialization parameters. Specifying Values in an Initialization Parameter File This section describes several aspects of setting parameter values in an initialization parameter file.

Rules Governing Initialization Parameter Files The following rules govern the specification of parameters in initialization parameter files: An initialization parameter file should contain only parameters and comments.

You can specify parameters in any order. Using Special Characters in Parameter Values If a parameter value contains a special character, then the special character must be preceded by a backslash or the entire parameter value must be enclosed in quotation marks. COM Table lists the special characters you can use in initialization parameter files.

Using Quotation Marks Quotation marks can be nested in one of two ways. Book List. Master Index. Note: Listing parameters in alphabetical order in the initialization parameter file can help you to find them and can help ensure that each parameter is specified only once.

Datacadamia - Data all the things Database Oracle Database. Table of Contents Oracle Database - initialization server parameter file init. You can use the Oracle Enterprise Manager Database Control to view the location of the server parameter file and list all of the initialization parameters, as follows: Log in to the Database Control.

The following command determine whether the system uses: an initialization parameter file initsid. Powered by ComboStrap. Unsupported Parameters. Additional Notes on Initialization Parameters. ORA parameter file is created during Oracle Database installation. You can copy and edit this as a text file. Specifying these parameters in the initialization file results in an Oracle Database error during startup.

The workaround is to remove such lines from the file.