我用 sqlplus
sys/test as sysdba
登入数据库后,执行:
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET ZHS16CGB231280;
SHUTDOWN IMMEDIATE; -- or SHUTDOWN NORMAL;
STARTUP;
执行后报错:
SQL>; ALTER DATABASE CHARACTER SET ZHS16CGB231280;
ALTER DATABASE CHARACTER SET ZHS16CGB231280
*
ERROR at line 1:
ORA-12720: operation requires database is in EXCLUSIVE mode