R12.2 ADCFGCLONE FAILS
During the cloning process adcfgclone fails with below error message: ERROR : Below Oracle Homes are already registered in the global inventory: /u01/oracle/R122/fs1/FMW_Home/oracle_common /u01/oracle/R122/fs1/FMW_Home/webtier /u01/oracle/R122/fs1/FMW_Home/Oracle_EBS-app1 SOLUTION: Make sure that the…
R12.2 Adcfgclone.pl ERROR Exit Code 255
when attempting to run perl appsTier, the following error occurs: ERROR: Log file located at /local/FDEV/fs2/inst/apps/FDEV_lapdev01/admin/log/ – 50% completed ERROR while running Apply… Fri May 30 17:37:39 2014 ERROR: Failed…
Perl lib version (v5.8.8) doesn’t match executable version (v5.10.0)
Issue while running adcfgclone on target database node, I can see below error messages in ERROR: perl dbTechStack RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack Perl lib version ()…
ORA-39097 Data Pump job encountered unexpected error
ERROR: Export: Release – Production on Wednesday, 08 August, 2007 10:12:50 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release – Production With…
EBS 12.2 Upgrade and Installation Logs
Before the installation starts: $TMP/<MMDDHHMM>/<MMDDHHMM>.log $TMP/<MMDDHHMM>/<hostname>_<SID>.xml $TMP/<MMDDHHMM>/<hostname>_<SID> The Rapidwiz Configuration File is saved in 4 locations: $TMP/<MMDDHHMM>/conf_<SID>.txt Primary $INST_TOP/conf_<SID>.txt Secondary $INST_TOP/conf_<SID>.txt <RDBMS ORACLE_HOME>/appsutil/conf_<SID>.txt Preinstall System Check logs: $TMP/<MMDDHHMM>/<MMDDHHMM>.log $ $…
ORA-39181: Only partial table data may be exported due to fine grain access control
The below error appeared when trying to export the Schema: ORA-39181: Only partial table data may be exported due to fine grain access control on “GLOGOWNER”.”WORKFLOW_ACTION_PARAM” . . exported “GLOGOWNER”.”WORKFLOW_ACTION_PARAM”…
DATABASE SCHEMA SIZE from the database
set linesize 150 set pagesize 5000 col owner for a155 select OWNER,sum(bytes)/1024/1024/1000 “SIZE_IN_GB” from dba_segments group by owner order by owner; Thank you !!
NLS boot file not found or invalid opmnctl ping – EBS 12.2 ADCFGCLONE FAIL
failed while performing clone of EBS instance. This occurred while ohsT2PApply is in progress. ERROR: INST_TOP/admin/log/clone/run/ohsT2: 2015-12-02T3:10:04-06:00] ... 2015-12-02T13:10:04-06:00] lxlinit - NLS boot file not found or invalid opmnctl ping:…
ADOP FS_CLONE Fails with OutOfMemoryError: Java Heap Space Error
ERROR: Exception in thread “Thread-1” : GC overhead limit exceeded SOLUTION: $ export CONFIG_JVM_ARGS=”-Xms1024m -Xmx2048m” $ echo $CONFIG_JVM_ARGS -Xms1024m -Xmx2048m re-executes completed successfully adop phase=fs_clone force=Yes
Find Plan Hash Values from SQLID
SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 60 SET LINESIZE 300 SELECT DISTINCT sql_id, plan_hash_value FROM dba_hist_sqlstat q, ( SELECT /*+ NO_MERGE */ MIN(snap_id) min_snap,…