Oracle远程连接配置

来源：互联网发布：琼恩龙母知乎编辑：程序博客网时间：2024/06/12 19:16

Oracle远程连接配置

进入oracle的安装目录

C:\app\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN

这里写图片描述

第一步修改listener.ora文件，将host从localhost改为当前机器IP或者机器名
下面是修改后的文件：

# listener.ora Network Configuration File: D:\app\uniplore\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = orcl)      (ORACLE_HOME = C:\app\oracle\product\11.2.0\dbhome_1)    )  )LISTENER =  ( DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.101.205)(PORT = 1521))    )  )ADR_BASE_LISTENER = C:\app\oracle

第二步修改tnsnames.ora文件，添加当前数据库的实例名：

# tnsnames.ora Network Configuration File: C:\app\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.ORCL =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.101.205)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = orcl)    )  )

0 0