Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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