PL/SQL远程连接Oracle数据库

发表于 | 更新于:
字数统计: 54 | 阅读时长 ≈ 1

F:oracleproduct11.2.0dbhome_F:oracleproduct11.2.0dbhome_1NETWORKADMIN1NETWORKADMIN

修改 tnsnames.ora 增加远程连接：

MYDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))

(CONNECT_DATA =

  (SERVER = DEDICATED)

  (SERVICE_NAME = mydb)

)

)

打开PL/SQL输入用户名和密码，选择数据库MYDB，即可。

0%