Re: parameter file location

Run this query on to the instance you want to see the parameter file for: select instance_name from v$instance;

Then at the OS level, search for files that start with init and end with .ora. For example, if you're using some sort of Unix..this should work: find / -name init*.ora

Since you have multiple instances, search through those files with the instance name you found with the above query.

So if you're instance name is "BILLYBOB", there should be a file called "initBILLYBOB.ora". The only problem is that you can name your parameter file whatever you want..and also store it in whichever directory you want. But for the most part, they're named with the above scheme. Hope this helps.

""Anurag Minocha"" <aminocha_at_herold.com> wrote in message news:EBBA6D3A81229C42981E3AEA79BF5A4E111231_at_jshemail.herold.com...
> Hi All,
> Is there anyway i can find out the location of the parameter file which a
> database in an open state is poiting to.
>
> I have a lot of files with the same name on the database server and I dont
> know which one the database is using.
>
>
> Thanks
> Anurag
>
Received on Fri Mar 09 2001 - 20:54:44 CST