#oci8

Installing OCI8 as a Shared Extension on RHEL or CentOS

Introduction

Recently, I’ve had issues getting the install of OCI8 using other methods as described in my articles Installing OCI8 & PHP 7.2 on RHEL or CentOS 6 and Installing OCI8 on RHEL. This article covers installing as a “Shared Extension” as described in The Underground PHP and Oracle Manual.

Steps

Below are the steps that I followed:

# Stop Apache and uninstall old versions of…

Fatal error: oci8_dtrace_gen.h: No such file or directory

Introduction

Recently when installing OCI8 on CentOS 7 (Linux) as a shared extension using PECL, after issuing the command “pecl install oci8” I got the error:

fatal error: oci8_dtrace_gen.h: No such file or directory

I was baffled as to what this error means. Basically what is going on is that the Remi PHP repositories are setup for dynamic tracing. If you follow instructions in the Underground…

Configure oracle database in PHP development environment

Three things needed for connecting with oracle database with PHP.

OCI8

PHP

Instant Client

  Those three option should be the same version, same configuration with with each one. Suppose, if our machine has 64bit , then PHP, OCI and instant client should be the same 64Bit system.

  Step 1: Download PHP 7.2

https://windows.php.net/downloads/releases/php-7.2.6-Win32-VC15-x64.zip

  Here, things to…

Installing OCI8 & PHP 7.2 on RHEL or CentOS 6

Introduction

In response to my extremely (thousands of hits) popular article Installing OCI8 on RHEL, I decided to add this article since I find those instructions have become somewhat out of date, and also it is recommended to use PHP 7.2 with any web application that you are currently supporting. PHP 7.2 provides significant performance improvements over PHP 7.0, so if you are using PHP 7.0, I…

Introduction

I frequently use the Symfony Framework to develop PHP applications and I have recently started developing using the latest Symfony 4 Framework. The Symfony Developers have significantly simplified the configuration and setup required for the framework. This article is about the setup of connecting to an external Oracle database using a Doctrine connection with the OCI8 driver.

My Setup

Symfony: Connecting to External Database

Introduction

In a number of my Symfony applications, I’ve had to connect to an external Oracle database to get various data. In this case, I’m merely querying the database for data and there is no need to create any Entities (or data) in the external database. This article describes how to configure the 2nd Symfony database connection, and how to connect and query the 2nd database.

Doctrine…

Debian Jessie compiling PHP with OCI8 & PDO OCI

First we need to grab instant client from oracle.. Basic and Devel RPM packages is enough.

Before we install PHP we need to install prerequisites.

sudo apt-get install gcc libbz2-dev libpng12-dev libc-client2007e-dev libmcrypt-dev libxml2-dev libcurl4-openssl-dev libxslt1-dev libaio1 apache2-dev alien

Turn rpm packages to debian packages with alien.

sudo alien -d…