oracle 11g 升级 多久,oracle 11g升级 - SealL的个人空间 - 51Testing软件测试网 51Testing软件测试网-软件测试人的精神家园...

这几天一直在Linux上装数据库，遇到个升级的问题，总结一下，以便以后用到！

要求在suse 10上安装Oracle11g 11.1.0.7.1的数据库，因为没有现成的7.1的安装程序，所以我们要先装Oracle 11g 11.1.0.6.0这个版本，

然后打两个补丁，分别是Oracle 11g 11.1.0.7.0 和Oracle 11g 11.1.0.7.1

安装6.0和7.0就不用多说了，很简单，Oracle用户下直接运行./runInstall

特别说一下，7.1补丁的安装，因为7.1的补丁包不像7.0有runInstall这样的可执行程序，而是些各种各样的文件

这就需要我们用OPatch工具给Oracle打补丁

注册一个http://aru.us.oracle.com/帐户，首页-》申请帐户-》页面最底端有个按钮(很变态)，然后填入全局email。收邮件，用密码登陆。

下载，上传，解压：upzip xxxxxxx

添加PATH环境变量：

:$ORACLE_HOME/OPatch

检查补丁情况：oracle@IntelRAC1:~> cd 4933302/oracle@IntelRAC1:~/4933302> opatch lsinventory

Invoking OPatch 10.2.0.1.0

Oracle interim Patch Installer version 10.2.0.1.0

Copyright (c) 2005, Oracle Corporation.  All rights reserved..

Oracle Home       : /oracle/db

Central Inventory : /oracle/oraInventory

from           : /oracle/db/oraInst.loc

OPatch version    : 10.2.0.1.0

OUI version       : 10.2.0.1.0

OUI location      : /oracle/db/oui

Log file location : /oracle/db/cfgtoollogs/opatch/opatch-2006_Mar_23_16-05-02-CST_Thu.log

Lsinventory Output file location : /oracle/db/cfgtoollogs/opatch/lsinv/lsinventory-2006_Mar_23_16-05-02-CST_Thu.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle Database 10g                                                  10.2.0.1.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------

OPatch succeeded.

停止需要打补丁的实例：

sqlplus / as sysdba

shutdown immediate;

打补丁：oracle@IntelRAC1:~/4933302> opatch apply

Invoking OPatch 10.2.0.1.0

Oracle interim Patch Installer version 10.2.0.1.0

Copyright (c) 2005, Oracle Corporation.  All rights reserved..

Oracle Home       : /oracle/db

Central Inventory : /oracle/oraInventory

from           : /oracle/db/oraInst.loc

OPatch version    : 10.2.0.1.0

OUI version       : 10.2.0.1.0

OUI location      : /oracle/db/oui

Log file location : /oracle/db/cfgtoollogs/opatch/opatch-2006_Mar_23_16-05-40-CST_Thu.log

ApplySession applying interim patch '4933302' to OH '/oracle/db'

Invoking fuser to check for active processes.

OPatch finds following executables active:

/oracle/db/bin/oracle

Before you proceed, stop all active processes.  Press when ready.

Do you want to proceed? [y|n]

Could not recognize input. Please re-enter.

y

User Responded with: Y

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/oracle/db')

Is the local system ready for patching?

Do you want to proceed? [y|n]

y

User Responded with: Y

Backing up files and inventory (not for auto-rollback) for the Oracle Home

Backing up files affected by the patch '4933302' for restore. This might take a while...

Backing up files affected by the patch '4933302' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.1.0...

Updating archive file "/oracle/db/lib/libserver10.a"  with "lib/libserver10.a/knahs.o"

Updating archive file "/oracle/db/lib/libserver10.a"  with "lib/libserver10.a/knalf.o"

Updating archive file "/oracle/db/lib/libserver10.a"  with "lib/libserver10.a/knals.o"

Updating archive file "/oracle/db/lib/libserver10.a"  with "lib/libserver10.a/knalsp.o"

Updating archive file "/oracle/db/lib/libserver10.a"  with "lib/libserver10.a/knas.o"

Running make for target ioracle

ApplySession adding interim patch '4933302' to inventory

The local system has been patched and can be restarted.

OPatch succeeded.

再检查已安装的补丁：oracle@IntelRAC1:~/4933302> opatch lsinventory

Invoking OPatch 10.2.0.1.0

Oracle interim Patch Installer version 10.2.0.1.0

Copyright (c) 2005, Oracle Corporation.  All rights reserved..

Oracle Home       : /oracle/db

Central Inventory : /oracle/oraInventory

from           : /oracle/db/oraInst.loc

OPatch version    : 10.2.0.1.0

OUI version       : 10.2.0.1.0

OUI location      : /oracle/db/oui

Log file location : /oracle/db/cfgtoollogs/opatch/opatch-2006_Mar_23_16-10-44-CST_Thu.log

Lsinventory Output file location : /oracle/db/cfgtoollogs/opatch/lsinv/lsinventory-2006_Mar_23_16-10-44-CST_Thu.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle Database 10g                                                  10.2.0.1.0

There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch  4933302      : applied on Thu Mar 23 16:10:15 CST 2006

Created on 27 Feb 2006, 16:57:02 hrs US/Pacific

Bugs fixed:

4373733

--------------------------------------------------------------------------------

OPatch succeeded.

补丁安装成功。

重起数据库：

sqlplus / as sysdba

startup open;

SQL> startup open;

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE instance started.

Total System Global Area 2097152000 bytes

Fixed Size                  2022080 bytes

Variable Size             738198848 bytes

Database Buffers         1342177280 bytes

Redo Buffers               14753792 bytes

Database mounted.

Database opened.

上面的方法 显示的是给Oracle10g 打的补丁，Oracle11g同样受用！