首页 > 数据库技术 > 详细

oracle 配置监听

时间:2015-01-27 20:16:31      阅读:318      评论:0      收藏:0      [点我收藏+]


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = raccontroller.cc)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl.raccontroller.cc)
      (SID_NAME = orcl)
      (ORACLE_HOME = /ruiy/ocr/DBSoftware/app/oracle/product/11.2.0/dbhome_1)
    )
  )
ADR_BASE_LISTENER = /ruiy/ocr/DBSoftware/app/oracle

技术分享

 

2,Instance "ruiy", status UNKNOWN, has 1 handler(s) for this service...

就是你的/ruiy/ocr/DBSoftware/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora中建的监听,没在tnsnames.ora中加

listener.ora文件Example

技术分享
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = raccontroller.cc)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl.raccontroller.cc)
      (SID_NAME = orcl)
      (ORACLE_HOME = /ruiy/ocr/DBSoftware/app/oracle/product/11.2.0/dbhome_1)
    )
   (SID_DESC =
      (GLOBAL_DBNAME = ruiy.raccontroller.cc)
      (SID_NAME = ruiy)
      (ORACLE_HOME = /ruiy/ocr/DBSoftware/app/oracle/product/11.2.0/dbhome_1)
    )

  )
ADR_BASE_LISTENER = /ruiy/ocr/DBSoftware/app/oracle
View Code

tnsnames.ora文件Example

技术分享
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = raccontroller.cc)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.raccontroller.cc)
    )
  )


RUIY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = raccontroller.cc)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ruiy.raccontroller.cc)
    )
  )
View Code

 global_dbname

sid_name

service_name

instance_name

oracle 配置监听

原文:http://www.cnblogs.com/ruiy/p/4253767.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!