Try:
1) Force shared connections using (SRVR=SHARED) in the tnsnames.ora.
2) Change the service name for the MTS_service and restart te db and
listener. Make sure the service is registered with the listener. Add a new
entry pointing to the new service in tnsnames.ora and let you app use this
entry. I think the entry in tnsnames.ora will need to be like (service_name
= ) instead of (sid = ).
3) sqlnet tracing may need to be done.
Regards,
Waleed
-----Original Message-----
Sent: Friday, December 27, 2002 8:49 AM
To: Multiple recipients of list ORACLE-L
>
> What do you get when run this on the server hosting Oracle:
>
> lsnrctl services
>
>
Waleed, thanks for your input. Here is what I have (below are my MTS
settings)
MYDB has 1 service handler(s)
DEDICATED SERVER established:259 refused:1
LOCAL SERVER
MYDB has 6 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
DISPATCHER established:2 refused:0 current:2 max:4000 state:ready
D004 <machine: MYSERVER, pid: 683>
(ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2276))
DISPATCHER established:4 refused:0 current:0 max:4000 state:ready
D003 <machine: MYSERVER, pid: 636>
(ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2275))
DISPATCHER established:1 refused:0 current:1 max:4000 state:ready
D002 <machine: MYSERVER, pid: 534>
(ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2274))
DISPATCHER established:1 refused:0 current:1 max:4000 state:ready
D001 <machine: MYSERVER, pid: 301>
(ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2273))
DISPATCHER established:1 refused:0 current:0 max:4000 state:ready
D000 <machine: MYSERVER, pid: 668>
(ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2272))
DB2 has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
DB3 has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
#######################################
MTS_DISPATCHERS="(protocol=tcp)(dispatchers=5)(pool=on)(tick=1)
(connections=1000)(sessions=4000)"
MTS_MAX_DISPATCHERS=32
MTS_SERVERS=5
MTS_MAX_SERVERS=64
MTS_SERVICE=MYDB
MTS_LISTENER_ADDRESS =
"(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=MYSERVER))"
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
