7 Replies Latest reply on Aug 29, 2011 5:03 AM by 829303

    11gR2 upgrade

    829303
      Hi guys

      I upgraded my db from 11.1.0 to 11.2.0. Ran catupgrd.sql with no errors. Then ran the utlrp.sql. Now I would like to run autoconfig bit it completes with errors.

      Starting AutoConfig at Fri Aug 26 10:54:57 2011
      Using adconfig.pl version 120.26

      Classpath : :/u01/oracle/R12/db/tech_st/11.2.0/jdbc/lib/ojdbc6.jar:/u01/oracle/R12/db/tech_st/11.2.0/appsutil/java/xmlparserv2.jar:/u01/oracle/R12/db/tech_st/11.2.0/appsutil/java:/u01/oracle/R12/db/tech_st/11.2.0/jlib/netcfg.jar

      ===========================================================================
      Starting Utility to Report Version Conflicts at Fri Aug 26 10:54:59 SAST 2011
      Using VersionConflictListGenerator.java version 120.3

      All driver files processed.

      No version conflict encountered.
      ===========================================================================

      Using Context file : /u01/oracle/R12/db/tech_st/11.2.0/appsutil/R12_db12.xml

      Attempting to create a back up of the Context file
      Created back up file of name :
      /u01/oracle/R12/db/tech_st/11.2.0/appsutil/out/R12_db12/08261054/R12_db12.xml
      ===========================================================================
      Starting synchronization of file system Context file and its templates with those in the database

      Database connection : Established

      ---------------------------------------------------------------
      ADX Database Utility
      ---------------------------------------------------------------

      getConnectionUsingAppsJDBCConnector() -->
      APPS_JDBC_URL='null'
      Trying to get connection using SID based connect descriptor
      getConnection() -->
      sDbHost : db12.tigerbrands.net
      sDbDomain : tigerbrands.net
      sDbPort : 1521
      sDbSid : R12
      sDbUser : apps
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@db12.tigerbrands.net.tigerbrands.net:1521:R12
      Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection
      Trying to connect using SID as ServiceName
      getConnectionUsingServiceName() -->

      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db12.tigerbrands.net.tigerbrands.net)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=R12)))
      Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection
      Trying to connect using SID as ServiceName.DomainName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db12.tigerbrands.net.tigerbrands.net)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=R12.tigerbrands.net)))
      Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection
      Connection could not be obtained; returning null

      -------------------ADX Database Utility Finished---------------

      Connection could not be obtained using s_dbhost
      Trying to connect using s_hostname
      getConnection() -->
      sDbHost : db12
      sDbDomain : tigerbrands.net
      sDbPort : 1521
      sDbSid : R12
      sDbUser : apps
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@db12.tigerbrands.net:1521:R12
      Connection obtained

      -------------------ADX Database Utility Finished---------------

      OAM Context editing support feature: Enabled
      OAM Customization support feature : Enabled

      File system template : /u01/oracle/R12/db/tech_st/11.2.0/appsutil/template/adxdbctx.tmp

      Checking for customizations to Context template
      Customizations found : None
      ----------------------------------------------------------------
      File system Context file :/u01/oracle/R12/db/tech_st/11.2.0/appsutil/R12_db12.xml

      Checking the Context file for possible updates from the Database
      Comparing the Context file stored in database with the Context file in the file system

      Result : The two Context files are in sync

      ===========================================================================
      Starting Updates of Context file Fri Aug 26 10:55:02 SAST 2011

      found context version : 120.34.12010000.2
      available update version : 120.34.12010000.2

      No updates to apply

      Ending Updates of Context file
      ===========================================================================

      ===========================================================================
      Config Tool CVMHelper started at Fri Aug 26 10:55:02 SAST 2011
      ===========================================================================


      Updating local context file variables for Database Tier
      Getting listener port from /u01/oracle/R12/db/tech_st/11.2.0/network/admin/R12_db12/listener.ora
      Exception occurred while preseeding variables in the context file: java.lang.reflect.InvocationTargetException


      StackTrace:
      java.lang.reflect.InvocationTargetException
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
      at java.lang.reflect.Constructor.newInstance(Unknown Source)
      at oracle.apps.ad.tools.configuration.CVMHelper.getCurrentPort(CVMHelper.java:601)
      at oracle.apps.ad.tools.configuration.CVMHelper.processDBTierListener(CVMHelper.java:488)
      at oracle.apps.ad.tools.configuration.CVMHelper.processLocalConfig(CVMHelper.java:771)
      at oracle.apps.ad.context.CtxValueMgt.preSeed2Ctx(CtxValueMgt.java:1813)
      at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1610)
      at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:755)
      Caused by: java.lang.UnsatisfiedLinkError: oracle.net.common.NetGetEnv.get(Ljava/lang/String;)Ljava/lang/String;
      at oracle.net.common.NetGetEnv.get(Native Method)
      at oracle.net.config.Config.getNetDir(Unknown Source)
      at oracle.net.config.Config.initConfig(Unknown Source)
      at oracle.net.config.Config.<init>(Unknown Source)
      ... 10 more

      ===========================================================================
      Starting Context Value Management System at Fri Aug 26 10:55:02 SAST 2011
      Using version 120.13
      Options:
      -------------------ADX Database Utility Finished---------------

      Verifying connection to the Database : Established
      Restore Profile Feature : Enabled

      Restore Profile file created at : /u01/oracle/R12/db/tech_st/11.2.0/appsutil/out/R12_db12/08261054/restore.sql

      Purging the table ADX_PRE_AUTOCONFIG of rows containing attribute R12_db12
      Purging completed

      Restore Profile utility ran successfully

      ===========================================================================


      adcvmlog.xml renamed to /u01/oracle/R12/db/tech_st/11.2.0/appsutil/log/R12_db12/08261054/adcvmlog.xml.08261055


      [AutoConfig Error Report]
      The following report lists errors AutoConfig encountered during each
      phase of its execution. Errors are grouped by directory and phase.
      The report format is:
      <filename> <phase> <return code where appropriate>

      [PROFILE PHASE]
      AutoConfig could not successfully execute the following scripts:
      Directory: /u01/oracle/R12/db/tech_st/11.2.0/appsutil/install/R12_db12
      afdbprf.sh INSTE8_PRF 1

      [APPLY PHASE]
      AutoConfig could not successfully execute the following scripts:
      Directory: /u01/oracle/R12/db/tech_st/11.2.0/appsutil/install/R12_db12
      adcrobj.sh INSTE8_APPLY 1


      AutoConfig is exiting with status 2


      Please can someone shed some light. I don't know where to start :(

      Regards
        • 1. Re: 11gR2 upgrade
          12cdb
          It seems there is a problem in connecting to the database..
          .DbUser : apps
          Trying to connect using SID...
          getConnectionUsingSID() -->
          JDBC URL: jdbc:oracle:thin:@db12.tigerbrands.net.tigerbrands.net:1521:R12
          Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection
          Trying to connect using SID as ServiceName
          getConnectionUsingServiceName() -->

          JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db12.tigerbrands.net.tigerbrands.net)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=R12)))
          Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection
          Trying to connect using SID as ServiceName.DomainName
          getConnectionUsingServiceName() -->
          Can you please check if the ORACLE_HOME & ORACLE_SID variable are set.
          • 2. Re: 11gR2 upgrade
            EBSDBA
            Hi,
            Please search in the log file for details on scripts

            afdbprf.sh
            and
            adcrobj.sh
            Thanks
            • 3. Re: 11gR2 upgrade
              EBSDBA
              Hi,
              Please search in the log file for details on scripts

              afdbprf.sh
              and
              adcrobj.sh
              Thanks
              • 4. Re: 11gR2 upgrade
                EBSDBA
                Hi,
                Please search in the log file for details on scripts

                afdbprf.sh
                and
                adcrobj.sh
                Thanks
                • 5. Re: 11gR2 upgrade
                  829303
                  Thanks for the reply.

                  But I have managed. I had to load a patch on the apps and recreate the appsutil.zip

                  regards
                  • 6. Re: 11gR2 upgrade
                    EBSDBA
                    Hi,
                    Could you please share us which patch you have applied and close this thread, so that it will be helpful to others as well.

                    Thanks
                    • 7. Re: 11gR2 upgrade
                      829303
                      Good day

                      I loaded patch 7651166 - Oracle Techstack Release Update Pack 2 for 12.1 (R12.TXK.B.DELTA.2)

                      After loading the patch, you need to recreate the appsutil.zip and copy it over to the db and rerun autoconfig.

                      Regards