Difference between revisions of "Installing Oracle"

From EPrints Documentation
Jump to: navigation, search
(Requirements)
Line 10: Line 10:
 
* Oracle database client
 
* Oracle database client
 
* [http://search.cpan.org/~pythian/DBD-Oracle-1.21/ DBD::Oracle]
 
* [http://search.cpan.org/~pythian/DBD-Oracle-1.21/ DBD::Oracle]
 +
 +
You should set the Oracle table character coding to "utf-8".
  
 
== Installation ==
 
== Installation ==

Revision as of 12:52, 22 July 2009


 This page is a working document. Oracle support hasn't been fully tested yet.

Added in version 3.1.0.

Requirements

  • An Oracle database with an account that has full privileges
  • Oracle database client
  • DBD::Oracle

You should set the Oracle table character coding to "utf-8".

Installation

Install EPrints as normal but don't create a (MySQL) database.

Edit archives/[repoid]/cfg/cfg.d/database.pl to add the Oracle configuration:

   #$c->{dbname} = 'eprints';
   #$c->{dbhost} = 'localhost';
   #$c->{dbport} = undef;
   #$c->{dbsock} = undef;
   $c->{dbdriver} = 'Oracle';
   $c->{dbsid} = 'XE';
   $c->{dbuser} = 'HR';
   $c->{dbpass} = 'HR';

dbsid is the name of the Oracle database.

Create the database and import subjects:

./bin/epadmin create_tables [repoid]
./bin/import_subjects [repoid]
./bin/epadmin create_user [repoid]

Continue configuring EPrints.

Troubleshooting

Depending on your server configuration you may find you need to set environment variables for DBD::Oracle to find your Oracle client:

export ORACLE_SID=XE
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

At the moment starting the indexer from the Admin page doesn't work, due to the Oracle environment variables not being present.