oracle 11g rac dbca建库时提示创建监听

Oracle 11g rac dbca建库时提示创建监听

在安装oracle 11g rac时，使用dbca建库的过程中提示需要创建监听：

Default Listener "LISTENER" is not configured in Grid Infrantructure home.Use NetCA to configure Default Listener and return DBCA

解决步骤如下

因为oracle 11g rac在安装过程中会自动创建监听，无需手动创建，首先使用grid用户登录查看监听状态：

[grid@node1 ~]$ crs_stat -tName           Type           Target    State     Host        ------------------------------------------------------------ora.DATA.dg    ora....up.type ONLINE    ONLINE    node1       ora....N1.lsnr ora....er.type ONLINE    ONLINE    node1       ora.OCRVOTE.dg ora....up.type ONLINE    ONLINE    node1       ora.asm        ora.asm.type   ONLINE    ONLINE    node1       ora.cvu        ora.cvu.type   ONLINE    ONLINE    node1       ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               ora....network ora....rk.type ONLINE    ONLINE    node1       ora....SM1.asm application    ONLINE    ONLINE    node1       ora.node1.gsd  application    OFFLINE   OFFLINE               ora.node1.ons  application    ONLINE    ONLINE    node1       ora.node1.vip  ora....t1.type ONLINE    ONLINE    node1       ora....SM2.asm application    ONLINE    ONLINE    node2       ora.node2.gsd  application    OFFLINE   OFFLINE               ora.node2.ons  application    ONLINE    ONLINE    node2       ora.node2.vip  ora....t1.type ONLINE    ONLINE    node2       ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    node1       ora.ons        ora.ons.type   ONLINE    ONLINE    node1       ora.scan1.vip  ora....ip.type ONLINE    ONLINE    node1

使用命令crs_stat -t查看各资源状态,发现没有监听资源，下面查看详细信息：

[grid@node1 ~]$ crs_statNAME=ora.DATA.dgTYPE=ora.diskgroup.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.LISTENER_SCAN1.lsnrTYPE=ora.scan_listener.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.OCRVOTE.dgTYPE=ora.diskgroup.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.asmTYPE=ora.asm.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.cvuTYPE=ora.cvu.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.gsdTYPE=ora.gsd.typeTARGET=OFFLINESTATE=OFFLINENAME=ora.net1.networkTYPE=ora.network.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.node1.ASM1.asmTYPE=applicationTARGET=ONLINESTATE=ONLINE on node1NAME=ora.node1.gsdTYPE=applicationTARGET=OFFLINESTATE=OFFLINENAME=ora.node1.onsTYPE=applicationTARGET=ONLINESTATE=ONLINE on node1NAME=ora.node1.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.node2.ASM2.asmTYPE=applicationTARGET=ONLINESTATE=ONLINE on node2NAME=ora.node2.gsdTYPE=applicationTARGET=OFFLINESTATE=OFFLINENAME=ora.node2.onsTYPE=applicationTARGET=ONLINESTATE=ONLINE on node2NAME=ora.node2.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINE on node2NAME=ora.oc4jTYPE=ora.oc4j.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.onsTYPE=ora.ons.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.scan1.vipTYPE=ora.scan_vip.typeTARGET=ONLINESTATE=ONLINE on node1

手动添加监听资源：

[grid@node1 admin]$ srvctl status listenerPRCN-2044 : No listener exists[grid@node1 admin]$ [grid@node1 admin]$ srvctl add listener[grid@node1 admin]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is not running[grid@node1 admin]$ [grid@node1 admin]$ crs_stat -tName           Type           Target    State     Host        ------------------------------------------------------------ora.DATA.dg    ora....up.type ONLINE    ONLINE    node1       ora....ER.lsnr ora....er.type OFFLINE   OFFLINE               ora....N1.lsnr ora....er.type ONLINE    ONLINE    node1       ora.OCRVOTE.dg ora....up.type ONLINE    ONLINE    node1       ora.asm        ora.asm.type   ONLINE    ONLINE    node1       ora.cvu        ora.cvu.type   ONLINE    ONLINE    node1       ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               ora....network ora....rk.type ONLINE    ONLINE    node1       ora....SM1.asm application    ONLINE    ONLINE    node1       ora....E1.lsnr application    OFFLINE   OFFLINE               ora.node1.gsd  application    OFFLINE   OFFLINE               ora.node1.ons  application    ONLINE    ONLINE    node1       ora.node1.vip  ora....t1.type ONLINE    ONLINE    node1       ora....SM2.asm application    ONLINE    ONLINE    node2       ora....E2.lsnr application    OFFLINE   OFFLINE               ora.node2.gsd  application    OFFLINE   OFFLINE               ora.node2.ons  application    ONLINE    ONLINE    node2       ora.node2.vip  ora....t1.type ONLINE    ONLINE    node2       ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    node1       ora.ons        ora.ons.type   ONLINE    ONLINE    node1       ora.scan1.vip  ora....ip.type ONLINE    ONLINE    node1

