<div>
In addation to Schwertner comment, if listerner is blocked or stoped, you can still connect to oracle server using SET ORACLE_SID command performed on database server rather than proviiding connecting string.
</div>


In addation to Schwertner comment, if listerner is blocked or stoped, you can still connect to oracle server using SET ORACLE_SID command performed on database server rather than proviiding connecting string.

<div>
<div class="content wysiwyg-content">
In my production environment, I recently saw that no one could log on as the listner state was blocked.<br />
<br />
Service &quot;prd002l&quot; has 1 instance(s).<br />
&nbsp; Instance &quot;prd002l&quot;, status READY, has 1 handler(s) for this service...<br />
&nbsp; &nbsp; Handler(s):<br />
&nbsp; &nbsp; &nbsp; &quot;DEDICATED&quot; established:12730 refused:0 state:blocked<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LOCAL SERVER <br />
<br />
This is IBM-AIX 5.3 envoronment. CPU = 2 &nbsp; &nbsp; Memory = 16GB<br />
<br />

</div>
</div>


In my production environment, I recently saw that no one could log on as the listner state was blocked.

Service "prd002l" has 1 instance(s).
  Instance "prd002l", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:12730 refused:0 state:blocked
         LOCAL SERVER 

This is IBM-AIX 5.3 envoronment. CPU = 2     Memory = 16GB



How to determine ideal number of Sessions, Processes and Open Cursors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.