Answers

Question and Answer:

  Home  Oracle Security

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

 179 views

More Questions for you: