Tuesday 30 July 2013

oracle database 12c pre installation steps

-Unzip the files.

#unzip linuxamd64_12c_database_1of2.zip
#unzip linuxamd64_12c_database_2of2.zip


-Add or amend the following lines in the "/etc/sysctl.conf" file.

#vi /etc/sysctl.conf

fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
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 = 1048576



-Run the following command to change the current kernel parameters.

#/sbin/sysctl -p


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

#vi /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

-Reate the new groups and users.

#groupadd -g 54321 oinstall
#groupadd -g 54322 dba
#groupadd -g 54324 backupdbadd

#useradd -u 500 -g oinstall -G dba oracle

-set password for oracle

#passwd oracle

-Set secure Linux to permissive by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.

#vi /etc/selinux/config

SELINUX=permissive or disable

-Once the change is complete, restart the server


-If you have the Linux firewall enabled, you will need to disable or configure it, as shown here or here. To disable it, do the following.

# service iptables stop
# chkconfig iptables off

#systemctl status firewalld
#service firewalld stop
#systemctl disable firewalld

- create directories

#mkdir -p /u01/app/oracle/product/12.1.0/db_1
#chown -R oracle:oinstall /u01
#chmod -R 775 /u01

-login as oracle user and start installaion


$./runInstaller


click here for Explanation of each kernal parameter

For database creation using DBCA click here

very good examples for crontab


No comments:

Post a Comment