I have a instance which run as MTS mode. When i startup my instance, i can see all the dispatcher (D000) and shared server process (S000, S001...) in OS level. When i query v$dispatcher, the dispatcher return everything is normal.
However, when i run "lsnrctl service", i can only see the DEDICATED SERVER status. My Dispatcher seems can't register to my Listener.
When i check the listener.log, i see
"22-JUL-2003 10:27:38 * service_died * 12537" and this error occurs once a minute !
I think there is some problem with my Listener so that it can't recognise the Dispatcher and MTS mode can't be used.
When i connect to my DB through SQL Plus, I can connect and everything is normal, but this connection is forced to be in "Dedicated Server" mode. The Dispatcher did not receive any request.
If i really think this is the problem of the listener. Can i use listener in another server for this instance instead ?? (i.e. can the listener and instance in different host ??)
What is the Database version and OS? In the Unix systems if you don't have enough memory and semophores, the dispatchers will not register with the listeners.
Bookmarks