百科狗Oracle(PDO) - PDO驱动
Oracle(PDO)
安装
If the Oracle Database is on the same machine as PHP, the database software already contains the necessary libraries. When PHP is on a different machine, use the free » Oracle Instant Client libraries. For details refer to the OCI8 Requirements section.
Use--with-pdo-oci[=DIR]to install the PDO Oracle OCI extension, where the optional[=DIR]is the Oracle Home directory.[=DIR]defaults to the$ORACLE_HOMEenvironment variable.
Use--with-pdo-oci=instantclient,prefix,versionfor an Oracle Instant Client SDK, where prefix and version are configured.
// Using $ORACLE_HOME $ ./configure --with-pdo-oci // Using OIC for Linux with 10.2.0.3 RPMs with a /usr prefix $ ./configure --with-pdo-oci=instantclient,/usr,10.2.0.3
预定义常量
下列常量由此驱动定义，且仅在扩展编译入 PHP或在运行时动态载入时可用。另外，使用此驱动时，仅会使用这些驱动特定的常量。使用其他驱动的驱动特定的常量可能会导致不可预见的情况。如果代码可运行于多个驱动，PDO::getAttribute()可被用于获取PDO_ATTR_DRIVER_NAME属性以检查驱动。
PDO::OCI_ATTR_ACTION(integer)Provides a way to specify the action on the database session.
自以下版本起 PHP 7.2.16 and 7.3.3
PDO::OCI_ATTR_CLIENT_INFO(integer)Provides a way to specify the client info on the database session.
自以下版本起 PHP 7.2.16 and 7.3.3
PDO::OCI_ATTR_CLIENT_IDENTIFIER(integer)Provides a way to specify the client identifier on the database session.
自以下版本起 PHP 7.2.16 and 7.3.3
PDO::OCI_ATTR_MODULE(integer)Provides a way to specify the module on the database session.
自以下版本起 PHP 7.2.16 and 7.3.3
Table of Contents
- PDO_OCI DSN— Connecting to Oracle databases
If you're getting the "I'm too dumb to find oci.h" error, try creating a variety of paths. One variety uses just the major and minor of your OIC version (eg, 11.2 for 11.2.0.2) and another variety uses client64 as well as client. Something like this (for 11.2.0.2): ln -s /usr/include/oracle/11.2.0.2/ /usr/include/oracle/11.2 ln -s /usr/include/oracle/11.2/client /usr/include/oracle/11.2/client64 ln -s /usr/lib/oracle/11.2.0.2/ /usr/lib/oracle/11.2 ln -s /usr/lib/oracle/11.2/client /usr/lib/oracle/11.2/client64 This should cover your bases for 64-bit systems, as well as PHP patched to use the major.minor version number only. See also PHP bug #44989.
if oracle and oracle instant client has been installed, without db in the same host For UNIX/LINUX，set $LD_LIBRARY_PATH appent your instant client path and client/lib path to it, For windows set PATH like this After set the path ,set TNS_ADMIN everioment ,point to where tnsnames.ora located. Then,you can use service name to connect to your Database Test coding
