Author Archives: compitionpoint - Page 7
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,…
SET PASSWORD LIFE TIME TO UNLIMITED
Set the password life time to unlimited for DEFAULT profile. SQL> SELECT resource_name,limit FROM dba_profiles WHERE profile=’DEFAULT’; RESOURCE_NAME LIMIT ——————————– —————————– COMPOSITE_LIMIT UNLIMITED SESSIONS_PER_USER UNLIMITED CPU_PER_SESSION UNLIMITED CPU_PER_CALL UNLIMITED LOGICAL_READS_PER_SESSION…
RC-50013 Fatal: Instantiate driver
Error: Seen the issue during the execution of adcfgclone. perl dbTechStack ==================== WARNING: The following report lists errors AutoConfig encountered during each phase of its execution. Errors are grouped by…