Configuring Multi Threaded Server

[psachdev]

Our database has the following settings in init.ora :

mts_dispatchers="tcp,1"
mts_max_dispatchers=10
mts_servers=1
mts_max_servers=5
mts_service=EXPSRVR
mts_listener_address="(ADDRESS=(PROTOCOL=TCP)(HOST=NH_ORACLE)(PORT=1521))"

The listener.ora file is as follows :
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = NH_ORACLE)(PORT = 1521))
)
)


The users are able to connect. But when I run the query :

select username, server from v$session; I see that every user is DEDICATED. V$CIRCUIT view is also empty. I have also checked the TNSNAMES.ORA file and it does NOT contain
(SRVR = DEDICATED) in the CONNECT_DATA.

Any idea why everybody is still connecting using a dedicated server...???

Regards

[sln81]

Checkup if the dispatcher process is startted or not.

[psachdev]

The V$dispatcher view is showing one D000 with WAIT in the status column.

Regards

[sreddy]

Whats your dataabse name ? Is it EXPSRVR ?

[psachdev]

Yes this is the DB_NAME. This is also the GLOBAL_DBNAME and SID defined in SID_LIST clause of listener.ora.

[sreddy]

type in at the prompt "lsnrctl services" and see you have the services runnning and dispathers are active.