Oracle数据库

欢迎查看

对于需要远程连接oracle数据库时出现的问题在此处进行一下记录,如有不对之处,也请多多指教.

服务端的设置

1. 确保已成功安装oracle数据库
2. 配置监听文件: D:\Program Files (x86)\Oracle\Instant Client\network\admin\ listener.ora](此地址请根据自己电脑自行查找)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\Oracle11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\Oracle11.2.0\dbhome_1\bin\oraclr11.dll")
    )
     (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME =D:\Oracle11.2.0\dbhome_1)
      (SID_NAME = ORCL)
    ) 
  )

3. 打开 NET Manager 如图:
   
4. 移除NIS
   
5. 重启监听服务
   

本机的配置

1. 安装PL/SQL Developer并激活;
2. 安装Instant Client;
3. 在PL/SQL Developer中设置[工具>首选项>连接]:如图:
4. 修改配置文件D:\Program Files (x86)\Oracle\Instant Client\network\admin\tnsnames.ora:
   添加:

# Modify the following content to fit your own needs.
orcl =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 远程IP)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

注:SERVICE_NAME = orcl中的orcl同服务端[D:\Program Files (x86)\Oracle\Instant Client\network\admin\ listener.ora]设置的相同,如图
5. 打开PL/SQL Developer,登录即可.

注:关闭防火墙.

ps:如有不对之处,也请多多指教.