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

On 3 Jul., 14:26, EdStevens <quetico_..._at_yahoo.com> wrote:
> 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"- Skjul tekst i anførselstegn -
>
> - Vis tekst i anførselstegn -

Hi Ed,

Thx for taking time to help.
ORA-12560: TNS:protocol adapter error Cause: A generic protocol adapter error occurred.
Yes I did see the 12560 in the client trace, but 12560 is so generic that it does not help me solve the problem.

Server trace has
nsgetclientaddress: entry
nserror: nsres: id=0, op=76, ns=12534, ns2=12560; nt[0]=504, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nszgclient: entry

ORA-12534: TNS:operation not supported Cause: An internal function received a request to perform an operation that is not supported (on this machine).
I dont know what this means

Sorry I havent had MetaLink access for years. TIA
Peter Laursen Received on Tue Jul 03 2007 - 07:44:07 CDT