1. Download Oracle Client rpm
Instant Client for Linux http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
Oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64
Oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64
$rpm-IVH oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
$rpm-IVH oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
Here the next two will be able to then install
The. So file is generated in this directory
/usr/lib/oracle/11.2/client64/lib
$ls/usr/lib/oracle/11.2/client64/lib
$echo/usr/lib/oracle/11.2/client64/lib/>/etc/ld.so.conf.d/oracle_client.conf
At the this point, you ' re ready to register your newly-installed libraries:
$ldconfig-V
2. Configure Phpize
The downloaded version will be the same as the PHP version, or it won't fit.
Http://rpm.pbone.net/index.php3/stat/4/idpl/24668595/dir/scientific_linux_6/com/php-devel-5.3.3-26.el6.x86_64.rpm.html
php-devel-5.3.3-26 x86_64 Download
Phpize, a build tool that prepares the build environment for PHP extensions.
[Email protected] tmp]# RPM-IVH php-devel-5.3.3-26.el6.x86_64.rpm
Warning:php-devel-5.3.3-26.el6.x86_64.rpm:header V4 dsa/sha1 Signature, key ID 192a7d7d:nokey
Preparing ... ########################################### [100%]
1:php-devel ########################################### [100%]
[Email protected] tmp]# Whereis phpize
Phpize:/usr/bin/phpize/usr/share/man/man1/phpize.1.gz
3. Configure Oci8
Https://pecl.php.net/package/oci8 oci8 Download
[[Email protected] oci]# CD
Oci8-1.3.3/oci8-1.3.3.tgz package.xml
[Email protected] oci]# CD oci8-1.3.3
[[email protected] oci8-1.3.3]# ls
CONFIG.M4 CREDITS oci8_collection.c oci8_interface.c oci8_statement.c php_oci8_int.h tests
Config.w32 oci8.c oci8.dsp oci8_lob.c php_oci8.h README
[Email protected] oci8-1.3.3]# phpize
Configuring for:
PHP Api version:20090626
Zend Module Api no:20090626
Zend Extension Api no:220090626
When prompted, enter either the value of $ORACLE _home, or Instantclient,/path/to/instant/client/lib.
Note:do not enter the variable $ORACLE _home because it won't be expanded. Instead, enter the actual path of the Oracle home directory.
If using an rpm-based installation of Oracle Instant Client, the Configure line would look like this:
./configure--with-oci8=shared,instantclient,/usr/lib/oracle/<version>/client/lib
For example, --with-oci8=shared,instantclient,/usr/lib/oracle/12.1/client/lib
Note that Oracle Instant Client support first appeared in PHP 4.3.11 and 5.0.4 and originally used the option --with-o Ci8-instant-client to configure PHP.
[Email protected] oci8-1.3.3]# ./configure-with-oci8=shared,instantclient,/usr/lib/oracle/11.2/client64/ Lib
....
Checking for CC option to produce PIC ...-fpic-dpic
Checking if cc PIC flag-fpic-dpic works ... yes
Checking if cc static flag-static works ... no
Checking if cc supports-c-o file.o ... yes
Checking if cc supports-c-o file.o ... (cached) Yes
Checking whether the CC linker (/usr/bin/ld-m elf_x86_64) supports GKFX libraries ... yes
Checking WHETHER-LC should is explicitly linked in ... No
Checking dynamic linker characteristics ... Gnu/linux ld.so
Checking how to HardCode library paths into programs ... immediate
Checking whether stripping libraries is possible ... yes
Checking if Libtool supports shared libraries ... yes
Checking whether to build shared libraries ... yes
Checking whether to build static libraries ... no
Configure:creating./config.status
Config.status:creating config.h
config.status:executing Libtool Commands
Make install
Libraries has been installed in:
/tmp/oci/oci8-1.3.3/modules
If you ever happen to want to link against installed libraries
In a given directory, Libdir, you must either use Libtool, and
Specify the pathname of the library, or use the '-llibdir '
Flag during linking and do at least one of the following:
-Add Libdir to the ' Ld_library_path ' environment variable
During execution
-Add Libdir to the ' Ld_run_path ' environment variable
During linking
-Use the '-WL,-RPATH-WL,LIBDIR ' linker flag
-Your system administrator add Libdir to '/etc/ld.so.conf '
See all operating system documentation about GKFX libraries for
More information, such as the LD (1) and ld.so (8) manual pages.
----------------------------------------------------------------------
Installing Shared extensions:/usr/lib64/php/modules/
$echo extension=oci8.so >/etc/php.d/oci8.ini
$/ETC/INIT.D/HTTPD restart
The official documentation for the installation of Oci8 is as follows:
http://php.net/manual/en/oci8.installation.php
4. Verify that PHP can connect to the Oracle database:
You can see the information in the Phpinfo oci8 module has been loaded
[Email protected] html]# more get_dbinfo.php
<?php
$db _connect = oci_connect (' system ', ' xxx ', ' (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1
30.131) (PORT = 1521)) (Connect_data = (SERVER = dedicated) (service_name = Deff)));
$sql _query = Oci_parse ($db _connect, ' Select status from V$instance ');
Oci_execute ($sql _query,oci_default);
# #echo $sql _query
while ($r =oci_fetch_row ($sql _query))
{
echo $r [0];
echo "<BR>";
}
?>
[[email protected] html]# PHP get_dbinfo.php
Open<br>[[email protected] html]#
Here, the configuration of PHP is all done, and then there is something about PHP and the database that are combined with the shell script to make the HTML interface.
=============ended============
PHP Configuration Oci8