2 Replies Latest reply on Jan 15, 2016 6:46 AM by Narsi M-Oracle

    ADAUTOCFG Failed with adgendbc.sh afwebprf.sql afcpctx.sh in EBS R12.2

    Ramaraju

      Hi,

      We are upgrading 11i to R12.2.x, After running R12.2 software with upgrade we are unable to start the R12.2 application services.

      We find that /oracle/fs1/inst/apps/CONTEXT/ora/10.1.2/network/admin/listener.ora is missing.

      For this executing adadutocfg.sh, it fails with "adgendbc.sh afwebprf.sql afcpctx.sh".

       

      adgendbc.sh showing following error.

      Unique constraint error (00001) is OK if key already exists

      Creating the DBC file...

      java.sql.SQLException: ORA-01403: no data found

      ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 91

      ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 136

      ORA-06512: at line 1

      - Database error modifying the server

      ADD call failed with exit code 1

      Updating Server Security Authentication

      java.sql.SQLRecoverableException: IO Error: Invalid number format for port number

      Database connection to jdbc:oracle:thin:@host_name:port_number:database failed

      Updating Server Security Authentication failed with exit code 1

      Restoring DBC file from backed up location /oracle/fs1/inst/apps/ARCH_archapp1/appltmp/TXK/ARCH_Thu_Jan_14_19_32_2016.dbc

      adgendbc.sh ended at Thu Jan 14 19:32:21 EST 2016

      adgendbc.sh exiting with status 1

      ERRORCODE = 1 ERRORCODE_END

       

      Thanks,

      Ramaraju

        • 1. Re: ADAUTOCFG Failed with adgendbc.sh afwebprf.sql afcpctx.sh in EBS R12.2
          Ramaraju

          $ perl adgentns.pl

          Enter the APPS user password:

          ##########################################################################

                             Generate Tns Names

          ##########################################################################

          Logfile:  ..../admin/log/01142050/NetServiceHandler.log

            Classpath                   : ..../shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/.../fs1/EBSapps/comn/java/classes

           

          Updating s_tnsmode to 'generateTNS'

          UpdateContext exited with status: 0

          AC-50480: Internal error occurred: java.sql.SQLException: ORA-06550: line 1, column 7:

          PLS-00306: wrong number or types of arguments in call to 'REGISTER_APPNODE'

          ORA-06550: line 1, column 7:

          PL/SQL: Statement ignored

           

          Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates

          Instantiating Tools tnsnames.ora

          Tools tnsnames.ora instantiated

          Error in instantiating web tnsnames.ora:

           

          adgentns.pl exiting with status 2

          ERRORCODE = 2 ERRORCODE_END

           

          For this I have found Doc ID 1459109.1 Is this suitable for my issue?


          Thanks,

          Ramaraju

          • 2. Re: ADAUTOCFG Failed with adgendbc.sh afwebprf.sql afcpctx.sh in EBS R12.2
            Narsi M-Oracle

            Hello Ramaraju,

             

            Ideally, you are not supposed to start services until all upgrade  activities are completed.

            Currently you are stuck at which stage of the upgrade ?

            Did you apply Online Enablement Patch and complete the Post upgrade tasks ?

             

            Best Regards,

            Narsi Mogulapalli