Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem with SQLNet/VMS/Multinet

Problem with SQLNet/VMS/Multinet

From: Malcolm Dunnett <dunnett_at_mala.bc.ca>
Date: 1997/09/29
Message-ID: <P+4rNfpTvq4G@malvm1.mala.bc.ca>

 I'm trying to set up Oracle SQLNet on a VMS/Alpha 7.1 system using Oracle 7.3.2.3.2 and Multinet 4.0B. I can't get the connection to work, whenever I try to use sqlplus to connect (sqlplus user/password_at_service) I get a "12221 - Illegal address parameter" error. A server process gets created on the server side and appears to be happily sitting there waiting for client communication, which will never come because of the above error.

 I've turned on tracing of the connection and attached the log. It seems to me the error is occurring at this point:

>connecting...
>(ADDRESS=(PROTOCOL=tcp)(DEV=_BG388:)(HOST=134.87.44.10)(PORT=0))
>port resolved to 0

   I don't believe the port number should be 0 here - I think it should be the port number the server process created for this connection is listening on. I believe this is information passed back to the client from the server during the initial handshake.

   I'm not sure where to look next - whether this is a SQLNet configuration problem or a bug in Multinet ( not returning the port number of a connection properly? )

   Is anyone successfully using this combination of SQLNet and Multinet? Any known bugs in this setup? Am I just completely missing the point?

-- 
=============================================================================
Malcolm Dunnett    Malaspina University-College     Email: dunnett_at_mala.bc.ca
Computer Services  Nanaimo, B.C. CANADA V9R 5S5       Tel: (250)755-8738


--- SQLNet trace file

--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is "[ORACLE7.NETWORK.ADMIN]sqlnet.trc"
New trace level is 4
--- TRACE CONFIGURATION INFORMATION ENDS ---

--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source DISK$MALVM2_SYS:[ORACLE7.NETWORK.ADMIN]sqlnet.ora
Parameter source loaded successfully

Attempted load of local pfile source SYS$LOGIN:sqlnet.ora
Parameter source was not loaded

 -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
 -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = user
NAME.DEFAULT_ZONE = mala.bc.ca
NAMES.DEFAULT_DOMAIN = mala.bc.ca
SQLNET.EXPIRE_TIME = 0
--- PARAMETER SOURCE INFORMATION ENDS ---

--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "[ORACLE7.NETWORK.ADMIN]sqlnet.log"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

Unable to get data from navigation file tnsnav.ora
local names file is SYS$LOGIN:tnsnames.ora
system names file is DISK$MALVM2_SYS:[ORACLE7.NETWORK.ADMIN]tnsnames.ora
Protocol stack: ipc
bad protocol stack i = 1
Protocol stack: beq
bad protocol stack i = 2
Protocol stack: decnet
bad protocol stack i = 3
Protocol stack: tcp
Protocol stack: raw
bad protocol stack i = 5
Not trying to enable dead connection detection.
Calling address: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=malvm2.mala.bc.ca)(PORT=1521))(CONNECT_DATA=(SID=MALASP)(GLOBAL_NAME=malasp.mala.bc.ca)(CID=(PROGRAM=)(HOST=MALVM2)(USER=ORACLE7))))
Getting local community information
Looking for local addresses setup by nrigla
No addresses in the preferred address list
TNSNAV.ORA is not present. No local communities entry.
Getting local address information
Simple address...
No community component so just use straight address
Resolving address to use to call destination or next hop
Found destination address
Local address
Local destination community found
This is a local community access
Got routable address information
Making call with following address information: (DESCRIPTION=(CONNECT_DATA=(SID=MALASP)(GLOBAL_NAME=malasp.mala.bc.ca)(CID=(PROGRAM=)(HOST=MALVM2)(USER=ORACLE7)))(ADDRESS=(PROTOCOL=TCP)(HOST=malvm2.mala.bc.ca)(PORT=1521)))
Calling with outgoing connect data (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=malvm2.mala.bc.ca)(PORT=1521))(CONNECT_DATA=(SID=MALASP)(GLOBAL_NAME=malasp.mala.bc.ca)(CID=(PROGRAM=)(HOST=MALVM2)(USER=ORACLE7))))
connecting...
(DESCRIPTION=(CONNECT_DATA=(SID=MALASP)(GLOBAL_NAME=malasp.mala.bc.ca)(CID=(PROGRAM=)(HOST=MALVM2)(USER=ORACLE7)))(ADDRESS=(PROTOCOL=TCP)(HOST=malvm2.mala.bc.ca)(PORT=1521)))
port resolved to 1521
looking up IP addr for host: malvm2.mala.bc.ca
opening transport...
trying to connect to socket 1.
transport is open
global context check-in (to slot 0) complete
doing connect handshake...
sending NSPTCN packet
got NSPTRD packet
redirected
no timer allocated
closing transport
global context check-out (from slot 0) complete
connecting...
(ADDRESS=(PROTOCOL=tcp)(DEV=_BG388:)(HOST=134.87.44.10)(PORT=0))
port resolved to 0
using host IP address: 134.87.44.10
opening transport...


