Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
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).
Received on Wed Apr 19 2006 - 13:46:40 CDT