用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)
  )
  )