修改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)
)
)