Sample Initialization Parameter File

Oracle Database provides generally appropriate values in a sample text initialization parameter file. You can edit these Oracle-supplied initialization parameters and add others, depending upon your configuration and options and how you plan to tune the database.

red hat Linux administration training courses malaysia

The sample text initialization parameter file is named init.ora and is found in the following location on most platforms: ORACLE_HOME/dbs

red hat enterprise Linux rhel training courses malaysia

Text Initialization Parameter File Format

The text initialization parameter file specifies the values of parameters in name/value pairs.

The text initialization parameter file (PFILE) must contain name/value pairs in one of the following forms:

• For parameters that accept only a single value: parameter_name=value
• For parameters that accept one or more values (such as the CONTROL_FILES parameter): parameter_name=(value[,value] …)

Parameter values of type string must be enclosed in single quotes (‘). Case (upper or lower) in file names is significant only if case is significant on the host operating system.

red hat certified specialist in server hardening malaysia

For parameters that accept multiple values, to enable you to easily copy and paste name/value pairs from the alert log, you can repeat a parameter on multiple lines, where each line contains a different value.

red hat certified specialist in Linux performance tuning malaysia