After RMAN Cloning, GG Manager abends on ORA-12154

Recently we refresh our Prodtest database from production using RMAN. now while starting the GG, i’m getting below error.

2016-05-27 19:31:12  ERROR   OGG-01668  Oracle GoldenGate Manager for Oracle, mgr.prm:  PROCESS ABENDING.
2016-05-27 19:49:26  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start mgr.
2016-05-27 19:49:27  ERROR   OGG-00664  Oracle GoldenGate Manager for Oracle, mgr.prm:  OCI Error during OCIServerAttach (status = 12154-ORA-12154: TNS:could not resolve the connect identifier specified).
2016-05-27 19:49:27  ERROR   OGG-01668  Oracle GoldenGate Manager for Oracle, mgr.prm:  PROCESS ABENDING.
bash-4.1$


Our database is running in 2 Node RAC, so immediately check the listeners.

Resource Name                           Resource Type                      Target              State
ora.DATA.dg                             ora.diskgroup.type                 ONLINE              ONLINE on xx01psmw22tp
ora.DATA.dg                             ora.diskgroup.type                 ONLINE              ONLINE on xx01psmw23tp
ora.FRA.dg                              ora.diskgroup.type                 ONLINE              ONLINE on xx01psmw22tp
ora.FRA.dg                              ora.diskgroup.type                 ONLINE              ONLINE on xx01psmw23tp
ora.GRID.dg                             ora.diskgroup.type                 ONLINE              ONLINE on xx01psmw22tp
ora.GRID.dg                             ora.diskgroup.type                 ONLINE              ONLINE on xx01psmw23tp
ora.LISTENER.lsnr                       ora.listener.type                  ONLINE              ONLINE on xx01psmw22tp
ora.LISTENER.lsnr                       ora.listener.type                  ONLINE              ONLINE on xx01psmw23tp
ora.LISTENER_SCAN1.lsnr                 ora.scan_listener.type             ONLINE              ONLINE on xx01psmw22tp
ora.LISTENER_SCAN2.lsnr                 ora.scan_listener.type             ONLINE              ONLINE on xx01psmw23tp
ora.LISTENER_SCAN3.lsnr                 ora.scan_listener.type             ONLINE              ONLINE on xx01psmw23tp
ora.asm                                 ora.asm.type                       ONLINE              ONLINE on xx01psmw22tp
ora.asm                                 ora.asm.type                       ONLINE              ONLINE on xx01psmw23tp
ora.cvu                                 ora.cvu.type                       ONLINE              ONLINE on xx01psmw23tp
ora.gsd                                 ora.gsd.type                       OFFLINE             OFFLINE
ora.gsd                                 ora.gsd.type                       OFFLINE             OFFLINE
ora.xx01psmw22tp.vip                    ora.cluster_vip_net1.type          ONLINE              ONLINE on xx01psmw22tp
ora.xx01psmw23tp.vip                    ora.cluster_vip_net1.type          ONLINE              ONLINE on xx01psmw23tp
ora.kycnpt2c.db                         ora.database.type                  ONLINE              ONLINE on xx01psmw22tp
ora.kycnpt2c.db                         ora.database.type                  ONLINE              ONLINE on xx01psmw23tp
ora.net1.network                        ora.network.type                   ONLINE              ONLINE on xx01psmw22tp
ora.net1.network                        ora.network.type                   ONLINE              ONLINE on xx01psmw23tp
ora.oc4j                                ora.oc4j.type                      ONLINE              ONLINE on xx01psmw23tp
ora.ons                                 ora.ons.type                       ONLINE              ONLINE on xx01psmw22tp
ora.ons                                 ora.ons.type                       ONLINE              ONLINE on xx01psmw23tp
ora.registry.acfs                       ora.registry.acfs.type             ONLINE              ONLINE on xx01psmw22tp
ora.registry.acfs                       ora.registry.acfs.type             ONLINE              ONLINE on xx01psmw23tp
ora.scan1.vip                           ora.scan_vip.type                  ONLINE              ONLINE on xx01psmw22tp
ora.scan2.vip                           ora.scan_vip.type                  ONLINE              ONLINE on xx01psmw23tp
ora.scan3.vip                           ora.scan_vip.type                  ONLINE              ONLINE on xx01psmw23tp

bash-4.1$ srvctl config scan
SCAN name: xx01psmw2-scan.bai.com, Network: 1/159.17.123.0/255.255.255.0/bond0
SCAN VIP name: scan1, IP: /xx01psmw2-scan.bai.com/ 111.111.123.137
SCAN VIP name: scan2, IP: /xx01psmw2-scan.bai.com/111.111.123.62
SCAN VIP name: scan3, IP: /xx01psmw2-scan.bai.com/111.111.123.138

bash-4.1$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:15211
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:15211
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:15211

bash-4.1$ nslookup xx01psmw2-scan.bai.com
Server:         192.193.215.65
Address:        192.193.215.65#53

Non-authoritative answer:
Name:   xx01psmw2-scan.bai.com
Address: 111.111.123.138
Name:   xx01psmw2-scan.bai.com
Address: 111.111.123.62
Name:   xx01psmw2-scan.bai.com
Address:  111.111.123.137

bash-4.1$

At cluster level everything looks good. now checking other thinks.

$ . oraenv
ORACLE_SID = [+ASM1] ? XX01PT2C1
The Oracle base has been changed from /optware/orabase/grid to /optware/oracle
$ bash
bash-4.1$ tnsping XX01PT2C

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 27-MAY-2016 20:38:53

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = xx01psmw2-scan.bai.com) (Port = 15211))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XX01PT2C)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))))
OK (20 msec)
bash-4.1$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Fri May 27 20:39:18 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn ggs_admin/ggs_admin@XX01PT2C
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


SQL> conn ggs_admin/ggs_admin@XX01PT2C1
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

SQL>

$ lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 27-MAY-2016 20:34:17

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN1
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                27-MAY-2016 20:27:17
Uptime                    0 days 0 hr. 7 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /optware/grid/11.2.0.4/network/admin/listener.ora
Listener Log File         /optware/grid/11.2.0.4/log/diag/tnslsnr/kycndsmw22tp/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= 111.111.123.137)(PORT=15211)))
The listener supports no services
The command completed successfully
$

So from above result no services is supported by scan 1.
Now lets check at Database level..remote_listener parameter.

SQL> show parameter remote_li;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_listener                      string

so now since the remote_listener is empty we need to set it.

SQL> alter system set remote_listener='xx01psmw2-scan.bai.com:15211' scope=both sid='*';
SQL> show parameter remote_listener;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_listener                      string      xx01psmw2-scan.bai.com:
                                                 15211
SQL>

bash-4.1$ lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 27-MAY-2016 20:50:58

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN1
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                27-MAY-2016 20:27:17
Uptime                    0 days 0 hr. 23 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /optware/grid/11.2.0.4/network/admin/listener.ora
Listener Log File         /optware/grid/11.2.0.4/log/diag/tnslsnr/kycndsmw22tp/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= 111.111.123.137)(PORT=15211)))
Services Summary...
Service "XX01PT2C" has 2 instance(s).
  Instance "XX01PT2C1", status READY, has 1 handler(s) for this service...
  Instance "XX01PT2C2", status READY, has 1 handler(s) for this service...
The command completed successfully
bash-4.1$ 

Now GG is working fine.


					
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s