Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Ora 3113 - Windows Authentication Services? - trace files

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

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Tue, 03 Jul 2007 17:11:22 -0000
Message-ID: <1183482682.821126.184890@k29g2000hsd.googlegroups.com>


On Jul 3, 8:25 pm, "Peter Laursen" <p..._at_REMOVEedbgruppenTHIS.dk> wrote:
> > 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
>
> Thanks,
>
> The server side trace was made from the database server, logged in at the
> console. Might have been from within svrmgrl using connect user_at_alias. What
> could cause the server not beeing able to retrieve client address? Customer
> does not report any other TCP/IP or networking issues. Anyway will forward
> to networking people :)
> sqlnet.ora has SQLNET.AUTHENTICATION_SERVICES = (NTS) and
> REMOTE_OS_AUTHENT=TRUE is in parameterfile.
>
> TIA
> Peter Laursen

Ignore that 12534 error on nsgetclientaddress(), it's normal for Bequeath connections. Where the client trace was taken - on the server or on a remote host? The trace shows it was trying to establish a Bequeath (local) connection - is this correct?

Another thing that sprang to mind while reviewing the traces: the server didn't happen to have a firewall installed or protected by an external firewall over the weekend? Try enabling shared sockets on the server by creating USE_SHARED_SOCKET string value in the server Registry under HKLM\SOFTWARE\ORACLE\HOME<#> key, where <#> is the Oracle home number, and setting it to TRUE. Then restart both the listener and the service (just bouncing the instance is not enough.) Not sure if it's related, but worth doing anyway (I saw strange redirect to a TCP port in the listener trace for Bequeath connection, which reminded me of this feature.) This parameter will cause Oracle on Windows to use shared sockets on TCP port 1521 and stop it from creating endpoints on different ports and redirecting clients to these new endpoints (since non-standard ports are usually blocked by firewalls this immediately creates connectivity problems.)

Hth,

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US