资源介绍
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增加监听