已安装oracle8i客服务端。能不能在sql/plus中登陆?
修改客户端的oralce client安装目录下net80或network目录下admin/tnsnames.ora文件。
添加:
server3.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = SERVER3)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = SERVER3)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = oracle8i)
)
)Top
注意host和sid及world名都要相应更改。host可以是ip地址。