Re: Client Connection Error (TNS-12518 TNS-12560 TNS-00530)

From: Jochen Erfurt <newsgroups_at_nickname.berlin.de>
Date: Mon, 16 Oct 2006 17:54:44 +0200
Message-ID: <eh0a05$jd7$00$1@news.t-online.com>

Dear Daniel,

"DA Morgan" <damorgan_at_psoug.org> schrieb im Newsbeitrag news:1161011702.730726_at_bubbleator.drizzle.com...

> Jochen Erfurt wrote:

>> Hello,
>>
>>
>> <frank.van.bortel_at_gmail.com> schrieb im Newsbeitrag
>> news:1161001732.683503.103040_at_m73g2000cwd.googlegroups.com...
>>> Jochen Erfurt schreef:
>>>
>>>> Hello All,
>>>>
>>>> we have a problem connecting to an Oracle DB 10.2 in a Windows
>>>> environment.
>>>>
>>>> In the servers listener.log I found the following errors:
>>>>
>>>> TNS-12518: TNS: Listener konnte Client-Verbindung nicht weitergeben
>>>> TNS-12560: TNS: Fehler bei Protokolladapter
>>>> TNS-00530: Protokolladapter-Fehler
>>>> 32-bit Windows Error: 2: No such file or directory
>>>>
>>>> There are no problems connecting to the Db on the server, when the
>>>> Windows
>>>> OS user on the client pc (local or domain user) does have admin rights,
>>>> the
>>>> connection works fine as well.
>>>>
>>>> Solution one: Each user will have full admin right. I guess the IT will
>>>> not
>>>> like me any more...
>>>>
>>>> Any other ideas?
>>>>
>>> Fail to see where the admin rights come in...
>>> What is the error on the client side? What OS version?
>>>
>>
>> Server: Windows 2003 Server SP2
>> ORACLE 10.2
>>
>> Clients: Windows 2000 Server SP4 (with Citrix)
>> ORACLE 8.1.7 Client
>>
>> Windows 2003 Server SP2 (Terminal Server)
>> ORACLE 10.2 Client
>>
>> Login on Windows client as normal or power user
>> connection to database fails
>>
>> Login on Windows client as lokal or domain admin
>> connection to database established
>>
>> As soon as an connection to the DB is established (e.g. via rdp and Admin
>> login) the normal OS user cann connect as well to the DB?!?
>>
>> Thanks and best regards,
>> Jochen

>
> Please try to provide the information required for someone to help you.
>
> The client connection to the database fails?

Yes, the client connection to the database fails.

>
> With what error message?

LISTENER.LOG

    TNS-12518: TNS:listener could not hand off client connection
    TNS-12560: TNS:protocol adapter error occurred
    TNS-00530: Protocol adapter error

    32-bit Windows Error: 2: No such file or directory

> What is the client software application?

A Centura based third party ERP application. In Centura I receive the following message:

   connect tbbt kw/poeffel

                         ^

   Error: 02554 SRV X54 Oracle specific error reported; more information available

And in the Centura trace file the following error message:

   10/16/06 17:29:34 1> [oracon] login string kw_at_TBBT    10/16/06 17:29:34 0> [ERROR] 2554 ORA-01019: unable to allocate memory in the user side

I guess this is misleading, the server and instance works fine for weeks - before the Windows User rights have been changed.

> Have you turned on SQLNET tracing?

Yes, I just did, but I do not understand the content. Before I post the complete file: What exactly should I look for?

>
> Wait a second 8.1.7 client connecting to 10gR2? Surely you jest.
> Reconsider this configuration choices.

Sorry, but I do not understand.

Thank you and best regards

Jochen Received on Mon Oct 16 2006 - 10:54:44 CDT