Monday, April 16, 2012

Configure for oracle Single Instance install with ASM on centos

Create VM:

Install system-config-services:

Setup Korn Shell:

Add Group dba.
Change login shell for user oracle to /bin/ksh.
Add group dba for user oracle.
Assign dba as primary  group for user oracle.

Setup network connection:

Add the following lines in /etc/hosts
# Public            rac1.localdomain rac1            rac2.localdomain rac2
#Private            rac1-priv.localdomain rac1-priv            rac2-priv.localdomain rac2-priv
#Virtual          rac1-vip.localdomain  rac1-vip          rac2-vip.localdomain  rac2-vip
# SCAN   rac-scan.localdomain rac-scan

Change the hostname
[root@localhost Desktop]# hostname rac1
[root@localhost Desktop]# cat /etc/sysconfig/network

Add or amend the following lines to the "/etc/sysctl.conf" file.
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax =1403885568
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500

Run the following command to change the current kernel parameters.
/sbin/sysctl -p
Add the following lines to the "/etc/security/limits.conf" file.
oracle               soft    nproc   2047
oracle               hard    nproc   16384
oracle               soft    nofile  1024
oracle               hard    nofile  65536

Add the following lines to the "/etc/pam.d/login" file, if it does not already exist.
session    required
Disable secure linux by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.
Alternatively, this alteration can be done using the GUI tool (System > Administration > Security Level and Firewall). Click on the SELinux tab and disable the feature.

To install Oracle 10g
Changed /etc/redhat-release to reflect: ‘Red Hat Enterprise Linux ES release 4 (Nahant Update 3)’
Installed libXp.s0.6: ‘yum install′ (as root of course).
The following packages are required for EM 11g
yum install compat-db-*
yum install compat-libstdc++-296*
yum install rng-utils-2*
yum install setarch-2*
yum install tunctl-1.5-3* (Redhat kernel-utils-2.4*)
The following packages are required for Grid 11g
yum install binutils-2.*
yum install compat-libstdc++-33*
yum install elfutils-libelf-0.*
yum install elfutils-libelf-devel-*
yum install gcc-4.*
yum install gcc-c++-4.*
yum install glibc-2.*
yum install glibc-common-2.*
yum install glibc-devel-2.*
yum install glibc-headers-2.*
yum install ksh-2*
yum install libaio-0.*
yum install libaio-devel-0.*
yum install libgcc-4.*
yum install libstdc++-4.*
yum install libstdc++-devel-4.*
yum install make-3.*
yum install sysstat-7.*
yum install unixODBC-2.*
yum install unixODBC-devel-2.*
yum install
yum install libaio-devel
yum install compat-libstdc++-33
yum install elfutils-libelf-devel
yum install gcc-c++

Enable Telnet:
Install telnet-server package and enable telnet in firewall options:
Enable xinetd and Telnet service:
Enable Telnet in firewall and restart xinetd service:

Enable Ftp:
Install vsftpd-2.2.2-6-el6 package and enable FTP in firewall options:
Enable and Start vsftpd:
Or Enable vsftp on start-up:chkconfig vsftpd on
Check SELinux setting: getsebool -a|grep ftp
Enable allow_ftpd_full_access and ftp_home_dir:

setsebool -P allow_ftpd_full_access 1
setsebool -P ftp_home_dir 1

Install Oracle Linux Kernal:

(NOT Required) wget
(NOT Required) wget
(NOT Required) rpm -Uvh kernel-firmware-2.6.32-131.0.15.el6.noarch.rpm
rpm -Uvh kernel-2.6.32-131.0.15.el6.x86_64.rpm
rpm -Uvh *uek*rpm
rpm -Uvh oracleasm-support-2.1.5-1.el6.x86_64.rpm

Shutdown OS and add 3 more disks, 20G each, SCSI 0:1,0:2,0:3:

Change the contents of .vmx:
disk.locking = "FALSE"
diskLib.dataCacheMaxSize = "0"
diskLib.dataCacheMaxReadAheadSize = "0"
diskLib.dataCacheMinReadAheadSize = "0"
diskLib.dataCachePageSize = "4096"
diskLib.maxUnsyncedWrites = "0"
scsi0.sharedBus = "VIRTUAL"
scsi0:1.writeThrough = "TRUE"
scsi0:2.writeThrough = "TRUE"
scsi0:3.writeThrough = "TRUE"
scsi0:1.redo = ""
scsi0:2.redo = ""
scsi0:3.redo = ""
scsi0:1.deviceType = "disk"
scsi0:2.deviceType = "disk"
scsi0:3.deviceType = "disk"

Create an ext4 filesystem:

[root@localhost Desktop]# fdisk /dev/sdb

[root@localhost Desktop]# mkfs.ext4 /dev/sdb1

[root@localhost ~]# mkdir /orasw
[root@localhost ~]# e2label /dev/sdb1 /orasw
[root@localhost ~]# vi /etc/fstab
[root@localhost Desktop]# cat /etc/fstab


[root@localhost Desktop]# df -h

[root@localhost Desktop]# chown -R oracle:dba /orasw
[root@localhost Desktop]# fdisk /dev/sdc

[root@localhost Desktop]# mkfs.ext4 /dev/sdc1
[root@localhost Desktop]# mkdir /u01
[root@localhost Desktop]# e2label /dev/sdc1 /u01

[root@localhost Desktop]# mount /u01
[root@localhost Desktop]# chown -R oracle:dba /u01

Create a Raw disk:

[root@localhost Desktop]# fdisk /dev/sdd
Configure ASMLib using the following command:
[root@localhost Desktop]# oracleasm configure -i

Load the kernel module using the following command:
Mark the disks as follows:
[root@localhost Desktop]# oracleasm createdisk DISK1 /dev/sdd1
Scan disks:
If you installed the updates, you need to download the newest ASMlib .
After the new driver is installed, you need to run “oraclsasm init”:

To check the Kernel version: uname -r
Change tmp folder:
mkdir /orasw/tmp
chmod 777 /orasw/tmp

Edit .profile, add the following contents:
export TMP=/orasw/tmp
export TMPDIR=/orasw/tmp
export ORACLE_BASE=/orasw/app/oracle
export ORA_CRS_HOME=/orasw/app/oracle/grid/11.2.0
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0

export ORACLE_SID=testdb
export ORACLE_TERM=xterm
export PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export EDITOR=vi
export PS1='[$ORACLE_SID] $PWD >'
. oraenv
if [ $USER = "oracle" ]; then
 if [ $SHELL = "/bin/ksh" ]; then
    ## see SR:
    ##ulimit -p 16384
    ulimit -u 16384
    ulimit -n 65536
    ulimit -u 16384 -n 65536
umask 022
Enable port 1521 in firewall:

Install Oracle Grid Software:
Disable IPv6(Optional):
Remove the following line in /etc/hosts:
::1             localhost6.localdomain6 localhost6

After message “Creating trace directory” press Enter for 3 or more times.


Modify /etc/oratab to make ASM instance started automatically:
If you want to use asmcmd or sqlplus on ASM instance, remember to export ORACLE_HOME to the asm HOME (/u01/app/oracle/grid/11.2.0)

Install Oracle Software:

Create database with dbca:


Stop and start database and services

1. Start:

2. Stop:

Srvctl stop diskgroup –g DATA

No comments:

Post a Comment