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...??

Report message to a moderator

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 ...

Report message to a moderator

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

Report message to a moderator

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: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
savlon99 wrote on Thu, 26 June 2008 09:15
it,z not working ...

What does this mean?

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Don't use IM speak

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

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Data guard implementation on oracle 9i
Next Topic: ASSM with LMT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 25 20:32:43 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.