3 Replies Latest reply: Jun 25, 2013 2:37 AM by user61555 RSS

    adcrobj.sh fails with Connected to an idle instance.

    user61555

      Hi Guru's,

       

      Am doing an upgrade from 11i to R12.

      I have a single node installation 32bit running EBS 11.5.10.2 with an 11.2.0.3 database (upgrade from 9.2.0.6 to 9.2.0.8) on RHEL 4.

      I followed all the steps on the upgrade document, am now running autoconfig on DB Tier and its failing with:--

      adcrobj.sh started at Mon Jun 24 14:38:02 GMT 2013

       

      Parameters passed are :

       

      The environment settings are as follows ...

       

             ORACLE_HOME : /home/oracle/selfdb/11.2.0

              ORACLE_SID : self

                TWO_TASK :

                    PATH : /usr/bin:/home/oracle/selfdb/11.2.0/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:.

         LD_LIBRARY_PATH : /home/oracle/selfdb/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/home/oracle/selfdb/11.2.0/ctx/lib

       

      SQLPLUS Executable : /home/oracle/selfdb/11.2.0/bin/sqlplus

       

       

      Enter the APPS username: apps

       

      Enter the APPS password:

       

      SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 24 14:38:10 2013

       

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

       

      Connected to an idle instance.

      begin

      *

      ERROR at line 1:

      ORA-01034: ORACLE not available

      Process ID: 0

      Session ID: 0 Serial number: 0

       

       

      ERROR:

      ORA-01012: not logged on

      Process ID: 0

      Session ID: 0 Serial number: 0

       

       

      Disconnected

      adcrobj.sh exiting with status 1

       

       

       

      The database is up and running thats for sure.

      sqlplus / as sysdba

       

      SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 24 14:42:48 2013

       

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

      SQL> select status from v$instance;

       

      STATUS

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

      OPEN

       

       

      STEPS I TOOK TO TRY AND RESOLVE THE PROBLEM BUT UNFORTUNATELY NONE OF THEM WORKED:-

       

      1)Connected to:

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

       

      SELECT * FROM v$timezone_file;

       

      FILENAME VERSION

      ——————– ———-

      timezlrg_14.dat 14


      2) Applied autoconfig patches


      3) replaced /nolog with
      sqlplus "/ as sysdba" @/<ORACLE_RDBMS_HOME>/appsutil/install/<CONTEXT_NAME>/adcrobj.sql "$user"


      4)  The s_global_database_name ,s_systemname, s_dbSid, s_dbSidLower, s_dbGlnam, s_InstName, and s_dbService variables all have the same value.


      Am attaching the adconfig.log file.


      Thanks,

      Rajab

        • 1. Re: adcrobj.sh fails with Connected to an idle instance.
          user61555

          Starting AutoConfig at Mon Jun 24 10:57:39 2013

          Using adconfig.pl version 115.83

           

              Classpath                   : /home/oracle/selfdb/11.2.0/jdk/jre/lib/rt.jar:/home/oracle/selfdb/11.2.0/jdk/lib/dt.jar:/home/oracle/selfdb/11.2.0/jdk/lib/tools.jar:/home/oracle/selfdb/11.2.0/jdbc/lib/ojdbc5.jar:/home/oracle/selfdb/11.2.0/appsutil/java/xmlparserv2.zip:/home/oracle/selfdb/11.2.0/appsutil/java:/home/oracle/selfdb/11.2.0/jlib/netcfg.jar:/home/oracle/selfdb/11.2.0/jlib/ldapjclnt11.jar

           

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

          Starting Utility to Report Version Conflicts at Mon Jun 24 16:57:39 GMT+03:00 2013

          Using VersionConflictListGenerator.java version 115.4

            

          All driver files processed.

           

          No version conflict encountered.

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

           

              Using Context file          : /home/oracle/selfdb/11.2.0/appsutil/self_self.xml

           

          Attempting to create a back up of the Context file

          Created back up file of name :

                /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/self_self.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    : SELF

              sDbDomain  : vesltech.com

              sDbPort    : 1521

              sDbSid     : self

              sDbUser    : apps

              Trying to connect using SID...

          getConnectionUsingSID() -->

              JDBC URL: jdbc:oracle:thin:@SELF.vesltech.com:1521:self

              Connection obtained

           

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

           

             OAM Context editing support feature: Enabled

             OAM Customization support feature  : Enabled

           

             File system template    : /home/oracle/selfdb/11.2.0/appsutil/template/adxdbctx.tmp

           

             Checking for customizations to Context template

             Customizations found    : None

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

             File system Context file :/home/oracle/selfdb/11.2.0/appsutil/self_self.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 Mon Jun 24 16:57:41 GMT+03:00 2013

               

                found context version     : 115.86

                available update version  : 115.86

           

          No updates to apply

           

          Ending Updates of Context file

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

           

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

          Config Tool CVMHelper started at Mon Jun 24 16:57:41 GMT+03:00 2013

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

           

           

          Updating local context file variables for Database Tier

          Listener name in context file: self

          Listener name in listener.ora: SELF

          New listener name and existing listener name are the same.

          No updates will be done for listener name.

          Reading listener port from /home/oracle/selfdb/11.2.0/network/admin/self_self/listener.ora

          New Port: 1521

          Old Port: 1521

          New Port and existing port are the same.

          The new listener name and existing listener name are the same.

          No updates will be done.

           

          Making database connection using DBUtil

           

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

                             ADX Database Utility                       

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

           

          getConnectionUsingAppsJDBCConnector() -->

              APPS_JDBC_URL='null'

              Trying to get connection using SID based connect descriptor

          getConnection() -->

              sDbHost    : SELF

              sDbDomain  : vesltech.com

              sDbPort    : 1521

              sDbSid     : self

              sDbUser    : apps

              Trying to connect using SID...

          getConnectionUsingSID() -->

              JDBC URL: jdbc:oracle:thin:@SELF.vesltech.com:1521:self

              Connection obtained

           

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

           

          Database connection successfully obtained

           

           

          Updating context file variables for Database Tier

          Checking for new context variables

          No new variables found in the context file

           

           

          Processing existing variables with updated defaults

          Updated  s_apps_version to 11.5.10.2

           

          Writing Context File back to File System

          Context file updated

          Closing connection

          Connection closed

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

          Starting Context Value Management System at Mon Jun 24 16:57:41 GMT+03:00 2013

          Using version 115.40

          Options:

           

             Force               : no

             Contextfile         : /home/oracle/selfdb/11.2.0/appsutil/self_self.xml

             Templatefile        : /home/oracle/selfdb/11.2.0/appsutil/template/adxdbctx.tmp

             ValueUpdateFile     : /home/oracle/selfdb/11.2.0/appsutil/template/adcvmdb.xml

           

          Verifying value management system requirements:

             ContextFile         : VALID

             Template File       : VALID

             ValueUpdateFile     : VALID

            

          Parsing the ValueUpdateFile

           

          [ s_contextfile ]

             Action             : seed

             Change reason      : Setting the location to what has been specified by user

             New value          : /home/oracle/selfdb/11.2.0/appsutil/self_self.xml

           

          [ s_adperlprg ]

             Action             : seed

             Change reason      : Setting the location to what has been specified by user

             New value          : /usr/bin/perl

           

          [ s_perl5lib ]

             Action             : seed

             Change reason      : Setting the location to what has been specified by user

             New value          : /home/oracle/selfdb/11.2.0/perl/lib/5.10.0:/home/oracle/selfdb/11.2.0/perl/lib/site_perl/5.10.0:/home/oracle/selfdb/11.2.0/appsutil/perl

           

          [ s_db_tnsadmin ]

             Action             : translate

             Change reason      : Resetting it to correct value

             Expected value     : [/home/oracle/selfdb/11.2.0/network/admin]

             Found value        : /home/oracle/selfdb/11.2.0/network/admin/self_self

             New value          : /home/oracle/selfdb/11.2.0/network/admin/self_self

             Check Condition    : Unconditional

             INFO               : Customer has the new value already in place - skipping

           

          [ s_db_tnsadmin ]

             Action             : translate

             Change reason      : Resetting it to correct value

             Expected value     : [/home/oracle/selfdb/11.2.0/network/admin/self]

             Found value        : /home/oracle/selfdb/11.2.0/network/admin/self_self

             New value          : /home/oracle/selfdb/11.2.0/network/admin/self_self

             Check Condition    : Unconditional

             INFO               : Customer has the new value already in place - skipping

           

          [ s_db_linkctrl ]

             Action             : translate

             Change reason      : It should be unset in AutoConfig enabled RDBMS setup

             Expected value     : [L_PTHREADS_D7]

             Found value        :

             New value          :

             Check Condition    : Unconditional

             INFO               : Customer has the new value already in place - skipping

           

          [ s_systemname ]

             Action             : translate

             Change reason      : Resetting it to correct value

             Expected value     : [self]

             Found value        : self

             New value          : self

             Check Condition    : Unconditional

            

          [ s_db_nlslang ]

             Action             : translate

             Change reason      : Resetting it to correct value

             Expected value     : [American_America.%s_at_cset%]

             Found value        : American_America.US7ASCII

             New value          : American_America.US7ASCII

             Check Condition    : Unconditional

             INFO               : Customer has the new value already in place - skipping

           

          [ s_db_path ]

             Action             : translate

             Change reason      : Environment Variables should be updated through the context editor

             Expected value     : [/home/oracle/selfdb/11.2.0/bin:/usr/bin:/usr/sbin:/home/oracle/selfdb/11.2.0/jdk/bin:$PATH]

             Found value        : /home/oracle/selfdb/11.2.0/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin

             New value          : /home/oracle/selfdb/11.2.0/bin:/usr/bin:/usr/sbin:/home/oracle/selfdb/11.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:$PATH

             Check Condition    : Unconditional

             INFO               : Customer specified value - skipping

           

          [ s_db_ldlib ]

             Action             : translate

             Change reason      : Environment Variables should be updated through the context editor

             Expected value     : [/home/oracle/selfdb/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib]

             Found value        : /home/oracle/selfdb/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/home/oracle/selfdb/11.2.0/ctx/lib

             New value          : /home/oracle/selfdb/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/home/oracle/selfdb/11.2.0/lib:/usr/dt/lib:/home/oracle/selfdb/11.2.0/ctx/lib

             Check Condition    : Unconditional

             INFO               : Customer specified value - skipping

           

          [ s_db_sga_target ]

             Action             : translate

             Change reason      : This is recommended by the performance team

             Expected value     : [570M]

             Found value        : 1G

             New value          : 1G

             Check Condition    : Unconditional

             INFO               : Customer has the new value already in place - skipping

           

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

          [ Config tool : /home/oracle/selfdb/11.2.0/appsutil/bin/adgentns.pl ]

             Command            : /usr/bin/perl -I /home/oracle/selfdb/11.2.0/perl/lib/5.10.0 -I /home/oracle/selfdb/11.2.0/perl/lib/site_perl/5.10.0 -I /home/oracle/selfdb/11.2.0/appsutil/perl  /home/oracle/selfdb/11.2.0/appsutil/bin/adgentns.pl PASSWORD  contextfile=/home/oracle/selfdb/11.2.0/appsutil/self_self.xml  logdir=/home/oracle/selfdb/11.2.0/appsutil/log/self_self/06241057  outdir=/home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057

             Action             : execute

           

          SCRIPT RETURNED:

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

                             Generate Tns Names

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

              Classpath                   : /home/oracle/selfdb/11.2.0/jdk/jre/lib/rt.jar:/home/oracle/selfdb/11.2.0/jdk/lib/dt.jar:/home/oracle/selfdb/11.2.0/jdk/lib/tools.jar:/home/oracle/selfdb/11.2.0/jdbc/lib/ojdbc5.jar:/home/oracle/selfdb/11.2.0/appsutil/java/xmlparserv2.zip:/home/oracle/selfdb/11.2.0/appsutil/java:/home/oracle/selfdb/11.2.0/jlib/netcfg.jar:/home/oracle/selfdb/11.2.0/jlib/ldapjclnt11.jar

           

          Loading ORACLE_HOME environment from /home/oracle/selfdb/11.2.0

          Logfile: /home/oracle/selfdb/11.2.0/appsutil/log/self_self/06241057/NetServiceHandler.log

           

          adgentns.pl exiting with status 0

          ERRORCODE = 0 ERRORCODE_END

          .end std out.

           

          .end err out.

           

           

             Result             : SUCCEEDED

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

           

          Ending Context Value Management System.

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

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

          Uploading file system Context file and its templates to the database

           

           

             Context file            :

                  /home/oracle/selfdb/11.2.0/appsutil/self_self.xml

           

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

                             ADX Database Utility                       

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

           

          getConnectionUsingAppsJDBCConnector() -->

              APPS_JDBC_URL='null'

              Trying to get connection using SID based connect descriptor

          getConnection() -->

              sDbHost    : SELF

              sDbDomain  : vesltech.com

              sDbPort    : 1521

              sDbSid     : self

              sDbUser    : apps

              Trying to connect using SID...

          getConnectionUsingSID() -->

              JDBC URL: jdbc:oracle:thin:@SELF.vesltech.com:1521:self

              Connection obtained

           

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

           

             Result                  : Successfully uploaded the Context file to the DataBase

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

           

           

             Context template file   :

                  /home/oracle/selfdb/11.2.0/appsutil/template/adxdbctx.tmp

           

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

                             ADX Database Utility                       

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

           

          getConnectionUsingAppsJDBCConnector() -->

              APPS_JDBC_URL='null'

              Trying to get connection using SID based connect descriptor

          getConnection() -->

              sDbHost    : SELF

              sDbDomain  : vesltech.com

              sDbPort    : 1521

              sDbSid     : self

              sDbUser    : apps

              Trying to connect using SID...

          getConnectionUsingSID() -->

              JDBC URL: jdbc:oracle:thin:@SELF.vesltech.com:1521:self

              Connection obtained

           

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

           

             Result                  : Successfully uploaded the Context template file to the DataBase

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

           

           

             Uploading the Context information template to the DataBase

           

             Context information template :

                  /home/oracle/selfdb/11.2.0/appsutil/template/adxdbinf.tmp

           

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

                             ADX Database Utility                       

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

           

          getConnectionUsingAppsJDBCConnector() -->

              APPS_JDBC_URL='null'

              Trying to get connection using SID based connect descriptor

          getConnection() -->

              sDbHost    : SELF

              sDbDomain  : vesltech.com

              sDbPort    : 1521

              sDbSid     : self

              sDbUser    : apps

              Trying to connect using SID...

          getConnectionUsingSID() -->

              JDBC URL: jdbc:oracle:thin:@SELF.vesltech.com:1521:self

              Connection obtained

           

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

           

             Result                  : Successfully uploaded the Context information template file to the DataBase

           

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

          Updating rdbms version in Context file to db112

          Updating rdbms type in Context file to 32 bits

          Configuring templates from ORACLE_HOME ...

          Processing DriverFile = /home/oracle/selfdb/11.2.0/appsutil/template/addbtmpl.drv

          AutoConfig Profile Phase

          Running Instantiation Drivers for AppsUtil

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adlicnse.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adlicnse.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adlicnse.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adlicnse.sql

             setting permissions: 600

             setting ownership: oracle:oracle

          File /home/oracle/selfdb/11.2.0/network/admin/self_self/tnsnames.ora of type INSTALL already exists, this file will not be instantiated.

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adexecsql.pl

             dest   : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adexecsql.pl

             backup : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adexecsql.pl to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adexecsql.pl

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adstopdb.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adstopdb.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adstopdb.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adstopdb.sql

             setting permissions: 600

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adstrtdb.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adstrtdb.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adstrtdb.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adstrtdb.sql

             setting permissions: 600

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/addbccnv.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/addbccnv.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/addbccnv.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/addbccnv.sql

             setting permissions: 600

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adclobconv.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adclobconv.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adclobconv.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adclobconv.sql

             setting permissions: 600

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adclobtmp.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adclobtmp.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adclobtmp.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adclobtmp.sql

             setting permissions: 600

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adpreclone.pl

             dest   : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adpreclone.pl

             backup : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adpreclone.pl to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adpreclone.pl

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adcrobj.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcrobj.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcrobj.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adcrobj.sql

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adchknls.pl

             dest   : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adchknls.pl

             backup : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adchknls.pl to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adchknls.pl

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/ad8idbux.env

             dest   : /home/oracle/selfdb/11.2.0/self_self.env

             backup : /home/oracle/selfdb/11.2.0/self_self.env to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/self_self.env

             setting permissions: 644

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adupdlib_ux.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adupdlib.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adupdlib.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adupdlib.sql

             setting permissions: 600

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adcrdb.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcrdb.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcrdb.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adcrdb.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adsvdb.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adsvdb.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adsvdb.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adsvdb.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adsvdlsn.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adsvdlsn.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adsvdlsn.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adsvdlsn.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adsvdcnv.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adsvdcnv.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adsvdcnv.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adsvdcnv.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/addbprf.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/addbprf.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/addbprf.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/addbprf.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/addbprf.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/addbprf.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/addbprf.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/addbprf.sql

             setting permissions: 600

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/addbupdgsm.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/addbupdgsm.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/addbupdgsm.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/addbupdgsm.sql

             setting permissions: 600

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/afdbprf.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/afdbprf.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/afdbprf.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/afdbprf.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/afdbprf.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/afdbprf.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/afdbprf.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/afdbprf.sql

             setting permissions: 600

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/addbctl.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/addbctl.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/addbctl.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/addbctl.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/addlnctl.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/addlnctl.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/addlnctl.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/addlnctl.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adlsnodes_ux.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adlsnodes.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adlsnodes.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adlsnodes.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adlnkoh.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/adlnkoh.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/adlnkoh.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adlnkoh.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adcrdbrdlg.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcrdbrdlg.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcrdbrdlg.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adcrdbrdlg.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adautocfg_ux.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adautocfg.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adautocfg.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adautocfg.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adcrobj.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcrobj.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcrobj.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adcrobj.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          File /home/oracle/selfdb/11.2.0/dbs/initself.ora of type INSTALL already exists, this file will not be instantiated.

          File /home/oracle/selfdb/11.2.0/network/admin/self_self/listener.ora of type INSTALL already exists, this file will not be instantiated.

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/txkcreateACL.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/txkcreateACL.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/txkcreateACL.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/txkcreateACL.sql

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/txkcreateACL.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/txkcreateACL.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/txkcreateACL.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/txkcreateACL.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/afmkinit.sh

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/afmkinit.sh

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/afmkinit.sh to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/afmkinit.sh

             setting permissions: 700

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/config_ux.c

             dest   : /home/oracle/selfdb/11.2.0/rdbms/lib/config.c

             backup : /home/oracle/selfdb/11.2.0/rdbms/lib/config.c to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/config.c

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adcmclean.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcmclean.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcmclean.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adcmclean.sql

             setting permissions: 600

             setting ownership: oracle:oracle

          instantiate file:

             source : /home/oracle/selfdb/11.2.0/appsutil/template/adcctclean.sql

             dest   : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcctclean.sql

             backup : /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcctclean.sql to /home/oracle/selfdb/11.2.0/appsutil/out/self_self/06241057/adcctclean.sql

             setting permissions: 600

             setting ownership: oracle:oracle

          AutoConfig Setup Phase

          Running Setup Process 1 of 2 for AppsUtil

          Executing script in InstantiateFile:

          /usr/bin/perl -I /home/oracle/selfdb/11.2.0/perl/lib/5.10.0 -I /home/oracle/selfdb/11.2.0/perl/lib/site_perl/5.10.0 -I /home/oracle/selfdb/11.2.0/appsutil/perl /home/oracle/selfdb/11.2.0/appsutil/scripts/self_self/adchknls.pl

           

          script returned:

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

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

                       Validating information needed for NLS........

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

          DATABASE version : db112

           

          Looking for the directory : /home/oracle/selfdb/11.2.0/nls/data/9idata

          Directory exists

           

          Looking for file : /home/oracle/selfdb/11.2.0/nls/data/old/cr9idata.pl

          File exists

           

          Validation complete

          ERRORCODE = 0 ERRORCODE_END

          .end std out.

           

          .end err out.

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

           

           

          AutoConfig Setup Phase

          Running Setup Process 2 of 2 for AppsUtil

          Executing script in InstantiateFile:

          /home/oracle/selfdb/11.2.0/appsutil/install/self_self/afmkinit.sh

           

          script returned:

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

           

          afmkinit.sh started at Mon Jun 24 10:58:18 GMT 2013

           

           

          The environment settings are as follows ...

           

                 ORACLE_HOME : /home/oracle/selfdb/11.2.0

                  ORACLE_SID : self

                    TWO_TASK :

                        PATH : /usr/bin:/home/oracle/selfdb/11.2.0/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:.

                Library Path : /home/oracle/selfdb/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/home/oracle/selfdb/11.2.0/ctx/lib

           

          afmkinit.sh exiting with status 0

           

          .end std out.

           

          .end err out.

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

           

           

          AutoConfig Profile Phase

          Running Profile Process 1 of 1 for AppsUtil

          Executing script in InstantiateFile:

          /home/oracle/selfdb/11.2.0/appsutil/install/self_self/afdbprf.sh

           

          script returned:

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

           

          afdbprf.sh started at Mon Jun 24 10:58:19 GMT 2013

           

           

          The environment settings are as follows ...

           

                 ORACLE_HOME : /home/oracle/selfdb/11.2.0

                  ORACLE_SID : self

                        PATH : /usr/bin:/home/oracle/selfdb/11.2.0/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:.

                Library Path : /home/oracle/selfdb/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/home/oracle/selfdb/11.2.0/ctx/lib

           

          Executable : /home/oracle/selfdb/11.2.0/bin/sqlplus

           

           

          SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 24 10:58:19 2013

           

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

           

          Enter value for 1: Enter value for 2: Enter value for 3: Connected.

          Updated profile option value - 1 row(s) updated

          Application Id : 0

          Profile Name : FND_DB_WALLET_DIR

          Level Id : 10001

          New Value : /home/oracle/selfdb/11.2.0/appsutil/wallet

          Old Value : /home/oracle/selfdb/11.2.0/appsutil/wallet

          Updated profile option value - 1 row(s) updated

          Application Id : 174

          Profile Name : ECX_UTL_XSLT_DIR

          Level Id : 10001

          New Value : /usr/tmp

          Old Value : /usr/tmp

          Updated profile option value - 1 row(s) updated

          Application Id : 174

          Profile Name : ECX_UTL_LOG_DIR

          Level Id : 10001

          New Value : /usr/tmp

          Old Value : /usr/tmp

          Updated profile option value - 1 row(s) updated

          Application Id : 0

          Profile Name : BIS_DEBUG_LOG_DIRECTORY

          Level Id : 10001

          New Value : /usr/tmp

          Old Value : /usr/tmp

          Updated profile option value - 1 row(s) updated

          Application Id : 1

          Profile Name : UTL_FILE_LOG

          Level Id : 10001

          New Value : /usr/tmp, /usr/tmp,

          /home/oracle/selfdb/9.2.0/appsutil/outbound/self_self

          Old Value : /usr/tmp, /usr/tmp,

          /home/oracle/selfdb/9.2.0/appsutil/outbound/self_self

          Updated profile option value - 1 row(s) updated

          Application Id : 1

          Profile Name : UTL_FILE_OUT

          Level Id : 10001

          New Value : /usr/tmp

          Old Value : /usr/tmp

          Updated profile option value - 1 row(s) updated

          Application Id : 8405

          Profile Name : IGS_PS_EXP_DIR_PATH

          Level Id : 10001

          New Value : /usr/tmp

          Old Value : /usr/tmp

           

          PL/SQL procedure successfully completed.

           

           

          Commit complete.

           

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

          With the Partitioning, OLAP, Data Mining and Real Application Testing options

          ERRORCODE = 0 ERRORCODE_END

          .end std out.

           

          .end err out.

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

           

           

          AutoConfig Services Phase

          Running Service Process 1 of 2 for AppsUtil

          Executing script in InstantiateFile:

          /home/oracle/selfdb/11.2.0/appsutil/install/self_self/adcrobj.sh

           

          script returned:

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

           

          adcrobj.sh started at Mon Jun 24 10:58:20 GMT 2013

           

          Parameters passed are : -nopromptmsg

           

          The environment settings are as follows ...

           

                 ORACLE_HOME : /home/oracle/selfdb/11.2.0

                  ORACLE_SID : self

                    TWO_TASK :

                        PATH : /usr/bin:/home/oracle/selfdb/11.2.0/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:.

             LD_LIBRARY_PATH : /home/oracle/selfdb/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/home/oracle/selfdb/11.2.0/ctx/lib

           

          SQLPLUS Executable : /home/oracle/selfdb/11.2.0/bin/sqlplus

           

           

          SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 24 10:58:20 2013

           

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

           

          Connected to an idle instance.

          begin

          *

          ERROR at line 1:

          ORA-01034: ORACLE not available

          Process ID: 0

          Session ID: 0 Serial number: 0

           

           

          ERROR:

          ORA-01012: not logged on

          Process ID: 0

          Session ID: 0 Serial number: 0

           

           

          Disconnected

          adcrobj.sh exiting with status 1

          ERRORCODE = 1 ERRORCODE_END

          .end std out.

           

          .end err out.

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

           

           

          AutoConfig Services Phase

          Running Service Process 2 of 2 for AppsUtil

          Executing script in InstantiateFile:

          /home/oracle/selfdb/11.2.0/appsutil/install/self_self/txkcreateACL.sh

           

          script returned:

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

           

          You are running txkcreateACL.sh version 115.1

           

           

          The environment settings are as follows ...

           

                 ORACLE_HOME : /home/oracle/selfdb/11.2.0

                  ORACLE_SID : self

                        PATH : /usr/bin:/home/oracle/selfdb/11.2.0/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:.

          Executable : /home/oracle/selfdb/11.2.0/bin/sqlplus

           

           

          Executing txkcreateACL.sql ...

           

           

          SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 24 10:58:20 2013

           

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

           

          Connected to an idle instance.

          DECLARE

          *

          ERROR at line 1:

          ORA-01034: ORACLE not available

          Process ID: 0

          Session ID: 0 Serial number: 0

           

           

          ERROR:

          ORA-01012: not logged on

          Process ID: 0

          Session ID: 0 Serial number: 0

           

           

          Disconnected

           

          txkcreateACL.sh: exiting with status 1

           

           

          .end std out.

           

          .end err out.

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

           

           

           

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

          Starting Restore Profile utility at Mon Jun 24 16:58:20 GMT+03:00 2013

          Using version 115.6

           

           

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

                             ADX Database Utility                       

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

           

          getConnection() -->

              sDbHost    : SELF

              sDbDomain  : vesltech.com

              sDbPort    : 1521

              sDbSid     : self

              sDbUser    : apps

              Trying to connect using SID...

          getConnectionUsingSID() -->

              JDBC URL: jdbc:oracle:thin:@SELF.vesltech.com:1521:self

              Connection obtained

           

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

           

              Verifying connection to the Database   : Established

              Restore Profile Feature                : Disabled

           

              No Restore Profile file created.

           

           

          Restore Profile utility ran successfully

           

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

           

           

           

           

          [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>

           

            [APPLY PHASE]

            AutoConfig could not successfully execute the following scripts:

              Directory: /home/oracle/selfdb/11.2.0/appsutil/install/self_self

                adcrobj.sh              INSTE8_APPLY       1

                txkcreateACL.sh         INSTE8_APPLY       1

           

           

          AutoConfig is exiting with status 2

          • 2. Re: adcrobj.sh fails with Connected to an idle instance.
            alvaromiranda

            you need to use apps/apps user if that is what is failing

             

            did you check you have listener up and running and the listener is the one from the right home?

            • 3. Re: adcrobj.sh fails with Connected to an idle instance.
              user61555

              Hi Alvaro,

               

              Yes the listener is up and running.

              [oracle@self bin]$ lsnrctl status self

               

              LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 25-JUN-2013 10:26:18

               

              Copyright (c) 1991, 2011, Oracle.  All rights reserved.

               

              Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCself))

              STATUS of the LISTENER

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

              Alias                     self

              Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

              Start Date                24-JUN-2013 10:45:53

              Uptime                    0 days 17 hr. 40 min. 25 sec

              Trace Level               off

              Security                  ON: Local OS Authentication

              SNMP                      OFF

              Listener Parameter File   /home/oracle/selfdb/11.2.0/network/admin/self_self/listener.ora

              Listener Log File         /home/oracle/selfdb/11.2.0/log/diag/tnslsnr/self/self/alert/log.xml

              Listening Endpoints Summary...

                (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCself)))

                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=self.vesltech.com)(PORT=1521)))

              Services Summary...

              Service "PLSExtProc" has 1 instance(s).

                Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

              Service "self" has 2 instance(s).

                Instance "self", status UNKNOWN, has 1 handler(s) for this service...

                Instance "self", status READY, has 1 handler(s) for this service...

              The command completed successfully.

               

              Let me try and edit the file and see if apps/apps will work.