Listener services going in to blocked state
We are seeing that our listener services go into "blocked" state and at the same time then we see the following error getting displayed in the listener log :
TNS-12519: TNS:no appropriate service handler found
We tried increasing the processes count but that did not solve the issue ...also we have seen that each time this occurs there is a PMON dump file created which gets exhausted in logging the details since it has reached the "max_dump_file_size".
So one line of thought is that since the PMON is unable to log further it might be spinning and hence will stop registering the listener and hence the listener it not aware of the actual picture .
TNS-12519: TNS:no appropriate service handler found
We tried increasing the processes count but that did not solve the issue ...also we have seen that each time this occurs there is a PMON dump file created which gets exhausted in logging the details since it has reached the "max_dump_file_size".
So one line of thought is that since the PMON is unable to log further it might be spinning and hence will stop registering the listener and hence the listener it not aware of the actual picture .
0