Difference between revisions of "Installing Oracle"
(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 | |
| − | + | * Oracle database client | |
| − | + | * [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.
