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…
adcfgclone.pl appsTier dualfs
DUALFS – new feature is introduced in the latest AD-TXK Delta 7. This feature will create both the filesystems fs1 and fs2 during the clonning process. $ perl appsTier dualfs Copyright (c)…
Clone/Refresh Database using RMAN
For our understanding Source Database: PRIM (It would be TARGET in case of RMAN Terminology) Auxiliary/Clone Database: TEST 1) Take FULL backup on source database using RMAN: Verify Source database…
oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval
ICS runtime execution error Failed with following error message: ICS runtime execution error</summary></part><part name=”detail”><detail><detail><errorCode>OSB-380001</errorCode><ICSfaultVar/><reason>: Message not received within 240 seconds of wait interval.:Application Error Integrations created with DB…