PHP 7.0 Apache Oracle 12 Instantclient OCI8 install apt-get

If you need to do this from scratch I have followed these how-to-install-and-configure-php-70-or-php-71-on-ubuntu-16-04 insructions to install PHP7.0 and apache.

Once installed then
Follow these instructions to compile oci8 extentions Oracle tech note OCI8

Download the instant client from oracle’s web site here : Oracle instant client download
I downloaded the .ZIP files since I dont have RPM installed.
I then extracted it to ~/Downloads/instantclient_12_2
NOTE: Download the instantclient-basic-linux.x64-12.2.0.1.0.zip and instantclient-sdk-linux.x64-12.2.0.1.0.zip

cd ~Downloads
unzip instantclient-basic-linux.x64-12.2.0.1.0.zip
unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip

Now we need to create the paths

sudo mkdir /usr/lib/oracle
sudo mkdir /usr/lib/oracle/12.2
sudo mkdir /usr/lib/oracle/12.2/client64
sudo mkdir /usr/lib/oracle/12.2/client64/lib
cd ~/Downloads/instantclient_12_2
sudo cp * /usr/lib/oracle/12.2/client64/lib/
cd /usr/lib/oracle/12.2/client64/lib/
ln -s libclntsh.so.12.1 libclntsh.so
sudo mkdir /usr/include/oracle
sudo mkdir /usr/include/oracle/12.2
sudo mkdir /usr/include/oracle/12.2/client64
cd ~/Downloads/instantclient_12_2/sdk/include
sudo cp * /usr/include/oracle/12.2/client64
export ORACLE_HOME=/usr/lib/oracle/12.2

Edit ld.so.conf and include oracle libs. Add a file called oracle.conf under /etc/ld.so.conf.d

cd /etc/ld.so.conf.d
sudo vi oracle.conf
PRESS ESC i
/usr/lib/oracle/12.2/client64/lib
PRESS ESC :wq

Now to download and compile OCI8

sudo pecl install oci8 --with-oci8=instantclient,/usr/lib/oracle/12.2/client64/lib

On My machine it compiled it under ‘/usr/lib/php/20151012/oci8.so’ but look at the last few lines it should echo it.

First lets install a page to test that the configuration works.

sudo vi /var/www/html/t.php ( or xed /var/www/html/t.php if you dont know vi)
Press ESC i and paste

Press ESC :qw

now open your favorite browser and go to http://localhost/t.php and you should see a information page of php

to configure php do:

cd /etc/php/7.0/mods-available
vi oci8.ini

Edit oci8.ini with content

extension=oci8.so

Now restart

sudo service apache2 restart

My Installation now gave an error

apachectl configtest
if you get an error about libaio.so.1: cannot open shared object file: No such file or directory

sudo apt-get install libaio1 libaio-dev

Now we need to give the path to the libraries.
Edit /etc/apache2/envvars and add the flowing to the bottom of the file

ORACLE_HOME=/usr/lib/oracle/12.2/client64
LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib
LD_LIBRARY_PATH64=/usr/lib/oracle/12.2/client64/lib/
#TNS_ADMIN=$ORACLE_HOME/network/admin
#NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
#ORACLE_SID=your_db

To Test

php --ri oci8

Fixing Timezone Issue on Oracle SQL Developer

If you login with SQL Developer and you get the following:

An error was encountered performing the requested operation:

ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
00604. 00000 - "error occurred at recursive SQL level %s"
*Cause: An error occurred while processing a recursive SQL statement
(a statement applying to internal dictionary tables).
*Action: If the situation described in the next error on the stack
can be corrected, do so; otherwise contact Oracle Support.
Vendor code 604

Do the Following:
edit file
sqldeveloper\ide\bin\ide.conf
and add
AddVMOption -Duser.timezone=”+02:00″
at the bottom of the file
OR AddVMOption -Duser.timezone=”GMT+2″

(Just change it according to your time zone…..)

Start SQL developer and To fix date time format go to :
Tools -> Preferences -> database -> nls and change date format to YYYY/MM/DD HH24:MI:SS (Or any of your desired time formats)

And to fix startup errors go to
{USER HOME}\AppData\Roaming\SQL Developer
and rename system4.1.0.19.07 to system4.1.0.18.07

Xen Client VM to work with Oracle Virtual Box

To convert my Xen Client VM to Oracle Virtual Box I did the following:
UPDATE : 30 March 2017
A more easier way is to export the VM in the normal way that will export a system.vhd file.

Now just Extract the system.vhd to a folder on the PC. Go then to Oracle Virtual Box, select new VM
NewVM

Make sure you select Use Existing Virtual Hard Disk and browse to the system.vhd.

Click on the Create VM. After that BEFORE YOU RUN IT, go to settings and ADD an IDE controller.
After that add the system.vhd to the IDE controller and remove it from the SATA Controller.
it should look like:
Storage Settings VM

Save and start the VM,it should work fine.

I have exported my Windows 7 Xen Client VM using XenConvert XenConvert_Install2.5.exe.
Although this is used for P2V I used it to convert my Xen Virtual Machine to Open Virtualization Format.
Note this will ask you to specify the type and select Open Virtualization Format.

When the process is done you will end up with YourVirtualMachineName.ova, if you try to import into Virtual Box you will get an error:

The Appliance YourVirtualMachineName.ova could not be imported.
Document labelled UTF-16 but has UTF-8 content.
Location: ‘YourVirtualMachineName.ova’, line 1 (0), column 36.

Details:
Error code: VBOX_E_FILE_ERROR (0x80BB0004)
Component: Appliance
Interface: IAppliance {SOMEXXXXXNUMBER}

Now I untarred the .ova by typing tar -xvf YourVirtualMachineName.ova on your linux console. (Maybe try 7zip if you are running windows).

This will leave you with a YourVirtualMachineName.vhd. You can use one of the many Other Links on the internet to see how to import a VHD to virtual box. Now the problem is when you start it, it starts up and then a quick blue screen flash and it dies. Mine gave Stop error code 0x0000007B I think…

To solve this stop the virtual machine. Go to the Storage settings. Delete the SATA Controller with the attached VHD disk. Dont delete the disk though just the connection to the SATA. Then go and create a new IDE controller. Add the Virtual Disk YourVirtualMachineName.vhd and remember to also add an CD Rom. Whola!