note 4787 deleted from function.oci-connect by sixd

From: Date: Wed, 09 Dec 2009 21:02:10 +0000
Subject: note 4787 deleted from function.oci-connect by sixd
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-163755@lists.php.net to get a copy of this message
Note Submitter: rkohli at xperts dot com ---- Regarding connecting to an Oracle Db on NT from Linux, here is what you need to do. Little Oracle knowledge is a prerequisite. 1. Install Oracle database client onto Linux. 2. Once installed on Linux, modify the tnsanmes.ora file to create an alias to the database running on the NT box. Follow the syntax already in the tnsnames.ora file 3. Depending on the version of Oracle you have and the Oracle Database has the listener running there is a utility called tnsping(xx) that you can use to verify that you can hit a remote 0racle database syntax is tnsping <alias in tnsnames.ora> 4. You could use sqlplus to conenct to the remote database to verify the login process works. Remember to use login_id@tnsnames_alias/password 5. Once you have gotten this far PHP should be able to hit the database. Give it a shot. You might need to tool around the PHP config to get things to work. use the phpinfo function to debug, its rather useful.

« previous php.notes (#163755) next »