1 Reply Latest reply on Nov 8, 2013 9:30 AM by Jim Smith

    ERROR IN CONNECTING IN SQL PLUS(ORACLE DEVELOPER SUIT 10g)

    26c2ae0b-a932-4f8a-82c3-6808ea29e1dd

      hi Friends

       

      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

       

      XE =

        (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.