OraFAQ Forum: Server Administration » SPFILE OR PFILE RELATED QUERY

Home » RDBMS Server » Server Administration » SPFILE OR PFILE RELATED QUERY

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SPFILE OR PFILE RELATED QUERY [message #285235]

Tue, 04 December 2007 01:12

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"

Report message to a moderator

Re: SPFILE OR PFILE RELATED QUERY [message #285236 is a reply to message #285235]

Tue, 04 December 2007 01:15

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.

Report message to a moderator

Re: SPFILE OR PFILE RELATED QUERY [message #285238 is a reply to message #285235]

Tue, 04 December 2007 01:17

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.

Report message to a moderator

Re: SPFILE OR PFILE RELATED QUERY [message #285242 is a reply to message #285235]

Tue, 04 December 2007 01:24

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';

[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

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.

Report message to a moderator

Re: SPFILE OR PFILE RELATED QUERY [message #285248 is a reply to message #285235]

Tue, 04 December 2007 01:36

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.

Report message to a moderator

Re: SPFILE OR PFILE RELATED QUERY [message #285250 is a reply to message #285248]

Tue, 04 December 2007 01:38

idris_26
Messages: 5
Registered: November 2007
Location: Hyderabad

Junior Member

Ok thanks brother I will checkout.

Thanks for everything.

Report message to a moderator

Previous Topic:	Requirements in changing the sys password.
Next Topic:	Abnormal Shutdowns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:19:23 CST 2024