SDB:Oracle database installation

openSUSE Support Database

Portal - SDB Categories - How to write an article

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.

Install openSUSE 10.2 with "C/C++ Development" selection.
Read Oracle Installation Document for prerequisites (software requirements x86 x86-64).
Download and Install orarun package. Enable and set password for newly created user oracle by orarun.
Change some environment variables - ORACLE_HOME, ORACLE_SID, TNS_ADMIN in /etc/profile.d/oracle.sh.
Set updated kernel parameters by executing /etc/init.d/oracle start or rcoracle start.
Download and extract Oracle 10gR2 SW. Edit file database/install/oraparam.ini to add "SuSE-10" to [Certified Versions] line.
execute 'xhost +localhost' as current loggeding user to let the installer use the current X session.
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).

Install openSUSE 10.2 with "C/C++ Development" selection.
Read Oracle Installation Document for prerequisites (software requirements).
Download and Install orarun package. Enable and set password for newly created user oracle by orarun.
Change some environment variables - ORACLE_HOME, ORACLE_SID, TNS_ADMIN in /etc/profile.d/oracle.sh.
Set updated kernel parameters by executing /etc/init.d/oracle start or rcoracle start.
Download and extract Oracle Oracle 11gR1 SW.
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 @ Sun bug-6532373

Oracle 10gR2 :

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

Oracle 11gR1 :

Install openSUSE 11.0 with "C/C++ Development" selection.
Download and Install orarun package. Enable and set password for newly created user oracle by orarun.
Change some environment variables - ORACLE_HOME, ORACLE_SID, TNS_ADMIN in /etc/profile.d/oracle.sh.
Set updated kernel parameters by executing /etc/init.d/oracle start or rcoracle start.
Download and extract Oracle Oracle 11gR1 SW.
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 (this seems to mean that the 32 bit gcc package must be present).

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)

openSUSE 11.1

Ignore "libxcb: WARNING! Program tries to unlock a connection without having acquired a lock first..." from Oracle Universal Installer (OUI).

Install the libstdc++33 package. ie:

 zypper install libstdc++33

This package is used by some of the makefiles when creating database instances.

Oracle 11gR1 : Same as openSUSE 11.0

Oracle 10gR2 : Same as openSUSE 11.0

Oracle 9.2.0.4 :

Install db1 package, to fix an error "httpd: error while loading shared libraries: libdb.so.2" at the end of installation process.

 zypper install db1 compat

Follow this link, for the rest of installation instructions.
At the end of installation process you will get an error like this,

     Configuration tool Agent Configuration Assistant failed
         Parameter "orahome" = /opt/oracle/920
         Parameter "nodeinfo"  = NO_VALUE
       Agent Service Failed

that's OK.

Exit Oracle Universal Installer.
Shutdown database and listener.

 $ sqlplus /nolog
 SQL> connect / as sysdba
 Connected.
 SQL> shutdown immediate
 SQL> quit
 $ lsnrctl stop

Go to oracle support
Search and download patch 3238244 (i.e: downloaded to /home/oracle/p3238244_9204_LINUX.zip)
Search and download OPath 6880880 (i.e: downloaded to /home/oracle/p6880880_101000_LINUX.zip)

 $ cd /home/oracle
 $ unzip p3238244_9204_LINUX.zip
 $ unzip p6880880_101000_LINUX.zip
 $ export PATH=${PATH}:/home/oracle/OPatch
 $ which opatch
 /home/oracle/OPatch/opatch
 $ cd 3238244
 $ opatch apply

Relink dbsnmp

 $ cd $ORACLE_HOME/network/lib
 $ make -f ins_oemagent.mk install

Start your listener, and database back.

reference: Oracle 9i on RHEL