init.ora file

[nunnasujatha]

Hi all,



can a database have two sets of init.ora file??


How can we make 2 instances refer to one database?

kindly reply me

Thank you

[pragatiswain]

Hi all,
can a database have two sets of init.ora file??
How can we make 2 instances refer to one database?
kindly reply me
Thank you

init.ora helps the oracle client to resolve the DB.
What do you mean by "database having two sets of init.ora file"? Please give example. Is the environment Windows or UNIX?

[nunnasujatha]

init.ora contains initialization parameters
but my doubt is can we have two init.ora files for single DB.
i.e
we all know that there may be multiple instances for single DB.
so can we initialize the parameters for two different instances using two different init.ora files for a particular DB.

[pragatiswain]

init.ora contains initialization parameters
but my doubt is can we have two init.ora files for single DB.
i.e
we all know that there may be multiple instances for single DB.
so can we initialize the parameters for two different instances using two different init.ora files for a particular DB.

yes, you can do that. But you will not know which init.ora is reffered at the startup. But after the DB starts up see v$parameter to understand which init.ora was reffered at startup. Goto http://www.adp-gmbh.ch/ora/admin/init_ora.html for better understanding.

[nunnasujatha]

Thank you pragathi
u have given me useful info