3,491
社区成员
发帖
与我相关
我的任务
分享
SHUTDOWN IMMEDIATE;
STARTUP MOUNT EXCLUSIVE;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE UTF8;
SHUTDOWN immediate;
startup;
numenhuangsvrmgrl>shutdown immediate;
svrmgrl>startup mount;
svrmgrl>alter system enable restricted session;
svrmgrl>alter system set job_queue_processes=0;
svrmgrl>alter database open;
svrmgrl>alter database character set ZHS16GBK;
svrmgrl>alter database national character set ZHS16GBK;
这里如果遇到superset的问题,则可以用这两句来代替:
alter database character set set INTERNAL_USE ZHS16GBK;
alter database national character set INTERNAL_USE ZHS16GBK;
svrmgrl>shutdown immediate;
svrmgrl>startup;
SQL>STARTUP MOUNT;
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN;
SQL>ALTER DATABASE CHARACTER SET ZHS16GBK;
SQL>ALTER DATABASE national CHARACTER SET ZHS16GBK; SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP