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

Jochen Erfurt wrote:
> 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

We have a couple commercial programs that were written in Centura SQLWindows which connect to our 10g R2 (10.2.0.2) database using the Oracle 8.0.5, 8.1.7, and 10.2.0.1 Oracle clients. You can _probably_ eliminate the Oracle client version as the problem.

This may indicate a communication problem. Centura based applications require an entry in the SQL.INI file on the client computer that points to the correct entry in the TNSNAMES.ORA file. You should see something like this in the SQL.INI file under the heading [oragtwy] remotedbname=TBBT,@TNS:TBBT

Make certain that the non-domain admin user has read permissions on the SQL.INI file and the Oracle install folder. Make certain that ORACLE_HOME\oracore\zoneinfo\timezone.dat is accessible on the client computer and on the server. Verify that there are not duplicate files on the client computer, such as OCIW32.dll, which may be for a different version of the Oracle client. Make certain that the NLS settings are correctly set. The client may be trying to create a temporary file in an unexpected location (maybe a client side trace) - FileMon should be able to spot this problem.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Oct 16 2006 - 16:44:27 CDT