Database Blog

ORA-04063: package body “APPS.AD_ZD_ADOP” has errors

 adop prepare phase was failing with the following error in customer test environment. echo $FILE_EDITION run echo $TWO_TASK test adop phase=prepare Enter the APPS password: Enter the SYSTEM password: Enter…

Read More

Oracle Database and Applications Security Audit Part 1

Hello Everyone, I would like to start series of write ups/post based on the experience regarding How to perform Security Audit for oracle database and applications.  Hoping that it will…

Read More

MRP0: Background Media Recovery terminated with error 448

MRP0: Background Media Recovery terminated with error 448 Recently encountered ORA-00448: normal completion of background process Managed Standby Recovery not using Real Time Apply due to ORA-00600 on standby Database. …

Read More

Untrusted Certificate Issue in ECX (XML PO) transmission

When the XML Gateway (ECX) has been configured for XML PO Transmission ,  when https protocol has been configured in trading partner setup , valid certificates has to be uploaded…

Read More

Troubleshooting Punchout Issues

This post helps or guide you in fixing all issues related to punchout. 1. When user click over the punchout link, and in the detailed exception message you see “CONNECTION…

Read More

Assigning Approval Management Responsibilities

This post helps you to assign Approvals Management (AME) responsibilities to a Oracle Applications User Login as SYSADMIN user. Switch the responsibility to “User Management” and Navigate to the Users…

Read More

Troubleshooting Oracle Workflow Mailer Issues

This Post helps you to find almost straight solutions for the issues  you are facing in Oracle Workflow Mailer. Assumption: It is  assumed that you have basic configuration knowledge related…

Read More

Untitled

Resource manager capabilities (limit CPU and sessions) --------------------------------------------------------------------------- -- Create plan with consumer groups --------------------------------------------------------------------------- exec dbms_resource_manager.create_pending_area; exec dbms_resource_manager.delete_plan_cascade('night_plan'); exec dbms_resource_manager.create_plan('night_plan', 'Plan to use after 6PM'); exec dbms_resource_manager.create_consumer_group('batch', 'Group for…

Read More

Untitled

Oracle WebLogic Server does not start after domain creation after installation of WebLogic binaries and creation of the simplest domain configuration (only with Admin Server) from scratch, during the attempt…

Read More

Renaming UNNAMED datafile(s) to standby database

Renaming UNNAMED datafile(s) to standby database If parameter STANDBY_FILE_MANAGEMENT is set to MANUAL in Oracle standby database you may getthis error when rolling forward: Media Recovery Log logfile.arcFile #416 added…

Read More