SqlNet help needed

From: <edwardd_at_yin.earlham.edu>
Date: 1995/08/15
Message-ID: <40r0ea$c2d_at_mips.infocom.com>

I'm trying to get SQlv2 working between two Vaxes for the first time. Using Oracle 7.1.3.1.3, VMS v 5-5.2, TCP and Multinet. I'ts making me NUTS.

My client machine attempts a connect and the server sees it, but refuses it.
I know the network works, the node is accessible etc. I've tried many varieties of listener.ora and tnsnames.ora etc etc. This is as close as I get. The CURRENT THEORY is that something is screwed up with the bequest ( see below) It is attempting to pass the name of ORASRV.COM to start the detached process, but in ARGV0 it's APPENDING my instance name to the file extension! So it looks for ORASRV.COMseed, seed being the name of my instance. What gives? I'd be forever grateful for any clues, cause I'm clueless at this point.

SQLNET.LOG --------------------------------

Fatal OSN connect error 12500, connecting to: (DESCRIPTION=(CONNECT_DATA=(SID=seed)(CID=(PROGRAM=)(HOST=YIN)(USER=ALANMOOR)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=seed))(ADDRESS=(COMMUNITY=tcpadmin)(PROTOCOL=TCP)(Host=Tian)(Port=15. VERSION INFORMATION:

	TNS for VMS: Version 2.1.3.0.0 - Production
	VMS Mailbox NT Protocol Adapter for VMS: Version 2.1.3.0.0 - Production
	Oracle Bequeath NT Protocol Adapter for VMS: Version 2.1.3.0.0 - Production
	TCP/IP NT Protocol Adapter for VMS: Version 2.1.3.0.0 - Beta
	RAW NT Protocol Adapter for VMS: Version 2.1.3.0.0 - Beta

  Time: 15-AUG-95 10:12:02
  Tracing not turned on.
  Tns error struct:
    nr err code: 12204

TNS-12204: TNS:received data refused from an application

ns main err code: 12564

TNS-12564: TNS:connection refused

    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

Listener.Log ------------------------------

TNSLSNR for VMS: Version 2.1.3.0.0 - Production on 15-AUG-95 10:10:44

System parameter file is TIAN$DKA300:[ORACLE7.CODE_ROOT.NETWORK.ADMIN]listener.ora Log messages written to DISK$NEWDISK3:[ORACLE7.CODE_ROOT.network.log]listener.log Trace information written to DISK$NEWDISK3:[ORACLE7.CODE_ROOT.network.trace]listener.trc Trace level is currently 6

Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=seed.world)))
Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=seed)))
Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=prod.world)))
Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=prod)))
Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=a.world)))
Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=a)))
Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(COMMUNITY=tcpadmin.world)(PROTOCOL=TCP)(Host=Tian)(Port=1521)))
TIMESTAMP ** EVENT [** SID] ** RETURN CODE

15-AUG-95 10:11:01 ** status ** 0
15-AUG-95 10:11:50 ** establish ** seed ** 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact

Listener.Trc ---------------------------------

TNSLSNR for VMS: Version 2.1.3.0.0 - Production on 15-AUG-95 10:10:42

TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is "DISK$NEWDISK3:[ORACLE7.CODE_ROOT.network.trace] listener.trc" New trace level is 6
TRACE CONFIGURATION INFORMATION ENDS ---
PARAMETER SOURCE INFORMATION FOLLOWS --- Attempted load of system pfile source TIAN$DKA300:[ORACLE7.CODE_ROOT.NETWO RK.ADMIN]listener.ora Parameter source loaded successfully

Attempted load of command line source
Parameter source was not loaded

-> PARAMETER TABLE LOAD RESULTS FOLLOW <- Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-   STARTUP_WAIT_TIME_LISTENER = 0
  SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = seed)
