DBAs at work recently moved the Oracle 11g server from CentOS to Redhat. The end users tested our applications on the pilot Oracle server and verified everything was functioning. Yesterday they made the final switch to production and one of my ASP web pages which runs queries to this server is no longer working. I'm getting an ORA-12543 error. If I run the same query through SQL Developer, it works. If I run it through a ColdFusion website, it works. If I run a stripped down query directly to my target database without going through the database link, it works. However, if I try to run any of these queries using the database link in ASP, I get the error. The ColdFusion website and ASP website are running on the same web server and are both running through IIS. I need to use the link because my query spans several different databases--all hosted on this new server.
The DBA dropped the database link and recreated it and the problem is still there. I know there have been no changes to my web server and I'm getting the same problem on my development server so I feel the problem lies somewhere in the new Oracle server configuration. However, I don't know enough about it to troubleshoot--and I don't manage that server.
I have confirmed I can connect to this server with tnsping, and all of my ASP pages that don't use this database link are working.
Any ideas?
Thanks,
Paul