Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the minimum parameters should exist in the parameter file (init.ora) ?

April 26, 2017exist file init.ora minimum parameter parameters

0

Posted

What are the minimum parameters should exist in the parameter file (init.ora) ?

2 Answers

0

Posted

– 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.

0

Posted

DB_NAME – Must set to a text string of not more that 8 characters and it will be stored inside the datafiles, redo log 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) CONTROL_FILES – List of control filenames of the database. If name is not mentioned then default name will be used. DB_BLOCK_SIZE – The default data block size and is operating system dependent. It cannot be changed after database creation except by re-creating the database. DB_BLOCK_BUFFERS – The maximum 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.