Re: MTS on 8.1.5!

You need to have (SERVER=SHARED) in CONNECT_DATA string in Tnsnames.ora file on the SErver . Also Any client requiring a Shared Connection need to have this entry in it's Local Tnsnames.ora file

-Thiru

Man Yeung wrote:

> Hi,
> I have followed the instruction to configurate the MTS on winnt 4.0
> . However when I connect the server using sql+, it only can connect as
> dedicated server even dispatcher exists.
>
> When I issue lsnrctl service, following message appear,
>
> SNRCTL for 32-bit Windows: Version 8.1.5.0.0 - Production on 21-SEP-99
> 01:45:26
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Connecting to
> (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))
>
> Services Summary...
> HOME has 2 service handler(s)
> DEDICATED SERVER established:6 refused:0
> LOCAL SERVER
> DISPATCHER established:0 refused:0 current:0 max:254 state:ready
> D000 <machine: MY_COMPUTER, pid: 175>
> (ADDRESS=(PROTOCOL=tcp)(HOST=my_computer)(PORT=1030))
> Presentation: oracle.aurora.server.SGiopServer
> PLSExtProc has 1 service handler(s)
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
> The command completed successfully
>
> However, when I connect to the database, only dedicated server can
> be used. i.e.
>
> SQL> select username, program, server from v$session
> 2 where audsid=userenv('sessionid');
>
> USERNAME PROGRAM
> ------------------------------
> --------------------------------------------------------
> SERVER
> ---------
> SCOTT SQLPLUSW.EXE
> DEDICATED
>
> Following is my tnsname.ora
>
> # D:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration
> File:D:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
> # Generated by Oracle Net8 Assistant
>
> HOME =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = my_computer)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = HOME)
> )
> )
>
> Please help.
>
> Man
Received on Mon Sep 20 1999 - 13:14:58 CDT