Oracle upgrade version: 10.2.0.1.0à10.2.0.5.0 for Oracle Linux Server release 6.4
1. 检查数据库状态与版本信息:
[oracle@sam ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 27 15:40:46 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and D
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 – Production
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ WRITE
2. 关闭数据库:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
3. 对数据库软件进行备份
tar -zcvf /10g/app/oracle/product/10.2.0/dbhome_1.tar /10g/app/oracle/product/10.2.0/*
4. 安装 Oracle 10.2.0.5.0 软件:
[oracle@test Disk1]$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, redhat-6, UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4, enterprise-5 or SuSE-11
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-12-27_03-51-42PM. Please wait ...[oracle@test Disk1]$ Oracle Universal Installer, Version 10.2.0.5.0 Production
Copyright (C) 1999, 2010, Oracle. All rights reserved.
此报错处理方法,有程序未关闭,重启动再安装不出现此报错。
5. 执行root.sh脚本(用户root执行):
[root@test ~]# /10g/app/oracle/product/10.2.0/dbhome_1/root.sh
Running Oracle 10g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /10g/app/oracle/product/10.2.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
[root@test ~]#
6. 升级数据字典:
[oracle@test ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Dec 27 17:50:44 2013
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup upgrade;
ORACLE instance started.
Total System Global Area 419430400 bytes
Fixed Size 2096728 bytes
Variable Size 121635240 bytes
Database Buffers 289406976 bytes
Redo Buffers 6291456 bytes
Database mounted.
Database opened.
SQL> spool /tmp/upgrade.log
SQL> @?/rdbms/admin/catupgrd.sql
..........日志略过,完成后可以查看/tmp/upgrade.log日志文件
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
OCM10G OPEN MIGRATE
7. 重新启动到OPEN状态并检查版本信息:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 419430400 bytes
Fixed Size 2096728 bytes
Variable Size 171966888 bytes
Database Buffers 239075328 bytes
Redo Buffers 6291456 bytes
Database mounted.
Database opened.
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
OCM10G OPEN
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
SQL>
到此升级到此结束,后继还将分享OPatch打补丁方法。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26148431/viewspace-1066641/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26148431/viewspace-1066641/