Oracle 7.0.15 Multi-Threaded Server w/SCO Unix Setup Prob!

From: James Dicke <jdicke_at_carroll1.cc.edu>
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

Original text of this message