PL/SQL developer安装步骤:
1.
下载安装PL/SQL developer、与oracle client. 最好放在同一个目录下,解压文件。
2.
安装PL/SQL,在客户端文件下创建NETWORK目录:
3在类似于此D:DappPLsqlodac_clientNETWORKadmin目录下创建tnsnames.ora文件
tnsnames.ora文件里是关于服务器端数据的连接描述。
Eg1:
OMS_DEV_15 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.124.253.15)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OMS)
)
)
Eg2
ISS2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.124.253.154)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ISS)
)
)
4.登录PL/sql 不用连接上,click 工具==> 首选项
添加关于client路径的描述信息。
5. 做完之后,再次登录PL/SQL developer ,输入相关信息登录数据库。