Client Connection Error (TNS-12518 TNS-12560 TNS-00530)
in [Oracle]
|
Prev: -1555-ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small
Next: Oracle Chaining
From: Jochen Erfurt on 16 Oct 2006 04:50 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? Thanks, Jochen
From: frank.van.bortel@gmail.com on 16 Oct 2006 08:28 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?
From: Jochen Erfurt on 16 Oct 2006 10:32 Hello, <frank.van.bortel(a)gmail.com> schrieb im Newsbeitrag news:1161001732.683503.103040(a)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
From: DA Morgan on 16 Oct 2006 11:15 Jochen Erfurt wrote: > Hello, > > > <frank.van.bortel(a)gmail.com> schrieb im Newsbeitrag > news:1161001732.683503.103040(a)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(a)x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org
From: Jochen Erfurt on 16 Oct 2006 11:54
Dear Daniel, "DA Morgan" <damorgan(a)psoug.org> schrieb im Newsbeitrag news:1161011702.730726(a)bubbleator.drizzle.com... > Jochen Erfurt wrote: >> Hello, >> >> >> <frank.van.bortel(a)gmail.com> schrieb im Newsbeitrag >> news:1161001732.683503.103040(a)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(a)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 |