PHP and Oracle 8

Anon

Hi.
I have a Solars server with apache web server using PHP 3.0.15, and I have a Windows NT server with Oracle 8. I want to access to the information of the database, so I get the oracle libraries (to compile the php) for Solaris, and when I execute the script that invokes a connection to the database the answer of the web server is :

Warning: Unable to connect to ORACLE (Error while trying to retrieve text for error ORA-12514) in /hosting/ftp.afa1.com/public_html/demo/ORACLE/cgi-bin/principal.php3 on line 8

By the way, both servers have their own firewall, so I have to pass over two firewalls on each process. Any idea?

All the firewall rules are down, so I dont know wht is the problem.

Anon

the error description from oracle is as follows

12514, 00000, "TNS:listener could not resolve SERVICE_NAME given in connect descriptor"
// Cause: The SERVICE_NAME in the CONNECT_DATA was not found in the listener's tables.
// Action: Check to make sure that the SERVICE_NAME specified is correct.
// *Comment: This error will be returned if the database instance has not
// registered with the listener; the instance may need to be started.

are you able to connect beetwin the to pc's, try installing Oracle client on the Solaris to see if you can connect, if you are convinesed it's the firewall's fault the try opening port 1521 (oracle) and 1031 (tns listener i think) on both servers.

yavor

Anon

I have another question:
Can I invoke the connection with oracle Server using the IP Address of the NT Server? I mean, I have to use the IP address because the real IP address of that server belongs to a private network with no-valid IP addresses rage(192.168.200). So, Im using a NAT address on a Firewall before the real NT Server.

Thank you

Anon

well if i understood your question correctly. first are the 2 servers on the save private network if so you can use their internal ip's without having to specify a real ip addresses. oracle uses tns names to connect that is if you installed oracle client on the web server there shuold be and tnsnames.ora text file in your $ORACLE_BASE/network/admin dir (sometimes net80 depending on the client you have installed) a normal entry is of the type

ATHENA.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.5)(PORT = 1521))
(CONNECT_DATA = (SID = ORA8))
)

in this case athena is the tns name 10.10.1.5 is the ip address to use and ORA8 is the oracle SID. just replace there values with the ones for your system and you should be able to connect from the web server as
sqlplus scott/tiger@athena if this works you're all set (the scott/tiger account might not be availble so use an login and account given to you)

i hope this is of any help
yavor.

Anon

Just one more question: Do I have to re-compile the php executable file? Because it didnt work . The web server has a valid IP address, and the Oracle server has a no-valid IP address. Both are separate by two firewalls.

And (Im not very good using ORACLE, so this is my very first time with it) after modify the tnsnames.ora file, which service must I restart?

Thank you