Home » Server Options » Data Guard » parameter not modifiable (10gR1,Windows)
parameter not modifiable [message #362775] Thu, 04 December 2008 02:08 Go to next message
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
Re: parameter not modifiable [message #363027 is a reply to message #362775] Thu, 04 December 2008 16:40 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

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
Re: parameter not modifiable [message #365064 is a reply to message #362775] Wed, 10 December 2008 16:27 Go to previous message
sonumalhi
Messages: 62
Registered: April 2008
Member
You need to scope=spfile and bounce the database to change ths parameter
Previous Topic: STANDBY ERR - ORA-16032
Next Topic: Should I recreate this standby database?
Goto Forum:
  


Current Time: Tue Dec 06 00:11:31 CST 2016

Total time taken to generate the page: 0.12695 seconds