SQL*NET - OpenVMS 7.1 long connect time 
Author Message
 SQL*NET - OpenVMS 7.1 long connect time

Hi,

after trying several approaches to solve this problem I post some more
information, please excuse the waste of bandwidth.

The system is an alpha-server 800 with 256 MB RAM, running oracle
VLM 7.3.2.3.2.
Connect to the database via SQLplus directtly is no problem, but when
using SQLnet, connect time goes up to 15 seconds.
I turnd trace level  for client and server to ADMIN and got an error,
I can't fix.

1. ) From the Server trace
got NSPTCN packet
recving connect data
273 bytes from leftover
263 bytes from NS buffer
sending NSPTAC packet
24 bytes to transport
connect handshake is complete
nsctxinf[0]=0x9, [1]=0x8
initializing NLTM in asynchronous mode
starting timer at 13-NOV-97 16:15:30
timer created for connection
Broken-connection function has been set.
cmd=4, lcl=0x0

-<FATAL?>- failed with error 12630

2. Client trace gives another error
 Got routable address information
Making call with following address information: (DESCRIPTION=(CONNECT_DATA=(SID=REPORT)(GLOBAL_NAME=orasrv.world)(CID=(PROGRAM=)(HOS
T=ORASRV)(USER=ORAGATE)))(ADDRESS=(PROTOCOL=ipc)(KEY=orasrv.world)))
Calling with outgoing connect data (DESCRIPTION=(CONNECT_DATA=(SID=REPORT)(GLOBAL_NAME=orasrv.world)(CID=(PROGRAM=)(HOST=ORASRV)(USE
R=ORAGATE)))(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=orasrv)(Port=1526))(ADDRESS=(COMMUNITY=tcp.world)(PROTOC
OL=TCP)(Host=orasrv)(Port=1521))))
connecting...
(DESCRIPTION=(CONNECT_DATA=(SID=REPORT)(GLOBAL_NAME=orasrv.world)(CID=(PROGRAM=)(HOST=ORASRV)(USER=ORAGATE)))(ADDRESS=(PROTOCOL=ipc)
(KEY=orasrv.world)))
a[0]=(null)
a[1]=(null)
a[2]=(null)
a[3]=orasrv.world
a[4]=(null)
a[5]=(null)
a[6]=(null)
a[7]=(null)
ntmadmb1=orasrv.world
opening transport...
-<ERROR>- op=1, nt[0]=511, nt[1]=19, nt[2]=324
-<ERROR>- nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=19, nt[2]=324
-<ERROR>- unable to open transport
Call failed...
Call made to destination

Best regards

Andreas
--
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ proGIS Softwareentwicklung, Simulationssysteme, Beratung   +

+                                  FAX:  (49) 241 470 67 -29 +



Mon, 01 May 2000 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Move Oracle 7.1 on OpenVMS 6.1 to 7.1 VAX

2. RDBMS 7.1 on OpenVMS 7.1

3. RDBMS 7.1 on OpenVMS 7.1

4. ORA-07690 on OpenVMS 7.1

5. TNS 12203 with SQLNET-TCPIP and OPENVMS 7.1

6. Renaming datafiles on 7.1/OpenVMS

7. Forms 3.O on OpenVMS 7.1?

8. OpenVMS 7.1 error

9. Oracle 7.3 and OpenVMS 7.1 FAST I/O

10. TNS 12203 SQLNET - TCPIP - OPENVMS 7.1


 
Powered by phpBB® Forum Software