Author Archives: compitionpoint
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,…
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…
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)…
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…
Cause: java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body has been invalidated – ICS Integration Failed
ORA-04068: existing state of packages has been discarded Cause: : ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package “XXX” has been invalidated ORA-04065:…