Skip to main content

  • First prerequirements are a working apache2 and php7.2 (Ubunti 18.04) environment.
  • Download the basic (like and the sdk ( package from the Oracle Website
  • Upload both files to your webserver, you can use WinSCP (windows) or rsync/scp (linux) for it
  • Unzip both files on server, in my case, you will get a new folder named "instantclient_12_2"
  • Create destination folder : mkdir /opt/oracle
  • Move and rename the instantclient folder: mv instantclient_12_2 /opt/oracle/instantclient
  • Change rights on folder: chown -R root:www-data /opt/oracle 
  • Check if you have the required packages for installing OCI8: apt install php7.2-dev php-pear build-essential libaio1 
  • Create necessary soft links: ln -s /opt/oracle/instantclient/ /opt/oracle/instantclient/; ln -s /opt/oracle/instantclient/ /opt/oracle/instantclient/
  • Add instant client to ld config files : echo /opt/oracle/instantclient > /etc/
  • Update Dynamic Linker Run-Time Bindings : ldconfig
  • Now install OCI8 by pecl: pecl install oci8
  • The OCI8 installation is asking you for the right folder: instantclient,/opt/oracle/instantclient
  • Add oci lib to the cli php config (console php): echo "extension =" >>/etc/php/7.2/cli/php.ini
  • Add oci lib to the apache php config: echo "extension =" >> /etc/php/7.2/apache2/php.ini
  • Set environment variables for the cli version (you will need to reboot the server after): echo "LD_LIBRARY_PATH=\"/opt/oracle/instantclient\"" >> /etc/environment echo "ORACLE_HOME=\"/opt/oracle/instantclient\"" >> /etc/environment
  • Set environement variables for the apache version: echo "export LD_LIBRARY_PATH=\"/opt/oracle/instantclient\"" >> /etc/apache2/envvars; echo "export ORACLE_HOME=\"/opt/oracle/instantclient\"" >> /etc/apache2/envvars 
  • Restart Apache: service apache2 restart or systemctl restart apache2 
  • You're done, now you can test your connection to the Oracle database



Popular posts from this blog

mplayer-gui error : Error in skin config file

After installing mplayer-gui package, I can't start it.

$ gmplayer MPlayer 1.1-4.8 (C) 2000-2012 MPlayer Team mplayer: could not connect to socket mplayer: No such file or directory Failed to open LIRC support. You will not be able to use your remote control. Error in skin config file on line 6: PNG read error in /usr/share/mplayer/skins/default/main Config file processing error with skin 'default'
After googling a bit, I found out that it was due to the png files in dir /usr/share/mplayer/skins/default. This is the default skin directory. To fix this error, I have to install ImageMagick package because I want to use the convert program to convert all of the png files to format png24. Thus, cd /usr/share/mplayer/skins/default; for FILE in *.png ; do sudo convert $FILE -define png:format=png24 $FILE ; done
Rerun gmplayer and all should be fine.
Have fun!
UPDATE (02-10-2017)

It doesn't work on Ubuntu 16.04 (xenial) but there's a workaround here.

You can update your syst…

Transparent proxy with squid 2.6

I have upgraded my squid from 2.5 STABLE13 to 2.6 STABLE18. Transparent proxy is setup differently in this version. You need this directives in squid.conf (usually in /etc or /usr/local/etc or /usr/local/squid/etc, check with your distro).

acl our_networks src
http_access allow our_networks
http_port transparent
always_direct allow all

where is your proxy server IP address.

If you have flushed your iptables, create new rule:

iptables -t nat -A PREROUTING -i eth0 -p tcp –dport 80 -j REDIRECT –to-port 3128

where 3128 is the port where squid is running.

Moving your mysql database to another hard disk

Recently, my server's only hard disk was almost full. I bought a new hard disk with bigger size and I decided to just add it as a second hard disk. Since I need to move it to the 2nd hard disk, I need to find a proper way to move the db with minimum downtime. So I googled around and found a solution.
First, I needed to format the 2nd hard disk and I chose xfs as the filesystem. I created 2 partitions using Linux's fdisk for this task. First partition is 10 GB and 2nd one is around 900 GB. That's approximately added up to 1 TB. Then I mounted the 2nd partition in current partition eg /media/hd2 as follows:
mount -t xfs /dev/sdb5 /media/hd2
where /dev/sdb5 is the partition and /media/hd2 is the mounting dir.
Stop mysql db before doing anything:
service mysql stop
Afterthat, I copied the entire db to newly mounted hard disk:
cp -rv /var/lib/mysql /media/hd2
It will take a while if you have huge databases.
Then, change the ownership of the dir to user and group of mysql:
chown -R mysql:…