Drishti,

If your problem is not already resolved, it may be worth looking at a utility called oradim to delete and recreate the tns service.