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

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 16 Oct 2006 08:15:07 -0700
Message-ID: <1161011702.730726@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?

With what error message?
What is the client software application? Have you turned on SQLNET tracing?

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

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Oct 16 2006 - 10:15:07 CDT