1) perl adcfgclone.pl appsTier dualfs ERRORS and SOLUTION
============================================
ERROR 1
=========
StackTrace:
java.lang.Exception: oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Exception : Error executng BEGIN fnd_gsm_util.upload_context_
file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1552: ORA-01552: cannot use system rollback segment for non-system tablespace ‘APPS_TS_TX
_DATA_2’ has been detected in FND_GSM_UTIL.upload_context_file.
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:764)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:228)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1721)
at oracle.apps.ad.clone.ApplyApplTop.runCVM(ApplyApplTop.java:872)
at oracle.apps.ad.clone.ApplyApplTop.instantiateTxkWfClone(ApplyApplTop.java:540)
at oracle.apps.ad.clone.ApplyApplTop.executeTxkWfClone(ApplyApplTop.java:584)
at oracle.apps.ad.clone.ApplyApplTop.doConf(ApplyApplTop.java:388)
at oracle.apps.ad.clone.ApplyApplTop.doApply(ApplyApplTop.java:699)
at oracle.apps.ad.clone.ApplyApplTop.<init>(ApplyApplTop.java:297)
at oracle.apps.ad.clone.ApplyAppsTier.<init>(ApplyAppsTier.java:160)
at oracle.apps.ad.clone.RCloneApplyAppstier.runFSApplyAppsTier(RCloneApplyAppstier.java:112)
at oracle.apps.ad.clone.RCloneApplyAppstier.main(RCloneApplyAppstier.java:445)
SOLUTION 1
=============
SET “undo_management=auto” in init.ora file and rerun “perl adcfgclone.pl appsTier dualfs”
ERROR 2
=========
STACK TRACE
at /ORACLE/app/vision/R12apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
TXK::Error::abort(‘TXK::Error’, ‘HASH(0x10066c3f8)’) called at /ORACLE/app/vision/R12apps/fs1/EBSapps/appl/au/12.0.0/perl/T
XK/Common.pm line 299
TXK::Common::doError(‘TXK::SQLPLUS=HASH(0x100f466c8)’, ‘SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 – Produc.
..’, undef) called at /ORACLE/app/vision/R12apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError(‘TXK::SQLPLUS=HASH(0x100f466c8)’, ‘SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 – Produc
…’) called at /ORACLE/app/vision/R12apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832
TXK::SQLPLUS::_doExecute(‘TXK::SQLPLUS=HASH(0x100f466c8)’, 0) called at /ORACLE/app/vision/R12apps/fs1/EBSapps/appl/au/12.0
.0/perl/TXK/SQLPLUS.pm line 234
TXK::SQLPLUS::execute(‘TXK::SQLPLUS=HASH(0x100f466c8)’, ‘HASH(0x101ca5a00)’) called at /ORACLE/app/vision/R12apps/fs1/EBSap
ps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618
TXK::TechstackDB::_getSQLValue(‘TXK::TechstackDB=HASH(0x100ef1c08)’, ‘SELECT ad_zd_adop.get_node_type(\’hostname\’) FROM
DUAL’) called at /ORACLE/app/vision/R12apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573
TXK::TechstackDB::getSQLValue(‘TXK::TechstackDB=HASH(0x100ef1c08)’, ‘SELECT ad_zd_adop.get_node_type(\’hostname\’) FROM D
UAL’) called at /ORACLE/app/vision/R12apps/fs1/inst/apps/vis_hostname/admin/install/txkGenADOPWrapper.pl line 503
main::getNodeType() called at /ORACLE/app/vision/R12apps/fs1/inst/apps/vis_hostname/admin/install/txkGenADOPWrapper
.pl line 199
eval {…} called at /ORACLE/app/vision/R12apps/fs1/inst/apps/vis_hostname/admin/install/txkGenADOPWrapper.pl line
140
)
SOLUTION 2
============
SQL> SELECT ad_zd_adop.get_node_type(‘hostname’) from dual;
SELECT ad_zd_adop.get_node_type(‘hostname’) from dual
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at “APPS.AD_ZD_ADOP”, line 3025
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
PL/SQL procedure successfully completed.
SQL> exit
Run AUTOCONFIG on database tier and rerun “perl adcfgclone.pl appsTier dualfs”
