探索Oracle之数据库升级二11.2.0.3升级到11.2.0.4完整步骤(四)

2015-02-02 23:09:37 · 作者: · 浏览: 74
51304589 Oct 3 06:54p13390677_112040_Linux-x86-64_2of7.zip [oracle@db01 ~]$ unzipp13390677_112040_Linux-x86-64_1of7.zip [oracle@db01 ~]$ unzipp13390677_112040_Linux-x86-64_2of7.zip

5、 开始安装

6、 执行root.sh脚本

[root@db01 ~]#/DBSoft/Product/11.2.4/db_1/root.sh 

Performing root useroperation for Oracle 11g 

 
The following environmentvariables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /DBSoft/Product/11.2.4/db_1

 
Enter the full pathname ofthe local bin directory: [/usr/local/bin]: 
The contents of"dbhome" have not changed. No need to overwrite.
The contents of"oraenv" have not changed. No need to overwrite.
The contents of"coraenv" have not changed. No need to overwrite.

 
Entries will be added to the/etc/oratab file as needed by
Database ConfigurationAssistant when a database is created
Finished running genericpart of root script.
Now product-specific rootactions will be performed.
Finished product-specificroot actions.

[root@db01 ~]#

7、至此11.2.0.4的软件就已经装完了,修改Oracle环境变量

[root@db01 ~]# su - oracle
[oracle@db01 ~]$ vi.bash_profile                   -------修改如下行,将11.2.3改成11.2.4即可
export ORACLE_HOME=$ORACLE_BASE/Product/11.2.4/db_1

[oracle@db01 ~]$ vi /etc/oratab                     -------修改如下行11.2.3为11.2.4
woo:/DBSoft/Product/11.2.4/db_1:N

[oracle@db01 admin]$ cp/DBSoft/Product/11.2.3/db_1/dbs/* /DBSoft/Product/11.2.4/db_1/dbs/

8、 拷贝监听配置文件

[oracle@db01 admin]$ source~/.bash_profile 
[oracle@db01 admin]$ pwd
/DBSoft/Product/11.2.3/db_1/network/admin

[oracle@db01 admin]$ cd$ORACLE_HOME/network/admin
[oracle@db01 admin]$ ls

samples  shrept.lst

[oracle@db01 admin]$ cp -r/DBSoft/Product/11.2.3/db_1/network/admin/* $ORACLE_HOME/network/admin
[oracle@db01 admin]$ ls
listener.ora  samples shrept.lst  sqlnet.ora  tnsnames.ora

9、执行预升级脚本检查

[oracle@db01 dbs]$ sqlplus /as sysdba

 
SQL*Plus: Release 11.2.0.4.0Production on Sat Oct 4 02:26:01 2014
Copyright (c) 1982, 2013,Oracle.  All rights reserved.
Connected to an idleinstance.

 
SQL> startup upgrade;

ORACLE instance started.
Total System Global Area2037673984 bytes
Fixed Size                  2254704 bytes
Variable Size            1811941520 bytes
Database Buffers          218103808 bytes
Redo Buffers                5373952 bytes
Database mounted.
Database opened.

SQL>@?/rdbms/admin/utlu112i.sql    ---执行升级前检查

Oracle Database 11.2Pre-Upgrade Information Tool 10-04-2014 02:27:38
Script Version: 11.2.0.4.0Build: 001
.
**********************************************************************
Database:
**********************************************************************

--> name:          WOO
--> version:       11.2.0.3.0
--> compatible:    11.2.0.0.0
--> blocksize:     8192
--> platform:      Linux x86 64-bit
--> timezone file: V14
.
**********************************************************************
Tablespaces: [makeadjustments in the current environment]
**********************************************************************

--> SYSTEM tablespace isadequate for the upgrade.
.... minimum required size:917 MB
--> SYSAUX tablespace isadequate for the upgrade.
.... minimum required size:646 MB
--> UNDOTBS1 tablespaceis adequate for the upgrade.
.... minimum required size:400 MB
--> TEMP tablespace isadequate for the upgrade.
.... minimum required size:60 MB
.
**********************************************************************
Flashback: OFF
******