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).