Re: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

On 19 Apr 2006 11:46:40 -0700, "GM" <ganesh_boston_at_yahoo.com> wrote:

>I did a select * from global_name and it returned the GLOBAL_NAME as
>XE.
>I replaced SERVICE_NAME=XE with SID=XE and restarted the database and
>tried connecting using sqlplus but I still get the same error (ERROR:
>ORA-12154: TNS:could not resolve service name).

You have multiple tnsnames.ora floating around. If you run
tnsping XE
which directory is returned?
The tnsnames.ora in this directory needs the XE entry.

--
Sybrand Bakker, Senior Oracle DBA