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

GM wrote:
>
> XE =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = abcdefg)(PORT = 1521))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = XE)
> )
> )
>

Do a:
 select * from global_name;
whatever that returns, put it in tnsnames.ora as service_name. Retry. The is a fair chance the golbal_name is the servce, however no guarantee.

If that fails, try SID=XE instead of SERVICE_NAME; it's SQL*Net V2, but often does the trick

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...