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

转载于:http://blog.itpub.net/665511/viewspace-353271/