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

 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.

Showing Answers 1 - 1 of 1 Answers

Chiranjeevi Manne

  • Nov 9th, 2005
 

The Minimum that are required in an init.ora file are

db_name, db_block_size, udump, bdump, cdump, controfile

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions