This discussion is archived
3 Replies Latest reply: Jun 25, 2013 12:37 AM by user61555 RSS

adcrobj.sh fails with Connected to an idle instance.

user61555 Newbie
Currently Being Moderated

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 Newbie
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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.

Legend

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