Difference between revisions of "Installing Oracle"

From EPrints Documentation
Jump to: navigation, search
m (categories modified)
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Category:Installation]]
+
{{Work in Progress}}
 
+
[[Category:Work in Progress|Deprecated]]
   This page is a working document. Oracle support hasn't been fully tested yet.
+
   Oracle support hasn't been fully tested yet.
  
 
Added in version 3.1.0.
 
Added in version 3.1.0.
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".
 +
 +
== Installing Oracle Express Edition ==
 +
 +
This is only required if you wish to use the free Oracle DB for testing/development purposes.
 +
 +
See [https://help.ubuntu.com/community/Oracle Oracle on Ubuntu].
 +
 +
== Adding Oracle Environment Variables ==
 +
 +
Make life with Oracle easier by adding the Oracle environment variables to the global system profile.
 +
 +
Create /etc/profile.d/oracle.sh (replace 10.2.0 with the correct version for your Oracle server/client):
 +
 +
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
 +
ORACLE_SID=XE
 +
PATH=$PATH:$ORACLE_HOME/bin
 +
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
 +
export ORACLE_HOME
 +
export ORACLE_SID
 +
export PATH
 +
export LD_LIBRARY_PATH
 +
 +
You will need to log out/in for this change to take effect.
 +
 +
== GQLPlus ==
 +
 +
The sqlplus tool has very poor shell support. For a better shell tool use [http://gqlplus.sourceforge.net/ gqlplus].
  
 
== Installation ==
 
== Installation ==
Line 22: Line 51:
 
     #$c->{dbsock} = undef;
 
     #$c->{dbsock} = undef;
 
     $c->{dbdriver} = 'Oracle';
 
     $c->{dbdriver} = 'Oracle';
 +
    $c->{dbhost} = 'localhost';
 
     $c->{dbsid} = 'XE';
 
     $c->{dbsid} = 'XE';
 
     $c->{dbuser} = 'HR';
 
     $c->{dbuser} = 'HR';
Line 44: Line 74:
  
 
At the moment starting the indexer from the Admin page doesn't work, due to the Oracle environment variables not being present.
 
At the moment starting the indexer from the Admin page doesn't work, due to the Oracle environment variables not being present.
 +
 +
=== ORA-24327: need explicit attach before authenticating a user ===
 +
 +
Make sure you have set $c->{dbhost}.

Latest revision as of 13:07, 19 February 2024

Warning.png

Work in Progress
The page is a work in progress.

 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".

Installing Oracle Express Edition

This is only required if you wish to use the free Oracle DB for testing/development purposes.

See Oracle on Ubuntu.

Adding Oracle Environment Variables

Make life with Oracle easier by adding the Oracle environment variables to the global system profile.

Create /etc/profile.d/oracle.sh (replace 10.2.0 with the correct version for your Oracle server/client):

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
ORACLE_SID=XE
PATH=$PATH:$ORACLE_HOME/bin
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export ORACLE_HOME
export ORACLE_SID
export PATH
export LD_LIBRARY_PATH

You will need to log out/in for this change to take effect.

GQLPlus

The sqlplus tool has very poor shell support. For a better shell tool use gqlplus.

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->{dbhost} = 'localhost';
   $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.

ORA-24327: need explicit attach before authenticating a user

Make sure you have set $c->{dbhost}.