4 Replies Latest reply on Feb 12, 2016 9:11 AM by Narsi M-Oracle

    adcfgclone.pl dbTier

    2907350

      Hello,

       

      when I run perl adcfgclone.pl dbTier, it is completing with some errors. I have attached the log file.

       

      Before I ran perl adcfgclone.pl dbTier, i created the control files and temp files, started the database.

       

      Do you have any idea how i can start the listener so that at least users can connect to the database? i am getting error "TNS-01101: Could not find service name preprod


      rgds

      Roshan


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

      Started ApplyDBTier at Fri Feb 12 07:58:17 MUT 2016

      Version:

        ApplyDBTier.java : 120.11.12020000.3

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

      ApplyDBTier (prog) -1 true true true...

       

       

      START: Calling ApplyDBTechStack...

       

       

      START: ApplyDBTechStack Completed Successfully.

       

       

       

       

      START: Executing runInstallDriver...

       

       

      START: Started unzipping files...

       

       

      END: Unzipped files.

       

       

      START: Validate context.

       

       

       

       

      END: Validate context.

       

       

       

       

      END: Completed runInstallDriver.

       

       

       

       

      Executing home registration for s_db_oh...

      Determining Source system database type ("single" or "rac").

      Source system indentified as being of type "single"!

       

       

      instantiate file:

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

         dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/clone/ouicli.pl

         backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/clone/ouicli.pl to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/ouicli.pl

         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/config1.c

         setting permissions: 700

         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/clone/adlnkoh.sh

         backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/clone/adlnkoh.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/adlnkoh.sh

         setting permissions: 700

         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/clone/ouicli.pl

       

       

      script returned:

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

      Beginning OUI CLI cloning for s_db_ohFri Feb 12 07:58:19 2016

      /u01/oracle/PREPROD/db/11.2.0/appsutil/jre/bin/java -classpath /u01/oracle/PREPROD/db/11.2.0/appsutil/java:/u01/oracle/PREPROD/db/11.2.0/oui/jlib/OraInstaller.jar:/u01/oracle/PREPROD/db/11.2.0/appsutil/java/xmlparserv2.jar  oracle.apps.ad.clone.util.OracleHomeCloner  -OUICLI -e /u01/oracle/PREPROD/db/11.2.0/appsutil/PREPROD_erppreprod.xml -nolink -oaVar s_db_oh -homestub db -log /u01/oracle/PREPROD/db/11.2.0/appsutil/log/PREPROD_erppreprod/ohclone.log

      NON-COMPLIANT: /u01/oracle/PREPROD/db/11.2.0/oraInst.loc does not point to an inventory inside the current ORACLE_HOME

      Rapid Clone only supports oraInst.loc at that location if its content points to an inventory inside the same ORACLE_HOME

      Please make the necessary changes to the following file:

      /u01/oracle/PREPROD/db/11.2.0/oraInst.loc

      Running OUI CLI home cloning from within OracleHomeCloner:

        /u01/oracle/PREPROD/db/11.2.0/oui/bin/runInstaller  -clone -silent -waitForCompletion -invPtrLoc /etc/oraInst.loc ORACLE_HOME=/u01/oracle/PREPROD/db/11.2.0 ORACLE_BASE=/u01/oracle/PREPROD/db/11.2.0 ORACLE_HOME_NAME=PREPROD_DB__u01_oracle_PREPROD_db_11_2_0 oracle_install_OSDBA=oinstall oracle_install_OSOPER=oinstall -noConfig -nowait

      Finished OUI CLI cloning for s_db_oh with return code: 0Fri Feb 12 07:59:47 2016

       

       

      .end std out.

       

       

      .end err out.

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

       

       

       

       

      Executing script in InstantiateFile:

      /u01/oracle/PREPROD/db/11.2.0/appsutil/clone/adlnkoh.sh

       

       

      script returned:

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

       

       

      adlnkoh.sh started at Fri Feb 12 07:59:47 MUT 2016

      Log file located at /u01/oracle/PREPROD/db/11.2.0/appsutil/log/PREPROD_erppreprod/make_02120759.log

       

       

      Using make file "ins_emagent.mk" for linking SYSMAN utilities...

       

       

      adlnkoh.sh completed sucessfully

       

       

      .end std out.

       

       

      .end err out.

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

       

       

       

       

      instantiate file:

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

         dest   : /u01/oracle/PREPROD/db/11.2.0/appsutil/clone/ouicli.pl

         backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/clone/ouicli.pl to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/ouicli1.pl

         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/config2.c

         setting permissions: 700

         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/clone/adlnkoh.sh

         backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/clone/adlnkoh.sh to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/adlnkoh1.sh

         setting permissions: 700

         setting ownership: oratest:oinstall

       

       

      Completed home registration for s_db_oh

       

       

       

       

       

       

      START: Executing Technology Stack Configuration...

       

       

      START: Executing runAutoConfig...

       

       

      Deleting files of type INSTALL

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/sqlnet.ora

      Processing driver file: /u01/oracle/PREPROD/db/11.2.0/appsutil/template/addbtmpl.drv

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkConfigDbOcm.pl

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora

      File exists

      File deleted

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/tnsnames.ora

       

       

      START: Running CVM in INSTE8_SETUP mode

       

        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/02120800/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 Fri Feb 12 08:00:32 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

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

       

       

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

      Starting Context Value Management System at Fri Feb 12 08:00:32 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

       

       

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

      [ 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

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

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

       

       

      END: Finished running CVM.....

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

      AutoConfig Profile Phase

      Running Instantiation Drivers for AppsUtil

      Creation of Directory - /u01/oracle/PREPROD/db/11.2.0/appsutil/scripts/PREPROD_erppreprod Succeeded.

      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/02120800/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/02120800/adstopdb.sql

         setting permissions: 600

         setting ownership: oratest:oinstall

       

       

      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/02120800/adstrtdb.sql

         setting permissions: 600

         setting ownership: oratest:oinstall

       

       

      Creation of Directory - /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod Succeeded.

      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/02120800/addbccnv.sql

         setting permissions: 600

         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/02120800/adcrobj.sql

         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/02120800/adchknls.pl

         setting permissions: 700

         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/02120800/txkEBSWrapper.pl

         setting permissions: 755

         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/02120800/PREPROD_erppreprod.env

         setting permissions: 644

         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/02120800/adupdlib.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/02120800/adsvdb.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/02120800/adsvdlsn.sh

         setting permissions: 700

         setting ownership: oratest:oinstall

       

       

      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/02120800/adsvdcnv.sh

         setting permissions: 700

         setting ownership: oratest:oinstall

       

       

      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/02120800/addbprf.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/02120800/addbprf.sql

         setting permissions: 600

         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/02120800/afdbprf.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/02120800/afdbprf.sql

         setting permissions: 600

         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/02120800/addbctl.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/02120800/addlnctl.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/02120800/adlsnodes.sh

         setting permissions: 700

         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/02120800/adcrobj.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/02120800/addbperms.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 does not exist, will be instantiated in the current pass

      instantiate file:

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

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

         backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkConfigDbOcm.pl to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02120800/txkConfigDbOcm.pl

         setting permissions: 700

         setting ownership: oratest:oinstall

       

       

      File /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora of type INSTALL does not exist, will be instantiated in the current pass

      instantiate file:

         source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/afinit_db112.ora

         dest   : /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora

         backup : /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02120800/initPREPROD.ora

         setting ownership: oratest:oinstall

       

       

      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/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/02120800/txkcreateACL.sql

         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/02120800/txkcreateACL.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/02120800/txkDBSecUserAuditActionBanner.pl

         setting permissions: 755

         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/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/02120800/config.c

         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/02120800/adautocfg.sh

         setting permissions: 700

         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/02120800/adlicnse.sql

         setting permissions: 600

         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/02120800/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/02120800/adclobtmp.sql

         setting permissions: 600

         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/02120800/adpreclone.pl

         setting permissions: 700

         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/02120800/adcrdb.sh

         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/02120800/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/02120800/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/02120800/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/02120800/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/02120800/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/02120800/adcctclean.sql

         setting permissions: 600

         setting ownership: oratest:oinstall

       

       

      AutoConfig Setup Phase

      Running Setup Process 1 of 3 for AppsUtil

      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.

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

       

       

       

       

      AutoConfig Setup Phase

      Running Setup Process 2 of 3 for AppsUtil

      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.

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

       

       

       

       

      AutoConfig Setup Phase

      Running Setup Process 3 of 3 for AppsUtil

      Executing script in InstantiateFile:

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

       

       

      script returned:

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

       

       

      afmkinit.sh started at Fri Feb 12 08:00:44 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/appsutil/clone/bin/../jre/bin:/u01/oracle/PREPROD/db/11.2.0/appsutil/clone/bin/../jre/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/u01/oracle/TEST/db/11.2.0/bin:/u01/oracle/TEST/db/11.2.0:bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oratest/bin:/home/oratest/bin:/home/oratest/bin:/home/oratest/bin:.

            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.

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

       

       

       

       

      Skipping Profile Phase

      Skipping Apply Phase

       

       

      END: Completed runAutoConfig...

       

       

       

       

      END: Executed Technology Stack Configuration...

       

       

      END: ApplyDBTechStack Completed Successfully.

       

       

       

       

      END: Calling ApplyDBTechStack...

       

       

      START: Calling ApplyDatabase...

       

       

      START: Starting ApplyDatabase

       

       

        Installing Context File...   /u01/oracle/PREPROD/db/11.2.0/appsutil/PREPROD_erppreprod.xml

         Actual Database Context file...   /u01/oracle/PREPROD/db/11.2.0/appsutil/PREPROD_erppreprod.xml

      Updating Context...

       

       

      START: Executing runInstallDriver...

       

       

      START: Started unzipping files...

      UNZIP used: UnZip 6.00 of 20 April 2009, by Info-ZIP.  Maintained by C. Spieler.  Send

      Unzip0 - Start of native unzipping /u01/oracle/PREPROD/db/11.2.0/appsutil/clone//data/stage/adcrdb.zip at /u01/oracle/PREPROD/db/11.2.0/appsutil/template/

       

       

       

       

       

       

      END: Unzipped files

       

       

       

       

      END: Completed runInstallDriver.

       

       

       

       

       

       

      START: Executing Registration Phase...

       

       

      END: Executed Registration Phase...

       

       

      START: Executing StartDbLsnr...

       

       

      Deleting files of type INSTALL

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/sqlnet.ora

      Processing driver file: /u01/oracle/PREPROD/db/11.2.0/appsutil/template/addbtmpl.drv

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkConfigDbOcm.pl

      File exists

      File deleted

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora

      File exists

      File deleted

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora

      File exists

      File deleted

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/tnsnames.ora

      File exists

      File deleted

      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/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/02120800/adexecsql0.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/02120800/adstopdb0.sql

         setting permissions: 600

         setting ownership: oratest:oinstall

       

       

      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/02120800/adstrtdb0.sql

         setting permissions: 600

         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/02120800/addbccnv0.sql

         setting permissions: 600

         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/02120800/adcrobj0.sql

         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/02120800/adchknls0.pl

         setting permissions: 700

         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/02120800/txkEBSWrapper0.pl

         setting permissions: 755

         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/02120800/PREPROD_erppreprod0.env

         setting permissions: 644

         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/02120800/adupdlib0.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/02120800/adsvdb0.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/02120800/adsvdlsn0.sh

         setting permissions: 700

         setting ownership: oratest:oinstall

       

       

      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/02120800/adsvdcnv0.sh

         setting permissions: 700

         setting ownership: oratest:oinstall

       

       

      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/02120800/addbprf0.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/02120800/addbprf0.sql

         setting permissions: 600

         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/02120800/afdbprf0.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/02120800/afdbprf0.sql

         setting permissions: 600

         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/02120800/addbctl0.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/02120800/addlnctl0.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/02120800/adlsnodes0.sh

         setting permissions: 700

         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/02120800/adcrobj0.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/02120800/addbperms0.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 does not exist, will be instantiated in the current pass

      instantiate file:

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

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

         backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkConfigDbOcm.pl to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02120800/txkConfigDbOcm0.pl

         setting permissions: 700

         setting ownership: oratest:oinstall

       

       

      File /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora of type INSTALL does not exist, will be instantiated in the current pass

      instantiate file:

         source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/afinit_db112.ora

         dest   : /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora

         backup : /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02120800/initPREPROD0.ora

         setting ownership: oratest:oinstall

       

       

      File /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora of type INSTALL does not exist, will be instantiated in the current pass

      instantiate file:

         source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/ad8ilsnr.ora

         dest   : /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora

         backup : /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02120800/listener.ora

         setting permissions: 644

         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/02120800/txkcreateACL0.sql

         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/02120800/txkcreateACL0.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/02120800/txkDBSecUserAuditActionBanner0.pl

         setting permissions: 755

         setting ownership: oratest:oinstall

       

       

      File /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/tnsnames.ora of type INSTALL does not exist, will be instantiated in the current pass

      instantiate file:

         source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/ad8itns.ora

         dest   : /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/tnsnames.ora

         backup : /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/tnsnames.ora to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02120800/tnsnames.ora

         setting permissions: 644

         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/02120800/config0.c

         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/02120800/adautocfg0.sh

         setting permissions: 700

         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/02120800/adlicnse0.sql

         setting permissions: 600

         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/02120800/adclobconv0.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/02120800/adclobtmp0.sql

         setting permissions: 600

         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/02120800/adpreclone0.pl

         setting permissions: 700

         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/02120800/adcrdb0.sh

         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/02120800/addbupdgsm0.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/02120800/adlnkoh0.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/02120800/adcrdbrdlg0.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/02120800/afmkinit0.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/02120800/adcmclean0.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/02120800/adcctclean0.sql

         setting permissions: 600

         setting ownership: oratest:oinstall

       

       

      AutoConfig Setup Phase

      Running Setup Process 1 of 3 for AppsUtil

      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.

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

       

       

       

       

      AutoConfig Setup Phase

      Running Setup Process 2 of 3 for AppsUtil

      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.

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

       

       

       

       

      AutoConfig Setup Phase

      Running Setup Process 3 of 3 for AppsUtil

      Executing script in InstantiateFile:

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

       

       

      script returned:

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

       

       

      afmkinit.sh started at Fri Feb 12 08:01:01 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/appsutil/clone/bin/../jre/bin:/u01/oracle/PREPROD/db/11.2.0/appsutil/clone/bin/../jre/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/u01/oracle/TEST/db/11.2.0/bin:/u01/oracle/TEST/db/11.2.0:bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oratest/bin:/home/oratest/bin:/home/oratest/bin:/home/oratest/bin:.

            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.

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

       

       

       

       

      Skipping Profile Phase

      Skipping Apply Phase

       

       

      Testing for RAC enabled context values

      prior to listener startup and database restore...

      Starting DB listener with command:

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

      Logfile: /u01/oracle/PREPROD/db/11.2.0/appsutil/log/PREPROD_erppreprod/addlnctl.txt

       

       

      You are running addlnctl.sh version 120.4

       

       

       

       

      Starting listener process PREPROD ...

       

       

       

       

      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 12-FEB-2016 08:01:02

       

       

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

       

       

      Starting /u01/oracle/PREPROD/db/11.2.0/bin/tnslsnr: please wait...

       

       

      TNSLSNR for Linux: Version 11.2.0.3.0 - Production

      System parameter file is /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora

      Log messages written to /u01/oracle/PREPROD/db/11.2.0/admin/PREPROD_erppreprod/diag/tnslsnr/erppreprod/preprod/alert/log.xml

      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod.sunresort.local)(PORT=1524)))

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=erppreprod.sunresort.local)(PORT=1524)))

      STATUS of the LISTENER

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

      Alias                     PREPROD

      Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

      Start Date                12-FEB-2016 08:01:02

      Uptime                    0 days 0 hr. 0 min. 0 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora

      Listener Log File         /u01/oracle/PREPROD/db/11.2.0/admin/PREPROD_erppreprod/diag/tnslsnr/erppreprod/preprod/alert/log.xml

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod.sunresort.local)(PORT=1524)))

      Services Summary...

      Service "PREPROD" has 1 instance(s).

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

      The command completed successfully

       

       

      addlnctl.sh: exiting with status 0

       

       

      addlnctl.sh: check the logfile /u01/oracle/PREPROD/db/11.2.0/appsutil/log/PREPROD_erppreprod/addlnctl.txt for more information ... 

       

       

       

       

      .end std out.

       

       

      .end err out.

       

       

       

       

      END: Executed StartDbLsnr...

       

       

      START: Checking DB Connection...

      DEBUG: checkDBConnection in()

       

       

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

                         ADX Database Utility                       

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

       

       

      getConnection() -->

          sDbHost    : erppreprod

          sDbDomain  : sunresort.local

          sDbPort    : 1524

          sDbSid     : PREPROD

          sDbUser    : apps

          Trying to connect using SID...

      getConnectionUsingSID() -->

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

      WARNING:     Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Linux-x86_64 Error: 2: No such file or directory

       

       

          Trying to connect using SID as ServiceName

      getConnectionUsingServiceName() -->

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

      WARNING:     Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Linux-x86_64 Error: 2: No such file or directory

       

       

          Trying to connect using SID as ServiceName.DomainName

      getConnectionUsingServiceName() -->

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

      WARNING:     Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:

      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

       

          Connection could not be obtained; returning null

       

       

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

       

       

      conn is null

      WARNING: RC-40201: Unable to connect to Database PREPROD.

       

       

       

       

      StackTrace:

      java.lang.Exception: Cannot connect to database using DBUtil

        at oracle.apps.ad.clone.ApplyDatabase.checkDBConnection(ApplyDatabase.java:3278)

        at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:553)

        at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:493)

        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:384)

        at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:116)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

        at oracle.apps.ad.clone.util.CloneProcessor.run(Unknown Source)

        at java.lang.Thread.run(Thread.java:724)

       

       

      WARNING: DEBUG: checkDBConnection out()

       

       

      Testing for RAC enabled context values

      prior to listener startup and database restore...

      Verifying correctness of adcrdbclone.sql

      Clustered Database: false

      Instantiating /u01/oracle/PREPROD/db/11.2.0/appsutil/template/adcrdbclone.sql to /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrdbclone.sql.bak

      instantiate file:

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

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

      Instantiating /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrdbclone.sql.bak to /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrdbclone.sql

      instantiate file:

         source : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/adcrdbclone.sql.bak

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

      Skipping updating s_db_rollback_segs

      Updating:s_undo_tablespace:APPS_UNDOTS1:

      Updating:s_database:db112:

      Updating:isspfileexists:true:

      Updating:s_dbfiles:512:

      Updating:s_compatible:11.2.0:

       

       

      START: Executing Configuration Phase...

       

       

      Deleting files of type INSTALL

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/sqlnet.ora

      Processing driver file: /u01/oracle/PREPROD/db/11.2.0/appsutil/template/addbtmpl.drv

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkConfigDbOcm.pl

      File exists

      File deleted

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora

      File exists

      File deleted

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora

      File exists

      File deleted

       

       

      Checking for file: /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/tnsnames.ora

      File exists

      File deleted

      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/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/02120801/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/02120801/adstopdb.sql

         setting permissions: 600

         setting ownership: oratest:oinstall

       

       

      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/02120801/adstrtdb.sql

         setting permissions: 600

         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/02120801/addbccnv.sql

         setting permissions: 600

         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/02120801/adcrobj.sql

         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/02120801/adchknls.pl

         setting permissions: 700

         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/02120801/txkEBSWrapper.pl

         setting permissions: 755

         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/02120801/PREPROD_erppreprod.env

         setting permissions: 644

         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/02120801/adupdlib.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/02120801/adsvdb.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/02120801/adsvdlsn.sh

         setting permissions: 700

         setting ownership: oratest:oinstall

       

       

      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/02120801/adsvdcnv.sh

         setting permissions: 700

         setting ownership: oratest:oinstall

       

       

      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/02120801/addbprf.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/02120801/addbprf.sql

         setting permissions: 600

         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/02120801/afdbprf.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/02120801/afdbprf.sql

         setting permissions: 600

         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/02120801/addbctl.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/02120801/addlnctl.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/02120801/adlsnodes.sh

         setting permissions: 700

         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/02120801/adcrobj.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/02120801/addbperms.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 does not exist, will be instantiated in the current pass

      instantiate file:

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

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

         backup : /u01/oracle/PREPROD/db/11.2.0/appsutil/install/PREPROD_erppreprod/txkConfigDbOcm.pl to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02120801/txkConfigDbOcm.pl

         setting permissions: 700

         setting ownership: oratest:oinstall

       

       

      File /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora of type INSTALL does not exist, will be instantiated in the current pass

      instantiate file:

         source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/afinit_db112.ora

         dest   : /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora

         backup : /u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02120801/initPREPROD.ora

         setting ownership: oratest:oinstall

       

       

      File /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora of type INSTALL does not exist, will be instantiated in the current pass

      instantiate file:

         source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/ad8ilsnr.ora

         dest   : /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora

         backup : /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/listener.ora to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02120801/listener.ora

         setting permissions: 644

         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/02120801/txkcreateACL.sql

         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/02120801/txkcreateACL.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/02120801/txkDBSecUserAuditActionBanner.pl

         setting permissions: 755

         setting ownership: oratest:oinstall

       

       

      File /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/tnsnames.ora of type INSTALL does not exist, will be instantiated in the current pass

      instantiate file:

         source : /u01/oracle/PREPROD/db/11.2.0/appsutil/template/ad8itns.ora

         dest   : /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/tnsnames.ora

         backup : /u01/oracle/PREPROD/db/11.2.0/network/admin/PREPROD_erppreprod/tnsnames.ora to /u01/oracle/PREPROD/db/11.2.0/appsutil/out/PREPROD_erppreprod/02120801/tnsnames.ora

         setting permissions: 644

         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/02120801/config.c

         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/02120801/adautocfg.sh

         setting permissions: 700

         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/02120801/adlicnse.sql

         setting permissions: 600

         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/02120801/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/02120801/adclobtmp.sql

         setting permissions: 600

         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/02120801/adpreclone.pl

         setting permissions: 700

         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/02120801/adcrdb.sh

         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/02120801/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/02120801/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/02120801/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/02120801/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/02120801/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/02120801/adcctclean.sql

         setting permissions: 600

         setting ownership: oratest:oinstall

       

       

      AutoConfig Setup Phase

      Running Setup Process 1 of 3 for AppsUtil

      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.

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

       

       

       

       

      AutoConfig Setup Phase

      Running Setup Process 2 of 3 for AppsUtil

      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.

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

       

       

       

       

      AutoConfig Setup Phase

      Running Setup Process 3 of 3 for AppsUtil

      Executing script in InstantiateFile:

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

       

       

      script returned:

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

       

       

      afmkinit.sh started at Fri Feb 12 08:01:19 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/appsutil/clone/bin/../jre/bin:/u01/oracle/PREPROD/db/11.2.0/appsutil/clone/bin/../jre/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/u01/oracle/TEST/db/11.2.0/bin:/u01/oracle/TEST/db/11.2.0:bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oratest/bin:/home/oratest/bin:/home/oratest/bin:/home/oratest/bin:.

            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.

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

       

       

       

       

      Skipping Profile Phase

      Skipping Apply Phase

       

       

      END: Executed Configuration Phase...

       

       

      START: Executing CreateDB...

       

       

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

                         ADX Database Utility                       

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

       

       

      getConnectionUsingAppsJDBCConnector() -->

          APPS_JDBC_URL='null'

          Trying to get connection using SID based connect descriptor

      getConnection() -->

          sDbHost    : erppreprod

          sDbDomain  : sunresort.local

          sDbPort    : 1524

          sDbSid     : PREPROD

          sDbUser    : apps

          Trying to connect using SID...

      getConnectionUsingSID() -->

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

      WARNING:     Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Linux-x86_64 Error: 2: No such file or directory

       

       

          Trying to connect using SID as ServiceName

      getConnectionUsingServiceName() -->

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

      WARNING:     Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Linux-x86_64 Error: 2: No such file or directory

       

       

          Trying to connect using SID as ServiceName.DomainName

      getConnectionUsingServiceName() -->

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

      WARNING:     Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:

      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

       

          Connection could not be obtained; returning null

       

       

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

       

       

       

       

      adcrdb.sh started at Fri Feb 12 08:01:20 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/appsutil/clone/bin/../jre/bin:/u01/oracle/PREPROD/db/11.2.0/appsutil/clone/bin/../jre/bin:/u01/oracle/PREPROD/db/11.2.0/perl/bin:/u01/oracle/PREPROD/db/11.2.0/bin:/u01/oracle/TEST/db/11.2.0/bin:/u01/oracle/TEST/db/11.2.0:bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oratest/bin:/home/oratest/bin:/home/oratest/bin:/home/oratest/bin:.

         LD_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

       

       

      The log information will be written to

        /u01/oracle/PREPROD/db/11.2.0/appsutil/log/PREPROD_erppreprod/adcrdb_PREPROD.txt

       

       

       

       

      Creating the control file for PREPROD_erppreprod database ...

       

       

       

       

      SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 12 08:01:20 2016

       

       

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

       

       

      Connected to an idle instance.

      ORACLE instance shut down.

      Connected to an idle instance.

      ORACLE instance started.

       

       

      Total System Global Area 2137886720 bytes

      Fixed Size    2230072 bytes

      Variable Size  452987080 bytes

      Database Buffers 1660944384 bytes

      Redo Buffers   21725184 bytes

      CREATE CONTROLFILE REUSE SET DATABASE "PREPROD"

      *

      ERROR at line 1:

      ORA-01503: CREATE CONTROLFILE failed

      ORA-01158: database  already mounted

       

       

       

       

      alter database open resetlogs

      *

      ERROR at line 1:

      ORA-01507: database not mounted

       

       

       

       

      alter tablespace TEMP1 add tempfile '/u01/oracle/PREPROD/db/data/temp01.dbf' REUSE

      *

      ERROR at line 1:

      ORA-01109: database not open

       

       

       

       

      alter tablespace TEMP2 add tempfile '/u01/oracle/PREPROD/db/data/temp02.dbf' REUSE

      *

      ERROR at line 1:

      ORA-01109: database not open

       

       

       

       

      alter tablespace TEMP1 add tempfile '/u01/oracle/PREPROD/db/data/temp0001.dbf' REUSE

      *

      ERROR at line 1:

      ORA-01109: database not open

       

       

       

       

      ALTER DATABASE RENAME GLOBAL_NAME TO "PREPROD.sunresort.local"

                                           *

      ERROR at line 1:

      ORA-01109: database not open

       

       

       

       

      ORA-01507: database not mounted

       

       

       

       

      ORACLE instance shut down.

      Connected to an idle instance.

      ORACLE instance started.

       

       

      Total System Global Area 2137886720 bytes

      Fixed Size    2230072 bytes

      Variable Size  452987080 bytes

      Database Buffers 1660944384 bytes

      Redo Buffers   21725184 bytes

      ORA-01102: cannot mount database in EXCLUSIVE mode

       

       

       

       

      BEGIN dbms_backup_restore.zeroDbid(0); END;

       

       

      *

      ERROR at line 1:

      ORA-00210: cannot open the specified control file

      ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 4754

      ORA-06512: at line 1

       

       

       

       

      ORACLE instance shut down.

      Connected to an idle instance.

      ORACLE instance started.

       

       

      Total System Global Area 2137886720 bytes

      Fixed Size    2230072 bytes

      Variable Size  452987080 bytes

      Database Buffers 1660944384 bytes

      Redo Buffers   21725184 bytes

      CREATE CONTROLFILE REUSE SET DATABASE "PREPROD"

      *

      ERROR at line 1:

      ORA-01503: CREATE CONTROLFILE failed

      ORA-01158: database  already mounted

       

       

       

       

      alter database open resetlogs

      *

      ERROR at line 1:

      ORA-01507: database not mounted

       

       

       

       

      alter tablespace TEMP1 add tempfile '/u01/oracle/PREPROD/db/data/temp01.dbf' REUSE

      *

      ERROR at line 1:

      ORA-01109: database not open

       

       

       

       

      alter tablespace TEMP2 add tempfile '/u01/oracle/PREPROD/db/data/temp02.dbf' REUSE

      *

      ERROR at line 1:

      ORA-01109: database not open

       

       

       

       

      alter tablespace TEMP1 add tempfile '/u01/oracle/PREPROD/db/data/temp0001.dbf' REUSE

      *

      ERROR at line 1:

      ORA-01109: database not open

       

       

       

       

      ALTER DATABASE RENAME GLOBAL_NAME TO "PREPROD.sunresort.local"

                                           *

      ERROR at line 1:

      ORA-01109: database not open

       

       

       

       

      Error Running create/replace library with adupdlib.sql

      ORA-01109: database not open

       

       

      PL/SQL procedure successfully completed.

       

       

       

       

      File created.

       

       

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

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

      exit_code=0

       

       

      Checking for errors ...

       

       

       

       

      SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 12 08:01:45 2016

       

       

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

       

       

      Connected.

      ORACLE instance shut down.

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

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

       

       

      .end std out.

       

       

      .end err out.

       

       

       

       

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

                         ADX Database Utility                       

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

       

       

      getConnectionUsingAppsJDBCConnector() -->

          APPS_JDBC_URL='null'

          Trying to get connection using SID based connect descriptor

      getConnection() -->

          sDbHost    : erppreprod

          sDbDomain  : sunresort.local

          sDbPort    : 1524

          sDbSid     : PREPROD

          sDbUser    : apps

          Trying to connect using SID...

      getConnectionUsingSID() -->

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

      WARNING:     Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Linux-x86_64 Error: 2: No such file or directory

       

       

          Trying to connect using SID as ServiceName

      getConnectionUsingServiceName() -->

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

      WARNING:     Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Linux-x86_64 Error: 2: No such file or directory

       

       

          Trying to connect using SID as ServiceName.DomainName

      getConnectionUsingServiceName() -->

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

      WARNING:     Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:

      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

       

          Connection could not be obtained; returning null

       

       

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

       

       

      WARNING: RC-00118: Error occurred during creation of database

      Raised by oracle.apps.ad.clone.ApplyDatabase

       

       

       

       

      StackTrace:

      java.lang.Exception: Control file creation failed

        at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:658)

        at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:493)

        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:384)

        at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:116)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

        at oracle.apps.ad.clone.util.CloneProcessor.run(Unknown Source)

        at java.lang.Thread.run(Thread.java:724)

        • 1. Re: adcfgclone.pl dbTier
          Jignesh Makwana

          Hello,

          StackTrace:

          java.lang.Exception: Control file creation failed

            at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:658)

            at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:493)

            at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:384)

            at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:116)

           

          Please check the permission where you are creating your datafies.

           

          Jignesh

          • 2. Re: adcfgclone.pl dbTier
            2907350

            Hello,

             

            in fact I created the control files and was able to start DB before running autocfg. I removed the control files and stopped everything and it worked.

             

            Now when I start the database it says

             

            SQL> startup nomount

            startup pfile='/u01/oracle/PREPROD/db/11.2.0/dbs/initPREPROD.ora';

            ORA-00119: invalid specification for system parameter LOCAL_LISTENER

            ORA-00132: syntax error or unresolved network name 'PREPROD_LOCAL'

             

            My tnsname contains these

            PREPROD = (DESCRIPTION=

                            (ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod.sunresort.local)(PORT=1523))

                            (CONNECT_DATA= (SERVICE_NAME=PREPROD)

                                     (INSTANCE_NAME=PREPROD))

                        )

             

             

            PREPROD_LOCAL =

                        (DESCRIPTION=

                            (ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod.sunresort.local)(PORT=1523))

                        )

             

            Rgds

            Roshan

            • 4. Re: adcfgclone.pl dbTier
              Narsi M-Oracle

              Hello Roshan,

               

              In general, when you are going to manually start database, then you should follow below:

               

              1) perl adcfgclone.pl dbTechStack

               

              This will relink ORACLE HOME.

               

              2) Configure your database

              The below steps has to be performed manually

              1. Create the Target Database control files.
              2. Start the Target System Database in open mode
              3. Run the library update script against the Database

              cd $RDBMS_ORACLE_HOME/appsutil/install/[CONTEXT NAME]
              sqlplus "/ as sysdba" @adupdlib.sql

               

              3) perl adcfgclone.pl dbconfig

               

              It is used to configure the database with  context file.Database should be in open mode.

               

              cd $RDBMS_ORACLE_HOME/appsutil/clone/bin
              perl adcfgclone.pl dbconfig target_context_file

              Where Target Context File is:
              $RDBMS_ORACLE_HOME/appsutil/target_context_file.xml



              Hope this helps!!!




              Regards,

              Narsi