3 Replies Latest reply on Dec 9, 2013 5:01 AM by Karan Kukreja

    EBS with RAC autoconfig isues

    999762

      Hi,


      environment information.


      EBS : 1213

      DB: 11203

      Grid: 11203

      Linux 5.4

      2 node RAC


      I am doing EBS database migration from single node to RAC 2 node cluster,i am able to bring up RAC  database without any issues able to run autoconfig successfully,however as per MOS 823587.1i

       

      I am trying to run autoconfig in Middletier,however its failing with TNS error.

       

      I am able to do tnping the RAC servers

       

      here is autoconfig error log, i changed tnsenires before running autoconfig, i was able to ping the DEV

       

      getConnectionUsingAppsJDBCConnector() -->

          APPS_JDBC_URL='jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=racn2-vip.ebiz.com)(PORT=1529))(ADDRESS=(PROTOCOL=tcp)(HOST=racn1-vip.ebiz.com)(PORT=1529)))(CONNECT_DATA=(SERVICE_NAME=DEV)))'

          Trying to connect using APPS_JDBC_URL

          Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection

          Trying to get connection using SID based connect descriptor

      getConnection() -->

          sDbHost    : racn1

          sDbDomain  : ebiz.com

          sDbPort    : 1529

          sDbSid     : DEV

          sDbUser    : APPS

          Trying to connect using SID...

      getConnectionUsingSID() -->

          JDBC URL: jdbc:oracle:thin:@racn1.ebiz.com:1529:DEV

          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

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

      SQLPLUS Executable : /u01/oracle/dev/apps/tech_st/10.1.2/bin/sqlplus

       

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Thu Nov 21 13:45:41 2013

       

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

       

      Enter value for 1: Enter value for 2: ERROR:

      ORA-12545: Connect failed because target host or object does not exist

       

       

      Unable to generate listener.ora from database

      Using default listener.ora file

       

      .end std out.

       

      .end err out.

                                                          

       

      StackTrace:

      1. java.lang.Exception: Error while generating listener.ora.

              at oracle.apps.ad.tools.configuration.NetServiceHandler.generateMiddleTierListener(NetServiceHandler.java:2495)

              at oracle.apps.ad.tools.configuration.NetServiceHandler.processNode(NetServiceHandler.java:2269)

              at oracle.apps.ad.tools.configuration.NetServiceHandler.main(NetServiceHandler.java:3010)

       

      Closing connection

      Connection Closed

      instantiate file:

         source : /u01/oracle/dev/apps/apps_st/appl/fnd/12.0.0/admin/template/tnsnames_80.ora

         dest   : /u01/oracle/dev/inst/apps/dev_racdev/ora/10.1.2/network/admin/tnsnames.ora

       

       

       

      JDBC URL information from Middletier.

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

       

        <jdbc_url oa_var="s_apps_jdbc_connect_descriptor">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=racn2-vip.ebiz.com)(PORT=1529))(ADDRESS=(PROTOCOL=tcp)(HOST=racn1-vip.ebiz.com)(PORT=1529)))(CONNECT_DATA=(SERVICE_NAME=DEV)))</jdbc_url>

               <jdbc_url_generation_check oa_var="s_jdbc_connect_descriptor_generation">true</jdbc_url_generation_check>

       

      Changed rac db server  names

            <oa_db_server>

               <dbhost oa_var="s_dbhost">racn1</dbhost>

               <domain oa_var="s_dbdomain">ebiz.com</domain>

               <dbsid oa_var="s_db_serv_sid">DEV</dbsid>

               <dbcset oa_var="s_dbcset">US7ASCII</dbcset>

            </oa_db_server>

       

      1. Tnsnames.ora from middletier.

       

       

      DEV=

              (DESCRIPTION=

                      (ADDRESS=(PROTOCOL=tcp)(HOST=racn1.ebiz.com)(PORT=1529))

                  (CONNECT_DATA=

                      (SERVICE_NAME=DEV)

                      (INSTANCE_NAME=DEV1)

                  )

              )

       

      DEV_BALANCE=

       

          (DESCRIPTION=

                (ADDRESS_LIST=

                    (LOAD_BALANCE=YES)

                    (FAILOVER=YES)

                  (ADDRESS=(PROTOCOL=tcp)(HOST=racn1.ebiz.com)(PORT=1529))

               )

             (CONNECT_DATA=

                      (SERVICE_NAME=DEV)

       

                  )

              )

       

      DEV1=

              (DESCRIPTION=

                      (ADDRESS=(PROTOCOL=tcp)(HOST=racn1.ebiz.com)(PORT=1529))

                  (CONNECT_DATA=

                      (SERVICE_NAME=DEV)

                      (INSTANCE_NAME=DEV1)

                  )

              )

       

      [applmgr@racdev admin]$

       

       

      Tnsping is working fine from middletier before autoconfig.

       

       

      [applmgr@racdev admin]$ tnsping DEV

       

      TNS Ping Utility for Linux: Version 10.1.0.5.0 - Production on 21-NOV-2013 19:33:30

       

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

       

      Used parameter files:

       

       

      Used TNSNAMES adapter to resolve the alias

      Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=racn1.ebiz.com)(PORT=1529)) (CONNECT_DATA= (SERVICE_NAME=DEV) (INSTANCE_NAME=DEV1)))

      OK (10 msec)

      [applmgr@racdev admin]$ tnsping DEV1

       

      TNS Ping Utility for Linux: Version 10.1.0.5.0 - Production on 21-NOV-2013 19:33:32

       

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

       

      Used parameter files:

       

       

      Used TNSNAMES adapter to resolve the alias

      Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=racn1.ebiz.com)(PORT=1529)) (CONNECT_DATA= (SERVICE_NAME=DEV) (INSTANCE_NAME=DEV1)))

      OK (10 msec)

      [applmgr@racdev admin]$

       

      followed 756050.1 and set the below Remote and local listeners.


       

      SQL> show parameter remote

       

      NAME                                 TYPE        VALUE

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

      remote_dependencies_mode             string      TIMESTAMP

      remote_listener                      string      DEV_remote

      remote_login_passwordfile            string      EXCLUSIVE

      remote_os_authent                    boolean     FALSE

      remote_os_roles                      boolean     FALSE

      result_cache_remote_expiration       integer     0

      SQL> show parameter local

       

      NAME                                 TYPE        VALUE

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

      local_listener                       string      DEV1_local

      log_archive_local_first              boolean     TRUE

      parallel_force_local                 boolean     FALSE

      SQL>


      INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME                                                        DATABASE_STATUS

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

                    1 DEV1             racn1.ebiz.com                                                ACTIVE

                    2 DEV2             racn2.ebiz.com                                                ACTIVE

       

      SQL>

       

      SQL> SQL> select * from v$active_instances;

       

      INST_NUMBER INST_NAME

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

                1 racn1.ebiz.com:DEV1

                2 racn2.ebiz.com:DEV2

       

       

      I am able to login RAC instances before running autoconfig on Middletiers.

       

       

      [applmgr@racdev ~]$ sqlplus apps/xxx@DEV

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Thu Nov 21 19:49:37 2013

       

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

       

       

      Connected to:

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

      With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

      Data Mining and Real Application Testing options

       

      SQL> exit

      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

      With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

      Data Mining and Real Application Testing options

       

       

       

       

      [applmgr@racdev ~]$ sqlplus apps/xxx@DEV1

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Thu Nov 21 19:49:40 2013

       

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

       

       

      Connected to:

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

      With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

      Data Mining and Real Application Testing options

       

      SQL> exit