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 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 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 MoreCreates the DDL for the specified job:- SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true); DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'PRETTY',…
Read MoreScript to create foreign key DDL on all tables. SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true); DBMS_METADATA.set_transform_param…
Read MoreDBMS_ADVISOR :- 1. Gather a number of SQL statements that will form the tuning workload. 2. Check that the user running DBMS_ADVISOR has the ADVISOR privilege, and has SELECT access…
Read MoreBy default in Oracle Applications R12, users are not able to access Forms directly via the following url: http://hostname:port/forms/frmservlet The following error would pop out: APP-FND-01542: This Applications Server is…
Read More