Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MTS connection issue

Re: MTS connection issue

From: fonyema <fonyema.14guhp_at_mail.mcse.ms>
Date: Fri, 9 Apr 2004 11:20:50 -0500
Message-ID: <fonyema.14guhp@mail.mcse.ms>

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=server))(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.

--
fonyema
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message548644.html
 
Received on Fri Apr 09 2004 - 11:20:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US