Check Oracle 9.2.0

y.beyet · Post by **y.beyet** » Tue Nov 19, 2002 9:58 am

Hello,

I'm trying to check an oracle base in 9.2.0 release, the test give me the following error :
Oracle error #12154 : ORA-12154:TNS:Could not resolve service name

Connections are OK with oracle tools, the test works with a 8.1.7 database on an other PC.

a Bug with 9.2 ?

<font size=-1>[ This Message was edited by: y.beyet on 2002-11-19 09:01 ]</font>

KS-Soft · Post by **KS-Soft** » Wed Nov 20, 2002 2:16 am

Do you have specified TNS alias (that you use for the test) in tnsnames.ora file?

Regards
Alex

y.beyet · Post by **y.beyet** » Wed Nov 20, 2002 2:43 am

it's exatly the same configuration as 8.1.7 : the path is OK, tnsnames.ora is OK, oci.dll v9.2.0.

KS-Soft · Post by **KS-Soft** » Wed Nov 20, 2002 2:44 pm

H'm, does ODBC test works properly?

y.beyet · Post by **y.beyet** » Thu Nov 21, 2002 9:46 am

Yes, it's OK
I finaly find the problem :
the parameter server (tns alias) must be the complete name "dbname.domain.com" not only "dbname".

<font size=-1>[ This Message was edited by: y.beyet on 2002-11-21 08:54 ]</font>