This discussion is archived
10 Replies Latest reply: Jun 13, 2012 3:09 AM by 901766 RSS

Unable to login in sql plus without using SID

901766 Newbie
Currently Being Moderated
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.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points