用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)
)
)
[解决办法]
