日期:2014-05-16  浏览次数:20620 次

Oracle 静默模式升级数据库

因X window原因不能启动图形界面,采用静默模式升级数据库,即10.2.0.1升级至10.2.0.4。
操作系统版本为
引用
$ oslevel -r
5300-06

升级步骤大致如下:
1、编辑升级介质中的../Disk1/response/patchset.rsp文件,主要编辑以下条目
UNIX_GROUP_NAME="oinstall"
FROM_LOCATION="/oracle/Disk1/stage/products.xml"
ORACLE_HOME="/oracle/app/oracle/product/10.2/db_2"
ORACLE_HOME_NAME="OUIHome2"
注意ORACLE_HOME_NAME可以从../oraInventory/ContentsXML/inventory.xml文件中HOME NAME获取。
2、升级Oracle软件,刷新数据字典,不再赘述
引用
$ ./runInstaller -silent -ignoreDiskWarning -responseFile /oracle/Disk1/response/patchset.rsp

3、执行root.sh
引用
$ su
root's Password:
# /oracle/app/oracle/product/10.2/db_2/root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /oracle/app/oracle/product/10.2/db_2

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.


附升级过程显示日志:

引用
$ ./runInstaller -silent -ignoreDiskWarning -responseFile /oracle/Disk1/response/patchset.rsp
********************************************************************************

Your platform requires the root user to perform certain pre-installation
OS preparation.  The root user should execute '/usr/sbin/slibclean' on all the nodes before
you proceed with Patchset Installation.

Answer 'y' if root has run '/usr/sbin/slibclean' so you can proceed with Oracle
Patchset installation.
Answer 'n' to abort installation and then ask root to run '/usr/sbin/slibclean'.

********************************************************************************
Has '/usr/sbin/slibclean' been run by root? [y/n] (n)
y

Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be 5200, 5300 or 6100
                                      Passed


All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-02-27_03-32-47AM. Please wait ...$ Oracle Universal Installer, Version 10.2.0.4.0 Production
Copyright (C) 1999, 2008, Oracle. All rights reserved.

You can find a log of this install session at:
/oracle/app/oracle/oraInventory/logs/installActions2010-02-27_03-32-47AM.log
.................................................................................................... 100% Done.


Loading Product Information
.......................................................................................................... 100% Done.


Starting execution of Prerequisites...
Total No of checks: 2

Performing check for checkToInstallCCR
Checking the Components installed in Oracle Home
Check complete. The overall result of this check is: Passed


Check complete: Passed
==========================