目录:
第一部分:安装ORACLE 10.2.0.1 到REDHAT 5.2 1
1,修改内核参数 1
2,# sysctl –p 使之生效 2
3,修改系统限制,添加以下内容 2
4,设置selinux为宽松模式 2
5,安装以下系统包 2
6,创建用户和组 2
7,创建oracle目录 2
8,编辑oracle用户的.bash_profile文件 2
9,修改操作系统版本信息 3
10,解压安装文件 3
11,在windows系统上安装xming工具和putty工具,使之能够远程图像化界面操作 3
12,通过putty连接oracle 用户 3
第二部分:升级ORACLE 10.2.0.1到ORACLE 10.2.0.4 3
1,停止所有oracle服务 3
2,做个冷备份 4
3,解压补丁文件 4
4,安装补丁包 4
5,启动数据库到升级模式 4
6,重建数据字典(30分钟) catupgrd.sql 4
7,重启数据库 4
8,编译无效对象 utlrp.sql 5
9,检查升级之后,所有组件的状态 dba_registry 5
参考文档: 5
正文:
第一部分:安装Oracle 10.2.0.1 到redhat 5.2
1,修改内核参数
# vi /etc/sysctl.conf 追加以下内容
# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
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
2,# sysctl –p 使之生效
3,修改系统限制,添加以下内容
# vi /etc/security/limits.conf
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
4,设置selinux为宽松模式
# getenforce
Permissive
# setenforce
usage: setenforce [ Enforcing | Permissive | 1 | 0 ]
5,安装以下系统包
# rpm -Uvh setarch-2*
# rpm -Uvh make-3*
# rpm -Uvh glibc-2*
# rpm -Uvh libaio-0*
# rpm -Uvh compat-libstdc++-33-3*
# rpm -Uvh compat-gcc-34-3*
# rpm -Uvh compat-gcc-34-c++-3*
# rpm -Uvh gcc-4*
# rpm -Uvh libXp-1*
# rpm -Uvh openmotif-2*
# rpm -Uvh compat-db-4*
6,创建用户和组
# groupadd oinstall
# groupadd dba
# groupadd oper
# useradd -g oinstall -G dba oracle
# passwd oracle
7,创建oracle目录
# mkdir -p /u01/app/oracle/product/10.2.0/db_1
# chown -R oracle.oinstall /u01
8,编辑oracle用户的.bash_profile文件
# vi /home/oracle/.bash_profile
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=bkeep; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
9,修改操作系统版本信息
# uname -a
Linux oracle_vm_41 2.6.18-8.el5 #1 SMP Fri Jan 26 14:15:21 EST 2007 i686 i686 i386 GNU/Linux
# vi /etc/redhat-release
redhat-4
10,解压安装文件
# unzip -q 10201_database_linux32.zip
# chown -R oracle:oinstall /disk/
11,在windows系统上安装xming工具和putty工具,使之能够远程图像化界面操作
请参阅:http://bkeep.blog.163.com/blog/static/123414290201051884617120/
12,通过putty连接oracle 用户
login as: oracle
oracle@192.168.254.5's password:
Last login: Sun Jun 20 09:34:21 2010 from 192.168.254.211
$ cd /disk/database/
$ ls
doc install response runInstaller stage welcome.html
$ ./runInstaller
图形界面出来了,开始安装啦!
第二部分:升级oracle 10.2.0.1到oracle 10.2.0.4
1,停止所有oracle服务
$ emctl stop dbconsole
$ isqlplusctl stop
$ lsnrctl stop
2,做个冷备份
# cp -a app/ app.bak
3,解压补丁文件
$ unzip -q p6810189_10204_Linux-x86.zip
Tips:顺便看看patch_note.htm文件中关于该补丁的描述
4,安装补丁包
$ cd Disk1/
$ ls
10204_buglist.htm install patch_note.htm response runInstaller stage
$./runInstaller –ignoreSysPrereqs //后面的参数是忽略检查操作系统版本
5,启动数据库到升级模式
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Sun Jun 20 10:55:10 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1267068 bytes
Variable Size 92277380 bytes
Database Buffers 188743680 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
6,重建数据字典(30分钟) catupgrd.sql
SQL> spool path.log
SQL> @?/rdbms/admin/catupgrd.sql
7,重启数据库
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1267068 bytes
Variable Size 134220420 bytes
Database Buffers 146800640 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
8,编译无效对象 utlrp.sql
由于catupgrd.sql重建过程中可能造成一些对象失效,我们需要运行utlrp.sql重新编译PL/SQL packages
SQL> @?/rdbms/admin/utlrp.sql
9,检查升级之后,所有组件的状态 dba_registry
显示值为VALID,则成功完成升级
SQL> select comp_name,version,status from sys.dba_registry
COMP_NAME VERSION STATUS
----------------------------------- -------------------- -----------
Oracle Database Catalog Views 10.2.0.4.0 VALID
Oracle Database Packages and Types 10.2.0.4.0 VALID
Oracle Workspace Manager 10.2.0.4.3 VALID
JServer JAVA Virtual Machine 10.2.0.4.0 VALID
Oracle XDK 10.2.0.4.0 VALID
Oracle Database Java Packages 10.2.0.4.0 VALID
Oracle Expression Filter 10.2.0.4.0 VALID
Oracle Data Mining 10.2.0.4.0 VALID
Oracle Text 10.2.0.4.0 VALID
Oracle XML Database 10.2.0.4.0 VALID
Oracle Rule Manager 10.2.0.4.0 VALID
Oracle interMedia 10.2.0.4.0 VALID
OLAP Analytic Workspace 10.2.0.4.0 VALID
Oracle OLAP API 10.2.0.4.0 VALID
OLAP Catalog 10.2.0.4.0 VALID
Spatial 10.2.0.4.0 VALID
Oracle Enterprise Manager 10.2.0.4.0 VALID
参考文档:
oracle安装:http://bkeep.blog.163.com/blog/static/12341429020103108126820/
X windows:http://bkeep.blog.163.com/blog/static/123414290201051884617120/
Link URL: http://bkeep.blog.163.com/blog/static/12341429020105215218788
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22238176/viewspace-665892/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22238176/viewspace-665892/