It was actually a simple fix from Oracle support. In init.ora file, set the hostname with IP address instead of machine name for the local_listener and mts_dispatcher resolved the problem.

Thanks for all the effort. This is one of those occasions Oracle support had a quick and effective response. Closing this thread.