Orablog

Orablog as of version 0.1 is in an installable state. The following instructions and comments will help you install Orablog.
Orablog is designed to work with Oracle 10g XE (Express Edition) and the instructions below reflect this. Orablog should work with other releases of Oracle 10g but have not yet been tested.

Linux + Apache + PHP + Oracle

Install Apache

Install Zend Core for Oracle

It is recommended that php 5.1.2 or greater is used as this version contains the re-factored oci8 extension. Zend Core for Oracle is highly recommended and is freely available from Zend

Install Oracle XE

Available from Oracle or for debian users. Simply update the /etc/apt/source.list file with:

deb http://oss.oracle.com/debian/ unstable main non-free
deb-src http://oss.oracle.com/debian/ unstable main

Then apt-get update

apt-get install oracle-xe

Debian help

Install Orablog

1. Create an Oracle user. This can either be done using the web based administration tools or through sqlplus.
   Example using sqlplus
   Log in as a system user:

   sqlplus system

   create user orablog identified by password default tablespace users temporary tablespace temp quota unlimited on users;

   grant connect, resource to orablog;

2. Install the schema date functions.

   sqlplus orablog/orablog < sql/install-mysql-oracle-functions.sql

   sqlplus orablog/orablog < sql/install-schema.sql

3. Make everything below the htdocs directory readable by the webserver. This can be a achieved by copying the files or linking.
4. Copy htdocs/wp-config-sample.php to htdocs/wp-config.php
5. Edit the file htdocs/wp-config.php and change database settings as required
6. Copy htdocs/log4php-sample.xml to log4php.xml
7. Modify log4php.xml and change the location of the log files and the log levels as required.
8. Go to http://yourserver/orablog_install_directory/ and follow the remaining on screen instructions.