Oracle Installation Notes

Oracle Installation Notes

Only modified time, input: Date-s 14:15:00

Also modify the date time, note to add double quotation marks, the date and time there is a space, enter: Date-s "2015-08-03 14:15:00"

After modifying, remember to enter: Clock-w

Root User Login

1, swap area check:

grep memtotal/proc/meminfo

grep swaptotal/proc/meminfo

2, disk space situation

[Email protected] app]# df-h

Note that the-bash-3.2$ prompt when switching user su-oracle is due to the problem of commenting out the previous if statement of the Oracle user's. Bash_profile.

System parameter Modification

1, modifying the kernel

Added to/etc/sysctl.conf.

# for Oracle Install

Fs.file-max = 6553600

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 1024 65000

Net.core.rmem_default = 4194304

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 262144

Configuration takes effect:

[Email protected] ~]# sysctl-p

2. Modify User Resource Limits

/etc/security/limits.conf

#Oracle Install ADD

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

3, Login restrictions

/etc/pam.d/login

Session required/lib/security/pam_limits.so

4,

Vim/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

Install package

1, installation package check

Rpm-q gcc make binutils openmotif setarch compat-db compat-gcc \

> compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel

2, installation

RPM-UVH compat-db-4.2.52-5.1.i386.rpm

RPM-UVH compat-db-4.2.52-5.1.x86_64.rpm

RPM-UVH libaio-0.3.106-5.i386.rpm

RPM-UVH libaio-0.3.106-5.x86_64.rpm

RPM-UVH libaio-devel-0.3.106-5.i386.rpm

RPM-UVH libaio-devel-0.3.106-5.x86_64.rpm

RPM-UVH compat-libstdc++-33-3.2.3-61.i386.rpm

RPM-UVH compat-libstdc++-33-3.2.3-61.x86_64.rpm

RPM-UVH glibc-kernheaders-2.4-9.1.98.el.i386.rpm

RPM-UVH glibc-headers-2.5-49.x86_64.rpm

RPM-UVH glibc-devel-2.5-49.i386.rpm

RPM-UVH glibc-devel-2.5-49.x86_64.rpm

RPM-UVH compat-gcc-34-3.4.6-4.x86_64.rpm

RPM-UVH compat-gcc-34-c++-3.4.6-4.x86_64.rpm

RPM-UVH libxp-1.0.0-8.1.el5.i386.rpm

RPM-UVH libxp-1.0.0-8.1.el5.x86_64.rpm

RPM-UVH openmotif-2.3.1-2.el5_4.1.i386.rpm

RPM-UVH openmotif-2.3.1-2.el5_4.1.x86_64.rpm

RPM-UVH gcc-4.1.2-48.el5.x86_64.rpm

RPM-UVH gcc-c++-4.1.2-48.el5.x86_64.rpm

RPM-UVH glibc-2.5-49.i686.rpm

RPM-UVH glibc-2.5-49.x86_64.rpm

RPM-UVH libgomp-4.4.0-6.el5.i386.rpm

RPM-UVH libgomp-4.4.0-6.el5.x86_64.rpm

RPM-UVH binutils-2.17.50.0.6-14.el5.x86_64.rpm

RPM-UVH fontconfig-devel-2.4.1-7.el5.i386.rpm

RPM-UVH fontconfig-devel-2.4.1-7.el5.x86_64.rpm

RPM-UVH freetype-devel-2.2.1-21.el5_3.i386.rpm

RPM-UVH freetype-devel-2.2.1-21.el5_3.x86_64.rpm

RPM-UVH kernel-headers-2.6.18-194.el5.x86_64.rpm

RPM-UVH libstdc++44-devel-4.4.0-6.el5.x86_64.rpm

RPM-UVH libxmu-1.0.2-5.i386.rpm

RPM-UVH make-3.81-3.el5.x86_64.rpm

RPM-UVH setarch-2.0-1.1.x86_64.rpm

RPM-UVH sysstat-7.0.2-3.el5.x86_64.rpm

RPM-UVH zlib-devel-1.2.3-3.x86_64.rpm

Add user Name

/usr/sbin/groupadd Oinstall

/usr/sbin/groupadd DBA

/usr/sbin/useradd-m-G oinstall-g dba Oracle

ID Oracle

passwd Oracle

modifying variables

Modify the. bash_profile file: This file is hidden in/home/oracle/.base_profile

Add the following content:

#. Bash_profile

# Get the aliases and functions

If [-f ~/.BASHRC]; Then

. ~/.bashrc

Fi

# User specific environment and startup programs

Path= $PATH: $HOME/bin

Export PATH

# for Oracle Install

Export Oracle_base=/home/oracle

Export Oracle_home= $ORACLE _base/product/10g

Export path= $PATH: $ORACLE _home/bin: $ORACLE _home/apache/apache/bin

Export Oracle_owner=oracle

Export oracle_sid=mmkt11

Export nls_lang= "American_america. We8iso8859p1 "

After the modification, do the following to make the settings effective:

[Email protected] ~]# Source/home/oracle/.bash_profile

Installing the Database

1, new directory

[Email protected]/]# mkdir-p/u01

2, assigning permissions to the database installation directory

[Email protected]/]# chown-r oracle:oinstall/u01

3. Switch Oracle into the graphical interface to enter the installation directory to run

./instsllrun

Create DATABASE and Configuration

1, using Oracle user, go to the bin directory under Oracle software directory, run DBCA

2, using Oracle user, go to the bin directory under Oracle software directory, run NETCA

Oracle Installation Notes