Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » RDBMS Server » Server Administration » Remove spfile and create pfile
Remove spfile and create pfile [message #379509] Tue, 06 January 2009 20:12 Go to next message
caprikar
Messages: 123
Registered: March 2007
Senior Member
Hi,
I have a 2 node RAC database (10g) on ASM. Whoever created the database, created it with spfile and I want to use pfile. Can someone tell me the steps involved?
Thanks
Report message to a moderator
Re: Remove spfile and create pfile [message #379512 is a reply to message #379509 ] Tue, 06 January 2009 20:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 9610
Registered: March 2002
Location: oracleDocoVille
Senior Member
>>I want to use pfile
Why?
it is just more pain to maintain two different pfiles.
SPFILE is recommended with RAC.
On every node, create a pfile that will point to spfile inside ASM.
If you still want individual pfile, create pfile from spfile.
sql> create pfile='mypfile' from spfile;
Report message to a moderator
Re: Remove spfile and create pfile [message #379514 is a reply to message #379509 ] Tue, 06 January 2009 20:25 Go to previous messageGo to next message
caprikar
Messages: 123
Registered: March 2007
Senior Member
Hi,
We have a standard to have pfile.

Do I have to do,

1. startup nomount
2. create pfile='mypfile' from spfile;
3. go to asmcmd and rm the spfile
4. startup mount and alter database open?
Report message to a moderator
Re: Remove spfile and create pfile [message #379516 is a reply to message #379514 ] Tue, 06 January 2009 20:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 9610
Registered: March 2002
Location: oracleDocoVille
Senior Member
>>4. startup mount and alter database open?

I do not know about your "standards".
But I prefer to use srvctl to startup/shutdown Oracle RAC databases.
Create the pfile as init<sid>.ora in $ORACLE_HOME/dbs.
Report message to a moderator
Re: Remove spfile and create pfile [message #379518 is a reply to message #379516 ] Tue, 06 January 2009 20:36 Go to previous messageGo to next message
caprikar
Messages: 123
Registered: March 2007
Senior Member
what do you mean by

Create the pfile as init<sid>.ora in $ORACLE_HOME/dbs ?
Report message to a moderator
Re: Remove spfile and create pfile [message #379519 is a reply to message #379518 ] Tue, 06 January 2009 20:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 9610
Registered: March 2002
Location: oracleDocoVille
Senior Member
RAC database is same as regular database, except it as multiple instances.
If node1 (assuming your ORACLE_SID=PROD1), create pfile as $ORACLE_HOME/dbs/initPROD1.ora.
Similarly
in node2, $ORACLE_HOME/dbs/initPROD2.ora.

Or create it anywhere you like.
Atleast make some symlinks.

[Updated on: Tue, 06 January 2009 20:43]

Report message to a moderator
Re: Remove spfile and create pfile [message #379520 is a reply to message #379509 ] Tue, 06 January 2009 20:44 Go to previous messageGo to next message
caprikar
Messages: 123
Registered: March 2007
Senior Member
So it should be

create pfile as '$ORACLE_HOME/dbs/initPROD1.ora' from spfile;

and then physically remove the spfile?
Report message to a moderator
Re: Remove spfile and create pfile [message #379521 is a reply to message #379520 ] Tue, 06 January 2009 20:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 9610
Registered: March 2002
Location: oracleDocoVille
Senior Member
Yes. Just your syntax is wrong.
Use
sql> create pfile='mylocation/myfile' from spfile;

[Updated on: Tue, 06 January 2009 20:47]

Report message to a moderator
Re: Remove spfile and create pfile [message #379524 is a reply to message #379509 ] Tue, 06 January 2009 20:49 Go to previous messageGo to next message
BlackSwan
Messages: 2243
Registered: January 2009
Senior Member
>and then physically remove the spfile?
Rather than burning bridges by deleting file(s),
it can/should be renamed "out of the way" so it is no longer accessed by default.
Report message to a moderator
Re: Remove spfile and create pfile [message #379525 is a reply to message #379509 ] Tue, 06 January 2009 20:58 Go to previous message
caprikar
Messages: 123
Registered: March 2007
Senior Member
We use ASM. So I can't rename the file, i will have to remove it.
Thanks
Report message to a moderator
Previous Topic:ora 27300,ora 27301 ora 27302
Next Topic:database size
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 4 19:03:15 CDT 2009

Total time taken to generate the page: 0.01553 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.