-
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
Salman Ahmed Qureshi
Lahore, Pakistan
-
On linux/unix it is even simpler. Just create a symbolic link in ORACLE_HOME/dbs to your init.ora file.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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?
Sridhar R Patnam
-
well
we can place TNSNAMES.ORA etc to any location because e have TNS_ADMIN environment variable
but how init
???
Regards
Salman Ahmed Qureshi
Lahore, Pakistan
-
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=...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|