Oracle 11 and 12, Orarun and Single-server Multi-version Installations on SLES
This document (7018379) is provided subject to the disclaimer at the end of this document.
Environment
SUSE Linux Enterprise Server 11 Service Pack 4 (SLES 11 SP4)
SUSE Linux Enterprise Server 12 Service Pack 1 (SLES 12 SP1)
Situation
The Oracle Server installation pattern for SLES (which installs the ‘orarun’ package) , is designed to setup the environment on a SLES server so that you are ready to install the Oracle product of your choice.
However, ‘orarun’ for SLES11 always assumes you are working with Oracle11gR2 and ‘orarun’ for SLES12 always assumes you are working with Oracle12cR1. So if you want to install Oracle 12 on SLES11, you need to modify the environment that has been setup by the ‘orarun’ package (or, if you are an Oracle expert, you can just setup the environment without using the ‘orarun’ package/Oracle pattern).
Also, because the orarun package only configures a server for a the support of a single Oracle version, customers who wish to run multiple Oracle versions on the same SLES server, must manually modify the environment to accommodate their needs.
Resolution
Installing Oracle 12 on SLES 11:
After the Oracle Pattern / orarun installation, change the following lines in /etc/profile.d/oracle
From:
ORACLE_HOME=$ORACLE_BASE/product/11gR2/db
# export ORA_CRS_HOME=$ORACLE_BASE/product/11gR2/crs
# export ORA_ASM_HOME=$ORACLE_BASE/product/11gR2/asm
To:
ORACLE_HOME=$ORACLE_BASE/product/12cR1/db
# export ORA_CRS_HOME=$ORACLE_BASE/product/12cR1/crs
# export ORA_ASM_HOME=$ORACLE_BASE/product/12cR1/asm
Installing Oracle 11 on SLES 12:
After the Oracle Pattern / orarun installation, change the following lines in /etc/profile.d/oracle
From:
ORACLE_HOME=$ORACLE_BASE/product/12cR1/db
# export ORA_CRS_HOME=$ORACLE_BASE/product/12cR1/crs
# export ORA_ASM_HOME=$ORACLE_BASE/product/12cR1/asm
To:
ORACLE_HOME=$ORACLE_BASE/product/11gR2/db
# export ORA_CRS_HOME=$ORACLE_BASE/product/11gR2/crs
# export ORA_ASM_HOME=$ORACLE_BASE/product/11gR2/asm
Multiple Oracle Homes Support:
Oracle Database supports multiple Oracle versions / multiple Oracle homes on the same server. You must install each different release of Oracle Database into a unique Oracle home directory.
You must also create / edit the server environment appropriately so whenever any Oracle related action is executed on the server, the execution environment (e.g. ORACLE_HOME) in use is at that time is configured correctly for the correct database and Oracle version that the action is intended to be actioned against (e.g. database start/stop etc).
Additional Information
Configuration files installed by the orarun package:
/etc/sysconfig/oracle
/etc/init.d/oracle (init script: start|stop|status|restart)
/etc/profile.d/oracle.csh
/etc/profile.d/oracle.sh
Related configuration files created by the Oracle installation process:
/etc/oratab
/etc/oraInst.loc
Running Oracle 12 with the high-availability extension.
In order to successfully use the HAE Oracle resource agent with ‘container based’ Oracle 12 databases, you must define 2 parameters on the Oracle resource agent that start with C##. Here is an example:
Instance attributes: sid orcl
home /opt/oracle/product/12cR1/db
monprofile C##monprof1
monuser C##monitor1
NOTE: The monitor profile entry should be auto-created in the database if it does not already exists.
Remember to edit the /etc/oratab file (if it exists) and set the database Y/N start field to ‘N’ so that the HAE Oracle resource agent can be responsible for the start/stop of the database.
NOTE: Always use the latest resource agents available for the version of SUSE Linux Enterprise High Availability Extension being used (search for ‘resource-agents’ under the appropriate product/version on the patch finder web-site or use the appropriate zypper command on any High Availability Extension subscribed update repositories).
Disclaimer
This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented «AS IS» WITHOUT WARRANTY OF ANY KIND.
- Document ID:7018379
- Creation Date: 11-Dec-2016
- Modified Date:03-Mar-2020
-
- SUSE Linux Enterprise Server
For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback[at]suse.com
SDB:Oracle database installation
With the availability of orarun package, Oracle Database installation is reduced to few downloads and clicks.
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 x86x86-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
- 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
- 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.
- 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:
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
- 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
$ 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=$:/home/oracle/OPatch $ which opatch /home/oracle/OPatch/opatch $ cd 3238244 $ opatch apply
$ cd $ORACLE_HOME/network/lib $ make -f ins_oemagent.mk install