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

On Jul 3, 4:44 pm, p...@xxxxxxxxxxxxx wrote:
On 3 Jul., 14:26, EdStevens <quetico_...@xxxxxxxxx> wrote:

On Jul 3, 6:39 am, p...@xxxxxxxxxxxxx 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

.

Relevant Pages

  • Re: What doesnt lend itself to OO?
    ... >> proxy and instructs the server to constuct the real object. ... rather than client code. ... If 'clock' is instantiated in the server, ... > for the server interface at the OOA level. ...
    (comp.object)
  • This is going straight to the pool room
    ... or not the client has privilege to do what they're trying to do, ... The server environment is this: ... 3GL User action Routines that Tier3 will execute on your behalf during the ... Routine Name: USER_INIT ...
    (comp.os.vms)
  • [Full-Disclosure] R: Full-Disclosure Digest, Vol 3, Issue 42
    ... Full-Disclosure Digest, Vol 3, Issue 42 ... SD Server 4.0.70 Directory Traversal Bug ... Arkeia Network Backup Client Remote Access ...
    (Full-Disclosure)
  • Re: What doesnt lend itself to OO?
    ... > rather than client code. ... no way to do that without also touching the object with clock semantics ... will not encapsulate both clock semantics and network semantics. ... The server can do whatever it wants ...
    (comp.object)
  • RE: ProtocolError?
    ... If I just do a simple TCP trace I get: ... Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client ... WWW-Authenticate: Negotiate ... WWW-Authenticate header field that the Web server is not configured to accept. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
Loading