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 MoreOracle 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 MoreAPPLIES 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 MoreScript 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 MoreAPPLIES 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 MoreAPPLIES 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 MoreAPPLIES 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 MoreAPPLIES 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 Moreselect 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 MoreAPPLIES 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