6 Replies Latest reply on Jul 8, 2014 9:25 AM by Moonlight

    Change NLS_CHARACTER in Oracle RAC

    Moonlight

      Hi,

      I want to change NLS_CHARACTERSET in my oracle RAC database, so i use these steps:

       

      SQL> SHUTDOWN IMMEDIATE; 

      SQL> STARTUP MOUNT;

      SQL> ALTER SYSTEM ENABLE RESTRICED SESSION;

      SQL> ALTER DATABASE CHARACTER SET AL32UTF8;

      in this step I received a error message :

      ORA-12720: operation requires database is in EXCLUSIVE mode

       

      How can I change the value of  NLS_CHARACTERSET in oracle RAC database?

       

      Thank you

      Best regards