Hi All,
With each newer version of Oracle from Oracle 8i to Oracle 11g rman features are enchanced making it more and more powerful and thereby simplifying backup and recovery process to large extent.
The new feature of Oracle 11g makes rman more powerful by automatically detecting the failure, advising how to recover from failure and then actually recovering […]
20) What is the location of init<SID>.ora file for windows system and for unix system?
The default location of init<SID>.ora file is %ORACLE_HOME%/database folder for Windows while it is $ORACLE_HOME/dbs for UNIX System.
21) What is the use of init<SID>.ora file in Oracle Database?
init<SID>.ora Files contains all the parameters which is used to configure the Oracle Instance.
For e.g
shared_pool_size parameter in init<SID>.ora decides the size of shared pool
large_pool parameter decides the size of large pool.
22) Can the parameter of init file be changed dynamically?
No, the parameters of the init<SID>.ora does not take effect on the fly when the database
is running. To change the parameter we need to modify the parameter in init<SID>.ora
and then stop the database and start the database with the modified pfile.
23) How can we start the database with pfile which is
located in the non default location?
To start the database with pfile located in the non default location
i.e (Not in %oracle_home%/database OR $ORACLE_HOME/ dbs) we can use the following command at SQL prompt
SQL> startup pfile=<location of pfile>
24) Which parameter determines the location control files in oracle database?
CONTROL_FILES parameter decides the location of control files in oracle database.
25) What are Instance specific parameters and how are they defined in init<SID>.ora?
In RAC (Real Application Cluster) which is a Oracle HA(High Availability) Feature we can have multiple oracle instance configured on different nodes which can access the same database […]