OraFAQ Forum: Data Guard » parameter not modifiable

Home » Server Options » Data Guard » parameter not modifiable (10gR1,Windows)

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

parameter not modifiable [message #362775]

Thu, 04 December 2008 02:08

Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt

Member

while I was configuring the primary database
I failed to change the parameter db_file_name_convert for the primary DB with the value of path of datafiles of both primary and standby and got the error
--------------------------
ORA-02096: specified initialization parameter is not modifiable with this option
-----------------------

and when I opened TOAD I found that parameter is not system modifiable

can any one help me.
thank u in advance

Report message to a moderator

Re: parameter not modifiable [message #363027 is a reply to message #362775]

Thu, 04 December 2008 16:40

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Code: [Select all] [Show/ hide]

SQL>
SQL> ! oerr ora 02096
02096, 00000, "specified initialization parameter is not modifiable with this option"
// *Cause: Though the initialization parameter is modifiable, it cannot be
//         modified using the specified command.
// *Action: Check the DBA guide for information about under what scope
//          the parameter may be modified

Report message to a moderator

Re: parameter not modifiable [message #365064 is a reply to message #362775]

Wed, 10 December 2008 16:27

sonumalhi
Messages: 62
Registered: April 2008

Member

You need to scope=spfile and bounce the database to change ths parameter

Report message to a moderator

Previous Topic:	STANDBY ERR - ORA-16032
Next Topic:	Should I recreate this standby database?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 03:01:37 CDT 2025