Oracle on openSUSE

From openSUSE

Introduction

With the availability of orarun package, Oracle Database installation is reduced to few downloads and clicks.

SLES users please visit: http://www.novell.com/products/server/oracle/

openSUSE 10.2

Oracle Database 10gR2

If this is your first time Oracle install, then please read white paper Oracle Database 10gR2 on openSUSE 10.2.

1. Install openSUSE 10.2 with "C/C++ Development" selection.
2. Read Oracle Installation Document for prerequisites (software requirements).
3. Download and Install orarun package. Enable and set password for newly created user oracle by orarun.
4. Change some environment variables - ORACLE_HOME, ORACLE_SID, TNS_ADMIN in /etc/profile.d/oracle.sh.
5. Set updated kernel parameters by executing /etc/init.d/oracle start or rcoracle start.
6. Download and extract Oracle 10gR2 SW. Edit file database/install/oraparam.ini to add "SuSE-10" to [Certified Versions] line.
7. login as user oracle and run Oracle Universal Installer "database/runInstaller". Just follow step by step questions of Oracle installer.

Oracle Database 11gR1

For detailed instruction have a look at Introduction to Oracle 11gR1 on SLES10 (x86).

1. Install openSUSE 10.2 with "C/C++ Development" selection.
2. Read Oracle Installation Document for prerequisites (software requirements).
3. Download and Install orarun package. Enable and set password for newly created user oracle by orarun.
4. Change some environment variables - ORACLE_HOME, ORACLE_SID, TNS_ADMIN in /etc/profile.d/oracle.sh.
5. Set updated kernel parameters by executing /etc/init.d/oracle start or rcoracle start.
6. Download and extract Oracle Oracle 11gR1 SW.
7. login as user oracle and run Oracle Universal Installer "database/runInstaller". Just follow step by step questions of Oracle installer.

openSUSE 10.3

Oracle Universal Installer (OUI) on openSUSE 10.3 gives following java error:"java: xcb_xlib.c:52: xcb_xlib_unlock: Assertion `c->xlib.lock' failed.".

Workaround : export LIBXCB_ALLOW_SLOPPY_LOCK=1

Oracle 10gR2 : Same as openSUSE 10.2

Oracle 11gR1 : Same as openSUSE 10.2

openSUSE 11.0

Ignore "libxcb: WARNING! Program tries to unlock a connection without having acquired a lock first..." from Oracle Universal Installer (OUI). You may need previous workaround : "export LIBXCB_ALLOW_SLOPPY_LOCK=1". You can learn more about this java issue @ http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6532373

Oracle 10gR2 :

1. Install openSUSE 11.0 with "C/C++ Development" selection.
2. Download and Install orarun package. Enable and set password for newly created user oracle by orarun.
3. Change some environment variables - ORACLE_HOME, ORACLE_SID, TNS_ADMIN in /etc/profile.d/oracle.sh.
4. Set updated kernel parameters by executing /etc/init.d/oracle start or rcoracle start.
5. Download and extract Oracle 10gR2 SW. Edit file database/install/oraparam.ini to add "SuSE-11" to [Certified Versions] line.
6. login as user oracle and run Oracle Universal Installer "database/runInstaller". Just follow step by step questions of Oracle installer.

Oracle 11gR1 :

1. Install openSUSE 11.0 with "C/C++ Development" selection.
2. Download and Install orarun package. Enable and set password for newly created user oracle by orarun.
3. Change some environment variables - ORACLE_HOME, ORACLE_SID, TNS_ADMIN in /etc/profile.d/oracle.sh.
4. Set updated kernel parameters by executing /etc/init.d/oracle start or rcoracle start.
5. Download and extract Oracle Oracle 11gR1 SW.
6. login as user oracle and run Oracle Universal Installer "database/runInstaller". Just follow step by step questions of Oracle installer.

Note: If you are on x86_64, please make sure 32 bit Runtime Environment is installed to avoid Oracle linking errors.

Alternatively if you don't want problems in the installation of oracle 10g or 11g on openSUSE 11.0 (64bit) you can use this script doris1.1d.sh. This script will automate the setup by downloading from Yast dependencies, sorting out all the 32bit and 64bit libraries and linking where required. The purpose of this script is not to install Oracle but just to get the system ready for installation. Own risks policy applies. (root@localhost# sh doris1.1d.sh suse11 10g) --Ade90036 12:59, 7 August 2008 (UTC)