linux平台下oracle从10.2.0.1升级到10.2.0.4
来源:互联网 发布:淘宝特色美食店铺推荐 编辑:程序博客网 时间:2024/06/03 18:55
10.1.0.X.0 TO 10.2.0.4.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=169706.1&blackframe=1 : Oracle? Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.2.0.4.0 patchset on top of 10.2.0.1.0 ORACLE_HOME Patchset number is : 6810189
http://updates.oracle.com/download/6810189.html
3. Upgrade the database to 10.2.0.4.0
https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=419550.1&blackframe=1 : Different Upgrade Methods For Upgrading Your Database
https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=316889.1&blackframe=1 : Complete checklist for manual upgrades to 10gR2
REFERENCE:
List of fixes included in 10.2.0.4 https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=401436.1&blackframe=1
Known issues and alerts affecting 10.2.0.4 https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=555579.1&blackframe=1
升级过程:
1.如果是全新安装的数据库,直接运行补丁包就可以了
p6810189_10204_Linux-x86.zip
./runInstaller
2.如果是已经创建了数据库,并且有应用在上面,则先停止相关应用
再按以下步骤执行:
0)shutdown 数据库,并停止所有oracle相关的服务和stop listener .
$ isqlplusctl stop
$ emctl stop dbconsole
$ lsnrctl stop
注意: 需要停止Distributed Transaction Coordinator服务/iis服务/web publish(www)/;
1)冷备份数据库
2)运行安装补丁程序
3)startup upgrade; lsnrctl start
3.1)修改java_pool_size / large_pool_size=150M
4)运行脚本@rdbms/admin/catupgrd.sql
5)shutdown immediate
6)startup
7)运行脚本@rdbms/admin/utlrp.sql;
# @rdbms/admin/catalog.sql;
# @rdbms/admin/catproc.sql;
8)--察看数据库安装的组件、版本、状态:
col comp_name format a30
col version format a30
col status format a10
SELECT comp_name, version, status FROM dba_registry;
PS:
Chmod -R 777 /u01 -->改变权限
Chmod oracle /u01 -->改变文档所有者
When I execute the runInstaller for the patchset it gives me:
Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3
Failed <<<<
I already had set /etc/redhat-release to:
redhat-5
What needs editing is these files:
/etc/issue
/etc/issue.net
/etc/redhat-release
In those files you will put this:
Red Hat Enterprise Linux Server release 5 (Tikanga)
Kernel /r on an /m
"Tikanga" is for 5.0 only If your running 5.1 you need to substitute the name for it. The same applys to also CentOS version 4, you substitute the appropriate line.
After your Oracle DB or Oracle App is installed change them back.
an other way to resolve this is to use the switch
-ignoreSysPrereqs
when starting the installer
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=169706.1&blackframe=1 : Oracle? Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.2.0.4.0 patchset on top of 10.2.0.1.0 ORACLE_HOME Patchset number is : 6810189
http://updates.oracle.com/download/6810189.html
3. Upgrade the database to 10.2.0.4.0
https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=419550.1&blackframe=1 : Different Upgrade Methods For Upgrading Your Database
https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=316889.1&blackframe=1 : Complete checklist for manual upgrades to 10gR2
REFERENCE:
List of fixes included in 10.2.0.4 https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=401436.1&blackframe=1
Known issues and alerts affecting 10.2.0.4 https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=555579.1&blackframe=1
升级过程:
1.如果是全新安装的数据库,直接运行补丁包就可以了
p6810189_10204_Linux-x86.zip
./runInstaller
2.如果是已经创建了数据库,并且有应用在上面,则先停止相关应用
再按以下步骤执行:
0)shutdown 数据库,并停止所有oracle相关的服务和stop listener .
$ isqlplusctl stop
$ emctl stop dbconsole
$ lsnrctl stop
注意: 需要停止Distributed Transaction Coordinator服务/iis服务/web publish(www)/;
1)冷备份数据库
2)运行安装补丁程序
3)startup upgrade; lsnrctl start
3.1)修改java_pool_size / large_pool_size=150M
4)运行脚本@rdbms/admin/catupgrd.sql
5)shutdown immediate
6)startup
7)运行脚本@rdbms/admin/utlrp.sql;
# @rdbms/admin/catalog.sql;
# @rdbms/admin/catproc.sql;
8)--察看数据库安装的组件、版本、状态:
col comp_name format a30
col version format a30
col status format a10
SELECT comp_name, version, status FROM dba_registry;
PS:
Chmod -R 777 /u01 -->改变权限
Chmod oracle /u01 -->改变文档所有者
When I execute the runInstaller for the patchset it gives me:
Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3
Failed <<<<
I already had set /etc/redhat-release to:
redhat-5
What needs editing is these files:
/etc/issue
/etc/issue.net
/etc/redhat-release
In those files you will put this:
Red Hat Enterprise Linux Server release 5 (Tikanga)
Kernel /r on an /m
"Tikanga" is for 5.0 only If your running 5.1 you need to substitute the name for it. The same applys to also CentOS version 4, you substitute the appropriate line.
After your Oracle DB or Oracle App is installed change them back.
an other way to resolve this is to use the switch
-ignoreSysPrereqs
when starting the installer
- linux平台下oracle从10.2.0.1升级到10.2.0.4
- linux平台下oracle从10.2.0.1升级到10.2.0.4
- linux平台下oracle从10.2.0.1升级到10.2.0.4
- linux平台下oracle从10.2.0.1升级到10.2.0.4
- linux平台下oracle从10.2.0.1升级到10.2.0.4
- Linux 平台 Oracle 单实例 从10.2.0.1 升级到10.2.0.5.4 步骤
- Linux 平台 Oracle 单实例 从10.2.0.1 升级到10.2.0.5.4 步骤
- Linux 平台 Oracle 单实例 从10.2.0.1 升级到10.2.0.5.4 步骤
- Linux 平台 Oracle 单实例 从10.2.0.1 升级到10.2.0.5.4 步骤
- linux系统下oracle 10.2.0.1升级到10.2.0.4
- windows 2003 下oracle从10.2.0.1升级到10.2.0.4
- Oracle从10.2.0.1升级到10.2.0.4
- oracle从10.2.0.1升级到10.2.0.4
- LINUX平台上,oracle 10.2.0.1升级到10.2.0.4出现oracle universal installer has detected that there are processe
- suse系统下:oracle 从10.2.0.2 到 10.2.0.4 升级详解
- linux下oracle 11.2.0.1升级到11.2.0.4
- linux下oracle 11.2.0.1升级到11.2.0.4 linux下oracle 11.2.0.1升级到11.2.0.4
- Oracle 从10.2.0.1升级到10.2.0.5
- Advanced File Permissions in Linux
- java中反射机制详解
- Bind()方法与Eval()方法的区别与使用
- java中数组的相关操做
- Gridview行绑定调用后台方法
- linux平台下oracle从10.2.0.1升级到10.2.0.4
- 如何查看linux版本?
- Java教程——Java简介与环境配置
- 用户体验的评估与创造
- Oracle 10G windows 平台 DataGuard 实例
- GridView 模板列中的数据绑定
- Graphics 不能建立有索引像素格式的对象
- Mule ESB 学习笔记
- [转载]Android开发真实谎言:个人无空间 无奈搞吸费