How to install oci8 in Centos7 and Ubuntu

-

OCI8 Installation.

https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html


 # yum install php-devel systemtap-sdt-devel php-pear


# yum install oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm oracle-instantclient12.2-tools-12.2.0.1.0-1.x86_64.rpm


# ldconfig


# export PHP_DTRACE=yes


# pecl install oci8-2.2.0


downloading oci8-2.2.0.tgz ...

Starting to download oci8-2.2.0.tgz (196,449 bytes)

.........................................done: 196,449 bytes

11 source files, building

running: phpize

Configuring for:

PHP Api Version:         20190902

Zend Module Api No:      20190902

Zend Extension Api No:   320190902

Please provide the path to the ORACLE_HOME directory. Use 'instantclient,/path/to/instant/client/lib' if you're compiling with Oracle Instant Client [autodetect] : Enter

-----

------

------

Build complete.

Don't forget to run 'make test'.


running: make INSTALL_ROOT="/var/tmp/pear-build-rootx3fTor/install-oci8-2.2.0" install

Installing shared extensions:     /var/tmp/pear-build-rootx3fTor/install-oci8-2.2.0/usr/lib64/php/modules/

running: find "/var/tmp/pear-build-rootx3fTor/install-oci8-2.2.0" | xargs ls -dils

205570119   0 drwxr-xr-x 3 root root     17 Nov  4 17:45 /var/tmp/pear-build-rootx3fTor/install-oci8-2.2.0

136708230   0 drwxr-xr-x 3 root root     19 Nov  4 17:45 /var/tmp/pear-build-rootx3fTor/install-oci8-2.2.0/usr

205570120   0 drwxr-xr-x 3 root root     17 Nov  4 17:45 /var/tmp/pear-build-rootx3fTor/install-oci8-2.2.0/usr/lib64

   395320   0 drwxr-xr-x 3 root root     21 Nov  4 17:45 /var/tmp/pear-build-rootx3fTor/install-oci8-2.2.0/usr/lib64/php

 71494377   0 drwxr-xr-x 2 root root     21 Nov  4 17:45 /var/tmp/pear-build-rootx3fTor/install-oci8-2.2.0/usr/lib64/php/modules

 71494378 676 -rwxr-xr-x 1 root root 691056 Nov  4 17:45 /var/tmp/pear-build-rootx3fTor/install-oci8-2.2.0/usr/lib64/php/modules/oci8.so


Build process completed successfully

Installing '/usr/lib64/php/modules/oci8.so'

install ok: channel://pecl.php.net/oci8-2.2.0

configuration option "php_ini" is not set to php.ini location

You should add "extension=oci8.so" to php.ini


# vim /etc/php.ini 


============================================================


OCI8 Installation. Ubuntu 

https://medium.com/@dhanza/setup-apache2-php-oci8-on-ubuntu-20-04-d9e5b400f3fa

https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html


After we got all the components like apache2, php and the oracle client, now we follow the steps below :


    extract oracle instant client basic and sdk

   # unzip instantclient-basic-linux.x64–12.2.0.1.0.zip

   # unzip instantclient-sdk-linux.x64–12.2.0.1.0.zip

    make a folder /opt/oracle, and then move the extracted folder there

   # mkdir /opt/oracle

   # mv instantclient_12_2 /opt/oracle/instantclient

    change the ownership of folder

    # chown -R root:www-data /opt/oracle/instantclient

    install dependencies needed for oracle installation

    # apt-get install php7.4-dev php-pear build-essential libaio1

    make symbolic lynx for library needed for installation

  #  ln -s /opt/oracle/instantclient/libclntsh.so.12.1 /opt/oracle/instantclient/libclntsh.so

  #  ln -s /opt/oracle/instantclient/libocci.so.12.1 /opt/oracle/instantclient/libocci.so

    add instantclient folder to ldconfig, and then update it

   #  echo /opt/oracle/instantclient > /etc/ld.so.conf.d/oracle-instantclient.conf

    # ldconfig

    install oci8, and then enter this parameter when it requested

    # pecl channel-update pecl.php.net

   # pecl install oci8–2.2.0

    instantclient,/opt/oracle/instantclient

    add oci8 extension into php configuration

    # echo " extension = oci8.so " >> /etc/php/7.4/cli/php.ini

    # echo " extension = oci8.so " >> /etc/php/7.4/apache2/php.ini

    and instantclient environment configuration

   # echo "LD_LIBRARY_PATH=\"/opt/oracle/instantclient\"" >> /etc/environment

   # echo "ORACLE_HOME=\"/opt/oracle/instantclient\"" >> /etc/environment

   #  echo "LD_LIBRARY_PATH=\"/opt/oracle/instantclient\"" >> /etc/apache2/envvars

   #  echo "ORACLE_HOME=\"/opt/oracle/instantclient\"" >> /etc/apache2/envvars

    restart server

    test the application with phpinfo script. if it shown like this picture below then the installation is success


