安装plsql(本地没有安装oracle的情况下)
1、下载安装:PLSQL Developer 13 (64 bit)
2、下载 客户端连接工具:instantclient_11_2,然后随便放在一个文件夹
3、配置坏境
1)在instantclient_11_2目录下,新建文件tnsnames.ora,如果没有NETWORK和ADMIN,就手动新建两个文件夹
2)配置tnsnames.ora
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
THPUSER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.19.34)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = THPPDB)
)
)
4、配置环境变量,目的是为了系统能找到tnsnames.ora
5、打开plsql,配置文件
6、这时,全部工程已经完成,重新打开plsql,输入用户名等信息,就可以登录数据库了