Centos4.6+oracle10g(10.2.0)
以SecureCRT登录LINUX,想shutdown immediate,但
官方的解释:
===============
ORA-00106 cannot startup/shutdown database when connected to a dispatcher
Cause: An attempt was made to start or shut down an instance while connected to a shared server via a dispatcher.
Action: Reconnect as user INTERNAL without going through the dispatcher. For most cases, this can be done by connect to INTERNAL without specifying a network connect string.
==============
而我的数据库是shared server模式,所以无法直接在远程登录的Terminal上做startup/shutdown.
解决:1.直接login LINUX server可以直接shutdown
2.修改tnsnames.ora
把连接设为使用专用服务进程方式(SRVR = DEDICATED),从远程客户端端登录试验,可以shutdown数据库了。
#
ZENG=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = zeng)(SERVER = DEDICATED))
)