Re: Tnsnames.ora - Strange Connectivity problem

On 3 May 2006 08:32:17 -0700, "Johne_uk" <edgarj_at_tiscali.co.uk> wrote:

>There is actually no sqlnet.ora file specified although I did try
>tinkering on with a few test values.
>
>Thanks
>
>OUTPUT from connecting :-
>
>-bash-2.05b$ sqlplus osgdba_at_oranc1
>
>SQL*Plus: Release 9.2.0.7.0 - Production on Wed May 3 12:35:06 2006
>
>Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>Enter password:
>ERROR:
>ORA-12154: TNS:could not resolve service name

Too bad you didn't include output from the tnsping command, as that would have shown whether you are using the correct directory.

I never remember the difference between
12514 and 12154
One of the two refers to the *service_name of the database*. Assuming the SID of the database is oranc1 (hopefully) you could try to replace
connect_data=(service_name=...))
by
connect_data=(sid=...))

Whoever decided the error number for an incorrect database service name should be a permutation of the error number of the tnsnames.ora service_name, ought to be shot at once.

--
Sybrand Bakker, Senior Oracle DBA