Home » RDBMS Server » Server Administration » PFILE and SPFILE (SOLARIS 10)
PFILE and SPFILE [message #329626] Thu, 26 June 2008 01:21 Go to next message
savlon99
Messages: 22
Registered: June 2008
Location: Bangladesh
Junior Member

I am using solaris 10 .installed there oracle 10 .I want to knw where is the loction of the SPFIlE and PFILE...??
Re: PFILE and SPFILE [message #329627 is a reply to message #329626] Thu, 26 June 2008 01:28 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

The default location of the SPFILE is under $ORACLE_HOME/dbs on Unix

Read this

[Updated on: Thu, 26 June 2008 01:29]

Report message to a moderator

Re: PFILE and SPFILE [message #329635 is a reply to message #329627] Thu, 26 June 2008 02:15 Go to previous messageGo to next message
savlon99
Messages: 22
Registered: June 2008
Location: Bangladesh
Junior Member

it,z not working ...
Re: PFILE and SPFILE [message #329652 is a reply to message #329626] Thu, 26 June 2008 02:39 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
SQL>show parameter spfile
SQL>select name ,value from v$parameter 
where name='spfile';
Re: PFILE and SPFILE [message #329655 is a reply to message #329635] Thu, 26 June 2008 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
savlon99 wrote on Thu, 26 June 2008 09:15
it,z not working ...

What does this mean?

Regards
Michel
Re: PFILE and SPFILE [message #329680 is a reply to message #329626] Thu, 26 June 2008 03:59 Go to previous messageGo to next message
savlon99
Messages: 22
Registered: June 2008
Location: Bangladesh
Junior Member

thax .. i got the locathing ....can u help me ..how i use that spfile to startup database.
Re: PFILE and SPFILE [message #329713 is a reply to message #329680] Thu, 26 June 2008 05:30 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

You should find everything you need here
Re: PFILE and SPFILE [message #329715 is a reply to message #329680] Thu, 26 June 2008 05:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use IM speak

If spfile is in correct location and with correct name, just use "startup".

Regards
Michel
Re: PFILE and SPFILE [message #330299 is a reply to message #329715] Sun, 29 June 2008 01:52 Go to previous message
savlon99
Messages: 22
Registered: June 2008
Location: Bangladesh
Junior Member

thax everybody for kindly help.
Previous Topic: Data guard implementation on oracle 9i
Next Topic: ASSM with LMT
Goto Forum:
  


Current Time: Mon Dec 05 03:07:45 CST 2016

Total time taken to generate the page: 0.11135 seconds