Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Disabling and Uninstalling AWR (Doc ID 1909073.1) Some reference on it?– How To Avoid the AWR Usage Without Having Diagnostic Pack License (Doc ID 2276199.1)– Controlling Diagnostic and Tuning …
Read More »Disabling and Uninstalling AWR
Troubleshooting Oracle RAC Node Eviction
Troubleshooting Oracle RAC Node Eviction The RAC Node Eviction Troubleshooting Tool is designed to help diagnose and resolve RAC node eviction issues by analyzing uploaded log files. When …
Read More »ORA-01035: ORACLE only available to users with RESTRICTED SESSION
ORA-01035: ORACLE only available to users with RESTRICTED SESSION 1. First Check the Pdbs Status SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ———————————————————————————————————————— PDB$SEED …
Read More »Rename Datafile In Oracle Standby on New Location
Rename Datafile In Oracle Standby on New Location “Suppose you come across a situation while serving a customer, where the DR server faces space limitations. In order to address this …
Read More »Redo Transport Services fails with ORA-16198
Redo Transport Services fails with ORA-16198 At the alert log, we received this error message on the production database for the 19c Data Guard. The primary alert log file showed: LGWR: …
Read More »