ITPub博客

首页 > 数据库 > Oracle > Oracle静态监听器配置方法-万能的解决连接故障

Oracle静态监听器配置方法-万能的解决连接故障

原创 Oracle 作者:wcwen1990 时间:2016-05-12 11:44:04 0 删除 编辑
1、监听程序配置:
[oracle@localhost admin]$ vim listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
     (SID_DESC =
      (SID_NAME = sun)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (global_dbname = sun)
    )
    (SID_DESC =
      (SID_NAME = sun1)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (global_dbname = sun1)
    )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM = extproc)
    )
  )

2、配置tnsnames.ora-客户端:
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

SUN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = sun)
    )
  )

SUN1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = sun1)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29612373/viewspace-2098431/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-04-17

  • 博文量
    20
  • 访问量
    36804