Check Dispatcher

Often in architecture MTS (Multi Thread Server) we need check a specific dispatcher is running so correct. The first thing to do is identify where each dispatcher listens,we can do this with following query

select name, network from v$dispatcher;


It will return the name of all active ports where dispatchers are listening;


D070 (ADDRESS=(PROTOCOL=tcp)(HOST=dante)(PORT=65288))
D071 (ADDRESS=(PROTOCOL=tcp)(HOST=dante)(PORT=65289))
D072 (ADDRESS=(PROTOCOL=tcp)(HOST=dante)(PORT=65290))
D073 (ADDRESS=(PROTOCOL=tcp)(HOST=dante)(PORT=65291))
D074 (ADDRESS=(PROTOCOL=tcp)(HOST=dante)(PORT=65292))

75 rows selected.


The next thing we should do is see if we arrived, we will use the tnsping utility;

tnsping (ADDRESS=(PROTOCOL=tcp)(HOST=dante)(PORT=65286))


The last thing to make sure it works properly is to make a connection to the database;

sqlplus USER/PASSWORD@(ADDRESS=(PROTOCOL=tcp)(HOST=dante)(PORT=65286))




Leave a Reply

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

You are commenting using your 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