Database Blog

Workflow Notification Mailer Not Sending Notifications As event oracle.apps.wf.notification.send.group Is Disabled

APPLIES TO: Oracle Workflow - Version 12.1.3 to 12.2 [Release 12.1 to 12.2] Information in this document applies to any platform. SYMPTOMS: On Oracle Applications Release 12.1.3 When attempting to…

Read More

How To Query And Change The Oracle Hidden Parameters In Oracle 10g and Later

  GOAL: Q1: How to query the hidden initialization parameters in sql ? Q2: How to change these hidden parameters? SOLUTION: A1: The hidden parameters start with an "_".They can…

Read More

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