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 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 MoreAPPLIES 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 MoreIssue : OCI DBCS: RESTORE the DB from backup, OPEN command fails, wallet status is found to be CLOSED, Observation : – Took a complete database backup – Used the…
Read MoreIssue : OCI Restore fails during Recreate Controlfile step while adding tempfile to PDB SYMPTOMS : Create new DB System from backup fails during Recreate Controlfile script execution. Reason :…
Read MoreIssue : OCI Restore failure during Tempfile Creation Trying to create a new DB System from backup in OCI. Restore fails during “Re-Create Control File” step: Cause for the issue…
Read MoreIssue : Got the error : ORA-20401: Authorization failed, while listing contents of OCI Object storage using PL/SQL in ADB Error : ERROR at line 1: ORA-20401: Authorization failed for…
Read More