SQL*Net V2 problem

From: Ron Loxton <loxtonr_at_govonca.gov.on.ca>
Date: Mon, 19 Sep 1994 20:14:03 GMT
Message-ID: <1994Sep19.201403.15804_at_govonca.gov.on.ca>

        I am trying to configure a SQL*Net V2 network under pathworks V5 connecting to a Version 7 database on an Open VMS machine. The log files are included for your infomation. Any help would be appeciated.

---

SQLNET.LOG

---

Fatal OSN connect error 12500, connecting to:

(DESCRIPTION=(CONNECT_DATA=(SID=TEST)(CID=(PROGRAM=C:\SW\ORAWIN\BIN\PLUS31.EXE) (HOST=Windows
PC)(USER=OraUser)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=ALPHATEST.world)) (ADDRESS=(COMMUNITY=DECNET.world)(PROTOCOL=DECNet)(Node=NRNWPA)(Object=LSNR1))))

  VERSION INFORMATION:

	TNS for MSWINDOWS: Version 2.0.15.0.2 - Production
	ipc
	atk
	csn
	vines
	lu62
	ntb
	osi4
	PATHWORKS for Windows Decnet NT Protocol Adapter for 
	MSWINDOWS: Version 2.0.13.1.0 - Developer's Release
	beq
	ipc
	raw
	spx
	nmp
	tcp
	async

  Time: 19-SEP-94 15:59:47
  Tracing to file: D:\SQLNET\sqlnet.trc
  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

---

Fatal OSN connect error 12154.

  VERSION INFORMATION:

	TNS for MSWINDOWS: Version 2.0.15.0.2 - Production
	ipc
	atk
	csn
	vines
	lu62
	ntb
	osi4
	PATHWORKS for Windows Decnet NT Protocol Adapter for 
	MSWINDOWS: Version 2.0.13.1.0 - Developer's Release
	beq
	ipc
	raw
	spx
	nmp
	tcp
	async

  Time: 19-SEP-94 15:59:48
  Tracing to file: D:\SQLNET\sqlnet.trc

---

Fatal OSN connect error 12154.

  VERSION INFORMATION:

	TNS for MSWINDOWS: Version 2.0.15.0.2 - Production
	ipc
	atk
	csn
	vines
	lu62
	ntb
	osi4
	PATHWORKS for Windows Decnet NT Protocol Adapter for 
	MSWINDOWS: Version 2.0.13.1.0 - Developer's Release
	beq
	ipc
	raw
	spx
	nmp
	tcp
	async

  Time: 19-SEP-94 15:59:54
  Tracing to file: D:\SQLNET\sqlnet.trc

---

Fatal OSN connect error 12154.

  VERSION INFORMATION:

	TNS for MSWINDOWS: Version 2.0.15.0.2 - Production
	ipc
	atk
	csn
	vines
	lu62
	ntb
	osi4
	PATHWORKS for Windows Decnet NT Protocol Adapter for 
	MSWINDOWS: Version 2.0.13.1.0 - Developer's Release
	beq
	ipc
	raw
	spx
	nmp
	tcp
	async

  Time: 19-SEP-94 15:59:55
  Tracing to file: D:\SQLNET\sqlnet.trc

---

SQLNET.TRC

• TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is "D:\SQLNET\sqlnet.trc" New trace level is 6
• TRACE CONFIGURATION INFORMATION ENDS ---
• PARAMETER SOURCE INFORMATION FOLLOWS --- Attempted load of system pfile source C:\SW\ORAWIN\network\admin\sqlnet.ora Parameter source loaded successfully

Attempted load of local pfile source C:\SW\ORAWIN\BIN\sqlnet.ora Parameter source was not loaded

 -> PARAMETER TABLE LOAD RESULTS FOLLOW <- Successful parameter table load
 -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-   TRACE_DIRECTORY_CLIENT = D:\SQLNET
  LOG_DIRECTORY_CLIENT = D:\SQLNET
  name.default_zone = world
  names.default_domain = world
  sqlnet.expire_time = 2147483647
  TRACE_LEVEL_CLIENT = ADMIN
--- PARAMETER SOURCE INFORMATION ENDS ---

• LOG CONFIGURATION INFORMATION FOLLOWS --- Attempted open of log stream "D:\SQLNET\sqlnet.log" Successful stream open
• LOG CONFIGURATION INFORMATION ENDS ---
  • I DON'T KNOW WHY I GET THIS I'M NOT USING AN INTERCHANGE ********

Unable to get data from navigation file tnsnav.ora -<ERROR>- construction of local names file failed system names file is C:\SW\ORAWIN\network\admin\tnsnames.ora initial retry timeout for all servers is 500 csecs max request retries per server is 2
default zone is world
Using nncin2a() to build connect descriptor for (possibly remote) database.
initial load of C:\SW\ORAWIN\network\admin\tnsnames.ora success
Return code from nncin2a is 406
-<ERROR>- Couldn't connect, returning 12154 No Routing global data found

---

TNSNAMES.ORA

################
# Filename......: tnsnames.ora
# Client Profile: NWR.world

# Date..........: 19-SEP-94 15:57:43

################

ALPHATEST.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = DECNET.world)
          (PROTOCOL = DECNet)
          (Node = NRNWPA)
          (Object = LSNR1)
        )

    )
    (CONNECT_DATA = (SID = TEST)
    )
  ) Received on Mon Sep 19 1994 - 22:14:03 CEST