Re: How do I trace hanging "connect / as sysdba"?

Here's a summary of what I've found so far: The server is running W2k sp4, and I installed the software for Oracle 9.2
Active Directory is NOT installed.
I am logged on as a local OS user who is in groups Administrators and ORA_DBA.
With SQLNET.AUTHENTICATION_SERVICES= (NTS) in sqlnet.ora sqlplus "/ as sysdba" hangs,
but with sqlnet.authentication_services=(none) sqlplus "sys/CHANGE_ON_INSTALL as sysdba" works.

When I put TRACE_LEVEL_SERVER=support into sqlnet.ora I got some interesting output
in the trace file:
The Bequeath protocol is mentioned; I know this can be a problem with w2k
but I can't find anything which seems to fit this scenario. It looks like the process receives an error from a pipe but I am not clear what is at the other end of the pipe. Here is the error section:

[21-FEB-2006 12:11:35:890] nsprecv: reading from transport...
[21-FEB-2006 12:11:35:890] ntprd: entry
[21-FEB-2006 12:11:35:890] sntpread: entry
[21-FEB-2006 12:11:35:890] sntpread: Attempting to read 2064 bytes from
1060
[21-FEB-2006 12:12:30:015] sntpread: Read returned error 109 and 0
bytes
[21-FEB-2006 12:12:30:015] sntpread: Read returned 0 bytes
[21-FEB-2006 12:12:30:015] sntpread: exit
[21-FEB-2006 12:12:30:015] ntprd: exit
[21-FEB-2006 12:12:30:015] nsprecv: transport read error
....
[21-FEB-2006 12:12:30:015] nacomrc: failed with error 12637
....
[21-FEB-2006 12:12:30:015] nioqper: error from niotns: nsaccept
failed...
[21-FEB-2006 12:12:30:015] nioqper: nr err code: 0
[21-FEB-2006 12:12:30:015] nioqper: ns main err code: 12637
[21-FEB-2006 12:12:30:015] nioqper: ns (2) err code: 12537
[21-FEB-2006 12:12:30:015] nioqper: nt main err code: 0
[21-FEB-2006 12:12:30:015] nioqper: nt (2) err code: 0
[21-FEB-2006 12:12:30:015] nioqper: nt OS err code: 0
[21-FEB-2006 12:12:30:015] niotns: No broken-connection function
available.
[21-FEB-2006 12:12:30:015] niomapnserror: entry
[21-FEB-2006 12:12:30:031] niqme: entry
[21-FEB-2006 12:12:30:031] niqme: reporting NS-12637 error as ORA-12637
[21-FEB-2006 12:12:30:031] niqme: exit
[21-FEB-2006 12:12:30:031] niomapnserror: returning error 12637
[21-FEB-2006 12:12:30:031] niomapnserror: exit
[21-FEB-2006 12:12:30:031] niotns: Couldn't connect, returning 12637

It is interesting that it seems to trap the error ok but goes on to hang
- is that because "No broken-connection function available"? How could I fix that?

Is Oracle Advanced Security involved?
I haven't specifically installed it and it doesn't seem to appear in the
Net Manager Console, but the trace file mentions it and Oracle9i Security and Network Integration Guide Release 2 (9.2) for Windows refers to Kerberos.

Regards,
Peter Received on Sat Feb 25 2006 - 05:57:12 CST