How do I know which one is used to startup database by DBA if many spfile and pfile coexist?

From: Woody Ling <woodyling_at_gmail.com>
Date: Sun, 13 Apr 2008 20:50:14 -0700 (PDT)
Message-ID: <7be351d6-6186-40af-bae7-d80b6e0a95cb@c19g2000prf.googlegroups.com>

I find that many spfile and pfile coexist in one system. How do I know which one is used by the DBA to startup the database?

If the database is started, I can type "show parameter spfile" to check the location of spfile. But it show nothing if pfile is used. Besides, any way or log files to check which one is used last time if database is down?

Thanks.
Woody Ling
Hong Kong Received on Sun Apr 13 2008 - 22:50:14 CDT

This message: [ Message body ]
Next message: rgvguplb: "Re: How do I know which one is used to startup database by DBA if many spfile and pfile coexist?"
Previous message: Woody Ling: "How many instances are created in the server?"
Next in thread: rgvguplb: "Re: How do I know which one is used to startup database by DBA if many spfile and pfile coexist?"
Reply: rgvguplb: "Re: How do I know which one is used to startup database by DBA if many spfile and pfile coexist?"
Reply: rgvguplb: "Re: How do I know which one is used to startup database by DBA if many spfile and pfile coexist?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message