Peter:
8.1.7 is pretty picky about syntax.
Here's what I have in my 8.1.7.4 database. (It's
Solaris, but I believe the parameter is the same)
MTS_DISPATCHERS="(address=(PROTOCOL=TCP)(HOST=atex-ent-prd1))(disp=2)"
mts_servers = 20
Good luck!
Barb
- "Schauss, Peter" <peter.schauss_at_ngc.com> wrote:
> Oracle version 8.1.7
> AIX 4.3.3
>
> I am trying to configure mult-threaded server on one
> of my development
> databases. In my init.ora file, I set
>
> (mts_dispatchers="(address=(protocol=tcp))"
> mts_servers=10
>
> When I bring up the database, I can see the
> dispatcher and
> servers. When I connect to the database with
> sqlnet, however,
> it still gives me a dedicated server.
>
> I tried forcing the connection by putting
> (server=shared) into
> the tnsnames.ora file on my client. Then I get:
>
> ORA-12520: TNS:listener could not find available
> handler for requested type
> of
> server
>
> What am I missing here?
>
> Thanks,
> Peter Schauss
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Schauss, Peter
> INET: peter.schauss_at_ngc.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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).
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Barbara Baker
INET: barbarabbaker_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Mon Nov 17 2003 - 09:34:24 CST
