| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
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
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 =====================================
(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:chao_ping_cn_at_yahoo.com.cn] > 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" <Harvinder.Singh_at_metratech.com> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> > 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: Harvinder.Singh_at_MetraTech.com > > > > 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: ListGuru_at_fatcity.com (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 >
> jXh-'zםqdzSXEURDCTL*kSSX'Xu1(tm)j > kr+r?\--)Ѯv)...xb)-jXyʵSx5%9,B؝SX'X* > ??ɩv Br?jw...(tm)y'n? >
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: andersob_at_mail.dartnet.peachnet.edu 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Aug 06 2001 - 10:19:49 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |