Oracle Lesson #5: Setup Linux Environment

Contents:

1) Logging In to the System as root
2) Checking the Hardware Requirements
3) Checking the Software Requirements
4) Checking the Network Setup
5) Creating Required Operating System Groups and Users
6) Configuring Kernel Parameters
7) Identifying Required Software Directories
8) Identifying or Creating an Oracle Base Directory
9) Choosing a Storage Option for Oracle Database and Recovery Files
10) Creating Directories for Oracle Database or Recovery Files
11) Stopping Existing Oracle Processes
12) Configuring the oracle User's Environment

---------------------------------------------------------------------- 1) Logging In to the System as root ---------------------------------------------------------------------- su - root mount /u01/write/disk1.10201_database_linux32.iso /mnt/disk1 -o loop -- /mnt/disk1/doc/index.htm ---------------------------------------------------------------------- 2) Checking the Hardware Requirements ---------------------------------------------------------------------- grep MemTotal /proc/meminfo grep SwapTotal /proc/meminfo free df -kh /tmp df -kh grep "model name" /proc/cpuinfo ---------------------------------------------------------------------- 3) Checking the Software Requirements ---------------------------------------------------------------------- cat /etc/issue uname -r # The following packages (or later versions) must be installed: # Red Hat Enterprise Linux 3.0 and 4.0, and Asianux 1.0 and 2.0: # make-3.79.1 # gcc-3.2.3-34 # glibc-2.3.2-95.20 # compat-db-4.0.14-5 # compat-gcc-7.3-2.96.128 # compat-gcc-c++-7.3-2.96.128 # compat-libstdc++-7.3-2.96.128 # compat-libstdc++-devel-7.3-2.96.128 # openmotif21-2.1.30-8 # setarch-1.3-1 rpm -q make gcc glibc openmotif21 setarch compat-db rpm -qa | grep compat-gcc rpm -qa | grep compat-libstdc ---------------------------------------------------------------------- 4) Checking the Network Setup ---------------------------------------------------------------------- cat /etc/nsswitch.conf | grep hosts # hosts: files dns hostname # database2.ias.com domainname # (none) cat /etc/hosts | grep `eval hostname` # 172.16.1.55 database2.ias.com database2 ORACLE_HOSTNAME=database2.ias.com; export ORACLE_HOSTNAME ---------------------------------------------------------------------- 5) Creating Required Operating System Groups and Users ---------------------------------------------------------------------- more /etc/oraInst.loc /usr/sbin/groupadd oinstall /usr/sbin/groupadd dba /usr/sbin/groupadd oper id oracle /usr/sbin/useradd -g oinstall -G dba,oper oracle passwd oracle id nobody ---------------------------------------------------------------------- 6) Configuring Kernel Parameters ---------------------------------------------------------------------- /sbin/sysctl -a | grep sem /sbin/sysctl -a | grep shm /sbin/sysctl -a | grep file-max /sbin/sysctl -a | grep ip_local_port_range /sbin/sysctl -a | grep rmem_default /sbin/sysctl -a | grep rmem_max /sbin/sysctl -a | grep wmem_default /sbin/sysctl -a | grep wmem_max vi /etc/sysctl.conf kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 102790 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default = 262144 net.core.rmem_max = 262144 net.core.wmem_default = 262144 net.core.wmem_max = 262144 vi /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 vi /etc/pam.d/login session required /lib/security/pam_limits.so vi /etc/profile if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi vi /etc/csh.login if ( $USER == "oracle" ) then limit maxproc 16384 limit descriptors 65536 endif ---------------------------------------------------------------------- 7) Identifying Required Software Directories ---------------------------------------------------------------------- df -h ---------------------------------------------------------------------- 8) Identifying or Creating an Oracle Base Directory ---------------------------------------------------------------------- more /etc/oraInst.loc more /etc/oratab mkdir -p /u01/app/oracle chown -R oracle:oinstall /u01/app/oracle chmod -R 775 /u01/app/oracle ---------------------------------------------------------------------- 9) Choosing a Storage Option for Oracle Database and Recovery Files ---------------------------------------------------------------------- mkdir /u01/oradata chown oracle:oinstall /u01/oradata chmod 775 /u01/oradata ---------------------------------------------------------------------- 10) Creating Directories for Oracle Database or Recovery Files ---------------------------------------------------------------------- mkdir /u01/flash_recovery_area chown oracle:oinstall /u01/flash_recovery_area chmod 775 /u01/flash_recovery_area ---------------------------------------------------------------------- 11) Stopping Existing Oracle Processes ---------------------------------------------------------------------- su - oracle ps -ef | grep tnslsnr lsnrctl status ---------------------------------------------------------------------- 12) Configuring the oracle User's Environment ---------------------------------------------------------------------- cd ~ vi .bash_profile umask 022 # ORACLE_BASE=/u01/app/oracle # export ORACLE_BASE # ORACLE_HOME=${ORACLE_BASE}/product/10.2.0 # export ORACLE_HOME # ORACLE_SID=iasdb # export ORACLE_SID ---------------------------------------------------------------------- . .bash_profile export ORACLE_BASE=/u01/app/oracle export ORACLE_SID=iasdb unset ORACLE_HOME unset TNS_ADMIN /mnt/disk1/runInstaller

%%