R12.2克隆patch fs報錯——Rapid Clone completed successfully , but the AutoConfig run recorded some errors

根據同僚提供的網址，參考文檔：http://ermanarslan.blogspot.jp/2014/07/ebs-122-cloning-real-life-example.html 解決：

INFO :  Rapid Clone completed successfully , but the AutoConfig run recorded  some errors. 

Please review the AutoConfig section in the logfile.  and Re-Run the entire cloning cycle , after fixing the problem

Okay we completed the cloning but it seems that we have encountered a problem while running autoconfig..

Lets find that problem...

To find the cause of the error , we open the logfile of post clone, and search for autconfig related errors there..

vi /u01/fs1/inst/apps/PREPROD_erppreprod/admin/log/clone/ApplyAppsTier_07030932.log

Here, there is an important error in the 6th process of the Autoconfig..

AutoConfig Setup Phase

Running Setup Process 6 of 8 for AD_TOP

Executing script in InstantiateFile:

/u01/fs1/inst/apps/PREPROD_erppreprod/admin/install/afgcsreg.sh

script returned:

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

afgcsreg.sh started at Thu Jul  3 09:38:46 EEST 2014

The environment settings are as follows ...

       ORACLE_HOME : /u01/fs1/EBSapps/10.1.2

        ORACLE_SID :

          TWO_TASK : PREPROD_patch

              PATH : /u01/fs_ne/EBSapps/appl/ad/bin:/u01/fs1/FMW_Home/modules/org.apache.ant_1.7.1/bin:/u01/fs1/inst/apps/PREPROD_erppreprod/admin/scripts:/u01/fs1/FMW_Home/webtier/perl/bin:/u01/fs1/EBSapps/10.1.2/bin:/u01/fs1/EBSapps/appl/fnd/12.0.0/bin:/u01/fs1/EBSapps/appl/ad/12.0.0/bin:/u01/fs1/EBSapps/comn/util/jdk32/jre/bin:/u01/fs1/EBSapps/comn/util/jdk32/bin::/u01/fs1/EBSapps/10.1.2/OPatch:/u01/fs1/EBSapps/10.1.2/bin:/usr/bin:/usr/sbin:/u01/fs1/EBSapps/comn/util/jdk32/jre/bin:/u01/fs1/EBSapps/comn/clone/bin/../jre/bin:/u01/fs1/EBSapps/comn/clone/bin/../jre/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/applmgr/bin      Library Path : /u01/fs1/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/fs1/EBSapps/appl/cz/12.0.0/bin:/u01/fs1/EBSapps/10.1.2/lib32:/u01/fs1/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/fs1/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/fs1/EBSapps/appl/sht/12.0.0/lib

Executable : /u01/fs1/EBSapps/10.1.2/bin/sqlplus

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jul 3 09:38:47 2014

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

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

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

descriptor

after that, similar  errors are coming like a rain :)

Uploading Metadata file /u01/fs1/EBSapps/appl/ad/12.0.0/admin/template/adctxinf.tmp

Metadata file /u01/fs1/EBSapps/appl/ad/12.0.0/admin/template/adctxinf.tmp upload failed.

Check log file created by FNDCPUCF program.

ERRORCODE = 1 ERRORCODE_END

.end std out.

APP-FND-01564: ORACLE error 12514 in AFPCOA

Cause: AFPCOA failed due to ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

.

The SQL statement being executed at the time of the error was:  and was executed from the file .

So,

It s searching for the service name PREPROD_patch to connect to the db..

Lets check our db site, lets check our listener if it is listening for the patching service..

lsnrctl status PREPROD

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 03-JUL-2014 10:19:28

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=erppreprod.erman.ermandom.com)(PORT=1522)))

STATUS of the LISTENER

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

Alias                     PREPROD

Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date                02-JUL-2014 15:57:42

Uptime                    0 days 18 hr. 21 min. 45 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/oracle/product/11.2.0.3/db/network/admin/PREPROD_erppreprod/listener.ora

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

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreproderman.ermandom.com)(PORT=1522)))

Services Summary...

Service "PREPROD" has 1 instance(s).

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

The command completed successfully

Opps, it doesnt listens for PREPROD_patch.

Lets make the listener to listen PREPROD_patch..

sqlplus "/as sysdba"

SQL>alter system set service_names='PREPROD','ebs_patch','PREPROD_patch' scope=memory;

System altered.

SQL> alter system set local_listener=PREPROD scope=memory;

SQL> alter system register;

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 03-JUL-2014 10:30:25

Uptime                    0 days 18 hr. 32 min. 43 sec

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod.erman.ermandom.com)(PORT=1522)))

Service "PREPROD" has 2 instance(s).

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

Service "PREPROD_patch" has 1 instance(s).

Service "ebs_patch" has 1 instance(s).

Okay, Now it is listening for PREPROD_patch..

So , lets execute our post clone process again.. (because it says: Re-Run the entire cloning cycle , after fixing the problem)

First clean what we have done before and recreate the fs1 directory

$rm -fR fs1/

$ls

backup_sil  EBSapps.env  fs2  fs_ne  lost+found  oracle

$mkdir fs1

$cp -RH fs2/EBSapps/ fs1/

Then, re-execute  adcfgclone.pl appsTier from the patch edition filesystem.

/u01/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/fs1/EBSapps/comn/clone/jlib/java:/u01/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/u01/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.ApplyAppsTier -e /u01/fs1/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml -stage /u01/fs1/EBSapps/comn/clone    -showProgress -nopromptmsg 

Log file located at /u01/fs1/inst/apps/PREPROD_erppreprod/admin/log/clone/ApplyAppsTier_07031059.log

  -    100% completed       

Completed Apply...

Thu Jul  3 11:13:55 2014

Looking for incomplete CLONE record in ad_adop_session_patches table

The CLONE record status is no rows selected

Updating incomplete CLONE record to COMPLETED

Yes! This time ,it runs successful...

Now we are ready to start our cloned evironment..

Starting our clone environment:

Lastly we source our run environment and start our application services on the cloned environment.

. /u01/EBSApps.env run 

cd $ADMIN_SCRIPTS_HOME

sh adstrtal.sh apps/apps

That's it...  Our clone environment is up&running. Optionally, we can do other post clone stuff at this point.. I mean, we can change site name and color of the Forms screens, or we can mask our sensitive data etc..