ORA-02096: specified initialization parameter is not modifiable with this

Posted on by
Reply

Oracle 11gR2

Ora-02096

ORA-02096: specified initialization parameter is not modifiable with this

SQL> alter system set recyclebin=off scope=both;
alter system set recyclebin=off scope=both
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this
option

SQL> create spfile from memory;
create spfile from memory
*
ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance

mv spfile to another and created new one
SQL> create spfile from pfile;
File created.

SQL> alter system set recyclebin=off scope=both;
alter system set recyclebin=off scope=both
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this
option
SQL> SHOW PARAMETER RECYCLEBIN
NAME TYPE VALUE
———————————— ———– ——————————
recyclebin string on
SQL> ALTER SYSTEM SET recyclebin = OFF DEFERRED;

System altered.

SQL> SHOW PARAMETER RECYCLEBIN
NAME TYPE VALUE
———————————— ———– ——————————
recyclebin string OFF