test server install log
A. system install
----------------------------------------------------------------------------------------
1.硬盘分区(disk partition):
DISK TOTAL :500G
1. DB SERVER:
/ 22G
swap 8G
/var 20G
/home 50G
/www 100G
/opt 100G
/db1 100G
/db2 100G
2. WEB SERVER:
/ 22G
swap 8G
/var 20G
/home 50G
/www 200G
/opt 50G
/backup 150G
2.user group
--------------------------------------
developer developer
oracle oinstall
----------------------------------------------------------------------------------------
B. oracle 11g install log.
Checking the Hardware Requirements
1.Checking the Hardware Requirements
[root@cntestdb ~]# grep MemTotal /proc/meminfo
MemTotal: 6208736 kB
[root@cntestdb ~]# grep "model name" /proc/cpuinfo
model name : Intel(R) Xeon(R) CPU E5504 @ 2.00GHz
model name : Intel(R) Xeon(R) CPU E5504 @ 2.00GHz
model name : Intel(R) Xeon(R) CPU E5504 @ 2.00GHz
model name : Intel(R) Xeon(R) CPU E5504 @ 2.00GHz
2.Memory Requirements
[root@cntestdb ~]# grep SwapTotal /proc/meminfo
SwapTotal: 12289684 kB
[root@cntestdb ~]# free
total used free shared buffers cached
Mem: 6208736 1038892 5169844 0 89772 739368
-/+ buffers/cache: 209752 5998984
Swap: 12289684 0 12289684
3.Disk Space Requirements
[root@cntestdb ~]# df -k /tmp
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda1 50403000 2815712 45026932 6% /
4.Automatic Memory Management
[root@cntestdb ~]# df -k /dev/shm/
Filesystem 1K-blocks Used Available Use% Mounted on
none 3104368 0 3104368 0% /dev/shm
5.Operating System Requirements
[root@cntestdb ~]# cat /proc/version
Linux version 2.6.9-55.ELsmp (brewbuilder@ls20-bc2-14.build.redhat.com) (gcc version 3.4.6 20060404 (Red Hat 3.4.6-3))
#1 SMP Fri Apr 20 17:03:35 EDT 2007
6.Kernel Requirements
[root@cntestdb ~]# uname -r
2.6.9-55.ELsmp
#
#
Checking the Software Requirements
7.Package Requirements
The following or later version of packages for Asianux 2, Oracle Enterprise Linux 4, and Red Hat Enterprise Linux 4 should be installed:
binutils-2.15.92.0.2-18
compat-libstdc++-33.2.3-47.3
elfutils-libelf-0.97-5
elfutils-libelf-devel-0.97-5
glibc-2.3.4-2.19
glibc-common-2.3.4-2.19
glibc-devel-2.3.4-2.19
glibc-headers-2.3.4-2.19
gcc-3.4.5-2
gcc-c++-3.4.5-2
libaio-devel-0.3.105-2
libaio-0.3.105-2
libgcc-3.4.5
libstdc++-3.4.5-2
libstdc++-devel-3.4.5-2
make-3.80-5
numactl-0.6.4.i386
sysstat-5.0.5
检查现有系统是否已安装这些包。包的版本号信息。
To determine whether the required packages are installed, enter commands similar to the following:
# rpm -q package_name
检查现有支持包,没有安装的进行安装。
[root@cntestdb ~]# rpm -q binutils
binutils-2.15.92.0.2-22
[root@cntestdb ~]# rpm -q compat-libstdc++
package compat-libstdc++ is not installed
[root@cntestdb cdrom]# cd RedHat/RPMS
[root@cntestdb RPMS]# ll compat-libstdc*
-rw-r--r-- 98 root root 180344 Feb 2 2007 compat-libstdc++-296-2.96-132.7.2.i386.rpm
-rw-r--r-- 98 root root 231823 Feb 2 2007 compat-libstdc++-33-3.2.3-47.3.i386.rpm
[root@cntestdb RPMS]# rpm -ivh compat [root@cntestdb ~]# rpm -q binutils
--hash: unknown option
[root@cntestdb RPMS]# rpm -ivh compat-libstdc++-296-2.96-132.7.2.i386.rpm
warning: compat-libstdc++-296-2.96-132.7.2.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
package compat-libstdc++-296-2.96-132.7.2 is already installed
[root@cntestdb RPMS]# rpm -ivh compat-libstdc++-33-3.2.3-47.3.i386.rpm
warning: compat-libstdc++-33-3.2.3-47.3.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
package compat-libstdc++-33-3.2.3-47.3 is already installed
[root@cntestdb ~]# rpm -q elfutils-libelf
elfutils-libelf-0.97.1-4
[root@cntestdb RPMS]# ll elfutils-libelf-devel*
-rw-r--r-- 59 root root 53149 Dec 16 2006 elfutils-libelf-devel-0.97.1-4.i386.rpm
[root@cntestdb RPMS]# rpm -ivh elfutils-libelf-devel-0.97.1-4.i386.rpm
warning: elfutils-libelf-devel-0.97.1-4.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
1:elfutils-libelf-devel ########################################### [100%]
[root@cntestdb ~]# rpm -q glibc
glibc-2.3.4-2.36
[root@cntestdb ~]# rpm -q glibc-common
glibc-common-2.3.4-2.36
[root@cntestdb ~]#
[root@cntestdb ~]# rpm -q glibc-devel
glibc-devel-2.3.4-2.36
[root@cntestdb ~]# rpm -q glibc-headers
glibc-headers-2.3.4-2.36
[root@cntestdb ~]#
[root@cntestdb ~]# rpm -q gcc
gcc-3.4.6-8
[root@cntestdb ~]# rpm -q gcc-c
package gcc-c is not installed
[root@cntestdb ~]# rpm -q gcc-c++
gcc-c++-3.4.6-8
[root@cntestdb ~]# rpm -q libaio-devel
package libaio-devel is not installed
[root@cntestdb RPMS]# rpm -ivh libaio-devel-0.3.105-2.i386.rpm
warning: libaio-devel-0.3.105-2.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
1:libaio-devel ########################################### [100%]
[root@cntestdb ~]# rpm -q libgcc
libgcc-3.4.6-8
[root@cntestdb ~]# rpm -q libstdc++
libstdc++-3.4.6-8
[root@cntestdb ~]# rpm -q libstdc++-devel
libstdc++-devel-3.4.6-8
[root@cntestdb ~]# rpm -q make
make-3.80-6.EL4
[root@cntestdb ~]# rpm -q numactl
numactl-0.6.4-1.39
[root@cntestdb ~]# rpm -q sysstat
package sysstat is not installed
[root@cntestdb RPMS]# rpm -ivh sysstat-5.0.5-14.rhel4.i386.rpm
warning: sysstat-5.0.5-14.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
1:sysstat ########################################### [100%]
add group,user.
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
[root@cntestdb ~]# id oracle
uid=501(oracle) gid=502(oinstall) groups=502(oinstall),501(dba)
(oracle password: 123456)
--------------------------------------------------------------------------------------------------------------------
二、ORACLE INSTALL paramaters setting:
1.add content to sysctl.conf
/etc/sysctl.conf
kernel.shmmax = 1073741824
kernel.shmmni = 4096
kernel.shmall = 8388608
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
2.add content to limits.conf
/etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
3.bash_profile content:
.bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0
export ORACLE_SID=cntestdb
export ORACLE_TERM=xterm
export LANG=AMERICAN_AMERICA.utf8
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/openwin/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/td/lib:/usr/ucblib:/usr/local/lib
export LD_LIBRARY_PATH
export LD_ASSUME_KERNEL=2.4.19
PATH=/bin:/sbin:/usr/bin:/usr/sbin:/etc:/opt/bin
PATH=$PATH:$ORACLE_HOME/bin
PATH=$PATH:/usr/java/jdk/bin:/usr/java/jdk/jre/bin:.
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export CLASSPATH
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
[root@cntestdb ~]# cd /opt/
[root@cntestdb opt]# ll
total 40
drwxrwxr-x 2 oracle dba 4096 Jul 20 15:46 download
drwxr-xr-x 3 root root 4096 Jul 9 19:13 drives
drwx------ 2 root root 16384 Jul 10 02:43 lost+found
drwxr-xr-x 2 oracle dba 4096 Jul 9 19:27 oracle
[root@cntestdb opt]# chown -R oracle:oinstall oracle
[root@cntestdb opt]# chmod 775 oracle
[root@cntestdb opt]# ll
total 40
drwxrwxr-x 2 oracle dba 4096 Jul 20 15:46 download
drwxr-xr-x 3 root root 4096 Jul 9 19:13 drives
drwx------ 2 root root 16384 Jul 10 02:43 lost+found
drwxrwxr-x 2 oracle oinstall 4096 Jul 9 19:27 oracle
[root@cntestdb opt]#
192.168.0.2 server send file to 192.168.0.4
ftp 192.168.0.4
(oracle/123456)
ftp: connect : No route to host
ftp>passive
ftp>send testinn0709.dmp
ftp>send testimente0709.dmp
ftp>send testchnmy0709.dmp
ftp>send test_all_0707.dmp
ftp 192.168.0.4
(oracle/123456)
ftp>linux_11gR2_database_1of2.zip
ftp>linux_11gR2_database_2of2.zip
[root@cntestdb oracle]#unzip linux_11gR2_database_1of2.zip
[root@cntestdb oracle]#unzip linux_11gR2_database_2of2.zip
[root@cntestdb oracle]# chown oracle:oinstall database
[root@cntestdb oracle]# chmod 775 database
#安装更高版本运行包
[root@cntestdb oracle]# rpm -Uvh glibc-2.3.4-2.41.i386.rpm --force --nodeps
warning: glibc-2.3.4-2.41.i386.rpm: V3 DSA signature: NOKEY, key ID 82fd17b2
Preparing... ########################################### [100%]
1:glibc ########################################### [100%]
Stopping sshd:[ OK ]
Starting sshd:[ OK ]
[root@cntestdb oracle]# rpm -Uvh glibc-common-2.3.4-2.41.i386.rpm --force --nodeps
warning: glibc-common-2.3.4-2.41.i386.rpm: V3 DSA signature: NOKEY, key ID 82fd17b2
Preparing... ########################################### [100%]
1:glibc-common ########################################### [100%]
[root@cntestdb oracle]# rpm -Uvh glibc-header-2.3.4-2.41.i386.rpm --force --nodeps
error: open of glibc-header-2.3.4-2.41.i386.rpm failed: No such file or directory
[root@cntestdb oracle]# rpm -Uvh glibc-headers-2.3.4-2.41.i386.rpm --force --nodeps
warning: glibc-headers-2.3.4-2.41.i386.rpm: V3 DSA signature: NOKEY, key ID 82fd17b2
Preparing... ########################################### [100%]
1:glibc-headers ########################################### [100%]
[root@cntestdb oracle]#