Database Installation - 12c

Environment//.bash_profile: export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=db12cstby.profad.com export ORACLE_UNQNAME=stby export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/stby export ORACLE_SID=stby export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib Step#1: Change Hostname [root@db11g ~]# vi /etc/sysconfig/network [root@db11g ~]# cat /etc/sysconfig/network NETWORKING=yes NETWORKING_IPV6=yes HOSTNAME=db12cstby.profad.com [root@db11g ~]# [root@db11g ~]# vi /etc/hostname [root@db11g ~]# cat /etc/hostname db12cstby.profad.com [root@db11g ~]# [root@db11g ~]# cat /etc/hosts [root@db11g ~]# vi /etc/hosts [root@db11g ~]# cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1               db11g.profad.com db11g localhost.localdomain localhost ::1             localhost6.localdomain6 localhost6 192.168.1.121 db12cstby.profad.com db12cstby To reflect the changes: [root@db11g ~]# service network restart [root@db11g ~]# /etc/init.d/network restart Step#2:  /etc/sysctl.conf Edit Kernel Parameters /etc/sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 sysctl -p #Apply changes Step#3:  /etc/security/limits.conf oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 Step#4:  RPM required for 12c installation rpm -qa | grep -i <rpm_name>  ==> Check rpm is installed or not. rpm -ivh <rpm_name> --nodeps ==> install rpm compat-libcap1 ==> install compat-libstdc++-33 compat-libstdc++-33.i686 ==> Install gcc gcc-c++ glibc glibc.i686 ==> Instal glibc-devel glibc-devel.i686 ==> Instal ksh libgcc libgcc.i686 ==> Instal libstdc++ libstdc++.i686 ==>Install libstdc++-devel libstdc++-devel.i686 ==> Install libaio libaio.i686 ==> Install libaio-devel libaio-devel.i686 ==> Install libXext libXext.i686 ==> Install libXtst libXtst.i686 ==> Install libX11 libX11.i686 ==> Install libXau libXau.i686 ==> Install libxcb ==> Install libxcb.i686 ==> Install libXi libXi.i686 ==> Install make sysstat unixODBC unixODBC-devel Step#5: Add Groups and Users groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper useradd -u 54321 -g oinstall -G dba,oper oracle passwd oracle Step#6: /etc/security/limits.d/90-nproc.conf # Change this  * soft nproc 1024 # Do this * - nproc 16384 Step#7: Set SELINUX [root@db12c01 ~]# cat /etc/sysconfig/selinux # This file controls the state of SELinux on the system. # SELINUX= can take one of these three values: #       enforcing - SELinux security policy is enforced. #       permissive - SELinux prints warnings instead of enforcing. #       disabled - SELinux is fully disabled. SELINUX=disabled # SELINUX=permissive # SELINUXTYPE= type of policy in use. Possible values are: #       targeted - Only targeted network daemons are protected. #       strict - Full SELinux protection. SELINUXTYPE=targeted If it is different then edit the file. SELINUX=disable SELINUXTYPE=targeted Step#8 : Stop Firewall # service iptables stop # chkconfig iptables off Step#9 : Create dierectories for oracle installation mkdir -p /u01/app/oracle/product/12.1.0.2/stby cd /u01 chown -R oracle:oinstall * chmod -R 775 /u01 Step#10 - disable access control, clients can connect from any host # xclock # xhost + Step#11 :  Oracle Setting or Set .bash_profile export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=db12cstby.profad.com export ORACLE_UNQNAME=stby export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/stby export ORACLE_SID=stby export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib Step#12 : Extract Installation Files [oracle@db12cstby ~]$ cd 12c_64bit [oracle@db12cstby 12c_64bit]$ ls linuxamd64_12102_database_1of2.zip  linuxamd64_12102_grid_1of2.zip linuxamd64_12102_database_2of2.zip  linuxamd64_12102_grid_2of2.zip unzip both files. unzip linuxamd64_12102_database_1of2.zip unzip linuxamd64_12102_database_2of2.zip Step#13 : Start the Oracle Universal Installer Step#13.1 : Execute runInstaller Then, after few second, you will get a page like this -

Uncheck the ticked box and click next.

After unchecked, Click Next>

Click:  Yes and then Next>

I am creating a new database that’s why I choosed for 'Create and configure a database' and then click Next>

Tick the Checkbox of Desktop Class and Click Next>

Here, "Global database name" is different. So, I edited that to stby.profad.com and then click Next>. Here I did not put the Administrative password so I got,

As I did not put the 'Administrative password', So, I got this "[INS-32001] No value has been given for the password field." message.

Click OK

Here, I put Administrative password as 'oracle' and click Next>

Click Yes and Then Click Next> Here is all the information about the database installation paths and settings Click on Install Here, Installation is going on -

Here, I got a check box.

Message is 'Run root.sh script as Root User and then Click OK.

Here, I am executing root.sh script as Root User -

Now, Go to 'Oracle Database 12c Release 1 Installer' again and Click OK.

Then, You will get this screen. Here Database Configuration Assistant is in progress.

After completing Database Configuration,

You will get -

All configurations are done. Now, Click OK. Click on Close. The Database installation is done successfully.

Now, Lets check the Database is running or not. Is it working fine??

Here, We can see that the database is running and opened successfully.