修改tnsnames.ora文件:在CONNECT_DATA 中加入(server =
dedicated)
例:
sh2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.132)
(Port = 1521)
)
)
(CONNECT_DATA = (server = dedicated) (SID = sh2)
)
)
例:
sh2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.132)
(Port = 1521)
)
)
(CONNECT_DATA = (server = dedicated) (SID = sh2)
)
)
浙公网安备 33010602011771号