1.Check package
OS AS4 update 4
rpm 版本必须高于下面的版本,使用rpm –qa | grep 查询
compat-db-4.1.25-9
compat-gcc-32-3.2.3-47.3
compat-gcc-32-c++-3.2.3-47.3
compat-libgcc-296-2.96-132.7.2
compat-libstdc++-296-2.96-132.7.2
compat-libstdc++-33-3.2.3-47.3
gcc-3.4.3-9.EL4
gcc-c++-3.4.3-9.EL4
gnome-libs-1.4.1.2.90-44
gnome-libs-devel-1.4.1.2.90-44
libaio-devel-0.3.102-1
libaio-0.3.102-1
make-3.80-5
openmotif21-2.1.30-11
xorg-x11-deprecated-libs-devel-6.8.1-23.EL
xorg-x11-deprecated-libs-6.8.1-23.EL
打oracle patch,否则图形界面可能不出来
p4198954_21_linux.zip 在运行 runInstaller 之前打. Include compat-oracle-rhel4-1.0-3
compat-libcwait-2.0-1 rpm package.
对应的package name
rpm -ivh sysstat-5.0.5-1.i386.rpm disk4
rpm -ivh openmotif21-2.1.30-11.RHEL4.2.i386.rpm disk3
rpm -ivh libaio-0.3.102-1.i386.rpm disk3
rpm -ivh libaio-devel-0.3.102-1.i386.rpm disk3
rpm -ivh freetype-devel-2.1.9-1.i386.rpm disk3
rpm -ivh fontconfig-devel-2.2.3-7.i386.rpm disk3
rpm -ivh xorg-x11-devel-6.8.1-23.EL.i386.rpm disk3
rpm -ivh xorg-x11-deprecated-libs-devel-6.8.1-23.EL.i386.rpm disk3
rpm -ivh glib-devel-1.2.10-15.i386.rpm disk4
rpm -ivh ORBit-devel-0.5.17-14.i386.rpm disk4
rpm -ivh gtk+-devel-1.2.10-33.i386.rpm disk4
rpm -ivh alsa-lib-devel-1.0.6-4.i386.rpm disk3
rpm -ivh audiofile-devel-0.2.6-1.i386.rpm disk3
rpm -ivh esound-devel-0.2.35-2.i386.rpm disk3
rpm -ivh libjpeg-devel-6b-33.i386.rpm disk3
rpm -ivh libtiff-devel-3.6.1-7.i386.rpm disk3
rpm -ivh libungif-devel-4.1.3-1.i386.rpm disk3
rpm -ivh imlib-devel-1.9.13-23.i386.rpm disk3
rpm -ivh gnome-libs-devel-1.4.1.2.90-44.1.i386.rpm disk4
rpm -ivh compat-oracle-rhel4-1.0-5.i386.rpm (p4198954_21_linux.zip)
rpm -ivh compat-libcwait-2.0-2.i386.rpm (p4198954_21_linux.zip)
将gcc版本降级
mv /usr/bin/gcc /usr/bin/gcc.orig
mv /usr/bin/g++ /usr/bin/g++.orig
ln -s /usr/bin/x86_64-redhat-linux-gcc32 /usr/bin/gcc
ln -s /usr/bin/x86_64-redhat-linux-g++32 /usr/bin/g++
2.Groupadd oinstall
Groupadd dba
Useradd –m –g oinstall –G dba orai932
Useradd –m –g oinstall –G dba oracle
# mkdir –p
/oracle/302/orai932
/oracle/302
/oracle/redo1
/oracle/redo2
/oracle/arch
要注意目录的权限
3.修改oracle user .profile
export LD_ASSUME_KERNEL=2.4.19
ORACLE_BASE=/oracle/app/orai932
ORACLE_HOME=$ORACLE_BASE/product/9.2.0
ORACLE_DOC=$ORACLE_HOME/doc
ORACLE_PATH=.:$ORACLE_BASE/sql/public
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openwin/lib
ORACLE_SID=inst932
#PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/ccs/bin:/usr/sbin
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE
export ORACLE_HOME
export ORACLE_DOC
export ORACLE_PATH
export LD_LIBRARY_PATH
export ORACLE_SID
export PATH
4.Vi /etc/sysctl.conf
kernel.sysrq = 1
kernel.hostname = ssuzasptvm
kernel.domainname = amd.com
net.ipv4.ip_local_port_range = 1024 65000
net.ipv4.tcp_rmem = 4096 87380 262144
net.ipv4.tcp_wmem = 4096 65536 262144
net.ipv4.tcp_mem = 196608 262144 393216
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 262144
fs.file-max = 327679
kernel.shmmni = 4096
kernel.shmall = 4194304
kernel.shmmax = 17179869184
kernel.sem = 250 32000 100 128
5. Add the following settings to /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
orai932 soft nproc 2047
orai932 hard nproc 16384
orai932 soft nofile 1024
orai932 hard nofile 65536
Append a line to /etc/pam.d/login with the following commmand:
echo "session required pam_limits.so" >> /etc/pam.d/login
Add the following lines to /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
if [ $USER = "orai932" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
6.gunzip install1.cpio.gz
Cpio –idmv < install1.cpio
7. 设定DISPLAY
运行./runInstaller
安装过程中不建库
8.升级到9206
可以不安装oracle 4188455补丁,安装时加ignoreSysPrereqs参数
$./runInstaller.sh –ignoreSysPrereqs, 必须先升级OUI版本, OUI的home最好不用新的home 目录,然后安装oracle9206的补丁.
9.正常安装9207的补丁
10.dbca建库(这里通过hotbackup恢复)
将备份文件从磁带还原出来,拷贝文件到对应的目录
Startup nomount;
Alter database mount;
Recover database until cancel;利用archivelog 做recover
Alter database open resetlogs;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10897379/viewspace-964197/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10897379/viewspace-964197/