OraFAQ Forum: Server Administration » Remove spfile and create pfile

Home » RDBMS Server » Server Administration » Remove spfile and create pfile

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

Remove spfile and create pfile [message #379509]

Tue, 06 January 2009 20:12

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

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

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;

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

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?

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

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.

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

caprikar
Messages: 226
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

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

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?

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

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

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.

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

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

Report message to a moderator

Previous Topic:	ora 27300,ora 27301 ora 27302
Next Topic:	database size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 18:26:59 CST 2024