I am having an mts connection problem. I inherited this server that has MTS configured with problems. It takes forever to make an sqlplus connection using an mts alias. Any help? below are relevant configuration information.



mts_circuits 555

mts_dispatchers (ADDRESS=(PROTOCOL=tcp)(HOST=ip address))(DISPATCHERS=2)

mts_listener_address (ADDRESS=(PROTOCOL=tcp)(HOST=ip address)(PORT=1523))

mts_max_dispatchers 20

mts_max_servers 5

mts_multiple_listeners FALSE

mts_servers 1

mts_service creremt

mts_sessions 550



Here are also sections of the configurations files that i think are relevant:



init.ora:

db_name = creremt

instance_name = cre

#global_names = true

service_names = cre



mts_dispatchers="(ADDRESS=(PROTOCOL=tcp)(HOST=serv  er))(DISPATCHERS=2)"

mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(HOST  =ip address)(PORT=1523))"

mts_max_servers = 5

mts_servers = 1

mts_max_dispatchers = 20



Listener.ora

LISTENER_MTS =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS=(PROTOCOL=tcp)(HOST=ip address )(PORT=1523))

)

(ADDRESS=(PROTOCOL=IPC)(KEY=cre))

)

)

)



SID_LIST_LISTENER_MTS =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /u01/app/oracle/product/8.1.7)

(PROGRAM = extproc)

)





TNSNAMES.ora



cremts =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS=(PROTOCOL=tcp)(HOST=ip address)(PORT=1523))

)

(CONNECT_DATA =

(service_name=cre)

(server=shared)

)

)



here is the output from my lsnrctl:



services listener_mts

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip address)(PORT=1523)))

Services Summary...

PLSExtProc has 1 service handler(s)

DEDICATED SERVER established:0 refused:0

LOCAL SERVER

creremt has 2 service handler(s)

DISPATCHER established:0 refused:0 current:0 max:1022 state:ready

D001 <machine: servername, pid: 11801>

(ADDRESS=(PROTOCOL=tcp)(HOST=ip address)(PORT=36385))

DISPATCHER established:0 refused:0 current:0 max:1022 state:ready

D000 <machine: servername, pid: 11799>

(ADDRESS=(PROTOCOL=tcp)(HOST=ip address)(PORT=36383))

The command completed successfully



The shared pool and the large pool are set to the same size.



By setting trace support level off, i have been able to achieve a faster response time when using tnsping. Now it is in the range of 0-10 msecs. However connecting by sqlplus using mts still takes for ever.



I discovered that on this server, host name resolution is not achieved. When i asked i was told that an external domain server is used since the application runs on the internet. As such configuring a local domain server on the box will mess things up. What impact does this have on MTS?



This is a problem i met on ground. It is confusing why the sqlplus connection using mts taakes for ever to succeed. Any assistance here will be highly welcomed.



Thanks.