IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Sometimes You can get ” TNS-12516: TNS:listener could not find available handler with matching protocol stack ” error.
Read More »TNS-12516: TNS:listener could not find available handler with matching protocol stack
Tag Archives: ORA-00020
ORA-00018: maximum number of sessions exceeded
Hi, Sometimes you can get ” ORA-00018: maximum number of sessions exceeded ” error.
Read More »ORA-00020: maximum number of processes (%s) exceeded
How to increase PROCESSES initialization parameter : Check Current Setting of Parameters 1)show parameter sessions 2)show parameter processes 3)show parameter transactions A basic formula for determining these parameter values …
Read More »ORA-00020: maximum number of processes exceeded and alter system set processes
Sometimes you may get ” ORA-00020: maximum number of processes exceeded ” error while login oracle database via sqlplus and Application may encounter TNS errors.
Read More »