If you are connecting an Oracle Database using an Apache2 webserver that runs on an Ubuntu machine, you might randomly have this error. Warning: ocilogon() http://function.ocilogon: OCIEnvNlsCreate() failed. There is something wrong with your system – please check that LD_LIBRARY_PATH includes the directory with Oracle Instant Client libraries. It can be solved setting properly the […]

Get the OCI8 module working on a Mac require several settings. I wrote a script to automate the procedure that install and configure SqlPlus, the Oracle Client v10.2, Apache2, PHP5 and the OCI8 on a Mac OS X running Leopard. The script was tested on a Leopard 10.5.4 machine. I have never tested it on […]

Today I wrote this script that can be used to install and configure SqlPlus on a Mac OS X. It was tested on a Leopard 10.5.4 machine. Pre-installation: 1. Download from the Oracle website the Oracle Client for Mac OS X (Intel x86) Version and the SqlPlus: – the Oracle Client ‘Instant Package – […]

Connecting an Oracle Database via PHP, requires a not easy procedure. The bash scripts OracleViaPHP.sh and TNSconnect.sh will automate the set up process for you. The scripts are tested on a virtual machine running OS Linux Ubuntu Server 8.04.1 i386 created on a Mac OS X running Leopard 10.5.3. OracleViaPHP.sh will install and configure Apache2, PHP5, the Oracle Client v10.2 […]