Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

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

From: GM <ganesh_boston_at_yahoo.com>
Date: 19 Apr 2006 11:46:40 -0700
Message-ID: <1145472400.630929.11080@g10g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US