Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MTS
Hi Alan,
Find comments imbedded.
"Alan" <athiery_at_ais-nantes.fr> wrote in message
news:3d33b9a0$0$10538$626a54ce_at_news.free.fr...
> On an Oracle 8.1.7 Windows NT 4, I dont succed to
> access on an instance via MTS
>
> I have
>
> * in the init.ora :
>
> mts_dispatchers = "(protocol=TCP)(tick=15)(pool=true)(DISPATCHERS=2)"
> LOCAL_LISTENER = "(ADDRESS = (PROTOCOL=TCP)(HOST=pcat)(PORT=1521))"
The LOCAL_LISTENER parameter looks OK but note as you're using the default 1521 port, it's actually unnecessary. Oracle will register itself with the listener on this port by default. Try taking it out.
Check the SERVICES_NAMES parameter. Make sure it's set to ALAIN.
>
>
> * in the view v$dispacher i obtain
>
> NAME NETWORK PADDR STATUS ACCEPT MESSAGES BYTES BREAKS OWNED CREATED IDLE
> BUSY LISTENER CONF_INDX
> D000 (ADDRESS=(PROTOCOL=tcp)(HOST=pcat)(PORT=1515)) 2B7D9DC4 WAIT YES 0 0
0
> 0 0 202867 0 0 0
> D001 (ADDRESS=(PROTOCOL=tcp)(HOST=pcat)(PORT=1517)) 2B7DA0EC WAIT YES 0 0
0
> 0 0 202838 0 0 0
What does services on the listener say (lsnrctl services). Have the dispatcher processes registered themselves with the listener. Are you sure the listener has been started and configured correctly.
>
> * i force connection via MTS in the tnsnames.ora
>
>
> ALAIN =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = pcat)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = alain)
> (SRVR = SHARED)
> )
> )
>
Change (SID = alain) to (SERVICE_NAME = alain). Also make sure there are no funnies in the sqlnet.ora (eg. NAMES.DIRECTORY_PATH=(TNSNAMES), NAMES.DEFAULT_DOMAIN = world, etc.)
> But when i try to access via sqlplus i obtain an ORA-12519 error
>
> Why ???
Hopefully because of one of the above suggestions.
Good Luck
Richard
>
> ALAN
>
>
>
>
>
>
>
Received on Tue Jul 16 2002 - 02:25:24 CDT