note 4787 deleted from function.oci-connect by sixd
| From: | sixd@php.net | 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.