Installation Oracle Database 12c Release 1 (12.1) On CentOS-5.9 or On linux
Installation Oracle Database 12c
1.
we need 64 bit OS . Download this torrent and start downloading
http://mirror.centos.org/centos/5.9/isos/x86_64/CentOS-5.9-x86_64-bin-DVD.torrent
sha1sum's for these torrent files:765b578facd7da42704ccd37ef4e498d40376785 CentOS-5.9-i386-bin-1to8.torrent
3f750a2c780aff30c982358c8727ec4a540389ef CentOS-5.9-x86_64-bin-1to9.torrent
d2bd38a60ea03a4370bbbd91b4e909a48c89835b CentOS-5.9-i386-bin-DVD.torrent
11326c888ad0290f5ccc7d4e26c2540438f56c35 CentOS-5.9-x86_64-bin-DVD.torrent
Install Centos
CentOS-5.9-x86_64-bin-DVD
2. Download Oracle Software from E-delivery
edelivery: Oracle Database 12c Release 1 (12.1.0.1) Software (64-bit)
https://edelivery.oracle.com/
Download following file for oracle 12c database
file name
V38500-01_1of2
V38500-02_1of2
-rw-r--r-- 1 root root 1116527103 Jun 28 17:44 V38500-01_2of2.zip
-rw-r--r-- 1 root root 1361028723 Jun 28 17:48 V38500-01_1of2.zip
unzip both the file you will get this dir
In unix create following group and oracle user
groupadd dba
groupadd oinstall
groupadd asmdba
groupadd asmadmin
useradd -g oinstall -G dba,asmdba,asmadmin oracle
chown -R oracle:oinstall /home/oracle
chown -R oracle:oinstall database/
passwd oracle
su - oracle
Add the following lines at the end of the "/home/oracle/.bash_profile" file.
# Oracle Settings
export ORACLE_UNQNAME=vihaan
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1
export ORACLE_SID=vihaan
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
groupadd dba
groupadd oinstall
groupadd asmdba
groupadd asmadmin
useradd -g oinstall -G dba,asmdba,asmadmin oracle
create following dir
mkdir -p /u01/app/oracle/product/12.1.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
as root
umount tmpfs
vi /etc/fstab ---add this line in
mount -t tmpfs shmfs -o size=1300m /dev/shm
vi /etc/sysctl.conf
Add or amend the following lines in the "/etc/sysctl.conf" file.
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
/sbin/sysctl -p
Add the following lines to the "/etc/security/limits.conf" file.
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
Following 31 rpms/packages (or later version ) are required on Centos 5 / Oracle Linux 5 / Red Hat Enterprise Linux 5 for Oracle 12c 64 bit
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-58
glibc-2.5-58 (32 bit)
glibc-devel-2.5-58
glibc-devel-2.5-58 (32 bit)
ksh
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
libXext-1.0.1
libXext-1.0.1 (32 bit)
libXtst-1.0.1
libXtst-1.0.1 (32 bit)
libX11-1.0.3
libX11-1.0.3 (32 bit)
libXau-1.0.1
libXau-1.0.1 (32 bit)
libXi-1.0.1
libXi-1.0.1 (32 bit)
make-3.81
sysstat-7.0.2
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils-2.17.50.0.6 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXext libXtst libXtst libX11 libXau libXi make sysstat
binutils-2.17.50.0.6-20.el5_8.3 (x86_64)
compat-libstdc++-33-3.2.3-61 (x86_64)
compat-libstdc++-33-3.2.3-61 (i386)
gcc-4.1.2-54.el5 (x86_64)
gcc-c++-4.1.2-54.el5 (x86_64)
glibc-2.5-107.el5_9.5 (x86_64)
glibc-2.5-107.el5_9.5 (i686)
glibc-devel-2.5-107.el5_9.5 (x86_64)
glibc-devel-2.5-107.el5_9.5 (i386)
ksh-20100621-12.el5 (x86_64)
libaio-0.3.106-5 (x86_64)
libaio-0.3.106-5 (i386)
libaio-devel-0.3.106-5 (i386)
libaio-devel-0.3.106-5 (x86_64)
libgcc-4.1.2-54.el5 (x86_64)
libgcc-4.1.2-54.el5 (i386)
libstdc++-4.1.2-54.el5 (x86_64)
libstdc++-4.1.2-54.el5 (i386)
libstdc++-devel-4.1.2-54.el5 (x86_64)
libstdc++-devel-4.1.2-54.el5 (i386)
libXext-1.0.1-2.1 (x86_64)
libXext-1.0.1-2.1 (i386)
libXtst-1.0.1-3.1 (x86_64)
libXtst-1.0.1-3.1 (i386)
libXtst-1.0.1-3.1 (x86_64)
libXtst-1.0.1-3.1 (i386)
libX11-1.0.3-11.el5_7.1 (x86_64)
libX11-1.0.3-11.el5_7.1 (i386)
libXau-1.0.1-3.1 (x86_64)
libXau-1.0.1-3.1 (i386)
libXi-1.0.1-4.el5_4 (x86_64)
libXi-1.0.1-4.el5_4 (i386)
make-3.81-3.el5 (x86_64)
sysstat-7.0.2-12.el5 (x86_64)
[root@localhost ~]# yum -y install compat-libstdc++-33
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: mirror.bytemark.co.uk
* extras: mirror.sov.uk.goscomb.net
* updates: mirror.sov.uk.goscomb.net
Setting up Install Process
Package compat-libstdc++-33-3.2.3-61.x86_64 already installed and latest version
Package compat-libstdc++-33-3.2.3-61.i386 already installed and latest version
Nothing to do
or
rpm -q binutils-2.17.50.0.6 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXext libXtst libXtst libX11 libXau libXi make sysstat --qf '%{name}.%{arch}\n'|sort
rpm -q binutils-2.17.50.0.6 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXext libXtst libXtst libX11 libXau libXi make sysstat --qf '%{name}.%{arch}\n'|sort
binutils.x86_64
compat-libstdc++-33.i386
compat-libstdc++-33.x86_64
gcc-c++.x86_64
gcc.x86_64
glibc-devel.i386
glibc-devel.x86_64
glibc.i686
glibc.x86_64
ksh.x86_64
libaio-devel.i386
libaio-devel.x86_64
libaio.i386
libaio.x86_64
libgcc.i386
libgcc.x86_64
libstdc++-devel.i386
libstdc++-devel.x86_64
libstdc++.i386
libstdc++.x86_64
libX11.i386
libX11.x86_64
libXau.i386
libXau.x86_64
libXext.i386
libXext.x86_64
libXi.i386
libXi.x86_64
libXtst.i386
libXtst.i386
libXtst.x86_64
libXtst.x86_64
make.x86_64
sysstat.x86_64
Install following rpm
yum -y install binutils-2.17.50.0.6 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXext libXtst libXtst libX11 libXau libXi make sysstat
or
yum -y install binutils-2*
yum -y install compat-libcap1-1.*
yum -y install compat-libstdc++-33-*
yum -y install compat-libstdc*
yum -y install gcc-4.*
yum -y install gcc-c++-4.*
yum -y install glibc-2.12*
yum -y install glibc-2.*
yum -y install glibc-devel-2.*
yum -y install ksh
yum -y install libgcc-4.*
yum -y install libstdc++-4.*
yum -y install libstdc++-devel-4.*
yum -y install libaio-0.*
yum -y install libaio-0.3.*
yum -y install libaio-devel-0.3.*
yum -y install libXext-1.*
yum -y install libXtst-1.*
yum -y install libX11-1.*
yum -y install libXau-1.*
yum -y install libxcb-1.*
yum -y install libXi-1.*
yum -y install make-3.*
yum -y install sysstat*
===================================
editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.
SELINUX=permissive
su - oracle
as a oracle
cd database
./runInstaller
[root@localhost tmp]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@localhost tmp]# /u01/app/oracle/product/12.1.0/db_1/root.sh
Performing root user operation for Oracle 12c
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/12.1.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
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.
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun Jun 30 14:52:23 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> def
DEFINE _DATE = "30-JUN-13" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "vihaan" (CHAR)
DEFINE _USER = "SYS" (CHAR)
DEFINE _PRIVILEGE = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1201000100" (CHAR)
DEFINE _EDITOR = "ed" (CHAR)
DEFINE _O_VERSION = "Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options" (CHAR)
DEFINE _O_RELEASE = "1201000100" (CHAR)
SQL> select INSTANCE_NAME,VERSION from v$instance ;
INSTANCE_NAME VERSION
---------------- -----------------
vihaan 12.1.0.1.0