-<FATAL?>- error - the PORT field of the address is missing.

-<ERROR>- error on socket 503 - ntresnt[0]=0, ntresnt[1]=0, ntresnt[2]=1
-<ERROR>- nsres: id=0, op=65, ns=12533, ns2=12560; nt[0]=503, nt[1]=0, nt[2]=0
-<ERROR>- unable to open transport
Call failed... Call made to destination Exiting NRICALL with following termination result -1
-<ERROR>- error from nricall
-<ERROR>- nr err code: 12221
-<ERROR>- ns main err code: 12533
-<ERROR>- ns (2) err code: 12560
-<ERROR>- nt main err code: 503
-<ERROR>- nt (2) err code: 0
-<ERROR>- nt OS err code: 0
-<ERROR>- Couldn't connect, returning 12221
Not trying to enable dead connection detection. Calling address: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=ORA_ROOT:[NETWORK.ADMIN]orasrv_beq_MALASP.com)(ARGV0=oracleMALASP)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=no))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=MALVM2)(USER=ORACLE7)))) Getting local community information Looking for local addresses setup by nrigla No addresses in the preferred address list TNSNAV.ORA is not present. No local communities entry. Getting local address information Simple address... No community component so just use straight address Resolving address to use to call destination or next hop Found destination address Local address Local destination community found This is a local community access Got routable address information Making call with following address information: (DESCRIPTION=(CONNECT_DATA=(CID=(PROGRAM=)(HOST=MALVM2)(USER=ORACLE7)))(ADDRESS=(PROTOCOL=beq)(PROGRAM=ORA_ROOT:[NETWORK.ADMIN]orasrv_beq_MALASP.com)(ARGV0=oracleMALASP)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=no))) Calling with outgoing connect data (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=ORA_ROOT:[NETWORK.ADMIN]orasrv_beq_MALASP.com)(ARGV0=oracleMALASP)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=no))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=MALVM2)(USER=ORACLE7)))) connecting... (DESCRIPTION=(CONNECT_DATA=(CID=(PROGRAM=)(HOST=MALVM2)(USER=ORACLE7)))(ADDRESS=(PROTOCOL=beq)(PROGRAM=ORA_ROOT:[NETWORK.ADMIN]orasrv_beq_MALASP.com)(ARGV0=oracleMALASP)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=no))) opening transport... transport is open global context check-in (to slot 0) complete doing connect handshake... sending NSPTCN packet sending 240 bytes connect data 240 bytes to NS buffer got NSPTAC packet connect handshake is complete nsctxinf[0]=0x1, [1]=0x1 145 bytes to NS buffer 129 bytes from NS buffer Call successful: returned data Exiting NRICALL with following termination result 0 no timer allocated closing transport global context check-out (from slot 0) complete
Received on Mon Sep 29 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US