步骤一：执行以下命令

sqlplus "/as sysdba"

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

conn /as sysdba;

shutdown immediate;

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 UTF8;

shutdown immediate;

startup;

 

执行alter database character set UTF8; 报错
RROR at line 1:
　　ORA-12712: new character set must be a superset of old character set


ALTER DATABASE character set INTERNAL_USE zhs16gbk;


ALTER SESSION SET SQL_TRACE=FALSE;


shutdown immediate;

STARTUP

select NLS_CHARACTERSET from nls_database_parameters;

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