-
init and password file
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
-
On linux/unix it is even simpler. Just create a symbolic link in ORACLE_HOME/dbs to your init.ora file.
-
startup pfile='full path of parameter file'
-
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?
-
well
we can place TNSNAMES.ORA etc to any location because e have TNS_ADMIN environment variable
but how init
???
Regards
-
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=...