| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Client Connection Error (TNS-12518 TNS-12560 TNS-00530)
Hello Charles,
thanks for you comments. Pleas see my remarks below.
"Charles Hooper" <hooperc2000_at_yahoo.com> schrieb im Newsbeitrag
news:1161035067.010459.196180_at_k70g2000cwa.googlegroups.com...
> 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. >>
...
>
>
[win32client]
clientname=den-jerfurt
SetZeroLengthStringsToNULL=ON
[win32client.ora32]
;log=C:\TEMP\oracle.log
[win32client.dll]
comdll=sqlora32
[ORAGTWY]
REMOTEDBNAME=TBBT,@TBBT.BOH.PARCOM.DE
Since the database can be access when loged in with windows admin rights the
sql.ini should be ok, even if TNS: is not explicite defined in the
connection descriptor. The sqlora32.dll if from 2003 (file releas 5.0.3,
Team Developer 2.1-PTF4-13004
> 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.
Meanwhile I have a brand new installed virtual machine (W2k3 Server, 10.2 client), an admin account ADMIN and an user account USER. File access rights are Windows default and haven't been changed yet.
The files you mentioned are accessible by USER (read, execute), trace and log files are wirtten to C:\TEMP (full access for everyone).
I have checked the file access with FileMon and still wonder what is goning on:
When connect as USER there is * NO * access for files in C:\oracle\product\10.2.0\client_1\network\admin\ listed * BUT * for files in C:\oracle\product\10.2.0\client_1\RDBMS\mesg\. Obviously the error message.
I have set up access to a second database ODB2 on a different server runng 9i.
-Windows Client PC / Windows login USER Access ODB2 failed -Windows Client PC / Windows login ADMIN Access ODB2 ok
-Windows Server / Windows login USER Access TBBT failed -Windows Server / Windows login ADMIN Access TBBT ok
-Windows Server / Windows login ADMIN Access TBBT
AND
-Windows Client PC / Windows login USER Access ODB2 ok
Then I have closed all applications with DB connections in the ADMIN session. When I log on as USER and simply start sqlplus with /nolog I can connect with the Centura Application immediately?!?
Thanks and best regards,
Jochen
Received on Tue Oct 17 2006 - 07:00:48 CDT
 |
 |