手动启动监听：

[grid@node1 admin]$ srvctl start listener[grid@node1 admin]$ [grid@node1 admin]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): node2,node1[grid@node1 admin]$ [grid@node1 admin]$ crs_stat -tName           Type           Target    State     Host        ------------------------------------------------------------ora.DATA.dg    ora....up.type ONLINE    ONLINE    node1       ora....ER.lsnr ora....er.type ONLINE    ONLINE    node1       ora....N1.lsnr ora....er.type ONLINE    ONLINE    node1       ora.OCRVOTE.dg ora....up.type ONLINE    ONLINE    node1       ora.asm        ora.asm.type   ONLINE    ONLINE    node1       ora.cvu        ora.cvu.type   ONLINE    ONLINE    node1       ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               ora....network ora....rk.type ONLINE    ONLINE    node1       ora....SM1.asm application    ONLINE    ONLINE    node1       ora....E1.lsnr application    ONLINE    ONLINE    node1       ora.node1.gsd  application    OFFLINE   OFFLINE               ora.node1.ons  application    ONLINE    ONLINE    node1       ora.node1.vip  ora....t1.type ONLINE    ONLINE    node1       ora....SM2.asm application    ONLINE    ONLINE    node2       ora....E2.lsnr application    ONLINE    ONLINE    node2       ora.node2.gsd  application    OFFLINE   OFFLINE               ora.node2.ons  application    ONLINE    ONLINE    node2       ora.node2.vip  ora....t1.type ONLINE    ONLINE    node2       ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    node1       ora.ons        ora.ons.type   ONLINE    ONLINE    node1       ora.scan1.vip  ora....ip.type ONLINE    ONLINE    node1

发现监听正常启动，查看详细资源信息：

[grid@node1 admin]$ [grid@node1 admin]$ crs_statNAME=ora.DATA.dgTYPE=ora.diskgroup.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.LISTENER.lsnrTYPE=ora.listener.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.LISTENER_SCAN1.lsnrTYPE=ora.scan_listener.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.OCRVOTE.dgTYPE=ora.diskgroup.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.asmTYPE=ora.asm.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.cvuTYPE=ora.cvu.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.gsdTYPE=ora.gsd.typeTARGET=OFFLINESTATE=OFFLINENAME=ora.net1.networkTYPE=ora.network.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.node1.ASM1.asmTYPE=applicationTARGET=ONLINESTATE=ONLINE on node1NAME=ora.node1.LISTENER_NODE1.lsnrTYPE=applicationTARGET=ONLINESTATE=ONLINE on node1NAME=ora.node1.gsdTYPE=applicationTARGET=OFFLINESTATE=OFFLINENAME=ora.node1.onsTYPE=applicationTARGET=ONLINESTATE=ONLINE on node1NAME=ora.node1.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.node2.ASM2.asmTYPE=applicationTARGET=ONLINESTATE=ONLINE on node2NAME=ora.node2.LISTENER_NODE2.lsnrTYPE=applicationTARGET=ONLINESTATE=ONLINE on node2NAME=ora.node2.gsdTYPE=applicationTARGET=OFFLINESTATE=OFFLINENAME=ora.node2.onsTYPE=applicationTARGET=ONLINESTATE=ONLINE on node2NAME=ora.node2.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINE on node2NAME=ora.oc4jTYPE=ora.oc4j.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.onsTYPE=ora.ons.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.scan1.vipTYPE=ora.scan_vip.typeTARGET=ONLINESTATE=ONLINE on node1