Oracle无法通过IP连接数据库

最新推荐文章于 2021-04-11 06:18:08 发布

??yy

最新推荐文章于 2021-04-11 06:18:08 发布

阅读量443

点赞数

文章标签：数据库网络 python

原文链接：https://my.oschina.net/u/3209870/blog/821026

版权

2019独角兽企业重金招聘Python工程师标准>>>

1、问题描述：Oracle无法通过IP连接数据库

2、解决方法

打开${ORACLE_HOME}\product\11.2.0\dbhome_1\network\admin目录

1. 修改tnsnames.ora文件，将HOST值修改为计算机名（控制面板>系统和安全>系统，进行查看）

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 计算机名)(PORT = 1521))


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 计算机名)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

2. 修改listener.ora文件的HOST为计算机名

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 计算机名)(PORT = 1521))
    )
  )

转载于:https://my.oschina.net/u/3209870/blog/821026