ORA-00392 Solution

ora-00392

ORA-00392 log 1 of thread 1 is being cleared, operation not allowed, this ora error comes after restoration when we trying to open the database in resetlogs mode. Cause: ORA-00392 The first command “alter database open resetlogs” is abnormally abrupted leaving the redo log status as CLEARING/CLEARING_CURRENT in controlfile : ORA-00392 SOLUTION: First you try … Read more

Solve ORA-12528

ORA-12528

Today one of my client was facing ora-12528 TNS:listener: all appropriate instances are blocking new connections. ORA-12528 We checked the listener status and found the instance is also blocked in the listener which means the normal user cannot be able to establish a connection from the application side. Solve ORA-12528: TNS:listener: all appropriate instances are … Read more

ORA-00020: maximum number of processes exceeded

ORA-00020: maximum number of processes exceeded

In the Oracle database, we face an “ORA-00020: maximum number of processes exceeded” error while making a connection with the oracle database via sqlplus and the Application may encounter TNS errors. This practice we performing on Linux platform. Read how to solve ORA-12954 ORA-00020: maximum number of processes exceeded If you face ORA-00020 maximum number of … Read more