Here is an issue that is boggling my cells right now.
There is an oracle server that I want to connect to. I can easily connect to it using the sqlplus command line.
When I try to connect to the oracle database with PHP though, it fails. Here is the catch, we have the same setup in another datacenter; a PHP machine is trying to connect to an oracle database. I've run the exact same code, configured php identically on both PHP machines.
PHP1 can connect to Oracle1 with both sqlplus and through php.
PHP2 connects to Oracle2 with sqlplus but NOT with PHP.
There are firewalls and some port blocking going on. My current explanation is that the port php2 is using to connect to oracle2 is not the default 1521 and it is being blocked.
The ora error I get is :
ORA-06413 : Connection not open.
Any ideas?