Oracle 11g RAC DBCA to create a listener when building a library

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