Database Blog

Oracle Cloud Guard

Oracle Cloud Guard, a new Oracle Cloud Infrastructure (OCI) service designed to  maintain a strong security in OCI. Cloud Guard is just one of the new services that are part…

Read More

EM 12c, 13c: Enterprise Manager Cloud Control Agent Install Fails with Message: ERROR: Agent Configuration Failed SEVERE: emctl start agent command has failed with status1

APPLIES TO: Enterprise Manager Base Platform - Version 12.1.0.1.0 to 12.1.0.5.0 [Release 12.1] Information in this document applies to any platform. SYMPTOMS: This note is written for the 12.1.0 1.0…

Read More

Simple Script to Disable & Enable Cronjobs

Script disen_cronjobs.sh will help to disable and enable all cronjobs during maintenance. Script can be executed with below two options Disable cronjobs before starting maintenance $ sh disen_cronjobs.sh disable Enable…

Read More

[EM 13c]: 13c Cloud Control Agent Status Shows “Status agent Failure:unable to connect to http server”

APPLIES TO: Enterprise Manager Base Platform – Version 13.2.0.0.0 and later Information in this document applies to any platform. SYMPTOMS: 13.2 agent status shows following error: $ ./emctl status agent…

Read More

EM12c: ‘java.io.IOException: Cannot run program “/usr/lib/oracle/agent/sbin/nmo”: java.io.IOException: error=2, No such file or directory’ Reported in gcagent.log

APPLIES TO: Enterprise Manager Base Platform – Version 12.1.0.4.0 and later Information in this document applies to any platform.   SYMPTOMS: $AGENT_INST/sysman/log/gcagent.log reports the following message every 30 minutes 014-09-16…

Read More

XML Gateway Outbound PO Errors With Filenotfoundexception On Cwallett.Sso

APPLIES TO: Oracle XML Gateway – Version 12.0.0 to 12.1.3 [Release 12 to 12.1] Information in this document applies to any platform. SYMPTOMS Setup xml gateway with trading partner for…

Read More

POXML Workflow fails intermittently with Error Process ‘POXML/XXXX-XXXXX’ has no activities waiting to receive event ‘oracle.apps.po.event.xmlpo’

APPLIES TO: Oracle Purchasing – Version 12.1.3 and later Information in this document applies to any platform. SYMPTOMS When attempting to send some Purchase Orders (POs) by XML Gateway after…

Read More

Query to find Fragmentation on Database

select table_name,round((blocks*8),2) “size (mb)” , round((num_rows*avg_row_len/1024),2) “actual_data (mb)”, (round((blocks*8),2) – round((num_rows*avg_row_len/1024),2)) “wasted_space (mb)” from dba_tables where (round((blocks*8),2) > round((num_rows*avg_row_len/1024),2)) and owner=’&a’ order by 4 desc; set lines 170 set pages…

Read More

12.2 E-Business Suite – How To Clean Up a Rapid Install Failure and Restart a Fresh Install

APPLIES TO: Oracle Applications Manager – Version 12.2 to 12.2.5 [Release 12.2Cloud to 12.2] Information in this document applies to any platform. GOAL: How to clean up a failed 12.2…

Read More

Patching failed with “The inventory pointed at location is not valid” and ORA-48146 in OCI DBCS

APPLIES TO: Oracle Database Cloud Service – Version N/A to N/A [Release 1.0] Linux x86-64 SYMPTOMS: Customer tried to apply the patch from console and it was failing in two…

Read More