471,083 Members | 1,130 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,083 software developers and data experts.

Pfile Question

How do I find out which pfile the instance was started with?

Larry
Jul 19 '05 #1
1 4181

Originally posted by Larry Lowe
How do I find out which pfile the instance was started with? Larry


If you did not use option startup pfile=..... to start your database,
then Oracle looks for the pfile in the default location i.e.

Win*: ORACLE_HOME\database\init<SID>.ora

nix*: ORACLE_HOME/dbs/init<SID>.ora

For 9i, if you have created an spfile "spfile<SID>.ora", then it would
look for spfile first in the same locations according to OS.

Regards

/Rauf
--
Posted via http://dbforums.com
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Stevey | last post: by
10 posts views Thread by glenn | last post: by
53 posts views Thread by Jeff | last post: by
56 posts views Thread by spibou | last post: by
2 posts views Thread by Allan Ebdrup | last post: by
1 post views Thread by Larry Lowe | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.