Oracle Database Experts

Kernel Parameters in /etc/sysctl.conf< /STRONG >

kernel.shmall = 3279547
kernel.shmmax = 2147483648
kernel.shmmni = 4096
#semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 256 32000 100 142
fs.file-max = 327679
net.ipv4.ip_local_port_range = 1024 65000
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65535
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

To reload the kernel:
sysctl -p

RPM Requirements

glibc-2.3.4-2.9
make-3.79
binutils-2.15.92.0.2-13
gcc-3.4.3-22.1
libaio-0.3.96
glibgc-common-2.3.4-2.9
setarch-1.6-1
pdksh-5.2.14-30
openmotif21-2.1.30-11
sysstat-5.0.5-1
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-22.1
libstdc++devel-3.4.3-22.1
compat-libstdc++-296-2.96-
compat-db-4.1.25-9
control-center-2.8.0-12
xscreensaver-4.18-5.rhel4.2

Posted by Charles Kim @ DBAExpert.com

The rpm that is required to install uucp in Redhat is sharutils:

root# rpm -ihv sharutils-4.2.1-22.2.x86_64.rpm
Preparing… ########################################### [100%]
1:sharutils ########################################### [100%]

Once you have uuencode installed and configured, you can attach file using the example code below:

uuencode rman_backup.ksh rman_backup.ksh |mailx -s “Attached rman backup shell script” oradba@dbaexpert.com

Posted by: Charles Kim @ DBAExpert.com

up2date –arch=i386

or

up2date –arch=x86_64 libaio

[root@prdb1 ~]# rpm -qa –queryformat “%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n” | grep libaio

libaio-0.3.105.2 (i386)

libaio-0.3.105.2 (x86_64)

# more /etc/sysctl.conf

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 1048576

net.core.rmem_max = 1048576

net.core.wmem_default = 262144

net.core.wmem_max = 262144

service vsftpd start

On the server: 

First, modify /etc/exports

         #
         # /etc/exports for DBAExpert.com
         #
         /apps/oracle/11g rac101.dbaexpert.com(rw) \
                          rac11.dbaexpert.com

Start the NFS Server processes

service nfs start

On the client, mount the share:

First, create the directory for 11g (as in this example).  Next, mount the file system:

mount rac1:/apps/oracle/11g /11g

rpm -qa –queryformat “%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n”
List of RPMs for 64-bit RAC implementation

Oracle was added to the sudoers file so that most of the maintenance for CRS can be done as oracle.

[root@rac1.dbaexpert.com ~]# cat /etc/sudoers

# sudoers file.

#

# This file MUST be edited with the ‘visudo’ command as root.

#

# See the sudoers man page for the details on how to write a sudoers file.

#

# Host alias specification

# User alias specification

User_Alias DBAS = oracle

# Cmnd alias specification

Cmnd_Alias SUDO_ROOT = /etc/init.d/init.crs, \

/usr/bin/passwd oracle, /u01/app/oracle/product/CRS/bin/, \

/bin/cat /etc/sudoers, /sbin/init q, \

/usr/bin/vim /etc/inittab, \

/u01/app/oracle/product/CRS/root.sh, \

/u01/app/oracle/product/10.2.0/DB/root.sh, \

/u01/app/oracle/product/10.2.0/COMP/root.sh, \

/u01/app/oracle/oraInventory/orainstRoot.sh, \

/u01/app/oracle/product/CRS/install/root102.sh

# Defaults specification

# User privilege specification

root ALL=(ALL) ALL

# Uncomment to allow people in group wheel to run all commands

# %wheel ALL=(ALL) ALL

# Same thing without a password

# %wheel ALL=(ALL) NOPASSWD: ALL

# Samples

# %users ALL=/sbin/mount /cdrom,/sbin/umount /cdrom

# %users localhost=/sbin/shutdown -h now

DBAS ALL = SUDO_ROOT