Re: Ora 3113 - Windows Authentication Services? - trace files

On Jul 3, 6:39 am, p..._at_edbgruppen.dk wrote:
> System 8.1.7.4 on Windows
> A customer is running some old software on 8.1.7.4. (I know this is
> ancient, sorry upgrade no option) Monday morning clients got ora-3113
> and I cannot find the reason.
> Nothing special in alertlog. Instance running fine. Can log on via
> svrmgrl. Cannot log on in svrmgrl if using tnsname(Get ORA-3113). So
> the problem is only there if logging in via tcp/ip. Listener running
> fine. Server has been restarted several times before I was involved.
> I suspect problem has something to do with Windows Authentication
> Services. SQLNET.AUTHENTICATION_SERVICES = (NTS) is in use.I have
> traced listener and sqlnet client and serverside but found nothing
> usefull in the tracefiles. I attach trace from listener and sqlnet
> server and client.
> Can you read something usefull from these? If not what would be the
> next step in finding the reason for the ora3113?
>

<massive snippage>

> TIA
> Peter Laursen

You found NOTHING useful in the trace files? How about these lines:

nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=126,

nioqper: ns main err code: 12560

niqme: reporting NS-12560 error as ORA-12560

niomapnserror: returning error 12560

niotns: Couldn't connect, returning 12560

nserror: nsres: id=0, op=76, ns=12534, ns2=12560; nt[0]=504, nt[1]=0,

Try searching MetaLink for "ORA-12560" Received on Tue Jul 03 2007 - 07:26:45 CDT