①找到D:\app\husong\product\11.2.0\dbhome_1\NETWORK\ADMIN目录下的tnsnames.ora文件
②修改tnsnames.ora文件,新增如下内容:
# 新增远程数据库连接.
别名 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 远程ip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 数据库名)
)
)
③打开plsql developer,输入用户名和密码登录: