SQL*Net for DEC VAX/VMS and Oracle on VMS
Date: 1 Jun 92 15:44:27 GMT
Message-ID: <1992Jun01.154427.20798_at_eng.umd.edu>
To Oracle (VMS) netters,
Both the local VMS system manager and myself could not solve the following problem. Could you please take a look and see if you can spot the cause?
The objective and setup:
Using SQL*Net Macintosh version to query a database in Oracle VAX/VMS.
Networking is done by thin-ethernet TCP/IP. The connection is apparently fine
according to the server log below.
The Version of SQL*Net DEC VAX/VMS is 1.2
The Version of SQL*Net Mac is 1.7(?)
Both the Mac and the VAX have version 6 of the Oracle database.
Macintosh SQL*Plus Version 3.0.6.0.6 gives: ERROR: ORA-06118: NETTCP: unable to complete handshake with ORASRV when the 'connect system/<password> _at_t:128.183.244.8:tqm' command is issued. The IP address is 'toasted.gsfc.nasa.gov' used below in the log. 'tqm'is the system/database id. I have verified the connect string with the Macintosh technical support and it is correct.
My interpretation of the situation:
Mac SQL*Plus makes a connection request through TCP.
VAX senses connection request with no problem.
VAX attempts housekeeping stuff fine with the exception that it is
'unable to get information for user "" (98994)'
Eventhough, VAX continues.
After some more house keeping, VAX chokes because it complaints about
'talking to wrong ORASRV (got=0000,expect=3BBB,pno=00)'
The VAX server debug log: (i have put a line separating two different connection atempts)
SQL*Net TCP/IP NETWORK SERVER
Started at 29-MAY-92 15:30:41
CONFIGURED FOR UCX SUPPORT
ORASRV WILL RUN AS A DETACHED PROCESS
DEFAULT ORASRV USERNAME IS "HYU"
DEFAULT SID IS "TQM"
MAXIMUM ACTIVE CONNECTIONS IS 16
PORT NUMBER IS 1525
TERMINATION MAILBOX UNIT NO. IS 1924
STATUS REQUEST FROM LOCALHOST AT 29-MAY-92 15:31:06 LOG REQUEST FROM LOCAL HOST AT 29-MAY-92 15:32:26 LOG REQUEST FROM LOCAL HOST AT 29-MAY-92 15:32:40 SETTING LOGGING LEVEL TO 3
srv_reap_orasrv: returning w/o match (2160) waiting for connection request...
srv_getnetstr: string (2 chars):
srv_getnetstr: string (1 chars): S
STATUS REQUEST FROM LOCALHOST AT 29-MAY-92 15:42:16 srv_reap_orasrv: returning w/o match (2160) srv_reap_orasrv: returning w/o match (2160) waiting for connection request...
srv_getnetstr: string (1 chars):
srv_getnetstr: string (1 chars): I
CONNECT REQUEST FROM toasted.gsfc.nasa.gov AT 29-MAY-92 15:54:38 srv_getnetstr: string (9 chars): tqm,4096 ERROR: unable to get information for user "" (98994) srv_next_ci: pno=00
srv_set_ci:
ci.flgs = 0x0 ci.pnam = ORA_SRVT000_TQM ci.unam = HYU ci.sidx = 0 ci.sid = TQM srv_crelogname: "ORA_SRVT000_TQM_1" => "USER3:[ORACLE.ORACLE6.DB_TQM.AUTHOR_TQM] srv_crelogname: "ORA_SRVT000_TQM_2" => "T:I,4096,1,0" srv_crelogname: "ORA_SRVT000_TQM_3" => "600"srv_change_uname: "SYSTEM" -> "HYU"
srv_create_orasrv:
image = SYS$SYSTEM:LOGINOUT (19) sysin = $1$DUA0:[ORACLE.ORACLE6.NETCONFIG]ORASRV.COM (44) sysout = ORA_TCP_HOME:ORA_SRVT000_TQM.OUT;1 (34) syserr = ORA_TCP_HOME:ORA_SRVT000_TQM.OUT;1 (34) sysnam = ORA_SRVT000_TQM (15) srvuic = 0x9b0060 srvflg = 0x0
srv_change_uname: "HYU" -> "SYSTEM"
ORASRV PROCESS (PID=3BBB, PNO=00) CREATED
srv_revoke_dba: for "ORA_DBA" vmsret was 1 srv_revoke_dba: for "ORA_TQM_DBA" vmsret was 8684 srv_start_orasrv: reading from mailbox (30)... srv_start_orasrv: reading from mailbox (29)... srv_start_orasrv: reading from mailbox (28)...ERROR: Version mismatch for ORASRV - looking for V10207UCX, got ##, Verson mismatch for ORASRV -looking for V10207UCX, got ##, ERROR: talking to wrong ORASRV (got=0000,expect=3BBB,pno=00) ORASRV PROCESS (PID=3BBB, PNO=00) DELETED srv_reap_orasrv: msgtyp=3
ORASRV PROCESS (PID=3BBB) HAS EXIT STATUS 98970
srv_dellogname: "ORA_SRVT000_TQM_1" srv_dellogname: "ORA_SRVT000_TQM_2" srv_dellogname: "ORA_SRVT000_TQM_3" srv_reap_orasrv: returning w/o match (2160)waiting for connection request...
srv_getnetstr: string (1 chars):
srv_getnetstr: string (1 chars): I
CONNECT REQUEST FROM toasted.gsfc.nasa.gov AT 29-MAY-92 16:12:19 srv_getnetstr: string (9 chars): tqm,4096 ERROR: unable to get information for user "" (98994) srv_next_ci: pno=00
srv_set_ci:
ci.flgs = 0x0 ci.pnam = ORA_SRVT000_TQM ci.unam = HYU ci.sidx = 0 ci.sid = TQM srv_crelogname: "ORA_SRVT000_TQM_1" => "USER3:[ORACLE.ORACLE6.DB_TQM.AUTHOR_TQM] srv_crelogname: "ORA_SRVT000_TQM_2" => "T:I,4096,1,0" srv_crelogname: "ORA_SRVT000_TQM_3" => "600"srv_change_uname: "SYSTEM" -> "HYU"
srv_create_orasrv:
image = SYS$SYSTEM:LOGINOUT (19) sysin = $1$DUA0:[ORACLE.ORACLE6.NETCONFIG]ORASRV.COM (44) sysout = ORA_TCP_HOME:ORA_SRVT000_TQM.OUT;2 (34) syserr = ORA_TCP_HOME:ORA_SRVT000_TQM.OUT;2 (34) sysnam = ORA_SRVT000_TQM (15) srvuic = 0x9b0060 srvflg = 0x0
srv_change_uname: "HYU" -> "SYSTEM"
ORASRV PROCESS (PID=303D, PNO=00) CREATED
srv_revoke_dba: for "ORA_DBA" vmsret was 1 srv_revoke_dba: for "ORA_TQM_DBA" vmsret was 8684 srv_start_orasrv: reading from mailbox (30)... srv_start_orasrv: reading from mailbox (29)... srv_start_orasrv: reading from mailbox (28)...ERROR: Version mismatch for ORASRV - looking for V10207UCX, got ##, Verson mismatch for ORASRV -looking for V10207UCX, got ##, ERROR: talking to wrong ORASRV (got=0000,expect=303D,pno=00) ORASRV PROCESS (PID=303D, PNO=00) DELETED srv_reap_orasrv: msgtyp=3
ORASRV PROCESS (PID=303D) HAS EXIT STATUS 98970
srv_dellogname: "ORA_SRVT000_TQM_1" srv_dellogname: "ORA_SRVT000_TQM_2" srv_dellogname: "ORA_SRVT000_TQM_3" srv_reap_orasrv: returning w/o match (2160)waiting for connection request...
srv_getnetstr: string (2 chars):
srv_getnetstr: string (1 chars): S
STATUS REQUEST FROM LOCALHOST AT 29-MAY-92 16:28:00 srv_reap_orasrv: returning w/o match (2160) srv_reap_orasrv: returning w/o match (2160) waiting for connection request...
srv_getnetstr: string (2 chars):
srv_getnetstr: string (1 chars): S
STATUS REQUEST FROM LOCALHOST AT 29-MAY-92 16:31:08 srv_reap_orasrv: returning w/o match (2160) srv_reap_orasrv: returning w/o match (2160) waiting for connection request...
srv_getnetstr: string (2 chars):
srv_getnetstr: string (1 chars): Y
STATUS REQUEST FROM LOCALHOST AT 29-MAY-92 17:11:50
srv_reap_orasrv: returning w/o match (2160) srv_reap_orasrv: returning w/o match (2160) srv_reap_orasrv: returning w/o match (2160)Shutdown at 29-MAY-92 17:11:50
Statistics summary:
Total connections : 0 Total rejections : 2 Maximum connections : 0 Longest response time : 0 Shortest response time : 0 Average response time : 0 Timeouts : 0
SID accesses:
# accesses by node:
0 LOCALHOST 2 toasted.gsfc.nasa.govReceived on Mon Jun 01 1992 - 17:44:27 CEST