Home » SQL & PL/SQL » SQL & PL/SQL » check current parameter file (oracle)
check current parameter file [message #303319] Thu, 28 February 2008 21:26 Go to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
Hi Experts,
how to check whick current parameter file my database is using??

Thanks,
Daniesh
Re: check current parameter file [message #303320 is a reply to message #303319] Thu, 28 February 2008 21:41 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
The default location of init.ora is $ORACLE_HOME/dbs> on unix and %ORACLE_HOME%\database on Windows. On Windows, the location can be changed by changing ORA_%ORACLE_SID%_PFILE. The default name for the file is init$ORACLE_SID.ora (unix) or init%ORACLE_SID%.ora (windows) However, it is possible to start the database with another init.ora file than the default one. In this case, there is no way to determine which init.ora was used when the database is running (at least up to Oracle 9i).

regards,
Re: check current parameter file [message #303321 is a reply to message #303319] Thu, 28 February 2008 21:48 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
the things is that i want to know which parameter file my database is using . i checked the default but i think its not using that file it may be using some other file. this is the problem.
Re: check current parameter file [message #303322 is a reply to message #303319] Thu, 28 February 2008 21:59 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
Quote:
i checked the default but i think its not using that file it may be using some other file.


what is the reason to think so?

regards,
Re: check current parameter file [message #303325 is a reply to message #303319] Thu, 28 February 2008 22:05 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
oracle is not writing the data archive log destination from prod db to standby db casue of this i think so
Re: check current parameter file [message #303326 is a reply to message #303319] Thu, 28 February 2008 22:07 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
To see if you are using an spfile use:

SQL> sho parameter spfile

If it was started with a pfile, there really isn't any way to determine what file was used if there are multiple ones and if you don't think the default file was used.
Re: check current parameter file [message #303330 is a reply to message #303319] Thu, 28 February 2008 22:34 Go to previous message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
there are multiple in my admin loc. the problem is that my standby db is name is Prod and Prod db name is also prod.
this is the confusion.

Thanks,
Daniesh
Previous Topic: Self join with inner join followed by a full outer join
Next Topic: Unable to Load the English months in Staging Table.
Goto Forum:
  


Current Time: Thu Dec 08 20:18:47 CST 2016

Total time taken to generate the page: 0.37681 seconds