Oracle 1. Download and install Oracle 8i for Linux.
Complete installation, do not install the client only
Download location: Hot download of Chat.hn.cninfo.net/soft
The--with-oracle option allows PHP to access Oracle 7.x or 8.x via the Ora_ function
The--WITH-OCI8 option allows PHP to use more and better oci8 functions
4. Make
5. Make install
6. CP./php.ini-dist/wherever/your/conf/files/are/php.ini
Copy the php.ini to the appropriate location
7. Modify Httpd.conf
Modify the following line
LoadModule Php4_module lib/apache/libphp4.so
To
LoadModule php4_module/usr/lib/apache/libphp4.so
8. Restart Apache
9. Test whether the installation of PHP4 is successful
Create a test.php3 content for:
? Phpinfo ();?>
Access it in the browser to see if there is Oracle and ORACLE8 information.
If there is, then congratulations!
10. Now start using the Oracle function.
?
Setting Oracle Environment variables
Putenv ("Oracle_sid=prod");
Putenv ("oracle_home=/usr/local/oracle/8i/u01/app/oracle/product/8.1.5");
Establish a connection
Modify the current user_id,password,db to fit your configuration
if ($conn = Ocilogon ("user_id", "Password", "DB"))
{
Get information about the database
printf ("%s</p>", Ociserverversion ($conn));
}
Else
{
printf ("Conncetion Failed");
}
?>
This program will show some information about Oracle you're connected to.
12. Other
If you need to connect to a remote Oracle server, you will also need to set up your Sqlnet.ora and Tnsnames.ora to specify the location of the remote database.
Ask the database administrator to copy some files to
$ORACLE the _home/network/admin/directory
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
