Problem: when we try to cancel a concurrent request using frontend “Cancel Request” button from the Administer > Concurrent > Manager form. We are getting the following message: “Request xxxxxx…
Read MoreProblem: [ERROR] Failed to execute SQL statement: select AD_ZD_ADOP.GET_INVALID_NODES() from dual [ERROR] Error Message: [ERROR] ORA-04063: package body “APPS.AD_ZD_ADOP” has errors (DBD ERROR: OCIStmtExecute) Cause: Package “APPS.AD_ZD_ADOP” is not valid…
Read MoreProblem: <[Security:090295]caught unexpected exception, No such object> <[Security:090303]Authentication Failed: User weblogic weblogic.security.providers.authentication.LDAPAtnDelegateException: [Security:090295]caught unexpected exception, No such object> java.security.PrivilegedActionException: javax.security.auth.login.FailedLoginException: [Security:090938]Authentication failure: The specified user failed to log in. weblogic.security.providers.authentication.LDAPAtnDelegateException:…
Read MoreDescription: This query used to check the generation of all redo during the time period. Script: select to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time, dhsso.object_name, sum(db_block_changes_delta) from dba_hist_seg_stat dhss, dba_hist_seg_stat_obj dhsso, dba_hist_snapshot dhs where…
Read MoreIssue: In Linux Environment, script scheduled in Crontab is not working. Impact: Not able to do any automatic healthcheck, schedule a backup etc.. in Production Database and Application. Solution: Need…
Read MoreIntroduction: This post is a guide to install Oracle Database Firewall 12.2.0.8 on VMware. High Level steps 1. Media Download 2. Prerequisites 3. Installation of Database Firewall 12.2.0.8 4. Post…
Read MoreDescription: This script is used for finding ASM error details on ASM disk. script: select io.inst_id , dg.name diskgroup_name , io.disk_number , d.name disk_name –, d.label , d.read_errs , d.write_errs…
Read MoreDescription: This query belongs to find the top sort segment usage on oracle. Script: col sid format 999999 col spid format a6 col tablespace format a10 col username format a25…
Read MoreDescription: This query used to find and calculate the top 20 tables by growth for users requested days. Script: select * from (select so.owner, so.object_name, –so.subobject_name, so.object_type, so.tablespace_name, round(sum(ss.space_used_delta)/1024/1024) growth_mb…
Read MoreThis diagnostic test will validate the WORKFLOW NOTIFICATION MAILER – Java Mailer Setup and do an initial data collection of frequently requested information. 1) Enable STATEMENT Level Logging for the…
Read More