Installing Oracle - Revision history

Th.lauke@arcor.de: categories modified

2024-02-19T13:07:00Z

categories modified

2010-12-07T11:28:30Z

‎Troubleshooting

2010-12-07T11:27:55Z

‎Installation

2010-12-07T11:07:22Z

2010-12-07T11:04:25Z

2010-02-10T11:34:17Z

2009-07-22T12:52:37Z

‎Requirements

2008-06-11T10:13:05Z

2008-06-11T10:08:10Z

2008-06-11T10:06:18Z

@@ Line 1: / Line 1: @@
-[[Category:Installing EPrints Dependancies]]
+{{Work in Progress}}
-   This page is a working document. Oracle support hasn't been fully tested yet.
+[[Category:Work in Progress|Deprecated]]
 Added in version 3.1.0.

← Older revision		Revision as of 11:28, 7 December 2010
Line 73:		Line 73:

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

@@ Line 50: / Line 50: @@
      #$c->{dbsock} = undef;
      $c->{dbdriver} = 'Oracle';
      $c->{dbsid} = 'XE';
      $c->{dbuser} = 'HR';

← Older revision		Revision as of 11:07, 7 December 2010
Line 34:		Line 34:

	You will need to log out/in for this change to take effect.		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 ==

← Older revision		Revision as of 11:04, 7 December 2010
Line 11:		Line 11:

	You should set the Oracle table character coding to "utf-8".		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.

	== Installation ==		== Installation ==

← Older revision		Revision as of 11:34, 10 February 2010
Line 1:		Line 1:
−	[[Category:~~Installation~~]]	+	[[Category:Installing EPrints Dependancies]]
−
	This page is a working document. Oracle support hasn't been fully tested yet.		This page is a working document. Oracle support hasn't been fully tested yet.

@@ Line 10: / Line 10: @@
 * Oracle database client
 * [http://search.cpan.org/~pythian/DBD-Oracle-1.21/ DBD::Oracle]
 == Installation ==

← Older revision		Revision as of 10:13, 11 June 2008
Line 2:		Line 2:

	This page is a working document. Oracle support hasn't been fully tested yet.		This page is a working document. Oracle support hasn't been fully tested yet.
		+
		+	Added in version 3.1.0.

	== Requirements ==		== Requirements ==

@@ Line 1: / Line 1: @@
    This page is a working document. Oracle support hasn't been fully tested yet.
@@ Line 9: / Line 11: @@
 == Installation ==
-[[Category:Installation|Install EPrints]] as normal but don't create a (MySQL) database.
+Install EPrints as normal but don't create a (MySQL) database.
 Edit archives/[repoid]/cfg/cfg.d/database.pl to add the Oracle configuration:

@@ Line 3: / Line 3: @@
 == 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 ==
-Install EPrints as normal but don't create a database.
+[[Category:Installation|Install EPrints]] as normal but don't create a (MySQL) database.