Solusi Error ORA-00020 – Application Stop, Need Login Oracle

Kesempatan kali ini, saya ingin sharing kembali tentang Oracle problem. Sebagai seorang administrator system terkadang kita menemukan masalah yang tidak pernah kita duga sebelumnya. Masalah kali ini adalah, ketika ada traning atau workshop satu aplikasi GnG (Geology, Geophysics) di lingkungan kerja saya, tiba-tiba para peserta mengalami masalah aplikasi error, dengan notifikasi request Oracle Login.

Selanjutnya, error di atas harus didefinisikan terlebih dulu sebagai berikut :

PROBLEM:
When many users accessing the DSG application, the oracle login prompt appeared frequently

INVESTIGATION:
Check Oracle server alert log location:
From Oracle server, login as oracle user:
Start sqlplus connect as sysdba

Check location of Oracle alert log file, in the /trace/alert_owphe10.log

Noticed there are errors ORA-00020: maximum number of processes (400) exceeded.
Hence the processes instance parameter need to be increased.

SOLUTION:
Check current processes parameter value:

So, we tried to change processes parameter value to 2000. From oracle forum, recommended is doubling the value to allow for future growth.


Next steps are :
  • Stop Oracle listener:
  • Shutdown Oracle instance:
  • Wait until the instance shutdown completed
  • SQL> startup;
  • Wait until the instance started succesfully
  • Start again Oracle listener

Perhaps, masalah error ORA-00020 karena overlimit process di database Oracle di atas bisa teratasi. 🙂


Leave a Reply

Your email address will not be published. Required fields are marked *