Uncategorized Archives

How to deal with ORA-00020: maximum number of processes (%s) exceeded

tuanlpAugust 27, 2024131 views

I recently had a situation where access to the database was completely blocked because of the infamous error message ORA-00020: maximum number of processes (%s) exceeded Facts:The database had processes…

ORA-12537: TNS:connection closed – standby error in DGMGRL

tuanlpAugust 19, 2024116 views

Error: ORA-12537: TNS:connection closed Details: Occurred on a standby database after switchover from primary to standby. Error came up when checking DataGuard broker configuration. Cause: The mrp process not running on standbySolution:Checked if…