Oracle 11g RAC DBCA to create a listener when building a library
When you install an Oracle 11g RAC, you are prompted to create a listener when you use DBCA to build the library:
The Default Listener "Listener" is not a configured in Grid Infrantructure home. Use NETCA to configure Default Listener and return DBCA
650) this.width=650; "title=" 4.png "alt=" wkiom1keisrsvl5aaadjwco-yae862.png-wh_50 "src=" https://s5.51cto.com/ Wyfs02/m00/96/3e/wkiom1keisrsvl5aaadjwco-yae862.png-wh_500x0-wm_3-wmp_4-s_196505480.png "/> Steps to resolve the following
Because the Oracle 11g RAC automatically creates a listener during the installation process without having to create it manually, first use a grid user login to view the listening status:
[[email protected] ~]$ 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 view the status of each resource and discover that there are no listening resources, see details below:
[[Email protected] ~]$ 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
To manually add a listener resource:
[[email protected] admin]$ srvctl status listenerprcn-2044 : no Listener exists[[email protected] admin]$ [[email protected] admin]$ srvctl add listener[[email protected] admin]$ srvctl status listenerlistener listener is enabledlistener listener is not running[[email protected] admin]$ [[email protected] 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 &nbsP; 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&Nbsp; ora.ons ora.ons.type ONLINE ONLINE node1 ora.scan1.vip ora....ip.type ONLINE ONLINE node1
Start monitoring manually:
[[email protected] admin]$ srvctl start listener[[email protected] admin]$ [[email protected] admin]$ srvctl status listenerlistener listener is enabledlistener listener is running on node (s): node2,node1[[email protected] admin]$ [[email protected] 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&nBsp; 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
Discovery monitoring starts Normally, view detailed resource information:
[[Email protected] admin]$ [[email protected] 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
This article is from the "Future People" blog, please be sure to keep this source http://zaa47.blog.51cto.com/6181689/1927517
Oracle 11g RAC DBCA to create a listener when building a library