Oracle 11g rac dbca prompts to create listeners when building a database
Oracle 11g rac dbca prompts to create listeners when building a database
When installing oracle 11g rac, you are prompted to create a listener during the process of building a library using dbca:
Default Listener "LISTENER" is not configured in Grid Infrantructure home.Use NetCA to configure Default Listener and return DBCA
The solution steps are as follows
Because oracle 11g rac automatically creates listeners during installation, you do not need to create them manually. First, log in to grid to view the listening status:
[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
Use the command crs_stat-t to check the status of each resource and find that there are no listening resources. Check the details below:
[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
Manually add listening resources:
[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
Start monitoring manually:
[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
It is found that the monitoring starts normally. View the detailed resource information:
[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
