I'm betting you have epc_disabled in your listener.ora file.
(ENVS='EPC_DISABLED=TRUE')
This was put in to disable oracle trace in 8.0.5, but I was told it
caused problems for 8.1.6. I hadn't looked on metalink for details, but
after removing the epc_disabled line from my listener.ora, my MTS works
fine under 8.1.6.3. I was having the same trouble getting only
dedicated connections.
I just looked so I guess I'll have to try double quotes.
HTH
Brian
*******************************************
upgrade question 8.06 to 8.1.6 (EPC_DISABLED)
Hello,
friday i upgraded 8.0.6 to 8.1.6. thanks to you for the help l I became
succesfull. The only issue i had was with the listener having this
EPC_DISABLED=TRUE. the following is my current litsener configuration
for 816. How can I enable EPC_DISABLED=TRUE for 8.1.6? When epc was
enabled i received the following error message so i had to comment it
out.
=======================================
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12533: TNS:illegal ADDRESS parameters
TNS-12560: TNSrotocol adapter error
TNS-00503: Illegal ADDRESS parameter
=====================================
LISTENER = (ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = listener))
(ADDRESS =
(PROTOCOL = IPC)
(KEY = prod))
(ADDRESS =
(PROTOCOL = tcp)
(HOST = chihpdv2)
(PORT = 1521))
)
CONNECT_TIMEOUT_LISTENER = 90
SID_LIST_LISTENER = (SID_LIST =
(SID_DESC =
(SID_NAME = prod)
(ORACLE_HOME = /home/oracle/product/8.1.6)
# (ENVS='EPC_DISABLED=TRUE')
)
)
------------------------------------------------------------------------
--------
use double quotes " around the environment string.
> -----Original Message-----
> From: chao_ping [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 2:46 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
>
>
> hi,
> have u made it? i also encounted the same problem of
> oracle 817 on solaris,
> if i specify server=shared in tnsnames.ora, then it gives
> out 12520 error code.
>
> ----- Original Message -----
> From: "Harvinder Singh" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 25, 2001 11:36 PM
> Subject: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
>
>
> >
> > Hi,
> >
> > I have configured the server to use MTS and still dedicated
> connections r
> > used.
> > What might be the reason....database is 8.1.6.3.4
> >
> >
> >
> > LSNRCTL> services
> > Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
> > Services Summary...
> > ora2000 has 6 service handler(s)
> > DISPATCHER established:0 refused:0 current:0 max:1022
> state:ready
> > D004 <machine: ORA2000, pid: 1956>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
> > DISPATCHER established:0 refused:0 current:0 max:1022
> state:ready
> > D003 <machine: ORA2000, pid: 1952>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
> > DISPATCHER established:0 refused:0 current:0 max:1022
> state:ready
> > D002 <machine: ORA2000, pid: 1948>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
> > DISPATCHER established:0 refused:0 current:0 max:1022
> state:ready
> > D001 <machine: ORA2000, pid: 1944>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
> > DISPATCHER established:0 refused:0 current:0 max:1022
> state:ready
> > D000 <machine: ORA2000, pid: 1940>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
> > PLSExtProc has 1 service handler(s)
> > DEDICATED SERVER established:0 refused:0
> > LOCAL SERVER
> > ora2000 has 6 service handler(s)
> > DISPATCHER established:0 refused:0 current:0 max:1022
> state:ready
> > D004 <machine: ORA2000, pid: 1956>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
> > DISPATCHER established:0 refused:0 current:0 max:1022
> state:ready
> > D003 <machine: ORA2000, pid: 1952>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
> > DISPATCHER established:0 refused:0 current:0 max:1022
> state:ready
> > D002 <machine: ORA2000, pid: 1948>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
> > DISPATCHER established:0 refused:0 current:0 max:1022
> state:ready
> > D001 <machine: ORA2000, pid: 1944>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
> > DISPATCHER established:0 refused:0 current:0 max:1022
> state:ready
> > D000 <machine: ORA2000, pid: 1940>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
> > ora2000 has 1 service handler(s)
> > DEDICATED SERVER established:0 refused:0
> > LOCAL SERVER
> > ora2000 has 6 service handler(s)
> > DEDICATED SERVER established:76 refused:0
> > LOCAL SERVER
> > The command completed successfully
> >
> >
> > init.ora looks like:
> >
> > mts_dispatchers = "TCP,5"
> > mts_max_dispatchers=50
> > mts_servers=20
> > mts_max_servers=50
> > LOCAL_LISTENER = "(ADDRESS_LIST = (Address = (Protocol =
> TCP) (Host=ora2000)
> > (Port=1521)))"
> >
> >
> > Thanks
> > Harvinder
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Harvinder Singh
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> >Wzءr&9,BY>
뢷jSz7jSzɨrq(SI?YQ_ӝjpz
> jXh-'zםqdzSXEURDCTL*kSSX'Xu1(tm)j
> kr+r?\--)Ѯv)...xb)-jXyʵSx5%9,B؝SX'X*
> ??ɩvBr?jw...(tm)y'n?
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anderson, Brian
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).