各位好,我有个SUSE 11g SP1+ORACLE 11gR2+RAC的项目,现在RAC是搭建起来了,就是在配EM的时候老是报instance不可用,初步检查是监听配置的问题,但现在监听是正常工作的,PL/SQL连接也没有问题,因对11g R2 Grid 和Oracle用户的监听配置不是很了解,也多方请教了很多人远程协助过,都不能解决,如果您有时间,不知道方便帮我看看不,万分感谢了!
#emca -config dbcontrol db -cluster --报下面的错误:
Enter the following information:
Database unique name: racdb
Service name: racdb
Listener ORACLE_HOME [ /oracle/app/grid/product/11.2.0 ]:
Password for SYS user:
Invalid username/password or database/scan listener not up or database service is not registered with scan listener.
Password for SYS user: oracle@uap-zh-db01:~> ---手工修改过sys的密码,可以确认密码没有问题,监听也全都是起来的。
grid@uap-zh-db01:~> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type ONLINE ONLINE uap-zh-db02
ora.DATA.dg ora....up.type ONLINE ONLINE uap-zh-db02
ora.FRA.dg ora....up.type ONLINE ONLINE uap-zh-db02
ora....ER.lsnr ora....er.type ONLINE ONLINE uap-zh-db01
ora....N1.lsnr ora....er.type ONLINE ONLINE uap-zh-db01
ora.asm ora.asm.type ONLINE ONLINE uap-zh-db01
ora.eons ora.eons.type ONLINE ONLINE uap-zh-db01
ora.gsd ora.gsd.type ONLINE ONLINE uap-zh-db01
ora....network ora....rk.type ONLINE ONLINE uap-zh-db01
ora.oc4j ora.oc4j.type ONLINE ONLINE uap-zh-db01
ora.ons ora.ons.type ONLINE ONLINE uap-zh-db01
ora.racdb.db ora....se.type ONLINE ONLINE uap-zh-db02
ora.scan1.vip ora....ip.type ONLINE ONLINE uap-zh-db01
ora....SM1.asm application ONLINE ONLINE uap-zh-db01
ora....01.lsnr application ONLINE ONLINE uap-zh-db01
ora....b01.gsd application ONLINE ONLINE uap-zh-db01
ora....b01.ons application ONLINE ONLINE uap-zh-db01
ora....b01.vip ora....t1.type ONLINE ONLINE uap-zh-db01
ora....SM2.asm application ONLINE ONLINE uap-zh-db02
ora....02.lsnr application ONLINE ONLINE uap-zh-db02
ora....b02.gsd application ONLINE ONLINE uap-zh-db02
ora....b02.ons application ONLINE ONLINE uap-zh-db02
ora....b02.vip ora....t1.type ONLINE ONLINE uap-zh-db02
------解决思路----------------------
看下emca产生的log日志。
------解决思路----------------------
加qq:76946075吧