How to add a Listener on Oracle Restart

Checando que o listener LISTENERDR não está configurado no Oracle Restart:

[grid@fornix2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG_DATA.dg
               ONLINE  ONLINE       fornix2                  STABLE
ora.DG_FRA.dg
               ONLINE  ONLINE       fornix2                  STABLE
ora.DG_GRID.dg
               ONLINE  ONLINE       fornix2                  STABLE
ora.DG_RECO.dg
               ONLINE  ONLINE       fornix2                  STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       fornix2                  STABLE
ora.asm
               ONLINE  ONLINE       fornix2                  Started,STABLE
ora.ons
               OFFLINE OFFLINE      fornix2                  STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cortexdr.db
      1        ONLINE  ONLINE       fornix2                  Open,HOME=/oracle/19
                                                             .3.0/product,STABLE
ora.cssd
      1        ONLINE  ONLINE       fornix2                  STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       fornix2                  STABLE
--------------------------------------------------------------------------------
[grid@fornix2 ~]$

E o mesmo já está no ar:

[grid@fornix2 ~]$ ps -ef | grep lsnr
grid      3000     1  0 04:37 ?        00:00:00 /grid/19.3.0/product/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid      3680     1  0 04:39 ?        00:00:00 /grid/19.3.0/product/bin/tnslsnr LISTENERDR -inherit
grid      6944  6808  0 05:20 pts/1    00:00:00 grep --color=auto lsnr

Executando o comando abaixo para adicioná-lo. Como o mesmo já está no ar, é reportado um conflito de porta:

[grid@fornix2 ~]$ srvctl add listener -l LISTENERDR -p TCP:1522 -o /grid/19.3.0/product
PRCN-2061 : Failed to add listener ora.LISTENERDR.lsnr
PRCN-2065 : Ports 1522 are not available on the nodes given
PRCN-2067 : Port 1522 is not available on nodes: fornix2

Utilizando o parâmetro -s, essa conferência de conflitos é ignorada:

[grid@fornix2 ~]$ srvctl add listener -l LISTENERDR -p TCP:1522 -s -o /grid/19.3.0/product

Parando e ligando listener:

[grid@fornix2 ~]$ srvctl stop listener -l LISTENERDR
PRCC-1016 : LISTENERDR was already stopped
PRCR-1005 : Resource ora.LISTENERDR.lsnr is already stopped
 
[grid@fornix2 ~]$ srvctl start listener -l LISTENERDR

Checando status:

[grid@fornix2 ~]$ srvctl status listener -l LISTENERDR
Listener LISTENERDR is enabled
Listener LISTENERDR is running on node(s): fornix2

Checando serviço incluso no Oracle Restart:

[grid@fornix2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG_DATA.dg
               ONLINE  ONLINE       fornix2                  STABLE
ora.DG_FRA.dg
               ONLINE  ONLINE       fornix2                  STABLE
ora.DG_GRID.dg
               ONLINE  ONLINE       fornix2                  STABLE
ora.DG_RECO.dg
               ONLINE  ONLINE       fornix2                  STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       fornix2                  STABLE
ora.LISTENERDR.lsnr
               ONLINE  ONLINE       fornix2                  STABLE
ora.asm
               ONLINE  ONLINE       fornix2                  Started,STABLE
ora.ons
               OFFLINE OFFLINE      fornix2                  STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cortexdr.db
      1        ONLINE  ONLINE       fornix2                  Open,HOME=/oracle/19
                                                             .3.0/product,STABLE
ora.cssd
      1        ONLINE  ONLINE       fornix2                  STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       fornix2                  STABLE
--------------------------------------------------------------------------------
[grid@fornix2 ~]$

Leave a Comment Cancel Reply