10 Replies Latest reply: Jun 13, 2012 5:09 AM by 901766 RSS

    Unable to login in sql plus without using SID

      I am unable to login in to sqlplus without using the DB parameter
      ie if I login workgroup_test@WGS_Db it works
      but if i login using just workgroup_test . it fails

      I am getting the following error
      ORA-12545: Connect failed because target host or object does not exist

      My current set up is of Oracle 11g on RHEL 5 64 bit .

      I checked almost everything to work
      ie started the listener , checked tnsping , changed host name in tnsnames.ora by using the ip
      But still am faciing the same issue

      Kindly help.