Install Oracle 12c On openSUSE 42.1

Hello everyone.

Today we will go through how we can install Oracle 12c on OpenSuse 42.1. Let’s start then. For this, I will use OpenSuse 42.1 Linux distribution. I am assuming that you have already installed OpenSuse 42.1 on your system.

The following packages ( Updated version or version that matches with openSUSE 42.1 ) must be installed on your system.

binutils-2.25.0-5.2.x86_64
gcc-4.8-8.4.x86_64
gcc-c++-4.8-8.4.x86_64
glibc-2.19-17.4.x86_64
glibc-devel-2.19-17.4.x86_64
ksh-93v-5.5.x86_64
libaio1-0.3.109-19.1.x86_64
libaio-devel-0.3.109-19.1.x86_64
libcap1-1.10-61.2.x86_64
libstdc++-devel-4.8-8.4.x86_64
libstdc++-devel-32bit-4.8-8.4.x86_64
libstdc++48-devel-4.8.5-18.1.x86_64
libstdc++48-devel-32bit-4.8.5-18.1.x86_64
libstdc++6-5.2.1+r226025-4.2.x86_64
libstdc++6-32bit-5.2.1+r226025-4.2.x86_64
libstdc++6-devel-gcc5-5.2.1+r226025-4.2.x86_64
libstdc++6-devel-gcc5-32bit-5.2.1+r226025-4.2.x86_64
libgcc_s1-5.2.1+r226025-4.2.x86_64
libgcc_s1-32bit-5.2.1+r226025-4.2.x86_64
make-4.0-4.4.x86_64
sysstat-11.0.8-75.1.x86_64
xorg-x11-libs-7.6-47.1.noarch
xorg-x11-libX11-ccache-7.6-20.1.noarch
xdpyinfo-1.3.2-1.1.x86_64
xorg-x11-libXau
xorg-x11-libxcb
xorg-x11-libXext
unixODBC-32bit-2.3.1-3.2.x86_64
unixODBC-2.3.1-3.2.x86_64
unixODBC-devel-2.3.1-3.2.x86_64
unixODBC-devel-32bit-2.3.1-3.2.x86_64

Note: You must install all the prerequisite packages in order to install Oracle 12c. if you encounter any problem which is related to a missing package, please install that particular package. Make sure that you have all the necessary packages installed for your OpenSuse 42.1 and all the path variable are OK and all other prerequisites are done before beginning the installation.

Now, open a terminal and issue the following command to create a group. This will create a group called “oinstall”.

sudo groupadd -g 54321 oinstall

And then, we need to create a group called dba. Issue the following command in the terminal.

sudo groupadd -g 54322 dba

We need to create few more groups as well. Open a terminal and issue the following commands one after another to create those required groups.

sudo groupadd -g 54323 oper
sudo groupadd -g 54324 backupdba
sudo groupadd -g 54325 dgdba
sudo groupadd -g 54326 kmdba
sudo groupadd -g 54327 asmdba
sudo groupadd -g 54328 asmoper
sudo groupadd -g 54329 asmadmin

Now, we need to create a user called “oracle”. To create an “oracle” user, enter a command similar to the following in the terminal.

sudo useradd -u 54321 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba - m oracle

Let’s set the password of the oracle user.

sudo passwd oracle

Change the password of the user oracle accordingly.

We need to create database installation directory and set the proper ownership and permission for that directory. To do so, issue the following commands

 sudo mkdir -p /home/u01/app/oracle/product/12.1.0/dbhome_1
 sudo chown -R oracle:oinstall /home/u01/
 sudo chmod -R 775 /home/u01/

We need to configure the kernel parameters by editing the file /etc/sysctl.conf. Simply copy & paste the following lines in the /etc/sysctl.conf and then save & exit from the file.

 fs.suid_dumpable = 1
 fs.aio-max-nr = 1048576
 fs.file-max = 6815744
 kernel.shmall = 2097152
 kernel.shmmax = 536870912
 kernel.shmmni = 4096
 kernel.sem = 250 32000 100 128
 net.ipv4.ip_local_port_range = 9000 65500
 net.core.rmem_default=4194304
 net.core.rmem_max=4194304
 net.core.wmem_default=262144
 net.core.wmem_max=1048586

Note: These above parameters can be changed or tweaked depending on your server hardware capabilities.

Let’s put those limits value for oracle. By editing /etc/security/limits.conf  file, we can do this. Just follow the following lines.

 oracle              soft    nproc   2047
 oracle              hard    nproc   16384
 oracle              soft    nofile  1024
 oracle              hard    nofile  65536
 oracle              soft    stack   10240

Now logout from your current user and login into the system by using the user name “oracle” and the password you set just before.

Set the ORACLE_HOME environment variable to specify the appropriate Oracle home directory for the listener. To do so, open the file “/home/oracle/.bashrc” by using vim or your favourite file editor and copy and paste the below codes.

TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.1.0.1; export ORACLE_HOME
#ORACLE_SID=SNAP12C; export ORACLE_SID
#PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

Save & exit from the file.

Download Oracle 

You must download the two (2) zip files from this link. Download and unzip both files to the same directory. The two downloadable files names are linuxamd64_12c_database_1of2.zip & linuxamd64_12c_database_2of2.zip respectively. After extracting or unzipping, It will create a folder called database.

Now, let’s start the installation. Move to the folder location where you extracted the oracle zip files. Issue the following command in the terminal once you have moved to that extracted directory.

sudo ./runInstaller

This will start the Oracle installer to begin the installation.

STEP # 1

Step1_Oracle12c_OpenSuse

For Step 1, you can enter your email address and check the box to receive security updates from Oracle Support by putting your oracle password. Then click next.

STEP # 2

Step2_Oracle12c_OpenSuse

For Step 2, you can skip the software updates and click next to continue.

STEP # 3

Step3_Oracle12c_OpenSuse

For Step 3, select “Create and configure a database” and click next.

STEP # 4

Step4_Oracle12c_OpenSuse

For Step 4, select Server class and click next to move forward.

STEP # 5

Step5_Oracle12c_OpenSuse

For Step 5 select “Single instance database installation” and click next.

STEP # 6

Step6_Oracle12c_OpenSuse

For Step 6, I am selecting Typical install. You can select Adavance install as well. Click next.

STEP # 7

Step7_Oracle12c_OpenSuse

For Step 7, follow the above image and click next.

STEP # 8

Step8_Oracle12c_OpenSuse

STEP # 9

Step9_Oracle12c_OpenSuse

Click Install. Wait till install gets finished. It will ask you to run a script with root privilege.

Note: If you encounter any error(s) during the installation process, please Google for it as you may encounter lot of different issues and it is not possible for me to cover all of those different errors in a single topics.

If you need further more reading and instructions regarding installation guides and general Oracle Database 12c documentation, please visit this page.

Thank you.