init and password file

[salmanucit]

hi
i m creating a new database with the name "test"..when we issue the command of startup, by
default it checks the initifile with the name "inittest.ora" if "spfileinit.ora" at
$ORACLE_BAST/product/9.2.0.1.0/dbs....i want to ask that can we change this default
location??if yes then how will i tell oracle that check for inittest at that specific
location not on the default location...
same question is for the passowrd file....i mean how can we have a passowrd file with the
different then default name and how can we relocate it...
on windows its very simple...we just neet to edit registry variable but how on linux
Regards

[SANJAY_G]

On linux/unix it is even simpler. Just create a symbolic link in ORACLE_HOME/dbs to your init.ora file.

[Raminder]

startup pfile='full path of parameter file'

[patnams]

I am not sure about init* files. But you can place Tnsnames.ora and Listener.ora in /etc.

Can you try the same for init* files and post back?

[salmanucit]

well
we can place TNSNAMES.ORA etc to any location because e have TNS_ADMIN environment variable
but how init
???
Regards

[davey23uk]

as was previously said, put the init file anywhere you want and have a softlink to oracle_home/dbs

Or in all your startup scripts have startup pfile=...