用pl/sql如何连上oracle服务器
假设用户名 user

密码 user123

服务器ip 123,23,32.1

  oracle 10g tnsnames.ora 里面怎么写


pl/sql 外面的数据库怎么写




------解决方案--------------------
服务名 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 端口))
)
(CONNECT_DATA =
(SERVICE_NAME = 服务名)
)
)
------解决方案--------------------
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

TEST1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.88)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST1)
)
)


------解决方案--------------------

探讨

我是这样写的

123,23,32.1_sibpdb1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123,23,32.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = chen)
)
)

错误提示：监听程序当前无法识别……

------解决方案--------------------

探讨

sid=chen 是随便起的名字吗？ 还是它在什么地方存在