当利用PLSQL连接 Oracle的时候 ,有时候连接不上 ,有如下注意点
(1): 查看 PLSQL 客户端下
可查看 PLSQL连接 的客户端安装目录,可在该目录下设置 连接属性
client_1\network\admin\tnsnames.ora 文件 修改连接地址:
10.64.52.120 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.64.52.120)(PORT= 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =orcl)
)
)
thinkpad-pc.yt=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT= 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =orcl.YT)
)
)
(2):查看监听是否启动 客户端安装目录 查看 Net Manager