Oracle Database 12c R1 - Description & Command - Cloud Network

Networking | Support | Tricks | Troubleshoot | Tips

Buymecoffe

Buy Me A Coffee

Thursday, February 12, 2015

Oracle Database 12c R1 - Description & Command


Hello Everyone,

In this tutorial,

Step by Step Process on How to Install Oracle Database 12c R1 Enterprise Edition on Ubuntu 14.10 – 64Bit

You can also install in Ubuntu 14.04. Debian, Linux mint .

Note :- completed Installation time take around 1hr or 2hr above. Depends on Hardware configuration of system

AUCTION
Ubuntu-like Systems are Not in the List of Oracle 12c Database Supported. So you should Be Careful and Use It At Most for Development and Not As Production Database Server!

Download Oracle 12c R1 Database from Oracle Website for Linux :-
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html?ssSourceSiteId=ocomen

Hardware Requirements
1. For large-scale installation we need to use multicore processors with High availability.
2. Recommended minimum RAM needed for Oracle 12c is 2GB or more.
3. Swap must be enabled double the size of RAM.
4. Disk space must be more than 10GB, its depends on edition which are we going to choose for installing.
5. /tmp directory must have free space more than 1GB for error free installation.
6. Supported Linux operating systems are Linux Mint, Kubuntu, Debian.
7. Both x86_64 and i686 packages are required for installation.
8. Screen resolution must be more than 1024×768 resolution

Logging into ubuntu and Open Terminal
step1:- sudo apt-get update
step2:- sudo apt-get dist-upgrade
Restart the System (sudo reboot or sudo init 6)

step3:- sudo nano /etc/hosts  --- (To Edit Hosts File)
Eg :- <IP-address>  <fully-qualified-machine-name>  <machine-name>
        192.168.1.104   cloudnetwork.localdomain cloudnetwork

$uname –n  -- > to check machine name
$dnsdomainname -- > to check the localdomain
$arch -- > to check 32bit or 64bit of OS

Installation Dependencies
step4:-  sudo apt-get -y install alien binutils build-essential cpp-4.4
debhelper g++-4.4 gawk gcc-4.4 gcc-4.4-base gettext html2text lib32z1
lib32ncurses5 lib32bz2-1.0 intltool-debian ksh lib32bz2-dev lib32z1-dev
libaio-dev libaio1 libbeecrypt7 libc6 libc6-dev libc6-dev-i386
libelf-dev libelf1 libltdl-dev libltdl7 libmotif4 libodbcinstq4-1
libodbcinstq4-1:i386 libqt4-core libqt4-gui libsqlite3-0 libstdc++5
libstdc++6 libstdc++6-4.4-dev lsb lsb-core lsb-cxx lsb-desktop
lsb-graphics lsb-qt4 make odbcinst pax po-debconf rpm rpm-common sysstat
unixodbc unixodbc-dev unzip

Create New User and Groups
step5:- sudo addgroup oinstall
step6:- sudo addgroup dba
step7:- sudo addgroup nobody
step8:- sudo usermod -g nobody nobody
step9:- sudo useradd  -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle
step10:- sudo mkdir /home/oracle
step11:- sudo chown -R oracle:dba /home/oracle

Create and Prepare location to install the oracle binaries
step12:- sudo mkdir -p /u01/app/oracle
step13:- sudo mkdir -p /u01/binaries
step14:- sudo chown -R oracle:dba /u01
step15:- sudo passwd oracle

some softlinks to start the Installation
step16 :-  echo 'Red Hat Linux release 6' | sudo tee -a  /etc/redhat-release
sudo mkdir /usr/lib64
sudo ln -s /etc /etc/rc.d
sudo ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /lib64/
sudo ln -s /usr/bin/awk /bin/awk
sudo ln -s /usr/bin/basename /bin/basename
sudo ln -s /usr/bin/rpm /bin/rpm
sudo ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/
sudo ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/
sudo ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /lib64/
sudo ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/

Run following command to shell configuration for oracle user
step17 :- sudo cp /etc/security/limits.conf /etc/security/limits.conf.original
echo "#Oracle 12C shell limits:" | sudo tee -a /etc/security/limits.conf
echo "oracle soft nproc 2048" | sudo tee -a /etc/security/limits.conf
echo "oracle hard nproc 16384"| sudo tee -a /etc/security/limits.conf
echo "oracle soft nofile 1024" | sudo tee -a /etc/security/limits.conf
echo "oracle hard nofile 65536" | sudo tee -a /etc/security/limits.conf

Run following command to change the kernel parameters
step18 :- echo "#" | sudo tee -a /etc/sysctl.conf
echo "# Oracle 12C entries" | sudo tee -a /etc/sysctl.conf
echo "fs.aio-max-nr=1048576" | sudo tee -a /etc/sysctl.conf
echo "fs.file-max=6815744" | sudo tee -a /etc/sysctl.conf
echo "kernel.shmall=2097152" | sudo tee -a /etc/sysctl.conf
echo "kernel.shmmni=4096" | sudo tee -a /etc/sysctl.conf
echo "kernel.sem=250 32000 100 128" | sudo tee -a /etc/sysctl.conf
echo "net.ipv4.ip_local_port_range=9000 65500" | sudo tee -a /etc/sysctl.conf
echo "net.core.rmem_default=262144" | sudo tee -a /etc/sysctl.conf
echo "net.core.rmem_max=4194304" | sudo tee -a /etc/sysctl.conf
echo "net.core.wmem_default=262144" | sudo tee -a /etc/sysctl.conf
echo "net.core.wmem_max=1048586" | sudo tee -a /etc/sysctl.conf
echo "kernel.shmmax=1073741824" | sudo tee -a /etc/sysctl.conf

Load new kernel parameters
Step19:- sudo sysctl -p

We need to do changes in start-up script -- Root
step20:-  mkdir /etc/rc.d
for i in 0 1 2 3 4 5 6 S
do sudo ln -s /etc/rc$i.d /etc/rc.d/rc$i.d
done

I have downloaded both the zip file and move to /u01/binaries. let check
step21:- cd /u01/binaries/
step22:- ls

Extract both the zip to start the installation. To unzip run,
step23:- unzip linuxamd64_12c_database_1of2.zip
step24:- unzip linuxamd64_12c_database_2of2.zip

You will see database folder after extracting the binaries
step25:- ls

Before doing the installation we need to give proper permission to the extracted file, to do the same run following command
step26:- chown -Rf oracle:dba /u01/binaries
or
chown -Rf oracle:oinstall /opt/oracle


Start installation using following command
step27:-   /u01/binaries/database
step28:-  ./runInstaller -ignoreSysPrereqs


For Any Clarification Please Comment Below

Thanking You
Hope U Like it........