oracle 客户端安装

最新推荐文章于 2024-07-30 11:53:53 发布

Vivan

最新推荐文章于 2024-07-30 11:53:53 发布

阅读量564

点赞数

分类专栏： php 文章标签： PHP 数据库

本文链接：https://blog.csdn.net/yjier/article/details/42497057

版权

php 专栏收录该内容

28 篇文章 0 订阅

订阅专栏

   ************************************************
   *            注意事项                          *
   *   需要安装跟客户oracle相同版本的客户端       *
   *   此文件以oracle 10为例进行说明             *
   *     修改任何文件前请先备份                   *
   ************************************************

   ORACLE客户端及PDO OCI扩展的安装
   下载以下安装包
   oracle-instantclient-devel-10.2.0.5-1.x86_64.rpm
   oracle-instantclient-basic-10.2.0.5-1.x86_64.rpm
   oracle-instantclient-sqlplus-10.2.0.5-1.x86_64.rpm

   执行如下命令安装如下三个包:
   rpm -ivh oracle-instantclient-devel-10.2.0.5-1.x86_64.rpm
   rpm -ivh oracle-instantclient-basic-10.2.0.5-1.x86_64.rpm
   rpm -ivh oracle-instantclient-sqlplus-10.2.0.5-1.x86_64.rpm
   echo '/usr/lib/oracle/10.2.0.5/client64/lib/' > /etc/ld.so.conf.d/oracle_client.conf
   /sbin/ldconfig

   ------------------------------------------------------------
   yum install libaio
   tar zxvf oci8.tar.gz
   cd oci8
   /usr/local/php/bin/phpize
   ./configure --with-php-config=/usr/local/php/bin/php-config --with-oci8=instantclient,/usr/lib/oracle/10.2.0.5/client64/lib/
   make && make install
   vim /usr/local/etc/php/php.ini
   加入extension=oci8.so
   -----------------------------------------------------------
   tar zxvf pdo_oci.tar.gz
   cd pdo_oci/
   ln -s /usr/include/oracle/11.0.0.1 /usr/include/oracle/10.2.0.5
   ln -s /usr/lib/oracle/11.0.0.1/ /usr/lib/oracle/10.2.0.5
   /usr/local/php/bin/phpize
   ./configure --with-php-config=/usr/local/php/bin/php-config --with-pdo-oci=instantclient,/usr,10.2.0.5
   make && make install
   vim /usr/local/etc/php/php.ini
   加入extension=pdo_oci.so
   ------------------------------------------------------------
   配置环境变量(在文件/root/.bash_profile输入如下行)
   TNS_ADMIN=/usr/lib/oracle/10.2.0.5/client64
   LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.5/client64/lib
   NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
   export TNS_ADMIN LD_LIBRARY_PATH NLS_LANG
   -------------------------------------------------------------
   若执行完上述操作后，没有文件/etc/ld.so.conf.d/oracle-lib.conf,请在在/etc/ld.so.conf中加入如下行:
   /usr/lib/oracle/10.2.0.5/client64/lib/
   ------------------------------------------------------------
   若执行完上述操作后，没有文件/usr/lib/oracle/10.2.0.5/client64/tnsnames.ora
   在/usr/lib/oracle/10.2.0.5/client64/tnsnames.ora中加入
   ORCL =
   (DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   )
   (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
   )
   )

注:修改HOST的地址和SERVICE_NAME的数据库名称

sqlplus64 user/pass@host/dbname 连接数据库命令

如需切换用户执行需要/etc/sudoers 内的env_reset 后增加 NLS_LANG 以保证字符集正常