I have installed the default database in my machine. Oracle 8i enterprise edition. I started my database and listener. I created a new user giving him even the grant of connect,resource and dba. The person is not able to connect to my database. Its giving a problem
Tnsname couldnot be resolved.
I checked the tnsnames entry. It correctly have the sid as my sid here i.e prajora. Also checked the port it is 1521 and the protocol used is TCP. Also check the machine name. All seems to be right. What else could be the problem that it is not connecting to my database.
It would be helpful. If I cant get a hint on what could be the issue behind it.