What Are The Minimum Parameters Should Exist In The Parameter File (i

1.	What Are The Minimum Parameters Should Exist In The Parameter File (init.ora)?
Answer» DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles,REDO log files and control files and control file while database creation. DB_DOMAIN - It is string that specifies the network domain where the database is created. The global database name is identified by setting these PARAMETERS(DB_NAME & DB_DOMAIN) CONTORL FILES - List of control filenames of the database.If name is not mentioned then default name will be used. DB_BLOCK_BUFFERS - To DETERMINE the no of buffers in the buffer cache in SGA. PROCESSES - To determine number of operating system processes that can be connected to ORACLE concurrently. The value should be 5 (background process) and additional 1 for each USER. ROLLBACK_SEGMENTS - List of rollback segments an ORACLE instance acquires at database STARTUP. Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS. Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS.

What Are The Minimum Parameters Should Exist In The Parameter File (init.ora)?

Answer»

DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles,REDO log files and control files and control file while database creation.
DB_DOMAIN - It is string that specifies the network domain where the database is created. The global database name is identified by setting these PARAMETERS(DB_NAME & DB_DOMAIN)
CONTORL FILES - List of control filenames of the database.If name is not mentioned then default name will be used.
DB_BLOCK_BUFFERS - To DETERMINE the no of buffers in the buffer cache in SGA.
PROCESSES - To determine number of operating system processes that can be connected to ORACLE concurrently. The value should be 5 (background process) and additional 1 for each USER.
ROLLBACK_SEGMENTS - List of rollback segments an ORACLE instance acquires at database STARTUP.

Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS.