Re: parameter file location

> Anurag Minocha wrote:
>
> 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

Anurag,

If you're using a script to startup your database, check whether a parameter file is named as part of the STARTUP command, for example: STARTUP ... PFILE = '/some/directory/init.ora'

If no file is named in the STARTUP command, or you're starting your database as a service (eg: under NT) then you should check the default location where Oracle looks for a parameter file - This varies from one operating system to another. Some examples are...

On NT look in %ORACLE_BASE%\ADMIN\DB_NAME\PFILE - So if your Oracle software is installed under C:\ORACLE and your database is called test01, you would look for:
C:\ORACLE\ADMIN\TEST01\PFILE\INIT.ORA On Linux, you would look in $ORACLE_HOME/dbs for a symbolic link pointing to the actual parameter file, eg: $ORACLE_HOME/dbs/inittest01.ora
...or look for the file itself in...
$ORACLE_BASE/admin/test01/pfile/inittest01.ora

Once you think you've find the correct file, you can confirm it by changing a parameter value in the file (eg: add 1 block to the value of DB_BLOCK_BUFFERS) then bounce your database and check that the change has taken effect :

SQL> SELECT name, value FROM v$parameter

   > WHERE name = 'db_block_buffers' ;

If all else fails you can construct a new initialisation parameter file by editing the results of the following query (this lists all parameters on your database which have a non-default value):

SQL> SELECT name, value FROM v$parameter

   > WHERE isdefault = 'FALSE' ;

HTH
SB Received on Sat Mar 10 2001 - 05:56:16 CST