as5和centos5上安装oracle9i(9204)并升级到9208
1. 创建用户和组,添加安装过程中需要用到的用户和组
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle -d /home/user/oracle
passwd oracle
2. 创建目录,我们将把所有东西都安装到在 /w/oracle 目录下:
mkdir -p /w/oracle
chown -R oracle.oinstall /w/oracle
mkdir -p /w/oracle
chown -R oracle.oinstall /w/oracle
3. 系统配置
a) 设置内核参数,可以在运行时通过执行下列命令更改内核参数:vi /etc/rc.local
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 268435456 > /proc/sys/kernel/shmmax # 1/2 * mem_siz
echo 4096 > /proc/sys/kernel/shmmni
echo 524288 > /proc/sys/kernel/shmall # mem_size(M) * 102
echo 65536 > /proc/sys/fs/file-max
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range
a) 设置内核参数,可以在运行时通过执行下列命令更改内核参数:vi /etc/rc.local
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 268435456 > /proc/sys/kernel/shmmax # 1/2 * mem_siz
echo 4096 > /proc/sys/kernel/shmmni
echo 524288 > /proc/sys/kernel/shmall # mem_size(M) * 102
echo 65536 > /proc/sys/fs/file-max
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range
b)设置oracle对文件的要求,修改文件:/etc/security/limits.conf
echo #hzj add for db begin >> /etc/security/limits.conf
echo oracle soft nofile 65536 >> /etc/security/limits.conf
echo oracle hard nofile 65536 >> /etc/security/limits.conf
echo oracle soft nproc 16384 >> /etc/security/limits.conf
echo oracle hard nproc 16384 >> /etc/security/limits.conf
echo #hzj add for db end >> /etc/security/limits.conf
echo oracle soft nofile 65536 >> /etc/security/limits.conf
echo oracle hard nofile 65536 >> /etc/security/limits.conf
echo oracle soft nproc 16384 >> /etc/security/limits.conf
echo oracle hard nproc 16384 >> /etc/security/limits.conf
echo #hzj add for db end >> /etc/security/limits.conf
c) 设置环境变量,在/home/oracle/.bash_profile 中添加如下行:
#hzj add for db begin
export ORACLE_SID=oracle
export ORACLE_OWNER=oracle
export THREADS_FLAG=native
export ORACLE_BASE=/w/or9
export ORACLE_HOME=/w/or9/9.2.0
export LD_ASSUME_KERNEL=2.4.19
#hzj add for db begin
export ORACLE_SID=oracle
export ORACLE_OWNER=oracle
export THREADS_FLAG=native
export ORACLE_BASE=/w/or9
export ORACLE_HOME=/w/or9/9.2.0
export LD_ASSUME_KERNEL=2.4.19
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK (这里要求和db内的一致的字符集)
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/X11R6/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export PATH=/w/or9/9.2.0/bin:$ORACLE_HOME/OPatch:$PATH
#hzj add for db end
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/X11R6/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export PATH=/w/or9/9.2.0/bin:$ORACLE_HOME/OPatch:$PATH
#hzj add for db end
4. 打补丁、安装需要的包, 至于为什么要做这些工作,后面有个Tips,给出了安装中出现的错误及其Solution
--------------------------------------------------------------------------------------------------
a) 补丁说明:
p3006854_9204_LINUX.zip 安装前就要打好的补丁
p2617419_210_GENERIC.zip 安装后要打的(这只是一个伴随补丁,只要设置它的
环境变量)
p3238244_9204_LINUX.zip 安装后要打的9204的补丁,修复agent错误的补丁.
http://www.opennet.ru/soft/ora_inst/
--------------------------------------------------------------------------------------------------
a) 补丁说明:
p3006854_9204_LINUX.zip 安装前就要打好的补丁
p2617419_210_GENERIC.zip 安装后要打的(这只是一个伴随补丁,只要设置它的
环境变量)
p3238244_9204_LINUX.zip 安装后要打的9204的补丁,修复agent错误的补丁.
http://www.opennet.ru/soft/ora_inst/
compat-libcwait-2.0-2.i386.rpm LINUX AS 4 的补丁在安装前就要打
compat-oracle-rhel4-1.0-5.i386.rpm LINUX AS 4 的补丁在安装前就要打,但我没安装它
http://oss.oracle.com/projects/compat-oracle/files/RedHat/
compat-oracle-rhel4-1.0-5.i386.rpm LINUX AS 4 的补丁在安装前就要打,但我没安装它
http://oss.oracle.com/projects/compat-oracle/files/RedHat/
b) 打p3006854_9204_LINUX.zip
unzip p3006854_9204_LINUX.zip
chmod +x 3006854/rhel3_pre_install.sh
3006854/rhel3_pre_install.sh
unzip p3006854_9204_LINUX.zip
chmod +x 3006854/rhel3_pre_install.sh
3006854/rhel3_pre_install.sh
c) 安装 compat-libcwait-2.1-1.i386.rpm
rpm -ivh compat-libcwait-2.1-1.i386.rpm
rpm -ivh compat-libcwait-2.1-1.i386.rpm
d) 一些需要的包,这些包可以从系统盘中找到
rpm -ivh compat-db-4.2.52-5.1.i386.rpm
rpm -ivh libXp-1.0.0-8.i386.rpm
rpm -ivh libXp-devel-1.0.0-8.i386.rpm
rpm -ivh openmotif-2.3.0-0.3.el5.i386.rpm
rpm -ivh openmotif-devel-2.3.0-0.3.el5.i386.rpm
yum install openmotif-devel
rpm -ivh compat-db-4.2.52-5.1.i386.rpm
rpm -ivh libXp-1.0.0-8.i386.rpm
rpm -ivh libXp-devel-1.0.0-8.i386.rpm
rpm -ivh openmotif-2.3.0-0.3.el5.i386.rpm
rpm -ivh openmotif-devel-2.3.0-0.3.el5.i386.rpm
yum install openmotif-devel
gnome-libs-1.4.2-7.rhel5.i386.rpm 和 一些依赖包
这些包网上都可以找到,也可以从 http://ox0spy.googlepages.com/download.zip 下载
rpm -ivh giflib-4.1.3-8.i386.rpm
rpm -ivh glib-1.2.10-26.fc7.i386.rpm
rpm -ivh libpng10-1.0.18-2.i386.rpm
rpm -ivh ORBit-0.5.17-22.rhel5.i386.rpm
rpm -ivh gtk+-1.2.10-57.fc7.i386.rpm
rpm -ivh imlib-1.9.15-2.fc7.i386.rpm
rpm -ivh gnome-libs-1.4.2-7.rhel5.i386.rpm
yum install glib-devel
yum install gtk+
yum install esound-devel
rpm -q compat-db libXp libXp-devel openmotif openmotif-devel giflib glib libpng10 ORBit gtk+ imlib gnome-libs
rpm -ivh ./CentOS/compat-libgcc-296-2.96-138.i386.rpm
rpm -ivh ./CentOS/compat-libstdc++-*
rpm -ivh ./CentOS/compat-libf2c-34-3.4.6-4.i386.rpm
rpm -ivh ./CentOS/compat-gcc-3*
rpm -ivh ./CentOS/libaio-devel-0.3.106-3.2.i386.rpm
http://www.city-fan.org/ftp/contrib/drivers/pptp/
这些包网上都可以找到,也可以从 http://ox0spy.googlepages.com/download.zip 下载
rpm -ivh giflib-4.1.3-8.i386.rpm
rpm -ivh glib-1.2.10-26.fc7.i386.rpm
rpm -ivh libpng10-1.0.18-2.i386.rpm
rpm -ivh ORBit-0.5.17-22.rhel5.i386.rpm
rpm -ivh gtk+-1.2.10-57.fc7.i386.rpm
rpm -ivh imlib-1.9.15-2.fc7.i386.rpm
rpm -ivh gnome-libs-1.4.2-7.rhel5.i386.rpm
yum install glib-devel
yum install gtk+
yum install esound-devel
rpm -q compat-db libXp libXp-devel openmotif openmotif-devel giflib glib libpng10 ORBit gtk+ imlib gnome-libs
rpm -ivh ./CentOS/compat-libgcc-296-2.96-138.i386.rpm
rpm -ivh ./CentOS/compat-libstdc++-*
rpm -ivh ./CentOS/compat-libf2c-34-3.4.6-4.i386.rpm
rpm -ivh ./CentOS/compat-gcc-3*
rpm -ivh ./CentOS/libaio-devel-0.3.106-3.2.i386.rpm
http://www.city-fan.org/ftp/contrib/drivers/pptp/
e) 创建链接
# ln -s /usr/lib/libstdc++-libc6.2-2.so.3 /usr/lib/libstdc++-libc6.1-1.so.2
# ln -s /usr/lib/libstdc++-libc6.2-2.so.3 /usr/lib/libstdc++-libc6.1-1.so.2
5. 开始安装oracle
----------------------------------------------------------------------------------
1) 准备工作
download oracle 9i
http://www.oracle.com/technology/software/products/oracle9i/htdocs/linuxsoft.html
解压
$ zcat ship_9204_linux_disk1.cpio.gz | cpio -idmv
$ zcat ship_9204_linux_disk2.cpio.gz | cpio -idmv
$ zcat ship_9204_linux_disk3.cpio.gz | cpio -idmv
2) 以oracle用户启动vnc后,用vnc客户端以oracle用户登陆系统, 否则会出现一些列的错误,如:xhost +、环境变量、etc
$ Disk1/runInstaller
没有特别说明的均按默认设置,根据界面提示,然后点 Next 或 OK即可.
Oracle install group : oinstall
Global Database Name : or9hzj.net (可根据你的情况填写)
这个过程中还会出现两次提示,让你运行指定目录下的脚本,根据提示做就可以了
/tmp/orainstRoot.sh
/w/oracle/9.2.0/root.sh
3) 现在安装到Configuration Tools了,如果在这出现错误,提示Configuration Tools安装失败,
不要着急,我们还有两个补丁没打呢. 其实准确的说是一个补丁, p2617419_210_GENERIC.zip只是
一个伴随补丁, 我这不需要,手动完成就好
解决Agent Configuration Assistant安装失败:
[root@linux db]# pwd
/w/tmp/db
[root@linux db]# chown -R oracle.oinstall ../db
[root@linux db]# pwd
/w/tmp/db
[root@linux db]# su - oracle
[oracle@linux ~]$ cd /w/tmp/db
[oracle@linux db]$ echo $ORACLE_HOME/lib/stubs/
/w/oracle/9.2.0/lib/stubs/
[oracle@linux db]$ cp 3238244/files/lib/stubs/* $ORACLE_HOME/lib/stubs/
----------------------------------------------------------------------------------
1) 准备工作
download oracle 9i
http://www.oracle.com/technology/software/products/oracle9i/htdocs/linuxsoft.html
解压
$ zcat ship_9204_linux_disk1.cpio.gz | cpio -idmv
$ zcat ship_9204_linux_disk2.cpio.gz | cpio -idmv
$ zcat ship_9204_linux_disk3.cpio.gz | cpio -idmv
2) 以oracle用户启动vnc后,用vnc客户端以oracle用户登陆系统, 否则会出现一些列的错误,如:xhost +、环境变量、etc
$ Disk1/runInstaller
没有特别说明的均按默认设置,根据界面提示,然后点 Next 或 OK即可.
Oracle install group : oinstall
Global Database Name : or9hzj.net (可根据你的情况填写)
这个过程中还会出现两次提示,让你运行指定目录下的脚本,根据提示做就可以了
/tmp/orainstRoot.sh
/w/oracle/9.2.0/root.sh
3) 现在安装到Configuration Tools了,如果在这出现错误,提示Configuration Tools安装失败,
不要着急,我们还有两个补丁没打呢. 其实准确的说是一个补丁, p2617419_210_GENERIC.zip只是
一个伴随补丁, 我这不需要,手动完成就好
解决Agent Configuration Assistant安装失败:
[root@linux db]# pwd
/w/tmp/db
[root@linux db]# chown -R oracle.oinstall ../db
[root@linux db]# pwd
/w/tmp/db
[root@linux db]# su - oracle
[oracle@linux ~]$ cd /w/tmp/db
[oracle@linux db]$ echo $ORACLE_HOME/lib/stubs/
/w/oracle/9.2.0/lib/stubs/
[oracle@linux db]$ cp 3238244/files/lib/stubs/* $ORACLE_HOME/lib/stubs/
unzip p3238244_9204_LINUX.zip
cp 3238244/files/lib/stubs/* $ORACLE_HOME/lib/stubs/
cd $ORACLE_HOME/network/lib/
make -f ins_oemagent.mk install
cp 3238244/files/lib/stubs/* $ORACLE_HOME/lib/stubs/
cd $ORACLE_HOME/network/lib/
make -f ins_oemagent.mk install
解决Oracle Net Configuration Assistant, Oracle Database Configuration Assistant 安装失败
rm $ORACLE_HOME/JRE
#ln -s $ORACLE_BASE/jre/1.3.1/ $ORACLE_HOME/JRE xxxx
ln -s $ORACLE_BASE/9.2.0/jdk/jre $ORACLE_HOME/JRE
ln -s $ORACLE_HOME/JRE/bin/java $ORACLE_HOME/JRE/bin/jre
ln -s $ORACLE_HOME/JRE/bin/i386/native_threads/java $ORACLE_HOME/JRE/bin/i386/native_threads/jre
设置密码时注意不能用特殊符号,先用hzjnet2k,不然出现ora-00922的错误
cat /etc/redhat-release
./runInstaller -ignoreSYSPrereqs
使用./runInstaller -ignoreSysprereqs
[oracle@linux 4547809]$ cd / 必须退出解包目录,安装
[oracle@linux /]$ /w/tmp/db/4547809/Disk1/runInstaller -ignoreSysprereqs
Starting Oracle Universal Installer...
不然出现Error: OUI cannot be launched because the current working directory is set on the CD-ROM mount point. Launching OUI
from this directory will make it difficult to unmount the disk later in the installation. Please change the working directory
and relaunch OUI.的错误
[oracle@linux /]$ /w/tmp/db/4547809/Disk1/runInstaller -ignoreSysprereqs
Starting Oracle Universal Installer...
不然出现Error: OUI cannot be launched because the current working directory is set on the CD-ROM mount point. Launching OUI
from this directory will make it difficult to unmount the disk later in the installation. Please change the working directory
and relaunch OUI.的错误
OK,现在Retry,你就可以成功安装Configuration Tools了,安装也就结束了...
4)设置启动参数:
修改/etc/profile.d/oracle.sh,设置$ORACLE_HOME,$ORACLE_SID,$ORACLE_BASE。
export ORACLE_BASE=/w/oracle
export ORACLE_HOME=$ORACLE_BASE/9.2.0
export ORACLE_SID=or9hzj
export ORACLE_BASE=/w/oracle
export ORACLE_HOME=$ORACLE_BASE/9.2.0
export ORACLE_SID=or9hzj
修改/etc/sysconfig/oracle,将START_ORALCE改成"yes"。
修改/etc/oratab,将N改成Y。
修改/etc/oratab,将N改成Y。
export ORACLE_BASE=/w/oracle
export ORACLE_HOME=$ORACLE_BASE/9.2.0
export ORACLE_SID=or9hzj.bnet
export ORACLE_HOME=$ORACLE_BASE/9.2.0
export ORACLE_SID=or9hzj.bnet
5)升级到9208
startup
SHOW PARAMETER JAVA_POOL_SIZE
SHOW PARAMETER SHARED_POOL_SIZE
ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile;
ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;
SHOW PARAMETER JAVA_POOL_SIZE
SHOW PARAMETER SHARED_POOL_SIZE
SHUTDOWN
startup
SHOW PARAMETER JAVA_POOL_SIZE
SHOW PARAMETER SHARED_POOL_SIZE
SHUTDOWN
STARTUP MIGRATE
SPOOL patch.log
@?/rdbms/admin/catpatch.sql
SPOOL OFF
SHUTDOWN
startup
spool patch2.log
@?/rdbms/admin/utlrp.sql
SPOOL OFF
startup
SHOW PARAMETER JAVA_POOL_SIZE
SHOW PARAMETER SHARED_POOL_SIZE
ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile;
ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;
SHOW PARAMETER JAVA_POOL_SIZE
SHOW PARAMETER SHARED_POOL_SIZE
SHUTDOWN
startup
SHOW PARAMETER JAVA_POOL_SIZE
SHOW PARAMETER SHARED_POOL_SIZE
SHUTDOWN
STARTUP MIGRATE
SPOOL patch.log
@?/rdbms/admin/catpatch.sql
SPOOL OFF
SHUTDOWN
startup
spool patch2.log
@?/rdbms/admin/utlrp.sql
SPOOL OFF
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7551038/viewspace-614838/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7551038/viewspace-614838/