11 Replies Latest reply on Feb 14, 2016 12:48 AM by VishnuVinnakota

    cloning

    2907350

      Hello,

       

      when running autocfg I am getting the error below. Do I omit and proceed? Is it serious?

       

      AutoConfig is configuring the Database environment...

       

       

      AutoConfig will consider the custom templates if present.

              Using ORACLE_HOME location : /u01/oracle/PREPROD/db/11.2.0

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

       

       

              Using Context file          : /u01/oracle/PREPROD/db/11.2.0/appsutil/PREPROD_erppreprod.xml

       

       

      Context Value Management will now update the Context file

      UnsatisfiedLinkError exception loading native library: njni11

      java.lang.UnsatisfiedLinkError: /u01/oracle/PREPROD/db/11.2.0/lib/libnjni11.so: /u01/oracle/PREPROD/db/11.2.0/lib/libnjni11.so: wrong ELF class: ELFCLASS64 (Possible cause: architecture word width mismatch)

        • 1. Re: cloning
          Bashar.

          Hi,

           

          Do you have a folder "jre" in $ORACLE_HOME/appsutil?

          If yes then this is the problem. For 11gR2, you should not install JRE under the appsutil folder.

          Please review this document for the detailed solution steps:

           

          Running Autoconfig on DB Tier Errors With: Unsatisfiedlinkerror Exception Loading Native Library: Njni11 (Doc ID 1103163.1)

           

          Regards,

          Bashar

          • 2. Re: cloning
            2907350

            EBSR12.2.4 (source)

            Oracle database 11gR2

            Oracle Linux 6.4

            source database instance: PROD

             

            Hi,

             

            where should I place the jre folder?

             

            I am following the steps in Oracle Apps DBA: Clone Oracle Apps R12 (Hot)

             

            In step 5, how do I set PATH and LD_LIBRARY_PATH and ORACLE_SID?

            when I do startup nomount it gives me:

            ORA-01078: failure in processing system parameters

            LRM-00109: could not open parameter file '/u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora'

             

            in the dbs folder there is initPROD.ora.

             

            Rgds

            Roshan

            • 3. Re: cloning
              Ariz - Apps DBA

              Hi Roshan

              Since you did not set those paths, that is why you are getting error. Just export all those paths with appropriate values.

               

              Regards

              Ariz

              • 4. Re: cloning
                Ariz - Apps DBA

                Hi

                The export values should be as follows:

                export ORACLE_HOME=/u01/oracle/PREPROD/db/11.2.0

                export ORACLE_SID=PREPROD

                export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

                export LD_LIBRARY_PATH=$ORACLE_HOME/lib

                 

                Cross check as per your environment.

                 

                Regards

                Ariz

                1 person found this helpful
                • 5. Re: cloning
                  2907350

                  Hello,

                   

                  thanks for your reply. I managed to access sqlplus. When i startup nomount it is giving me

                  ORA-00845: MEMORY_TARGET not supported on this system

                   

                  The PROD(source instance) was given 128 GB RAM. The PREPROD instance was given 32 GB RAM. Do I need to modify the initPROD.ora in dbs folder?

                   

                  Rgds,

                  Roshan

                  • 6. Re: cloning
                    Bashar.

                    What is the value of the MEMORY_TARGET parameter in your pfile/spfile?

                    Please post the value of other memory related parameters, too.

                     

                    Regards,

                    Bashar

                    • 7. Re: cloning
                      2907350

                      Hello,

                       

                      I increased the size of /dev/shm to 50g. the size of memory-target is 48.9 g

                       

                      Rgds

                      Roshan

                      • 8. Re: cloning
                        2907350

                        Below is the log for autoconfig

                         

                        Starting AutoConfig at Sat Feb 13 07:43:53 2016

                        Using adconfig.pl version 120.32.12020000.2

                         

                         

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

                         

                         

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

                        Starting Utility to Report Version Conflicts at Sat Feb 13 07:43:57 MUT 2016

                        Using VersionConflictListGenerator.java version 120.4

                          

                        All driver files processed.

                         

                         

                        No version conflict encountered.

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

                         

                          Using Context file          : /u01/oracle/PREPROD/db/11.2.0/appsutil/PREPROD_erppreprod.xml

                         

                         

                        Attempting to create a back up of the Context file

                        Created back up file of name :

                              /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/PREPROD_erppreprod.xml

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

                        Starting synchronization of file system Context file and its templates with those in the database

                         

                         

                           Database connection     : Failed

                           OAM Context editing support feature: Unverified

                           OAM Customization support feature  : Unverified

                         

                         

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

                         

                         

                           Checking for customizations to Context template

                           Warning: Unable to connect to Database.

                                   If the system is OAM enabled, this may result in loss of customizations.

                           Looking for custom template at : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/custom/adxdbctx.tmp

                           Custom template         : Not Available

                           Customizations found    : None

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

                           File system Context file :/u01/oracle/PREPROD/db/11.2.0/appsutil/PREPROD_erppreprod.xml

                         

                         

                           Checking the Context file for possible updates from the Database

                           Warning: Unable to connect to Database.

                                   If the system is OAM enabled, this may result in loss of customizations and the Context files in DataBase and in the file system may be unsynchronized

                         

                         

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

                        Starting Updates of Context file Sat Feb 13 07:43:59 MUT 2016

                             

                              found context version     : 120.52.12020000.3

                              available update version  : 120.52.12020000.3

                         

                         

                        No updates to apply

                         

                         

                        Ending Updates of Context file

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

                         

                         

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

                        Config Tool CVMHelper started at Sat Feb 13 07:43:59 MUT 2016

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

                         

                         

                         

                         

                        Updating local context file variables for Database Tier

                        Could not retrieve listener name from listener.ora : null

                        Unable to retrieve listener name from /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora

                        Getting listener port from /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora

                        Could not retrieve listener port from listener.ora : null

                        New Port: 1523

                        Old Port: null

                        Current Listener Name: PREPROD

                        New Listener Name: PREPROD

                        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    : erppreprod

                            sDbDomain  : sunresort.local

                            sDbPort    : 1523

                            sDbSid     : PREPROD

                            sDbUser    : apps

                            Trying to connect using SID...

                        getConnectionUsingSID() -->

                            JDBC URL: jdbc:oracle:thin:@erppreprod.sunresort.local:1523:PREPROD

                        WARNING:     Exception occurred: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

                            Trying to connect using SID as ServiceName

                        getConnectionUsingServiceName() -->

                            JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod.sunresort.local)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=PREPROD)))

                        WARNING:     Exception occurred: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

                            Trying to connect using SID as ServiceName.DomainName

                        getConnectionUsingServiceName() -->

                            JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod.sunresort.local)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=PREPROD.sunresort.local)))

                        WARNING:     Exception occurred: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

                            Connection could not be obtained; returning null

                         

                         

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

                         

                         

                        Exception occurred while preseeding variables in the context file: java.sql.SQLException: Could not get connection to the database

                         

                         

                         

                         

                        StackTrace:

                        java.sql.SQLException: Could not get connection to the database

                          at oracle.apps.ad.tools.configuration.CVMHelper.processNewContextFile(CVMHelper.java:918)

                          at oracle.apps.ad.context.CtxValueMgt.preSeed2Ctx(CtxValueMgt.java:1852)

                          at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1644)

                          at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:787)

                         

                         

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

                        Starting Context Value Management System at Sat Feb 13 07:43:59 MUT 2016

                        Using version 120.14

                        Options:

                         

                         

                           Force               : no

                           Contextfile         : /u01/oracle/PREPROD/db/11.2.0/appsutil/PREPROD_erppreprod.xml

                           Templatefile        : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adxdbctx.tmp

                           ValueUpdateFile     : /u01/oracle/PREPROD/db/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          : /u01/oracle/PREPROD/db/11.2.0/appsutil/PREPROD_erppreprod.xml

                         

                         

                        [ s_adperlprg ]

                           Action             : seed

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

                           New value          : /u01/oracle/PREPROD/db/11.2.0/perl/bin/perl

                         

                         

                        [ s_perl5lib ]

                           Action             : seed

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

                           New value          : /u01/oracle/PREPROD/db/11.2.0/perl/lib/5.10.0:/u01/oracle/PREPROD/db/11.2.0/perl/lib/site_perl/5.10.0:/u01/oracle/PREPROD/db/11.2.0/appsutil/perl

                         

                         

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

                        [ Config tool : /u01/oracle/PREPROD/db/11.2.0/appsutil/bin/adgentns.pl ]

                           Command            : /u01/oracle/PREPROD/db/11.2.0/perl/bin/perl -I /u01/oracle/PREPROD/db/11.2.0/perl/lib/5.10.0 -I /u01/oracle/PREPROD/db/11.2.0/perl/lib/site_perl/5.10.0 -I /u01/oracle/PREPROD/db/11.2.0/appsutil/perl  /u01/oracle/PREPROD/db/11.2.0/appsutil/bin/adgentns.pl PASSWORD  contextfile=/u01/oracle/PREPROD/db/11.2.0/appsutil/PREPROD_erppreprod.xml  logdir=/u01/oracle/PREPROD/db/11.2.0/appsutil/log/PREPROD_erppreprod/02130743  outdir=/u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743

                           Action             : execute

                         

                         

                        SCRIPT RETURNED:

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

                                           Generate Tns Names

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

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

                         

                         

                        Loading ORACLE_HOME environment from /u01/oracle/PREPROD/db/11.2.0

                        Logfile: /u01/oracle/PREPROD/db/11.2.0/appsutil/log/PREPROD_erppreprod/02130743/NetServiceHandler.log

                        tnsnames.ora instantiated

                         

                         

                        *** RAC is NOT configured. Generating listener.ora from the template ad8ilsnr.ora ***

                        listener.ora instantiated

                         

                         

                        adgentns.pl exiting with status 0

                        ERRORCODE = 0 ERRORCODE_END

                        .end std out.

                         

                         

                        .end err out.

                         

                         

                         

                         

                           Result             : SUCCEEDED

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

                         

                         

                        Ending Context Value Management System.

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

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

                        No uploading of Context file and its templates to database. Database conection failed

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

                        Updating rdbms version in Context file to db112

                        Updating rdbms type in Context file to 64 bits

                        Configuring templates from ORACLE_HOME ...

                        AutoConfig is running in the multithreaded mode.

                        Processing DriverFile = /u01/oracle/PREPROD/db/11.2.0/appsutil/template/addbtmpl.drv

                        AutoConfig Profile Phase

                        Running Instantiation Drivers for AppsUtil

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adstrtdb.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adstrtdb.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adstrtdb.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adstrtdb.sql

                           setting permissions: 600

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adsvdb.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adsvdb.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adsvdb.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adsvdb.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adchknls.pl

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adchknls.pl

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adchknls.pl to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adchknls.pl

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adcrobj.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrobj.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrobj.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adcrobj.sql

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adupdlib_ux.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adupdlib.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adupdlib.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adupdlib.sql

                           setting permissions: 600

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/ad8idbux.env

                           dest   : /u01/oracle/PREPROD/db/11.2.0/PREPROD_erppreprod.env

                           backup : /u01/oracle/PREPROD/db/11.2.0/PREPROD_erppreprod.env to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/PREPROD_erppreprod.env

                           setting permissions: 644

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/addbccnv.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/addbccnv.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/addbccnv.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/addbccnv.sql

                           setting permissions: 600

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adexecsql.pl

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adexecsql.pl

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adexecsql.pl to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adexecsql.pl

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adstopdb.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adstopdb.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adstopdb.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adstopdb.sql

                           setting permissions: 600

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/txkEBSWrapper.pl

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkEBSWrapper.pl

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkEBSWrapper.pl to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/txkEBSWrapper.pl

                           setting permissions: 755

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/afdbprf.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/afdbprf.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/afdbprf.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/afdbprf.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adsvdlsn.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adsvdlsn.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adsvdlsn.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adsvdlsn.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        File /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkConfigDbOcm.pl of type INSTALL_APPLY already exists, this file will not be instantiated.

                         

                         

                        File /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora of type INSTALL already exists, this file will not be instantiated.

                         

                         

                        File /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora of type INSTALL already exists, this file will not be instantiated.

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adsvdcnv.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adsvdcnv.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adsvdcnv.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adsvdcnv.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/addbprf.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/addbprf.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/addbprf.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/addbprf.sql

                           setting permissions: 600

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/txkcreateACL.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkcreateACL.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkcreateACL.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/txkcreateACL.sql

                           setting ownership: oratest:oinstall

                         

                         

                        File /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/tnsnames.ora of type INSTALL already exists, this file will not be instantiated.

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/addbprf.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/addbprf.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/addbprf.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/addbprf.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/addlnctl.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/addlnctl.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/addlnctl.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/addlnctl.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/afdbprf.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/afdbprf.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/afdbprf.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/afdbprf.sql

                           setting permissions: 600

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adcrobj.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrobj.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrobj.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adcrobj.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adlsnodes_ux.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adlsnodes.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adlsnodes.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adlsnodes.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/config_ux.tmp

                           dest   : /u01/oracle/PREPROD/db/11.2.0/rdbms/lib/config.c

                           backup : /u01/oracle/PREPROD/db/11.2.0/rdbms/lib/config.c to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/config.c

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/addbctl.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/addbctl.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/addbctl.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/addbctl.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/txkcreateACL.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkcreateACL.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkcreateACL.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/txkcreateACL.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/addbperms.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/addbperms.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/addbperms.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/addbperms.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/txkDBSecUserAuditActionBanner_pl.tmp

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/bin/txkDBSecUserAuditActionBanner.pl

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/bin/txkDBSecUserAuditActionBanner.pl to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/txkDBSecUserAuditActionBanner.pl

                           setting permissions: 755

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adautocfg_ux.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adautocfg.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adautocfg.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adautocfg.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adclobconv.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adclobconv.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adclobconv.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adclobconv.sql

                           setting permissions: 600

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adclobtmp.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adclobtmp.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adclobtmp.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adclobtmp.sql

                           setting permissions: 600

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adlicnse.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adlicnse.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adlicnse.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adlicnse.sql

                           setting permissions: 600

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adcrdb.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrdb.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrdb.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adcrdb.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adpreclone.pl

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adpreclone.pl

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adpreclone.pl to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adpreclone.pl

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/addbupdgsm.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/addbupdgsm.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/addbupdgsm.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/addbupdgsm.sql

                           setting permissions: 600

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adlnkoh.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/adlnkoh.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/adlnkoh.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adlnkoh.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adcrdbrdlg.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrdbrdlg.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrdbrdlg.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adcrdbrdlg.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/afmkinit.sh

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/afmkinit.sh

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/afmkinit.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/afmkinit.sh

                           setting permissions: 700

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adcmclean.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcmclean.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcmclean.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adcmclean.sql

                           setting permissions: 600

                           setting ownership: oratest:oinstall

                         

                         

                        instantiate file:

                           source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adcctclean.sql

                           dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcctclean.sql

                           backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcctclean.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02130743/adcctclean.sql

                           setting permissions: 600

                           setting ownership: oratest:oinstall

                         

                         

                        Executing script in InstantiateFile:

                        /u01/oracle/PREPROD/db/11.2.0/perl/bin/perl -I /u01/oracle/PREPROD/db/11.2.0/perl/lib/5.10.0 -I /u01/oracle/PREPROD/db/11.2.0/perl/lib/site_perl/5.10.0 -I /u01/oracle/PREPROD/db/11.2.0/appsutil/perl /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod/adchknls.pl

                        script returned:

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

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

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

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

                        DATABASE version : db112

                         

                         

                        Looking for the directory : /u01/oracle/PREPROD/db/11.2.0/nls/data/9idata

                        Directory exists

                         

                         

                        Looking for file : /u01/oracle/PREPROD/db/11.2.0/nls/data/old/cr9idata.pl

                        File exists

                         

                         

                        Validation complete

                        ERRORCODE = 0 ERRORCODE_END

                        .end std out.

                         

                         

                        .end err out.

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

                         

                         

                         

                         

                        Executing script in InstantiateFile:

                        /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/afmkinit.sh

                        script returned:

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

                         

                         

                        afmkinit.sh started at Sat Feb 13 07:44:09 MUT 2016

                         

                         

                         

                         

                        The environment settings are as follows ...

                         

                         

                               ORACLE_HOME : /u01/oracle/PREPROD/db/11.2.0

                                ORACLE_SID : PREPROD

                                  TWO_TASK :

                                      PATH : /u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/PREPROD/db/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/PREPROD/db/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:.:.

                              Library Path : /u01/oracle/PREPROD/db/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/PREPROD/db/11.2.0/lib:/usr/dt/lib:/u01/oracle/PREPROD/db/11.2.0/ctx/lib

                         

                         

                        afmkinit.sh exiting with status 0

                         

                         

                        .end std out.

                         

                         

                        .end err out.

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

                         

                         

                         

                         

                        Executing script in InstantiateFile:

                        /u01/oracle/PREPROD/db/11.2.0/perl/bin/perl -I /u01/oracle/PREPROD/db/11.2.0/perl/lib/5.10.0 -I /u01/oracle/PREPROD/db/11.2.0/perl/lib/site_perl/5.10.0 -I /u01/oracle/PREPROD/db/11.2.0/appsutil/perl /u01/oracle/PREPROD/db/11.2.0/appsutil/bin/txkDBSecUserAuditActionBanner.pl

                        script returned:

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

                         

                         

                         

                         

                        Script Name    : txkDBSecUserAuditActionBanner.pl

                        Banner file /u01/oracle/PREPROD/db/11.2.0/appsutil/template/txkDBSecUserAuditActionBanner.txt already exists

                        Successfully Completed the script

                        ERRORCODE = 0 ERRORCODE_END

                        .end std out.

                         

                         

                        .end err out.

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

                         

                         

                         

                         

                        Executing script in InstantiateFile:

                        /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/afdbprf.sh

                        script returned:

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

                         

                         

                        afdbprf.sh started at Sat Feb 13 07:44:09 MUT 2016

                         

                         

                         

                         

                        The environment settings are as follows ...

                         

                         

                               ORACLE_HOME : /u01/oracle/PREPROD/db/11.2.0

                                ORACLE_SID : PREPROD

                                      PATH : /u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/PREPROD/db/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/PREPROD/db/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:.:.

                              Library Path : /u01/oracle/PREPROD/db/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/PREPROD/db/11.2.0/lib:/usr/dt/lib:/u01/oracle/PREPROD/db/11.2.0/ctx/lib

                         

                         

                        Executable : /u01/oracle/PREPROD/db/11.2.0/bin/sqlplus

                         

                         

                         

                         

                        SQL*Plus: Release 11.2.0.3.0 Production on Sat Feb 13 07:44:09 2016

                         

                         

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

                         

                         

                        Enter value for 1: Enter value for 2: Enter value for 3: ERROR:

                        ORA-12541: TNS:no listener

                         

                         

                         

                         

                        ERRORCODE = 1 ERRORCODE_END

                        .end std out.

                         

                         

                        .end err out.

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

                         

                         

                         

                         

                        File /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkConfigDbOcm.pl not instantiated in the current pass, this file will not be executed

                         

                         

                        Executing script in InstantiateFile:

                        /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrobj.sh

                        script returned:

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

                         

                         

                        adcrobj.sh started at Sat Feb 13 07:44:10 MUT 2016

                         

                         

                        Parameters passed are : -nopromptmsg

                         

                         

                        The environment settings are as follows ...

                         

                         

                               ORACLE_HOME : /u01/oracle/PREPROD/db/11.2.0

                                ORACLE_SID : PREPROD

                                  TWO_TASK :

                                      PATH : /u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/PREPROD/db/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/PREPROD/db/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:.:.

                              Library Path : /u01/oracle/PREPROD/db/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/PREPROD/db/11.2.0/lib:/usr/dt/lib:/u01/oracle/PREPROD/db/11.2.0/ctx/lib

                         

                         

                        SQLPLUS Executable : /u01/oracle/PREPROD/db/11.2.0/bin/sqlplus

                         

                         

                         

                         

                        SQL*Plus: Release 11.2.0.3.0 Production on Sat Feb 13 07:44:10 2016

                         

                         

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

                         

                         

                        Enter value for 1: Enter value for 2: Enter value for 3: ERROR:

                        ORA-12541: TNS:no listener

                         

                         

                         

                         

                        adcrobj.sh exiting with status 1

                        ERRORCODE = 1 ERRORCODE_END

                        .end std out.

                         

                         

                        .end err out.

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

                         

                         

                         

                         

                        Executing script in InstantiateFile:

                        /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/addbperms.sh

                        script returned:

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

                         

                         

                        addbperms.sh started at Sat Feb 13 07:44:10 MUT 2016

                         

                         

                         

                         

                        The environment settings are as follows ...

                         

                         

                               ORACLE_HOME : /u01/oracle/PREPROD/db/11.2.0

                                ORACLE_SID : PREPROD

                                  TWO_TASK :

                                      PATH : /u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/PREPROD/db/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/PREPROD/db/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:.:.

                              Library Path : /u01/oracle/PREPROD/db/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/PREPROD/db/11.2.0/lib:/usr/dt/lib:/u01/oracle/PREPROD/db/11.2.0/ctx/lib

                         

                         

                        SQLPLUS Executable : /u01/oracle/PREPROD/db/11.2.0/bin/sqlplus

                         

                         

                          Changing permissions for file sqlplus.

                          Changing permissions for file extproc.

                          Changing permissions for file tkprof.

                          Changing permissions for file listener.ora.

                          Changing permissions for file tnsnames.ora.

                        addbperms.sh exiting with status 0

                         

                         

                        .end std out.

                         

                         

                        .end err out.

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

                         

                         

                         

                         

                        Executing script in InstantiateFile:

                        /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkcreateACL.sh

                        script returned:

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

                         

                         

                        You are running txkcreateACL.sh version 120.1

                         

                         

                         

                         

                        The environment settings are as follows ...

                         

                         

                               ORACLE_HOME : /u01/oracle/PREPROD/db/11.2.0

                                ORACLE_SID : PREPROD

                                      PATH : /u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/PREPROD/db/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/PREPROD/db/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:.:.

                        Executable : /u01/oracle/PREPROD/db/11.2.0/bin/sqlplus

                         

                         

                         

                         

                        Executing txkcreateACL.sql ...

                         

                         

                         

                         

                        SQL*Plus: Release 11.2.0.3.0 Production on Sat Feb 13 07:44:10 2016

                         

                         

                        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 Sat Feb 13 07:44:10 MUT 2016

                        Using version 120.4

                         

                         

                         

                         

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

                                           ADX Database Utility                       

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

                         

                         

                        getConnectionUsingAppsJDBCConnector() -->

                            APPS_JDBC_URL='null'

                            Trying to get connection using SID based connect descriptor

                        getConnection() -->

                            sDbHost    : erppreprod

                            sDbDomain  : sunresort.local

                            sDbPort    : 1523

                            sDbSid     : PREPROD

                            sDbUser    : apps

                            Trying to connect using SID...

                        getConnectionUsingSID() -->

                            JDBC URL: jdbc:oracle:thin:@erppreprod.sunresort.local:1523:PREPROD

                        WARNING:     Exception occurred: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

                            Trying to connect using SID as ServiceName

                        getConnectionUsingServiceName() -->

                            JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod.sunresort.local)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=PREPROD)))

                        WARNING:     Exception occurred: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

                            Trying to connect using SID as ServiceName.DomainName

                        getConnectionUsingServiceName() -->

                            JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod.sunresort.local)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=PREPROD.sunresort.local)))

                        WARNING:     Exception occurred: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

                            Connection could not be obtained; returning null

                         

                         

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

                         

                         

                          Verifying connection to the Database   : Could not be stablished

                          No Restore Profile file created.

                         

                         

                         

                         

                        Restore Profile utility ran successfully

                         

                         

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

                         

                         

                         

                         

                        adcvmlog.xml renamed to /u01/oracle/PREPROD/db/11.2.0/appsutil/log/PREPROD_erppreprod/02130743/adcvmlog.xml.02130744

                         

                         

                         

                         

                        WARNING: [AutoConfig Error Report]

                        The following report lists errors AutoConfig encountered during each

                        phase of its execution.  Errors are grouped by directory and phase.

                        The report format is:

                              <filename>  <phase>  <return code where appropriate>

                         

                         

                          [PROFILE PHASE]

                          AutoConfig could not successfully execute the following scripts:

                            Directory: /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod

                              afdbprf.sh              INSTE8_PRF         1

                         

                         

                          [APPLY PHASE]

                          AutoConfig could not successfully execute the following scripts:

                            Directory: /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod

                              adcrobj.sh              INSTE8_APPLY       1

                              txkcreateACL.sh         INSTE8_APPLY       1

                         

                         

                         

                         

                         

                         

                        AutoConfig is exiting with status 3

                         

                         

                        AutoConfig execution completed on Sat Feb 13 07:44:10 2016

                         

                         

                        Time taken for AutoConfig execution to complete : 0 mins  17 secs

                        • 9. Re: cloning
                          Bashar.

                          You only have 32 GB of RAM.

                          Set the memory target to a reasonable value.

                           

                          Regards,

                          Bashar

                          • 10. Re: cloning
                            Bashar.

                            From the log you posted, both the database and the listener are down.

                            How do you expect AutoConfig to work?!

                             

                            Regards,

                            Bashar

                            1 person found this helpful
                            • 11. Re: cloning
                              VishnuVinnakota

                              Database and Listener Availability is mandatory for Autoconfig in both DB and APPS Tier. For Autoconfig on Apps Tier, services are recommended to be down though it works even when services are up.

                              1 person found this helpful