本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

0    205    1

Tags:

👉 本文共约23444个字,系统预计阅读时间或需89分钟。

数据库情况

  • 单实例非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.

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

数据库保持运行状态:

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

解压命令:

unzip p10404530_112030_Linux-x86-64_1of7.zip -d /tmp && unzip p10404530_112030_Linux-x86-64_2of7.zip -d /tmp

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

升级Oracle database 软件

开始安装:

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

执行到76%的时候弹出如下窗口:

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

[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 ~]#

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

升级Instance

升级Instance 有两种方法,第一种是使用dbua工具,第二种是手工执行脚本。

使用DBUA工具

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

操作界面:

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境

该步骤可以在告警日志中查看相关信息:

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

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!
本地使用dbua和手工脚本的方式升级Oracle 11.2.0.1到11.2.0.3环境后续精彩内容已被小麦苗无情隐藏,请输入验证码解锁本站所有文章!
验证码:
请先关注本站微信公众号,然后回复“验证码”,获取验证码。在微信里搜索“DB宝”或者“www_xmmup_com”或者微信扫描右侧二维码都可以关注本站微信公众号。

标签:

Avatar photo

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复

嘿,我是小麦,需要帮助随时找我哦。
  • 18509239930
  • 个人微信

  • DB宝
  • 个人邮箱
  • 点击加入QQ群
  • 个人微店

  • 回到顶部