DB Installation(Prerequisites)-1

                                                                    


                                             Database Installation(12.1.01.)

OS Pre requisites before Installing DB:

Checking Operating system:

Login as root user give the command lsb_release a

Gives the total information about the operation release

To find out hostname

Login as root user  give the command as :”hostname” it display host name of the node/server/system

ex:

Setting hostname and IP address in the vi /etc/hosts file

Ex:

Adding groups

Login in as root user give the following command to create groups

Groupadd space groupname

Ex:#groupadd oinstall

            #groupadd dba

#groupadd oclsascr

Creates 3 groups with their respective names

Adding Opapps User

Login as root user

The following command creates a user name “opapps” having primary group as oinstall,secondary groups as oclsascr and dba with home directory as /home/opapps as a default location.

#Useradd  -m –g oinstall –G oclsascr,dba opapps

-m create home directory

-g primary group

-G secondary group(s)

 

Setting Password for Opapps User

Passwd username

Ex:passwd opapps

Changes the password for opapps

Newpassword:xxxxxx

Re type new  password:xxxxxx

Test for “C “compiler type

# ls -l `which cc`

Test that the make command is accessible

ls -l `which make`

not single code use above tab button.

I have created a mount point called /u01

In that mount point(/u01) I have created  a directory called downloaded_softwares .

Under downloaded softwares I have created following sub directories

1.DB12C

2.Clinical

Copy and paste respective softwares which is downloaded from oracle E-delievery to their respective directories.

For DB12C path “/u01/ downloaded_softwares/DB12C/ V38500-01_1of2.zip V38500-01_2of2.zip”

For Clinical path “/u01/downloaded_softwares/clinical/ V47005-01.zip”.

Unzip respective softwares .

For database you will get database folder size of 2.6GB

Complete path is “/u01/ downloaded_softwares/DB12C/database”

For clinical you will get

application_server.zip

server_code_linux-x86-64.zip

server_code_windows-64.zip

server_code_solaris_sparc.zip

server_code_hpux-ia64.zip

my server is Linux-x86-64 that is why again I have unzipped  server_code_linux-x86-64.zip then I will get

Disk1

Setting password for Oracle user

Installing prerequistes for 12CR1 database

#yum install oracle-rdbms-server12c-preinstall –y

Y with out asking installation,it automatically install prerequisite packages

 

Check whether  following  values changed in /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

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

*   soft   nofile    1024

*   hard   nofile    65536

*   soft   nproc    16384

*   hard   nproc    16384

*   soft   stack    10240

*   hard   stack    32768

 Creating directory structure for installation
DB

 

Changing owner from root to oracle

chown -R oracle:oinstall /u01

Changing permission to the mount point “/u01”

chmod -R 775 /u01

Check the following rpm which is installed or not.

You need to install latest following  rpm

yum install binutils -y

yum install compat-libstdc++-33 -y

yum install compat-libstdc++-33.i686 -y

yum install gcc -y

yum install gcc-c++ -y

yum install glibc -y

yum install glibc.i686 -y

yum install glibc-devel -y

yum install glibc-devel.i686 -y

yum install ksh -y

yum install libgcc -y

yum install libgcc.i686 -y

yum install libstdc++ -y

yum install libstdc++.i686 -y

yum install libstdc++-devel -y

yum install libstdc++-devel.i686 -y

yum install libaio -y

yum install libaio.i686 -y

yum install libaio-devel -y

yum install libaio-devel.i686 -y

yum install libXext -y

yum install libXext.i686 -y

yum install libXtst -y

yum install libXtst.i686 -y

yum install libX11 -y

yum install libX11.i686 -y

yum install libXau -y

yum install libXau.i686 -y

yum install libxcb -y

yum install libxcb.i686 -y

yum install libXi -y

yum install libXi.i686 -y

yum install make -y

yum install sysstat -y

yum install unixODBC -y

yum install unixODBC-devel -y

yum install zlib-devel -y

yum install zlib-devel.i686 -y

for yum install compat-libstdc++-33.i686 -y

 

Note:If not Installed install about rpm's using yum(Yum install  <packagename>)

simply copy and paste above rpms in your system terminal ,if it is installed shows already installed otherwise it will install .

 For my system X11 is not installed to enable GUI.

Therefore when I type x clock

Iam getting xclock command not found

#yum install xorg-x11-apps.x86_64

 

After installing package now Iam able to get