oracle 11g升级
上一篇 / 下一篇 2010-03-23 11:03:04 / 个人分类：DB
这几天一直在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_HOME/OPatch
检查补丁情况：
oracle@IntelRAC1:~> cd 4933302/
oracle@IntelRAC1:~/4933302> opatch lsinventory
Invoking OPatch 10.2.0.1.0
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..
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):
Installed Top-level Products (1):
Oracle Database 10g 10.2.0.1.0
There are 1 products installed in this Oracle Home.
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;
sqlplus / as sysdba
shutdown immediate;
Oracle interim Patch Installer version 10.2.0.1.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..
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 <Enter> when ready.
Do you want to proceed? [y|n]
Invoking fuser to check for active processes.
OPatch finds following executables active:
/oracle/db/bin/oracle
Before you proceed, stop all active processes. Press <Enter> when ready.
Do you want to proceed? [y|n]
Could not recognize input. Please re-enter.
y
User Responded with: Y
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...
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
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 interim Patch Installer version 10.2.0.1.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..
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):
Installed Top-level Products (1):
Oracle Database 10g 10.2.0.1.0
There are 1 products installed in this Oracle Home.
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
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.
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.
Fixed Size 2022080 bytes
Variable Size 738198848 bytes
Database Buffers 1342177280 bytes
Redo Buffers 14753792 bytes
Database mounted.
Database opened.
上面的方法 显示的是给Oracle10g 打的补丁，Oracle11g同样受用！
TAG:
