Difference between revisions of "Installing Oracle"

From EPrints Documentation
Jump to: navigation, search
(New page: This page is a working document. Oracle support hasn't been fully tested yet. == Requirements == * An Oracle database with an account that has full privileges * Install Oracle client...)
 
Line 3: Line 3:
 
== Requirements ==
 
== Requirements ==
  
* An Oracle database with an account that has full privileges
+
* An Oracle database with an account that has full privileges
* Install Oracle client
+
* Oracle database client
* Install [http://search.cpan.org/~pythian/DBD-Oracle-1.21/ DBD::Oracle]
+
* [http://search.cpan.org/~pythian/DBD-Oracle-1.21/ DBD::Oracle]
  
 
== Installation ==
 
== Installation ==
  
Install EPrints as normal but don't create a database.
+
[[Category: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.

Revision as of 10:06, 11 June 2008

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

Requirements

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

Installation

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.