Problem: When running AutoConfig on the application tier, AutoConfig completes in error. Checked adconfig.log file:

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates
Instantiating Tools tnsnames.ora
Tools tnsnames.ora instantiated
Web tnsnames.ora instantiated

adgentns.pl exiting with status 2

Solution: Disable IPV6 from Local Area Network connection and retry AutoConfig on apps tier

Other solutions tried:

1. Clean FND_NODES table and rerun AutoConfig.

perl D:\ORACLE\PROD\apps\apps_st\appl\ad\12.0.0\bin\adgentns.pl appspass=apps contextfile=D:\ORACLE\PROD\inst\apps\PROD_testsrv2\appl\admin\PROD_testsrv2.xml –removeserver
perl D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\bin\adgentns.pl appspass=apps contextfile=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\PROD_testsrv2.xml -removeserver
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;
cd D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\scripts\PROD_testsrv2
adautocfg.cmd
cd D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\scripts
adautocfg.cmd

May need to shutdown database and restart it.

Check D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\log\09062315\adconfig.log
Check D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\log\09062315/NetServiceHandler.log
Check D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\install\admk80ln.sql

Problem: When running AutoConfig on the application tier, the following error occurs:

  -     90% completed
ERROR while running Apply...

Checked D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\log\09061401\adconfig.log:
  [SETUP PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\install
      adgendbc.cmd            INSTE8_SETUP       1

Possible solution: Disable JAVA_JIT_ENABLED

SQL> show parameter jit

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------------
java_jit_enabled                     boolean     TRUE

SQL> alter system set JAVA_JIT_ENABLED=FALSE scope=both;

System altered.

SQL>

Reference: Adgendbc Fails With Database Connection Failure (Doc ID 1302708.1)

Problem: When running adcfgclone, the following error occurs:

Complete port information available at D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\out\PROD_testsrv2\portpool.lst

Creating the new Database Context file from :
  D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\template\adxdbctx.tmp

The new database context file has been created :
  D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\PROD_testsrv2.xml

Log file located at D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\CloneContext_0906103441.log
Check Clone Context logfile D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\CloneContext_0906103441.log for details.

Running Rapid Clone with command:
perl D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\adclone.pl java=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\..\jre mode=apply stage=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone component=dbTier method=CUSTOM dbctxtg=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\PROD_testsrv2.xml showProgress contextValidated=true
Running:
perl D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\adclone.pl java=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\..\jre mode=apply stage=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone component=dbTier method=CUSTOM dbctxtg=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\PROD_testsrv2.xml showProgress contextValidated=true
Perl lib version (5.10.0) doesn't match executable version (v5.8.5) at d:/ORACLE/PROD/db/tech_st/11.2.0/perl/lib/Config.pm line 46.
Compilation failed in require at D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone
\bin\adclone.pl line 34.
BEGIN failed--compilation aborted at D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\adclone.pl line 34.

 ERROR: Failed to execute D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\adclone.pl

 Please check logfile.

Solution: May need to set PERL5LIB before running adcfgclone.

set PERL5LIB=D:\ORACLE\PROD\db\tech_st\11.2.0\perl\lib\5.10.0;D:\ORACLE\PROD\db\tech_st\11.2.0\perl\site_perl\5.10.0;D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\perl
cd /d D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin
d:\ORACLE\PROD\db\tech_st\11.2.0\perl\bin\perl.exe adcfgclone.pl dbTier

Problem: When running adcfgclone on Windows 2008, the following error occurs:

D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin>d:\ORACLE\PROD\db\tech_st\11.2.0\perl\bin\perl.exe adcfgclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.8

Enter the APPS password : apps


Running:
D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\..\jre\bin\java.exe -Xmx600M
 -cp D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\jlib\java;D:\ORACLE\PROD\db
\tech_st\11.2.0\appsutil\clone\jlib\xmlparserv2.jar;D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\jlib\ojdbc5.jar oracle.apps.ad.context.CloneContext -e D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\..\context\db\CTXORIG.xml -validate -pairsfile C:\Users\ADMINI~1\AppData\Local\Temp\1\adpairsfile_4724.lst -stage
 D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone  2> C:\Users\ADMINI~1\AppData\Local\Temp\1\adcfgclone_4724.err && echo %ERRORLEVEL% > C:\Users\ADMINI~1\AppData\Local\Temp\1\adcfgclone_4724.res
RC-20011: Fatal: Failed to retrieve OS name. The following OS string returned from System.getProperty("os.name") is unknown: Windows Server 2008 R2
Can't open Exception in thread "main" java.lang.ExceptionInInitializerError:
Invalid argument

D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin>

Solution: Apply patch 11071569 on source system, then copy to target system. Then rerun adcfgclone.

Reference: How to Overcome Windows 2008 Being Unrecognised by AutoConfig and rapid Clone? (Doc ID 1270782.

Problem: While running patch 9239095, the following error occurs:

Assigned: file FNDGFU.exe   on worker  1 for product fnd username APPLSYS.

   FAILED: file FNDGFU.exe   on worker  1 for product fnd username APPLSYS.

 Deferred: file FNDGFU.exe   on worker  1 for product fnd username APPLSYS.

          (Deferment number 1 for this job)

Checked D:\ORACLE\MFGPR12\apps\apps_st\appl\admin\MFGP\log\ adwork001.log

ORA-01653: unable to extend table APPLSYS.FND_LOBS by 16 in tablespace APPS_TS_MEDIA

D:\oracle\MFGPR12\apps\apps_st\appl\fa\12.0.0\help\US\FA00019109.htm: upload failed

 

AD Worker error:

The above program failed with error code 1.

See the AD Worker log file and/or the program log file for details.

 Solution: Add datafile to APPS_TS_MEDIA tablespace:

select tablespace_name, file_name, bytes/1024/1024 from dba_data_files 
where tablespace_name = 'APPS_TS_MEDIA';

alter tablespace apps_ts_media add datafile 
'D:\ORACLE\MFGP\MFGPDB\ORADATA\MFGP\A_MEDIA02.DBF' size 1200M;

Problem:While running adstats.sql, the following error occurs:

--------------------------------------------------
--- adstats.sql started at 2013-09-03 14:08:43 ---


Checking for the DB version and collecting statistics ...

declare
*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:
[1350], [1], [23], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 24889
ORA-06512: at "SYS.DBMS_STATS", line 25430
ORA-06512: at line 3
ORA-06512: at line 33


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options

D:\ORACLE\MFGPR12\db\tech_st\11.2.0> 

Solution: Bounce database, then retry script.

Note: Make sure that you have at least 1.5 GB of free default temporary tablespace.

Problem: While running adbldxml.pl, the following error occurs:

D:\ORACLE\PRODR12\db\tech_st\11.2.0>perl D:\ORACLE\PRODR12\db\tech_st\11.2.0\appsutil\bin\adbldxml.pl

Starting context file generation for db tier..

D:ORACLEPRODR12dbtech_st11.2.0binsqlplus.exe: not found

D:ORACLEPRODR12dbtech_st11.2.0bintnsping.exe: not found

ERROR: while running command : D:\ORACLE\PRODR12\db\tech_st\11.2.0\bin\tnsping.exe

Failed to execute the specified command.

Verify that the command can be executed from the command prompt.

Solution: Use perl located in %ORACLE_HOME%\perl\bin. Do not use perl bundled with MKS Toolkit.

e.g. D:\ORACLE\PRODR12\db\tech_st\11.2.0\perl\bin\perl D:\ORACLE\PRODR12\db\tech_st\11.2.0\appsutil\bin\adbldxml.pl

Problem: While running admkappsutil.pl, the following error occurs:

D:\ORACLE\PRODR12\apps\apps_st\appl>perl D:\ORACLE\PRODR12\apps\apps_st\appl\ad\12.0.0\bin\admkappsutil.pl
Starting the generation of appsutil.zip

Log file located at D:\oracle\PRODR12\inst\apps\PROD_vasusrv\admin\log\MakeAppsUtil_09031037.log
output located at D:\oracle\PRODR12\inst\apps\PROD_vasusrv\admin\out\appsutil.zip

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again...
MakeAppsUtil completed with errors, Please check logfile for more information.

Solution: Download unzip for your platform from Info-Zip (http://www.info-zip.org). For Windows 2003, download unz552xn.exe). For Windows 2008 64-bit, download the 64-bit version (unz552xn-x64.exe). Or see the readme: ftp://ftp.info-zip.org/pub/infozip/win32/readme

ftp://ftp.info-zip.org/pub/infozip/win32/

Problem: While running patch 6678700, the following error occurs:

FAILED: file czhist.sql   on worker  1.

Solution: Execute the following commands:

sqlplus / as sysdba 
EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('APPLSYS','FND_STATTAB');

Then retest issue (use adctrl option 2 restart failed worker)

Reference: Script Czhist.Sql Fails During Application Of Patch 6678700 (Doc ID 1281478.1)