Comments

Post a Comment

Popular posts from this blog

How to install and configure node js and PM2 in rhel7

-
OS RHEL7.6 Minimal Install Download :  libuv-1.7.5-3.el7.x86_64.rpm , nodejs-4.7.2-1.el7.x86_64.rpm [root@node1 ~]# rpm -ivh nodejs-4.7.2-1.el7.x86_64.rpm warning: nodejs-4.7.2-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY error: Failed dependencies: libuv >= 1:1.7.5 is needed by nodejs-4.7.2-1.el7.x86_64 libuv.so.1()(64bit) is needed by nodejs-4.7.2-1.el7.x86_64 [root@node1 ~]# rpm -ivh libuv-1.7.5-3.el7.x86_64.rpm warning: libuv-1.7.5-3.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY Preparing...                          ################################# [100%] Updating / installing...    1:libuv-1:1.7.5-3.el7              ################################# [100%] [root@node1 ~]# rpm -ivh nodejs-4.7.2-1.el7.x86_64.rpm warning: nodejs-4.7.2-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY Preparing...                          ################################# [100%] Updating / installing.
Read more

PCS Corosync Pacemaker Cluster Mariadb using NFS

-
              PCS Corosync Pacemaker Cluster Mariadb using NFS I have use 2 node cluster with nfsserver  (NODE1,NODE2 and nfsserver )  OS RHEL7.6 Minimal Install IP 192.168.122.50 node1.example.com node1 IP 192.168.122.51 node2.example.com node2 IP 192.168.122.49 nfsserver.example.com nfsserver [root@node1 ~]# vi /etc/hosts  ( edit in NODE1,NODE2 and nfsserver ) 127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.122.49 nfsserver.example.com nfsserver 192.168.122.50 node1.example.com node1 192.168.122.51 node2.example.com node2 #####  Stop Firewall in NODE1,NODE2 and nfsserver  ####### [root@node1 ~]# iptables -F [root@node1 ~]# iptables -F -t nat [root@node1 ~]# systemctl stop firewalld [root@node1 ~]# systemctl disable firewalld [root@node1 ~]# systemctl stop NetworkManager [root@node1 ~]# systemctl disable NetworkManager [root@node1 ~]# vi /etc/sy
Read more

How to Create or Configure iSCSI Server and Clinet

-
Server: server.example.com IP Address: 192.168.122.246 OS: CentOS 7.9 Client: client.example.com IP Address: 192.168.122.245 Server: [root@server ~]# pvcreate /dev/vdb [root@server ~]# vgcreate newvg /dev/vdb [root@server ~]#  lvcreate -L 10G -n iscsi newvg [root@server ~]# yum install targetcli -y [root@server ~]# targetcli > cd /backstores/block /backstores/block> create iscsi_disk1 /dev/newvg/iscsi Created block storage object iscsi_disk1 using /dev/newvg/iscsi. /backstores/block> cd /iscsi /iscsi> create iqn.2016-02.local.cass2.server:disk1 Created target iqn.2016-02.local.cass2.server:disk1. Created TPG 1. Global pref auto_add_default_portal=true Created default portal listening on all IPs (0.0.0.0), port 3260. /iscsi> cd /iscsi/iqn.2016-02.local.cass2.server:disk1/tpg1/acls  /iscsi/iqn.20...sk1/tpg1/acls> create iqn.2016-02.local.cass2.server:cass1 Created Node ACL for iqn.2016-02.local.cass2.server:cass1 /iscsi/iqn.20...sk1/tpg1/acls> cd /iscsi/iqn.2016-02.
Read more