Oracle 7.0.15 Multi-Threaded Server w/SCO Unix Setup Prob!
Date: 6 Mar 1994 21:42:47 -0600
Message-ID: <2le7rn$drs_at_carroll1.cc.edu>
I've had one hell of a problem tring to install SQL*NET V2 multi-threaded server (dispatchers). The information needed is scattered in many manuals and some arn't even accurate (several changes from 7.0.11 - 7.0.13 - 7.0.15). Also, the auto-configure routine is made to work for people who have SQL*Forms (I don't). Anyway, in a nut shell, I have been pulling out my hair over this. Thus, I'm posting here. :)
I have SCO UNIX 3.2 v4.2 with TCP/IP RUNTIME (most recent version with lli drivers). I also have Oracle 7.0.15 installed/running (works fin without MTS). I'm just tring to get MTS to work on a single machine to save memory from all the oracleorac instances that exist for every user/program (100k+ for each program just waisted). I don't need to use any other services of SQL*NET other then the dispatchers of MTS!
After getting as far as I could, I am getting the following errors when tring to start the database with MTS parameters in the INITORAC.ORA file.
00101, 00000, "invalid specification for system parameter mts_dispatchers" // *Cause: The syntax for the "mts_dispatchers" parameter is incorrect. // *Action: refer to the manual for correct syntax. 00102, 00000, "network protocol %s cannot be used by dispatchers"
// *Cause: The network specified in "mts_dispatchers" doesn't have the // functionalities required by the dispatchers. // *Action: refer to the manual on network protocols supported by the // dispatchers.
The %s in the second error contians the string "ipc" when it dumps to the screen. Problem is, the only thing I did to the initorac.ora was to uncomment the defualt MTS stuff:
mts_dispatchers = "ipc,1" mts_max_dispatchers=10 mts_servers=1 mts_max_servers=10 mts_service=orac mts_listener_address = "(ADDRESS=(PROTOCOL=ipc)(KEY=orac))"
So why isn't "ipc" valid here? I've tried things like "soc" and "uds" and a few other older things, but nothing helped. One would assume the remarked fields in the shipped init.ora file would have worked- what am I missing?
Also, I can't start the listener and that is probably because the MTS stuff never started, but here is the info on that as well:
# FILENAME: $ORAHOME/network/admin/listener.ora
#
LISTENER=
(ADDRESS=
(PROTOCOL=ipc)
(KEY=orac)
)
#
SID_LIST_LISTENER=
(SID_DESC=
(SID_NAME=orac)
(ORACLE_HOME=/u2/oracle)
)
# FILENAME: $ORAHOME/network/admin/tnsnames.ora
#
orac=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=ipc)
(OBJECT=LISTNER)
) (CONNECT_DATA=
(SID=orac)
)
)
--- And the output I get from issuing: lsnrctl start LSNRCTL for AT&T System V/386: Version 2.0.14.0.0 - Production Copyright (c) Oracle Corporation 1993. All rights reserved. Starting /u2/oracle/bin/tnslsnr: please wait... TNSLSNR for AT&T System V/386: Version 2.0.14.0.0 - Production System parameter file is /u2/oracle/network/admin/listener.ora Log messages written to /u2/oracle/network/log/listener.log Trace information written to /u2/oracle/network/trace/listener.trc Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=ipc)(KEY=orac))) TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error AT&T System V/386 Error: 97: Protocol not supported --- If anyone has any ideas, hints, manual pages, etc... I need it all :) I'm baffled by this. James Dicke Minion Development Corp.Received on Mon Mar 07 1994 - 04:42:47 CET