合 本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境
Tags: Oracle升级DBUA11.2.0.311.2.0.1
数据库情况
- 单实例非ASM存储
- ORACLE_SID : orcl
- ORACLE_HOME: /u01/app/oracle/product/11.2.0/dbhome_1
数据库原始状态
[oracle@rhel6 tmp]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 26 16:44:37 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create table test as select * from user_objects;
Table created.
SQL> select count(1) from test;
COUNT(1)
----------
30804
SQL>set linesize 150
SQL>set pagesize 9999
SQL> col comp_name format a40
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ -----------
OWB 11.2.0.1.0 VALID
Oracle Application Express 3.2.1.00.10 VALID
Oracle Enterprise Manager 11.2.0.1.0 VALID
OLAP Catalog 11.2.0.1.0 VALID
Spatial 11.2.0.1.0 VALID
Oracle Multimedia 11.2.0.1.0 VALID
Oracle XML Database 11.2.0.1.0 VALID
Oracle Text 11.2.0.1.0 VALID
Oracle Expression Filter 11.2.0.1.0 VALID
Oracle Rules Manager 11.2.0.1.0 VALID
Oracle Workspace Manager 11.2.0.1.0 VALID
Oracle Database Catalog Views 11.2.0.1.0 VALID
Oracle Database Packages and Types 11.2.0.1.0 VALID
JServer JAVA Virtual Machine 11.2.0.1.0 VALID
Oracle XDK 11.2.0.1.0 VALID
Oracle Database Java Packages 11.2.0.1.0 VALID
OLAP Analytic Workspace 11.2.0.1.0 VALID
Oracle OLAP API 11.2.0.1.0 VALID
18 rows selected.
数据库保持运行状态:
解压命令:
unzip p10404530_112030_Linux-x86-64_1of7.zip -d /tmp && unzip p10404530_112030_Linux-x86-64_2of7.zip -d /tmp
升级Oracle database 软件
开始安装:
执行到76%的时候弹出如下窗口:
[root@rhel6 ~]# /u01/app/oracle/product/11.2.0.4/dbhome_1/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.4/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
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 script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@rhel6 ~]#
升级Instance
升级Instance 有两种方法,第一种是使用dbua工具,第二种是手工执行脚本。
使用DBUA工具
操作界面:
该步骤可以在告警日志中查看相关信息:
Sun Sep 28 16:16:31 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =167
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1
System name: Linux
Node name: rhel6.5
Release: 2.6.32-431.el6.x86_64
Version: #1 SMP Sun Nov 10 22:19:54 EST 2013
Machine: x86_64
VM name: VMWare Version: 6
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/spfileorcl.ora
System parameters with non-default values:
processes = 1000
shared_pool_size = 252M
java_pool_size = 252M
memory_target = 1G
control_files = "/u01/app/oracle/oradata/orcl/control01.ctl"
control_files = "/u01/app/oracle/oradata/orcl/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
undo_tablespace = "UNDOTBS1"
recyclebin = "OFF"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
local_listener = "LISTENER_ORCL"
audit_file_dest = "/u01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
Sun Sep 28 16:16:38 2014
PMON started with pid=2, OS id=26426
Sun Sep 28 16:16:38 2014
PSP0 started with pid=3, OS id=26428
Sun Sep 28 16:16:39 2014
VKTM started with pid=4, OS id=26430 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sun Sep 28 16:16:39 2014
GEN0 started with pid=5, OS id=26434
Sun Sep 28 16:16:39 2014
DIAG started with pid=6, OS id=26436
Sun Sep 28 16:16:39 2014
DBRM started with pid=7, OS id=26438
Sun Sep 28 16:16:39 2014
DIA0 started with pid=8, OS id=26440
Sun Sep 28 16:16:39 2014
MMAN started with pid=9, OS id=26442
Sun Sep 28 16:16:39 2014
DBW0 started with pid=10, OS id=26444
Sun Sep 28 16:16:39 2014
LGWR started with pid=11, OS id=26446
Sun Sep 28 16:16:39 2014
CKPT started with pid=12, OS id=26448
Sun Sep 28 16:16:39 2014
SMON started with pid=13, OS id=26450
Sun Sep 28 16:16:39 2014
RECO started with pid=14, OS id=26452
Sun Sep 28 16:16:39 2014
MMON started with pid=15, OS id=26454
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Sep 28 16:16:39 2014
MMNL started with pid=16, OS id=26456
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Sun Sep 28 16:16:58 2014
ALTER DATABASE MOUNT
Sun Sep 28 16:17:03 2014
Successful mount of redo thread 1, with mount id 1387228411
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Sun Sep 28 16:17:06 2014
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Sun Sep 28 16:17:10 2014
Stopping background process VKTM
Sun Sep 28 16:17:12 2014
Instance shutdown complete
Sun Sep 28 16:17:14 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =167
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1
System name: Linux
Node name: rhel6.5
Release: 2.6.32-431.el6.x86_64
Version: #1 SMP Sun Nov 10 22:19:54 EST 2013
Machine: x86_64
VM name: VMWare Version: 6
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/spfileorcl.ora
System parameters with non-default values:
processes = 1000
shared_pool_size = 252M
java_pool_size = 252M
memory_target = 1G
control_files = "/u01/app/oracle/oradata/orcl/control01.ctl"
control_files = "/u01/app/oracle/oradata/orcl/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
undo_tablespace = "UNDOTBS1"
recyclebin = "OFF"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
local_listener = "LISTENER_ORCL"
audit_file_dest = "/u01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
Sun Sep 28 16:17:17 2014
PMON started with pid=2, OS id=26627
Sun Sep 28 16:17:17 2014
PSP0 started with pid=3, OS id=26629
Sun Sep 28 16:17:18 2014
VKTM started with pid=4, OS id=26631 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sun Sep 28 16:17:18 2014
GEN0 started with pid=5, OS id=26635
Sun Sep 28 16:17:18 2014
DIAG started with pid=6, OS id=26637
Sun Sep 28 16:17:18 2014
DBRM started with pid=7, OS id=26639
Sun Sep 28 16:17:18 2014
DIA0 started with pid=8, OS id=26641
Sun Sep 28 16:17:18 2014