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

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

Here is a suggestion - the client may be trying to resolve the database name using DNS rather than the TNSNAMES file. You can confirm this with Ethereal/Wireshark.

In the SQL.INI file, change the ORAGTWY as follows: [ORAGTWY]
;REMOTEDBNAME=TBBT,@TBBT.BOH.PARCOM.DE
REMOTEDBNAME=TBBT,@TNS:TBBT Add an entry to the TNSNAMES.ORA file on the client as follows (replace the ... with the TNSNAMES entry for the TBBT.BOH.PARCOM.DE connection:

TBBT =
  (DESCRIPTION =
    (ADDRESS_LIST =
...

    )
  )

Check the sqlnet.ora file on the client computer to see if it contains a line such as:
TRACE_LEVEL_CLIENT = 16 If it does, the Oracle client will try to generate trace files, likely in the same folder as the EXE files of the Centura program.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Tue Oct 17 2006 - 08:01:57 CDT