th host names and the service names are there. I've even tried with the ip address and the global db_names. But still the same error persists. but the tnsping gives me result still unable to connect.

Mohit.