(PROGRAM = TIAN$DKA300:[ORACLE7.CODE_ROOT.rdbms]ORASRV.COM) (TIMEOUT = 0))
(SID_DESC = (SID_NAME = prod)
(PROGRAM = tian$dka300:[oracle7.code_root.rdbms]orasrv.com) (TIMEOUT = 0))
(SID_DESC = (SID_NAME = a)
(PROGRAM = tian$dka300:[oracle7.code_root.rdbms]orasrv.com) (TIMEOUT = 0)))
  CONNECT_TIMEOUT_LISTENER = 10
  TRACE_LEVEL_LISTENER = ADMIN
  LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL=IPC) (KEY= seed.world))
(ADDRESS= (PROTOCOL=IPC) (KEY= seed))
(ADDRESS= (PROTOCOL=IPC) (KEY= prod.world))
(ADDRESS= (PROTOCOL=IPC) (KEY= prod))
(ADDRESS= (PROTOCOL=IPC) (KEY= a.world))
(ADDRESS= (PROTOCOL=IPC) (KEY= a))
(ADDRESS = (COMMUNITY = tcpadmin.world) (PROTOCOL = TCP)
(Host = Tian) (Port = 1521)))

--- PARAMETER SOURCE INFORMATION ENDS ---

LOG CONFIGURATION INFORMATION FOLLOWS --- Log stream will be "DISK$NEWDISK3:[ORACLE7.CODE_ROOT.network.log]listener.log" Log stream validation requested Log stream is valid .
(stuff deleted).
. opening transport... transport is open global context check-in (to slot 7) complete Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=a)))
(DESCRIPTION=(CONNECT_TIMEOUT=10)
(ADDRESS=(COMMUNITY=tcpadmin.world)(PROTOCOL=TCP)(Host=Tian)(Port=1521)))
port resolved to 1521 looking up IP addr for host: Tian opening transport... No PROTOCOL.ORA file is found Validnode Table IN use; err 0x0 transport is open global context check-in (to slot 8) complete Listening on: (DESCRIPTION=
(CONNECT_TIMEOUT=10)(ADDRESS=
(COMMUNITY=tcpadmin.world)(PROTOCOL=TCP)(Host=Tian)(Port=1521)))
begin registration process for 1 begin notification process for 1 setting transport read mode (2) reading (asynchronously) from transport... . .
(Stuff deleted)
. . transport is open global context check-in (to slot 9) complete doing connect handshake... 195 bytes from transport got NSPTCN packet command = establish
(ADDRESS=(PROTOCOL=beq)(ENVS=)(ARGV0=
vLOOK HERE! TIAN$DKA300:[ORACLE7.CODE_ROOT.rdbms]ORASRV.COMseed)
(ARGS='(LOCAL=NO)')(SID_NAME=seed)
(PROGRAM=TIAN$DKA300:[ORACLE7.CODE_ROOT.rdbms]ORASRV.COM)(TIMEOUT=0))
connecting... -<ERROR>- nsres: id=9, op=72, ns=12547, ns2=12560; nt[0]=517, nt[1]=0, nt[2]=340 sending NSPTRF packet 200 bytes to transport no timer allocated closing transport global context check-out (from slot 9) complete Deallocating cxd 0x1c1720. 0 pre-posted event(s) waiting for transport event (1 thru 8)... 1 newly-posted event(s) event is 0x1, on 1 1 posted event(s) opening transport... reading (asynchronously) from transport... ..into overflow area...

Thanks for your help.
ed

Ed Delaney                                   | Internet: 
Assoc. Dir. of Administrative Computing      |   edwardd_at_earlham.edu
Drawer-14                                    | Phone:
Earlham College                              |   317-983-1284

Richmond, IN 47374

If you can walk you can dance, if you can talk you can sing.

Received on Tue Aug 15 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: XLI: "Where can I get an ODBC driver for Oracle??"
Previous message: Phil Filder: "Re: Oracle down"
Next in thread: Morgan Skinner: "Re: SqlNet help needed"
Reply: Morgan Skinner: "Re: SqlNet help needed"
Maybe reply: Edward Delaney: "Re: SqlNet help needed"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message