Oracle12c - Installing Oracle12c on OpenSuSE 42.1

From aoxoaWiki
Jump to navigationJump to search

UNDER CONSTRUCTION

Here are the steps I used to install Oracle 12c v.12.1.0.2 onto my 64bit OpenSuSE Leap (42.1) system.

Note that you need to be running 64bit (not that Leap is available in 32bit mode....)

I used a post at UnixMen by Mohammad Forhad Iftekher as reference for the details specific to Leap.

I have also assumed that you are familiar with running Oracle Installers. If you need details about the installation options, please refer to Iftekher's page.

Overall Comments

Overall, the installation was pretty painless. Getting the required packages and everything set up took most of the work....

Required Packages

Make sure that the packages below have been installed (or newer versions of them). Use zypper install package to install each one (as root, or sudo zypper....)

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

Create Groups

Make sure that these group numbers are not already used, then create the groups. Note that the numbers themselves are not important.

groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
groupadd -g 504 backupdba
groupadd -g 505 dgdba
groupadd -g 506 kmdba
groupadd -g 507 asmdba
groupadd -g 508 asmoper
groupadd -g 509 asmadmin

Create the Oracle User

Now create the oracle userid and set its password

useradd -u 500 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba -m oracle
passed oracle

Kernel Parameters

Edit the /etc/sysctl.conf file. The following values are suggestions:

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


Set O/S Limits

I am not really sure what this does, but.... add the following to the /etc/security/limits.conf file.

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

Swap Space

Make sure the swap space is at least 150MB

Reboot

Reboot the system to activate the changes

Download Oracle RDBMS Software

Login as oracle.

Download the Oracle12c RDBMS file(s) from Oracle's Technet site. Unzip both files into the same location.

Run the Installer

Start a terminal session, and move to the folder created in the previous step (probably named 'database').

./runInstaller

Follow the instructions.

Note: I got an error indicating that "Environment does not meet minimum requirements." This is probably because OpenSuSE 42.1 is not directly listed as a supported platform. I found that it was safe to ignore this warning. The full installation log file can be found at:

~oracle/app/oraInventory/logs/installActionsXXXXXX.log

e.g.

/home/oracle/app/oraInventory/logs/installActions2016-11-10_09-34-31PM.log

At one point, you will have to run some scripts as root. Make sure you do this step.

Post Installation Steps

  • open up firewall on port 1521
  • set up oracle environment
  • autostart
  • listener config
  • backups
  • archive log mode

See also Oracle12c - Pro*C Include Pathing Fixes



Back to OpenSuSE Linux - Oracle