Home » RDBMS Server » Server Administration » SPFILE OR PFILE RELATED QUERY
SPFILE OR PFILE RELATED QUERY [message #285235] Tue, 04 December 2007 01:12 Go to next message
idris_26
Messages: 5
Registered: November 2007
Location: Hyderabad
Junior Member
Hi Everybody,

I have one question please tell me the solutions for this question. "HOw to find our database is running with parameter file or Server parameter file when the database is running"

Re: SPFILE OR PFILE RELATED QUERY [message #285236 is a reply to message #285235] Tue, 04 December 2007 01:15 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Did you search before posting ?

Default behaviour of parameter file

Instance startup with SPFILE (default) if spfile not found then
instance startup with pfile (init<sid>.ora) if pfile not found then
we can startup our instance through text pfile.

Re: SPFILE OR PFILE RELATED QUERY [message #285238 is a reply to message #285235] Tue, 04 December 2007 01:17 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

This question is asked more than 10 times.

just invoke ,

show parameter spfile
and see the value. If value appears then spfile otherwise your database is started with pfile.
Re: SPFILE OR PFILE RELATED QUERY [message #285242 is a reply to message #285235] Tue, 04 December 2007 01:24 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

select decode(value,null,'Your Database Started with pfile','Your Database Started with spfile') 
from v$parameter where name='spfile';


Cool

[Updated on: Tue, 04 December 2007 01:25]

Report message to a moderator

Re: SPFILE OR PFILE RELATED QUERY [message #285245 is a reply to message #285236] Tue, 04 December 2007 01:28 Go to previous messageGo to next message
idris_26
Messages: 5
Registered: November 2007
Location: Hyderabad
Junior Member
Yes already Searched.

I knw the behaviour of spfile n pfile but the thing is that i want knw which view is there to find that our database is running with pfile or spfile when the database is running.

Already somebody mention that show parameter spfile. I will findout whether its working or not.

Thanks a lot for ur replies.
Re: SPFILE OR PFILE RELATED QUERY [message #285248 is a reply to message #285235] Tue, 04 December 2007 01:36 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

I will findout whether its working or not.


Start your database by pfile and execute the above query. and note it down , again start your database by spfile and execute the query. If it is not work in your database then tell.
Re: SPFILE OR PFILE RELATED QUERY [message #285250 is a reply to message #285248] Tue, 04 December 2007 01:38 Go to previous message
idris_26
Messages: 5
Registered: November 2007
Location: Hyderabad
Junior Member
Ok thanks brother I will checkout.

Thanks for everything.
Previous Topic: Requirements in changing the sys password.
Next Topic: Abnormal Shutdowns
Goto Forum:
  


Current Time: Fri Dec 13 07:15:48 CST 2024