27 Januari 2016

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

BY Nunung Indrianto IN , , No comments

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. :)



0 comments:

Posting Komentar

Bagaimana pendapat Anda tentang tulisan di Blog Nindrianto ini? Speak up your mind...

It's Me !