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 -> Server refuses to start MTS/Shared connection

Server refuses to start MTS/Shared connection

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Tue, 29 Jun 2004 21:23:06 GMT
Message-ID: <40e1d8d2.696633415@localhost>


I have 2 non-production databases than run on the same server. Both are 8.1.7.4. Both configured very similarly. All parameters are very similar, except for some memory variables and SID specific variables. Each has a corresponding listener listening on a different port (1521/1524); listener is always started first (although, this might be necessary anymore). The sid's are DEV1 and PROD.

The machine connecting to them has entries that are identical in tnsnames.ora file, except for SID/port (tried service_name too). However, DEV1 accepts shared/MTS connections, but PROD doesn't. The listener shows that dispatchers are registered with it. When I try to 'foce' MTS connection by setting SERVER=MTS, connection goes through, but goes through as DEDICATED (checked through v$session). In fact, a quick query of mts views shows that no mts connection has ever been made (listener services confirms that as well).

I am lost.. what to do? I tried to do TNS tracing, but can't make much of it.

Thanks for any help
.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Jun 29 2004 - 16:23:06 CDT

Original text of this message

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