lincle

6 积分	0 好友	0 主题

发消息

blog中提到的11GRAC手动添加监听遇到的问题

1^#

发表于 2012-5-31 11:05:33 | 查看: 6370| 回复: 4

Maclena LIU 大哥，你好
小弟参照您的blog手动添加11gR2监听教程http://www.oracledatabase12g.com/archives/11gr2-rac-add-listener-static-register.html
设置遇到了问题

首先，我的环境是AIX oracle是 11.0.2.3 RAC

RAC上启了两个数据库。我打算对新的数据库coredb设置另外一个监听,netca添加的监听名为core，端口为1527

rac中 10.0.58.153 与10.0.58.155是VIP  其中是在153这个VIP的节点上用grid添加的监听

netmgr中的配置是：
global database name：coredb
oracle home directory：/u01/app/11.2.0/grid
oracle_sid: coredb1(只填了运行netmgr节点的实例名，另外一个节点是coredb2没填）

grid用户下运行lsnrctl status core

sfpayhisdb1:grid:/home/grid>lsnrctl status core

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 31-MAY-2012 10:56:52

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=CORE)))
STATUS of the LISTENER
------------------------
Alias                   CORE
Version                TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date             31-MAY-2012 09:03:57
Uptime                   0 days 1 hr. 52 min. 55 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   ON
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File       /u01/app/grid/diag/tnslsnr/sfpayhisdb1/core/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=CORE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.58.152)(PORT=1527)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.58.153)(PORT=1527)))
Services Summary...
Service "coredb" has 1 instance(s).
  Instance "coredb1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

我在远程连接机器上配置的tnsnames是：

coredb2 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.58.153)(PORT = 1527))
(CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = coredb)
   (INSTANCE_NAME = coredb1)
)
  )

TNSPING没有问题，可以ping通，但是远程连接却提示
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory

[ 本帖最后由 lincle 于 2012-5-31 11:07 编辑 ]

分享0