I have just installed ORACLE DEVELOPER SUIT 10g. my DATABASE is ORACLE XE(express edition) and username ,password for database is "SYSTEM","*****".
when i log in SQL PLUS witn this user name and password ,and HOST STRING=XE.it shows an ERROR = ORA-12154: TNS:could not tesolve the connect identifier specified.
my tnsname.ora is
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ARUNSOROUT-PC)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )
EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) )
(CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )
ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) )
(CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )
please help me in solving this ERROR.
This forum is for the SQL Developer tool, not for general SQL or PL/SQL questions. The clue is in the name.
Try asking in the Database General or SQL and PL/SQL forums.