Oracle远程连接配置

最新推荐文章于 2023-10-30 08:24:57 发布

吴小全

最新推荐文章于 2023-10-30 08:24:57 发布

阅读量971

点赞数

分类专栏： oracle 文章标签： oracle 远程连接

本文链接：https://blog.csdn.net/WuXiaoQuan824212/article/details/52463542

版权

oracle 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

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)
    )
  )