Thanks guys.

I checked the TNSPING. I am able to get a positive response from both the databases.
I cannot create a view because, this code is working in one environment. The code in our production environment works, but we are getting an error when we are running the jobs in our new testing environment.

Not sure if we need to check any specific parameters in the databases.

Any info on that.

Thanks again