PL/SQL连接Oracle数据库的两种方式

1. 配置tnsnames.ora 添加
XXXXX=
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.xxx.xxx.1)(PORT = 1521))
   (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
   )
)

2. 通过IP/实例名直接登录

192.168.1.199:1521/orcl