ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Win2003 Oracle 10G,两个DB.这样配置listener.ora 对吗?

Win2003 Oracle 10G,两个DB.这样配置listener.ora 对吗?

原创 Linux操作系统 作者:kisschina 时间:2008-09-11 11:18:13 0 删除 编辑
Win2003 Oracle 10G,两个DB(MYDB PSTDBY).这样配置listener.ora 对吗?
=================================================


LISTENER =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCLISTENER))
        (ADDRESS= (PROTOCOL= TCP)(Host= chinaoracle)(Port= 1521))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME= E:\Oracle\DB10)
      (SID_NAME = MYDB)
    )
    (SID_DESC =
      (ORACLE_HOME= E:\Oracle\DB10)
      (SID_NAME = PSTDBY)
    )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\Oracle\DB10)
      (PROGRAM = extproc)
    )
  )


STARTUP_WAIT_TIME_MYDB = 0
CONNECT_TIMEOUT_MYDB = 10
TRACE_LEVEL_MYDB = OFF

LOG_DIRECTORY_MYDB = E:\Oracle\DB10\network\admin
LOG_FILE_MYDB = MYDB
TRACE_DIRECTORY_MYDB = E:\Oracle\DB10\network\admin
TRACE_FILE_MYDB = MYDB
ADMIN_RESTRICTIONS_MYDB = OFF
SUBSCRIBE_FOR_NODE_DOWN_EVENT_MYDB = OFF


STARTUP_WAIT_TIME_PSTDBY = 0
CONNECT_TIMEOUT_PSTDBY = 10
TRACE_LEVEL_PSTDBY = OFF

LOG_DIRECTORY_PSTDBY = E:\Oracle\DB10\network\admin
LOG_FILE_PSTDBY = PSTDBY
TRACE_DIRECTORY_PSTDBY = E:\Oracle\DB10\network\admin
TRACE_FILE_PSTDBY = PSTDBY
ADMIN_RESTRICTIONS_PSTDBY = OFF
SUBSCRIBE_FOR_NODE_DOWN_EVENT_PSTDBY = OFF

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

上一篇: 没有了~
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2008-09-11

  • 博文量
    1
  • 访问量
    4146