Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Oracle Security Interview Questions

What is snapshots ?

2 Answers  


what is meant by physical order and logical order in clustered index and non clustered index.

2 Answers  


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

1 Answers  


How can you Enforce Refrencial Integrity in snapshots ?

1 Answers  


What are the benefits of distributed options in databases ?

1 Answers  






What are the system resources that can be controlled through Profile ?

3 Answers  


What is Tablespace Quota ?

2 Answers  


What is the use of ANALYZE command ?

3 Answers  


What are the various type of snapshots ?

3 Answers  


What are Roles ?

2 Answers  


When will the data in the snapshot log be used ?

2 Answers  


What dynamic data replication ?

2 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)