11.2.0.4 RAC dbca建库时报错ASMSNMP ORA-12154
11.2.0.4 RAC for CentOS 5.10 x86-64dbca建库时报错ASMSNMP ORA-12154如附图。
cat listener.ora
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))
# (ADDRESS=(PROTOCOL=tcp)(HOST=11gr2node1)(PORT=1521))
# (ADDRESS=(PROTOCOL=tcp)(HOST=11gr2node1-vip)(PORT=1521)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
========================================
cat endpoints_listener.ora
LISTENER_11GR2NODE1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=11gr2node1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.21)(PORT=1521)(IP=FIRST)))) # line added by Agent
========================================
srvctl config scan
SCAN name: cluster-scan, Network: 1/192.168.2.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /cluster-scan/192.168.2.201
SCAN VIP name: scan2, IP: /cluster-scan/192.168.2.202
SCAN VIP name: scan3, IP: /cluster-scan/192.168.2.200
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=11gr2node1-vip)(PORT=1521))))' scope=both sid='+ASM1';
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=11gr2node2-vip)(PORT=1521))))' scope=both sid='+ASM2';
SQL> show parameter listener
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
listener_networks string
local_listener string
(DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=11gr
2node1-vip)(PORT=1521))))
remote_listener string
cluster-scan:1521
SQL>
怪哉！ ls -l $ORACLE_HOME/bin/oracle
Liu Maclean(刘相兵 发表于 2014-1-13 20:20 static/image/common/back.gif
ls -l $ORACLE_HOME/bin/oracle
11gr2node2-> id
uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper),1300(dba)
11gr2node2-> ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 grid oinstall 209914869 Jan 14 00:43 /u01/app/11.2.0/grid/bin/oracle
11gr2node2->
11gr2node1-> id
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1201(asmdba),1300(dba),1301(oper)
11gr2node1-> ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle asmadmin 239627031 Jan 14 02:53 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
11gr2node1-> 报错仅仅说 continue的话 ASM不将被DB CONTROL监控，我觉得这是可以接受的， 你可以尝试continue ，如果仍报错 那么把DBCA的日志上传 Maclean教你用Vbox安装 10g/11g RAC cluster 信息汇总贴 http://t.askmaclean.com/thread-2067-1-1.html
【Maclean Liu技术分享】12c 12.1.0.1 RAC安装教学视频 基于Vbox+Oracle Linux 5.7 http://t.askmaclean.com/thread-2667-1-1.html
[视频教学]Maclean教你用Vbox在Enterprise Linux 5安装Oracle 10gR2 RAC 10g RAC按照这个装不会有任何问题 http://t.askmaclean.com/thread-891-1-1.html
【视频教学】Maclean教你用Vbox在Linux 5安装Oracle 11gR2 RAC 11g RAC按照这个装不会有任何问题 http://t.askmaclean.com/thread-1061-1-1.html
【视频教学】Maclean教你用Vbox在Linux 6.3上安装Oracle 11gR2 RAC 11g RAC按照这个装不会有任何问题 http://t.askmaclean.com/thread-2007-1-1.html Liu Maclean(刘相兵 发表于 2014-1-14 21:02 static/image/common/back.gif
报错仅仅说 continue的话 ASM不将被DB CONTROL监控，我觉得这是可以接受的， 你可以尝试continue ，如果仍 ...
恩，是的，如果把oem选项取消之后，再安装就不会报任何错误，之后手动创建oem也不会报任何错误。只是奇怪为什么过程中选oem就报错，配置上肯定没有问题。
页:
[1]