ORA-12520: TNS:listener could not find available handler for requested type of server

The problem turned out to be caused by the fact that my listener was not named LISTENER. The database was still registering with it somehow, presumably because it was using the default port, but when attempting to open a connection to the service I saw the following error:

Error seperti ini di Database Oracle bisa muncul di karenakan listener di Oracle bukan bernama LISTENER.  Database masih mendaftarkan di dengan nama tadi, sepertinya antara LISTENER asli dengan ‘nama listener yg lain’ menggunakan port yg sama, tapi pada saat mencoba membuka koneksi muncul Error :

ORA-12520: TNS:listener could not find available handler for requested type of server

Sebelum error di atas muncul bisa diperiksa status service listener dengan cara sbb :

…$ lsnrctl service (perhatikan error yg muncul setelah command tadi di eksekusi)

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...

Service "scr9" has 1 instance(s).
  Instance "scr9", status BLOCKED, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:blocked
         LOCAL SERVER

state:blocked inilah yg nmenyebabkan listener di blokir.

Untuk penyelesaian masalah ini konfigur ulang instance local_listener parameter seperti berikut ini :

alter system set local_listener=
  '(ADDRESS=(PROTOCOL=TCP)(HOST=bloo)(PORT=1521))' scope=spfile;

Jika ada parameter di dalam tnsnames.ora yg menunjuk ke listener, gunakana saja nama listener yg ada :

alter system set local_listener='<listener_name>' scope=spfile;

~ by Ali Imran on July 12, 2011.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: