Installation of Oracle database 18C

Hi Everyone:

Oracle 18C have been released on Linux version like everyone even I am more excited to install the software , actually installation is pretty straight forward but you need make sure your system should be loaded with good  hardware at-least 8GB of RAM and between 8 and 16GB swap .

Interesting part here is when you unzip the folder (software folder which we download from OTN),directly comes with oracle software binaries . So when you start your installation it will just link your binaries to OS, So you can imagine it takes pretty less time to install the software.

So before installation on Linux make sure you are done with the prerequisites  , its a routine work where you need to spend some time before you start installation on Linux environments.

Rest it is pretty much the same

Let me share my environment:
=====================
Linux test1.oracle.com 4.1.12-61.1.28.el6uek.x86_64 #2 SMP Thu Feb 23 20:03:53 PST 2017 x86_64 x86_64 x86_64 GNU/Linux

I am using Oracle Linux 6 

As usual I am ready with the below steps before I start installation

Note: kernel parameter values have to be defined according to your requirement ,rest is pretty the same 

NOTE: At the end I will share the new oracle 18C features w.r.t installation

Please find the below steps :

====================

1-> Download Putty and install on your windows desktop 

2-> Download xming software and install on your windows 

3-> Now you have make sure to have communication from your windows to virtual host 

      eg: if you are using Oracle VM  make sure you use virtual host interface 

4-> Make sure you download the oracle software 

5-> Now login to the linux host and update the /etc/host file with the below entries as below 

Hosts File:

The "/etc/hosts" file must contain a fully qualified name for the server.

<IP-address>  <fully-qualified-machine-name>  <machine-name>

 [root@ora11g ~]# cat /etc/hosts

 127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

192.168.56.102 ora11g.oracle.com ora11g

 6-> update the below kernel parameters 

Oracle recommends the following minimum parameter settings.

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 = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

7-> Now define the security limits for the oracle user 

Add the following lines to the "/etc/security/limits.conf" file.

 oracle              soft    nproc   16384

oracle              hard    nproc   16384

oracle              soft    nofile  4096

oracle              hard    nofile  65536

oracle              soft    stack   10240

8-> Create the new groups and users.

groupadd -g 501 oinstall

groupadd -g 502 dba

groupadd -g 503 oper

groupadd -g 504 asmadmin

groupadd -g 506 asmdba

groupadd -g 505 asmoper

useradd -u 502 -g oinstall -G dba,asmdba,oper oracle

passwd oracle

9-> Amend the "/etc/security/limits.d/90-nproc.conf" file as described below. See MOS

 Note [ID 1487773.1]

# Change this

*          soft    nproc    1024

# To this

* - nproc 16384

10-> disable selinux and also disable firewall 

[root@ora11g ~]# vi /etc/selinux/config

[root@ora11g ~]# cat /etc/selinux/config

SELINUXTYPE=permissive

[root@ora11g ~]# service iptables stop

iptables: Setting chains to policy ACCEPT: nat mangle filte[  OK  ]

iptables: Flushing firewall rules:                         [  OK  ]

iptables: Unloading modules:                               [  OK  ]

[root@ora11g ~]# chconfig iptables off

-bash: chconfig: command not found

[root@ora11g ~]# chkconfig iptables off

[root@ora11g ~]#

11-> Now restart the linux server , before this go to the file "/boot/grub/grub.conf  and update the below entries with selinux=0

eg: 

        root (hd0,0)

        kernel /vmlinuz-4.1.12-61.1.28.el6uek.x86_64 ro root=/dev/mapper/vg_ora11g-lv_root rd_NO_LUKS LANG=en_US.UTF-8 rd_LVM_LV=vg_ora11g/lv_swap rd_NO_MD SYSFONT=latarcyrheb-sun16 crashkernel=1024M  KEYBOARDTYPE=pc KEYTABLE=us rd_LVM_LV=vg_ora11g/lv_root rd_NO_DM rhgb quiet selinux=0

12: Now using winscp copy the software to the linux server 

13-> Now  click on Xming and then open putty session and enable x11 settings and then launch putty session, 

Also execute xhost + 

14-> create directories 

mkdir -p /u02/app/oracle/product/18.0.0/db_1

chown -R oracle:oinstall /u02

chmod -R 775 /u02

15-> Define the oracle bash profile 

Login as the oracle user and add the following lines at the end of the ".bash_profile" file.

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=ora11g.oracle.com; export ORACLE_HOSTNAME

ORACLE_UNQNAME=TEST; export ORACLE_UNQNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1; export ORACLE_HOME

ORACLE_SID=TEST; 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

16-> Make sure you unzip the files under new ORACLE HOME , Here you can see the oracle software binaries 

rwxr-x--- 14 root   root           4096 Jun  4 06:50 OPatch

drwxr-xr-x  6 root   root           4096 Jul 18 22:47 sqlplus

-rwx------  1 root   root            638 Jul 18 22:48 root.sh

drwxr-xr-x  2 root   root           4096 Jul 18 23:09 jlib

drwxr-xr-x  5 root   root           4096 Jul 18 23:11 sqlpatch

drwxr-xr-x  7 root   root           4096 Jul 18 23:14 jdk

drwxr-xr-x 13 root   root           4096 Jul 18 23:14 rdbms

drwxr-xr-x  6 root   root           4096 Jul 18 23:14 precomp

drwxr-xr-x  5 root   root           4096 Jul 18 23:14 perl

drwxr-xr-x  7 root   root           4096 Jul 18 23:14 ord

drwxr-xr-x  7 root   root           4096 Jul 18 23:14 opmn

drwxr-xr-x  5 root   root           4096 Jul 18 23:14 nls

drwxr-xr-x 10 root   root           4096 Jul 18 23:14 network

drwxr-xr-x  9 root   root           4096 Jul 18 23:14 md

drwxr-xr-x 10 root   root           4096 Jul 18 23:14 ldap

drwxr-xr-x  8 root   root           4096 Jul 18 23:14 javavm

drwxr-xr-x  5 root   root           4096 Jul 18 23:14 hs

drwxr-xr-x  4 root   root           4096 Jul 18 23:14 drdaas

drwxr-xr-x  3 root   root           4096 Jul 18 23:14 demo

drwxr-xr-x  7 root   root           4096 Jul 18 23:14 cv

drwxr-xr-x  6 root   root           4096 Jul 18 23:14 crs

drwxr-xr-x  9 root   root           4096 Jul 18 23:14 assistants

drwxr-xr-x  8 root   root           4096 Jul 18 23:14 oui

drwxr-xr-x  3 root   root          16384 Jul 18 23:14 lib

drwxr-x--- 13 root   root           4096 Jul 18 23:14 inventory

drwxr-xr-x  5 root   root           4096 Jul 18 23:14 deinstall

drwxr-xr-x  4 root   root           4096 Jul 18 23:14 clone

drwxr-xr-x  2 root   root           4096 Jul 18 23:14 bin

drwxr-xr-x  2 root   root           4096 Jul 18 23:14 addnode

drwxr-xr-x 10 root   root           4096 Jul 18 23:23 install

17-> It took me just 2 to 3 min for software installation 

18-> Output of root.sh

[root@test1 u02]#  /u02/app/oracle/product/18.0.0/db_18/root.sh

Performing root user operation.

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u02/app/oracle/product/18.0.0/db_18

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying dbhome to /usr/local/bin ...

The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] :

no

Oracle Trace File Analyzer (TFA - Non Daemon Mode) is available at :

    /u02/app/oracle/product/18.0.0/db_18/suptools/tfa/release/tfa_home/bin/tfactl

Note :

1. tfactl will use TFA Daemon Mode if TFA already running in Daemon Mode and user has access to TFA

2. tfactl will configure TFA Non Daemon Mode only if user has no access to TFA Daemon mode or TFA Daemon mode is not installed

OR

Oracle Trace File Analyzer (TFA - Daemon Mode) can be installed by running this script :

    /u02/app/oracle/product/18.0.0/db_18/suptools/tfa/release/tfa_home/install/roottfa.sh

[root@test1 u02]#

19-> 

Oracle 18C features:

------------------------

Simplified Image-based Oracle Database Installation( this will just link your oracle binaries with OS)

RPM-Based Oracle Database Installation(This is good feature but I didn't much use of it )

Read-Only Oracle Home

Local Switch Home Command for Patching Databases(this is good feature where you can create multiple oracle homes and have one home to manage oracle databases and other home we can use for software provisioning this actually makes oracle binary cloning easier and less risk corruption of  running oracle home )

Thanks,

Satya

Ref : Oracle documentation