1 Reply Latest reply on Oct 12, 2017 4:30 AM by Jibu-Oracle

    Issue while connecting to standby database while invoking adcfgclone on Apps DR 1st node

    720971

      Hi All,

       

      We have following architecture:

      Primary Apps Tier: 2 nodes, E-Business Suite R12.2.4 with AD.DELTA.C.7

      Primary Database: 2 Node RAC, Oracle database 12.1.0.2

       

      Standby Apps Tier: 4 nodes

      Standby Database: Normal database

       

      Primary Apps Tier and database is already setup. Database DR server is also setup and is in sync with Primary db.

      Now we are building the Standby Apps Tier. For This we are referring MOS note "1.    Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 12c (12.1.0.2) Physical Standby Database (Doc ID 1963472.1)"

      We are referring to section 5.1 Configuration 1: Standby Application Tier(s) Connected to the Standby Database.

      Standby db has been converted to Snapshot db. Now we are configuring Apps standby.

      While invoking adcfgclone on the 1st Apps node, we are encountering the following connectivity issue:

       

      getConnectionUsingAppsJDBCConnector() -->

          APPS_JDBC_URL=''

          Trying to get connection using SID based connect descriptor

      getConnection() -->

          sDbHost    : drunixhost

          sDbDomain  : drdomain.com

          sDbPort    : 1533

          sDbSid     : RXEST02

          sDbUser    : APPS

          Trying to connect using SID...

      getConnectionUsingSID() -->

          JDBC URL: jdbc:oracle:thin:@drunixhost.drdomain.com:1533:RXEST02

      WARNING:     Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:

      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

       

          Trying to connect using SID as ServiceName

      getConnectionUsingServiceName() -->

          JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drunixhost.drdomain.com)(PORT=1533))(CONNECT_DATA=(SERVICE_NAME=RXEST02)))

      WARNING:     Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:

      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

       

       

      *****************************************************************************************************

       

      We are providing the correct standby database hostname and SID as below:

      DB hostname: drunixhost

      DB SID: RXEDV99

       

      Still it is taking RXEST02 for standby database sid and failing with above issue.

      Any pointers are appreciated.

      Following are the details from database standby:

       

       

      SQL> select name, NODE_NAME from fnd_oam_context_files;

       

      NAME    NODE_NAME

      --------------------------------------------------------------------------------

      RXEDV99_drunixhost  drunixhost

       

      TEMPLATE            drunixhost

       

      METADATA            drunixhost

       

       

       

      SQL>  select DB_NAME, DB_DOMAIN, IS_RAC_DB from fnd_databases;

       

      DB_NAME            DB_DOMAIN            IS_RAC_DB

      --------------------------------------------------------------------------------

      RXEDV99            drdomain.com        N

       

       

      SQL> select INSTANCE_NAME, HOST_NAME, STATUS, LOGINS,DATABASE_STATUS, INSTANCE_ROLE, INSTANCE_MODE from v$instance;

       

      INSTANCE_NAME    HOST_NAME      STATUS    LOGINS     DATABASE_STATUS   INSTANCE_ROLE      INSTANCE_MODE

      ---------- ----------------- ------------------ ----------- ------------------ ----------- ------------------

      RXEDV99            drunixhost    OPEN        ALLOWED    ACTIVE            PRIMARY_INSTANCE   REGULAR

       

       

       

      SQL> select NAME, SWITCHOVER#, DATABASE_ROLE , SWITCHOVER_STATUS, DB_UNIQUE_NAME, PRIMARY_DB_UNIQUE_NAME from v$database;

       

      NAME      SWITCHOVER# DATABASE_ROLE        SWITCHOVER_STATUS    DB_UNIQUE_NAME      PRIMARY_DB_UNIQUE_NAME

      --------- ----------- ---------------- ----------------------------------------------- ----------------

      RXEST02     582991250 SNAPSHOT STANDBY     NOT ALLOWED            RXEDV99  

       

       

       

      SQL> sho parameter fal_server

       

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      fal_server                           string      rxest02_PRIM

      SQL> sho parameter fal_client

       

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      fal_client                           string

       

       

      SQL> sho parameter name

       

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      db_name                              string      RXEST02

      db_unique_name                       string      RXEDV99

      global_names                         boolean     TRUE

      instance_name                        string      RXEDV99                                            

      service_names                        string      rxedv99, ebs_patch, rxedv99.drdomain

                                                       .com, RXEDV99.drdomain.COM, RXEDV9

                                                       9, ebs_patch.drdomain.com

       

       

       

       

      tnsping RXEDV99

       

      TNS Ping Utility for Solaris: Version 12.1.0.2.0 - Production on 11-OCT-2017 11:15:29

       

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

       

      Used parameter files:

      /ora/rxedv99/u01/db/tech_st/12.1.0.2/db_1/network/admin/RXEDV99_drunixhost/sqlnet_ifile.ora

       

       

      Used TNSNAMES adapter to resolve the alias

      Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=drunixhost.drdomain.com)(PORT=1533)) (CONNECT_DATA= (SERVICE_NAME=RXEDV99.drdomain.com) (INSTANCE_NAME=RXEDV99)))

      OK (0 msec)

       

      *******************************************************************************************************

       

       

       

      tnsname.ora ifile:

       

       

      RXEDV99=

              (DESCRIPTION=

                      (ADDRESS=(PROTOCOL=tcp)(HOST=drunixhost.drdomain.com)(PORT=1533))

                  (CONNECT_DATA=

                      (SERVICE_NAME=RXEDV99.drdomain.com)

                      (INSTANCE_NAME=RXEDV99)

                  )

              )

       

      RXEST02=

              (DESCRIPTION=

                  (ADDRESS_LIST=

                      (LOAD_BALANCE=YES)

                      (FAILOVER=YES)

                      (ADDRESS=(PROTOCOL=tcp)(HOST=10.179.112.153)(PORT=1521))

                      (ADDRESS=(PROTOCOL=tcp)(HOST=10.179.112.155)(PORT=1521))

                      (ADDRESS=(PROTOCOL=tcp)(HOST=10.179.112.154)(PORT=1521))

                  )

                  (CONNECT_DATA=

                      (SERVICE_NAME=RXEST02.drdomain.com)

                  )

              )

       

      rxest02_PRIM=

              (DESCRIPTION=

                  (ADDRESS_LIST=

                      (LOAD_BALANCE=YES)

                      (FAILOVER=YES)

                      (ADDRESS=(PROTOCOL=tcp)(HOST=10.179.112.153)(PORT=1521))

                      (ADDRESS=(PROTOCOL=tcp)(HOST=10.179.112.155)(PORT=1521))

                      (ADDRESS=(PROTOCOL=tcp)(HOST=10.179.112.154)(PORT=1521))

                  )

                  (CONNECT_DATA=

                      (SERVICE_NAME=RXEST02.drdomain.com)

                  )

              )

       

      BUKPR=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orasp0019)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = bukpr.drdomain.com)))

       

       

       

       

      Regards,

      Purnima Johari