文件名称:plsql客户端
文件大小:52.41MB
文件格式:RAR
更新时间:2021-09-29 14:57:28
plsql
plsql绿色版。。。。。。。。。。。。 1.安装pl/sql development 远程连接 修改tnsnames.ora 我的tnsnames.ora在D:\Program Files\PLSQL(绿色版)\PLSQL\instantclient_11_2文件夹下 修改为: orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.9.102)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 主要是更改连接的host和端口 服务端修改listener.ora 我的在 D:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN”目录下的 ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.9.102)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 主要是增加一条address 将本机的ip增加监听