This discussion is archived
3 Replies Latest reply: Dec 8, 2013 9:01 PM by Karan Kukreja RSS

EBS with RAC autoconfig isues

Endeca Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points