ORA-00106错误的解决.........
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)
)
)
00106.JPG来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/665511/viewspace-353271/ ，如需转载，请注明出处，否则将追究法律责任。
