所以一直认为plsql远程连接数据库时必须配置listener;其实不然;
我的操作系统:
Windows 7 64位
实现目标:
不安装本地Oracle服务端,不配置listener.ora 文件,通过plsql developer远程连接oracle数据库
步骤一:
下载 32位的instantclient_11_2.rar (http://download.csdn.net/detail/xiangzhengxian/9774684)
下载32位的plsqldeveloper.zip (http://download.csdn.net/detail/xiangzhengxian/9774556)
步骤二:
将 instantclient_11_2 解压后 (我的路径:D:\tools\instantclient_11_2)
a. 在D:\tools\instantclient_11_2目录里创建 network文件夹 ,在network里创建 ADMIN文件夹,在ADMIN里创建tnsnames.ora
b. D:\tools\instantclient_11_2\network\ADMIN下的tnsnames.ora内容如下:
# tnsnames.ora Network Configuration File: D:\tools\instantclient_11_2\network\admin\tnsnames.ora # Generated by Oracle configuration tools. MYORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 111.9.4.88)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )
注:
# tnsnames.ora Network ConfigurationFile: 与你的路径保存一致
MYORCL 为plsql选择连接时的别名
HOST 为远程数据库连接IP
PORT 为远程数据库连接端口,一般默认1521
SERVICE_NAME 为远程数据库的实例名,一般默认:ORCL
步骤三:
解压PLSQLDeveloper,双击plsqldev.exe即可;Not logged on (无用户登陆进去)
a.选择Tools====》Preferences
b.配置如下:
左边菜单选择Oracle下的Connection
(1)勾选Check connection
(2)我的 Oracle Home目录为:D:\tools\instantclient_11_2
(3)我的 OCI library目录为:D:\tools\instantclient_11_2\oci.dll
(4)勾选Allow multiple connetions
(5)勾选Store recent history
c.点击OK。重启plsql即可