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)
)
)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/665511/viewspace-353271/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/665511/viewspace-353271/