Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Problem with SQLNet/VMS/Multinet
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...Received on Mon Sep 29 1997 - 00:00:00 CDT
-<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
![]() |
![]() |