Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL> select status from v$instance;
STATUS
------------
OPEN MIGRATE
--编译无效对象
SQL> @/u01/app/oracle/product/11.2.0.3/db_1/rdbms/admin/utlrp.sql
--执行升级脚本
SQL> @/u01/app/oracle/product/11.2.0.3/db_1/rdbms/admin/catupgrd.sql
执行完后会自动 shutdown immediate，而且执行时间比较长
[oracle@redhat6 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sun Dec 8 04:13:52 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 208769024 bytes
Fixed Size 2226936 bytes
Variable Size 142607624 bytes
Database Buffers 58720256 bytes
Redo Buffers 5214208 bytes
Database mounted.
Database opened.
SQL> select status from v$instance;
STATUS
------------
OPEN