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

On Jul 3, 4:44 pm, p..._at_edbgruppen.dk wrote:
> 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

This means that the server couldn't determine client address. Looks like network issue. Maybe some network reconfiguration took place over the weekend? Also, if the client software uses JDBC Thin driver, it needs to be updated to at least 9.2.0.5 or later (yes, 9.2 series later than 9.2.0.4 work fine with 8.1.7.4 servers and even fix some serious issues in 8.1.7 series.)

Hth,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Tue Jul 03 2007 - 11:02:17 CDT