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: 226
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
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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>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;
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: 226
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?
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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>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.
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: 226
Registered: March 2007
Senior Member
what do you mean by

Create the pfile as init<sid>.ora in $ORACLE_HOME/dbs ?
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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
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: 226
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?
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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
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: 26766
Registered: January 2009
Location: SoCal
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.
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: 226
Registered: March 2007
Senior Member
We use ASM. So I can't rename the file, i will have to remove it.
Thanks
Previous Topic: ora 27300,ora 27301 ora 27302
Next Topic: database size
Goto Forum:
  


Current Time: Wed Dec 04 18:05:52 CST 2024