cmd窗口下
[list]
[*]sqlplus sys/sys@orcl as sysdba
[*]SQL>shutdown immediate
[*]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 INTERNAL_USE ZHS16GBK;
[*]SQL>shutdown immediate;
[*]SQL>STARTUP;
[/list]
开启监听和服务cmd
[list]
[*]lsnrctl start
[*]net start OracleServiceORCL
[/list]
[list]
[*]sqlplus sys/sys@orcl as sysdba
[*]SQL>shutdown immediate
[*]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 INTERNAL_USE ZHS16GBK;
[*]SQL>shutdown immediate;
[*]SQL>STARTUP;
[/list]
开启监听和服务cmd
[list]
[*]lsnrctl start
[*]net start OracleServiceORCL
[/list]