oracle 11.2.0.3 升级过程问题分享，有同学和我一样环境的可以参考
本帖最后由 crazy_gh 于 2014-8-25 18:38 编辑今天把家里的环境升级到了11.2.0.3，按照唐老师上课的步骤做下来，整个软件升级过程非常的顺利，没有出现其他问题，但是在startup upgrade的时候出现个小插曲：
先说明下环境：
OS： OEL 5.4 X86_64
DB： Grid+DB(11.2.0.1 x86_64)
和上课环境的不同的在于，我的环境存在Grid用户及asmadmin等组（问题就在这边）
在完成Grid和DB的软件升级后，准备对orcl数据库进行升级：
SQL > startup upgrade; >>报错，查看alert.log
ALTER DATABASE MOUNT
Sun Aug 10 11:29:55 2014
Sweep : completed
Sweep : completed
Sweep : completed
Sweep : completed
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_rbal_18887.trc:
ORA-15183: ASMLIB initialization error
WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_rbal_18887.trc:
ORA-15183: ASMLIB initialization error
SUCCESS: diskgroup DATA was mounted
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ckpt_18881.trc
(incident=54097):
ORA-00600: internal error code, arguments: , [], [], [], [], [],
[], [], [], [], [], []
Incident details in:
/u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_54097/orcl_ckpt_18881_i54097.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
NOTE: dependency between database orcl and diskgroup resource ora.DATA.dg is
established
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ckpt_18881.trc
(incident=54098):
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], [], [],
[], [], []
Incident details in:
/u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_54098/orcl_ckpt_18881_i54098.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
ERROR: unrecoverable error ORA-600 raised in ASM I/O path; terminating process 18881
Dumping diagnostic data in directory=, requested by (instance=1,
osid=18881 (CKPT)), summary=.
PMON (ospid: 18859): terminating the instance due to error 469
System state dump requested by (instance=1, osid=18859 (PMON)), summary=[abnormal
instance termination].
System State dumped to trace file
/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_diag_18869.trc
Dumping diagnostic data in directory=, requested by (instance=1,
osid=18859 (PMON)), summary=.
Instance terminated by PMON, pid = 18859
/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_rbal_18887.trc错误日志：
ERROR: asm_version error. err: driver/agent not installed rc:2
ORA-15183: ASMLIB initialization error
ORA-15183: ASMLIB initialization error
简单的google了下，说是权限问题，说要执行：
setasmgidwrap o=/u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
去翻了下readme的upgrade guide，在执行startup upgrade前有一个步骤：
http://docs.oracle.com/cd/E11882 ... rade.htm#UPGRD52646
4.If there is a different user and group for Grid Infrastructure and Oracle Database, then run the setasmgidwrap script, which is located in theGRID_HOME/bin directory, against the new ORACLE_HOME/bin/oracle directory with the -o option as shown in the following example:
$GRID_HOME/bin/setasmgidwrap o=ORACLE_HOME/bin/oracle
执行之后顺顺利利的完成了5个脚本升级。。
生产环境升级，还是要把readme通读一遍，做好充分的测试，避免出现准备不足的尴尬！测试环境倒是出问题越多越好，排错对自己也是一种提升。
升级过程没有做记录，只有笔记，如下：
1.查看grid版本
crsctl query has softwareversion
2.升级grid前，grid必须运行。（所以要新建一个grid安装目录，另外grid用户（没有grid就是oracle）要能执行crs_stat -t）
3.运行gridrunInstaller
32bit
skip software updates
Upgrade Oracle....
Language
ASM password
OS Group
soft location 换一个安装目录/u01/app/oracle/product/11.2.0.3/grid
prerequisite check
install
/u01/app/oracle/product/11.2.0.3/grid/rootupgrade.sh
ora.diskmon 在11.2.0.3 开始都是offline
新增一个ora.ons，默认禁用(srvctl enable ora.ons > vrsctl start res ora.ons ...用于rac环境，单实例没必要）
ln-s新grid 旧grid //就不需要再修改环境变量
4.升级db soft，建议备份dbs目录下的文件，然后删除dbhome_1
crsctl stop res ora.orcl.db
emctl stop dbconsole
db runInstaller
install database software only
ps:如果没有删除原安装目录以及选择Upgrade，会出现make错误。
5. 升级db，oracle建议用dbua，但是生产环境不建议使用：1.看不到后台运行，2.可能升级失败。
拷贝备份的dbs下文件到新安装的dbs
############
If there is a different user and group for Grid Infrastructure and Oracle Database, then run the setasmgidwrap script, which is located in the GRID_HOME/bin directory, against the new ORACLE_HOME/bin/oracle directory with the -o option as shown in the following example:
su- grid
setasmgidwrap o=/u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
############
startup upgrade //其实就是禁用新特性
spool filename.log
@utlu112i.sql << 10g升级所需
@catupgrd.sql >6h
自动shutdown immediate
startup
@utlu112s.sql
@catuppst.sql
@utlrp.sql 2h << 10g升级所需
亲 升级过程能出个手册吗? 帮主大家一起实验 最好是把准备条件 和 grid升级过程一份database升级一份thank you so much~ 求升级手册 lxq 发表于 2014-8-25 14:17
求升级手册
升级过程没有详细记录下来，只有上课时的笔记，给你参考下！ 几乎把上课,我所演示的都实践了一遍.
页:
[1]