Tekst źródłowy strony Installing Oracle for PHP

* http://www.oracle.com/technetwork/articles/technote-php-instant-084410.html
* http://moodle.org/mod/forum/discuss.php?d=65488#p308002 (with attached html document)
* http://es.php.net/oci8


== Broken versions of OCI8 driver ==

PHP v5.2.4 (and perhaps v5.2.3 as well) have shipped with a bug in the OCI8 driver that leaks statement handles. The version of the OCI8 driver with the bug is v1.2.4. Possible workarounds:

* Upgrade to PHP v5.2.5 or later
* Downgrade to PHP v5.2.1 (reported to work)
* Downgrade only the oci8 driver to the one included in PHP 5.2.1 (it worked for us -- iarenaza)
* If you are on linux and/or can compile PECL extensions, install an older OCI8 driver (v1.2.3 seems to work) from the PECL repository http://pecl.php.net/package/oci8

More information at
* http://bugs.php.net/bug.php?id=42496 -- tracking the PHP OCI8 bug
* http://tracker.moodle.org/browse/MDL-11429 -- diagnostics on the Moodle side

== Installing Moodle on Windows with Oracle Express Edition ==

=== Introduction ===
This section explains how to install Moodle with Oracle Express Edition on Windows. I'm using it for '''debugging''' purpose. It's definitively not a production environment. The goal is to setup easily and quickly a Moodle/Windows/Oracle environment.

=== Install Oracle ===
# Download Oracle Express Edition on [http://www.oracle.com/technology/products/database/xe/index.html Oracle web site].
# You will also need the Instant client [http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html from here] (free account sign up needed). Copy everything from the unzipped folder into apache/bin.
# Install both.<br />
# Access to the oracle console at http://127.0.0.1:8080/apex (Login=SYS Password=the_one_you_entered_during_the_installation).
# Create a new user and give it all rights (including DBA).
# Go to the SQL Commands page and grant your new user the dmbs_lock permission...<code sql>
grant execute on dbms_lock to XXXXX;
</code>...where XXXXX is the username of your new user.
# Log out and log in as the new user.
# Run the script found in the Moodle codebase at /lib/dml/oci_native_moodle_package.sql. If you can not run this script directly, you can run its parts (separated by slashes) independently via the SQL Commands page.

Note: Oracle Express Edition 10g is limited at one database called 'XE'.

=== Set up your Oracle extension ===

This document does not explain how to setup apache/php for Oracle. You can have more information on [http://www.oracle.com/technology/tech/php/htdocs/php-oracle-tutorial.html Oracle Documentation].

Edit your phi.ini file, uncomment (remove the leading semicolon) the php_oci8 extension. In a WAMP setup, this is listed as...

<code>
extension=php_oci8.dll
</code>

Also, if you are going to use the installation for development/testing purposes, uncomment the following line and set the value to zero. It's not needed for normal operations (it causes a BIG slowdown of the system!).

<code>
oci8.statement_cache_size = 0
</code>

You may also need to uncomment php_oracle, php_pdo_oci, php_pdo_oci8 in some set-ups.

=== Install Moodle ===
On the database setup page:<br />
Driver: Oracle oci8 (in the config file it should read "oci8po" for a 1.9.x install and "oci" for a 2.0.x install)<br />
Host: empty the field<br />
Database: //localhost:1521/XE<br />
User: the user that you created<br />
Password: the password you gave to the user<br />

=== Configure Apache ===

If you're running Moodle on Oracle with Apache on Linux, you might have issues with PHP being able to see the system environment variables.  To resolve this, you can edit /etc/sysconfig/apache2 and add the following lines to the bottom:<br />
<br />
LD_LIBRARY_PATH=/opt/oracle/instantclient_11_2# Set LANG Variables for UTF-8<br />
NLS_LANG=AMERICAN_AMERICA.AL32UTF8<br />
LANG=en_US.UTF-8<br />
LC_ALL=en_US.UTF-8<br />
LC_COLLATE=en_US.UTF-8<br />
LC_CTYPE=en_US.UTF-8<br />
LC_MESSAGES=en_US.UTF-8<br />
LC_MONETARY=en_US.UTF-8<br />
LC_NUMERIC=en_US.UTF-8<br />
LC_TIME=en_US.UTF-8<br />
NLS_NUMERIC_CHARACTERS='.,'<br />

export LANG LC_ALL LC_COLLATE LC_CTYPE LC_MESSAGES LC_MONETARY LC_NUMERIC LC_TIM NLS_LANG LD_LIBRARY_PATH NLS_NUMERIC_CHARACTERS<br />
<br />
Also need to add those two lines to ~/.bashrc so that the PHP command-line client can see it too. <br />
<br />

== Related links ==
* [http://lewiscarr.co.uk/node/4 Installing ORACLE drivers with PHP]
*[[Installing MSSQL for PHP]]
*[[PHP]]
*[http://moodle.org/mod/forum/discuss.php?d=134729#p588963 Can i install Moodle with Oracle database]
*[http://moodle.org/mod/forum/discuss.php?d=65488 Who uses Oracle]
*[https://docs.moodle.org/en/Step-by-step_Install_Guide_for_Solaris_10_with_Oracle_10 Step by step Install Guide for Solaris 10 with Oracle 10]
*[http://learningischange.com/2009/05/29/install-moodle-on-an-oracle-database-in-25-minutes-or-less/ Install Moodle on an Oracle Database (in 25 minutes or less)]. The related Using Moodle forum discussion is [http://moodle.org/mod/forum/discuss.php?d=124629 here].
*[http://www.mguhlin.org/2009/05/moodle-on-oracle-database.html Moodle on Oracle Database] discussion on Miguel Guhlin's blog 

[[Category:Installation]]
[[Category:XMLDB]]
[[Category:DB]]
[[Category:SQL databases]]