执行关闭数据库时报错
C:/>sqlplus sys/×××@mytest as sysdba
SQL> shutdown immediate;
ORA-00106: 无法在连接到调度程序时启动/关闭数据库
查看tnsnames.ora
MYTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = *********)(PORT = 1521))
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MYTEST)
)
)
红色部分表示为共享模式
修改成专有模式
MYTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = *********)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYTEST)
)
)
保存后再重新登入
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
已经OK了