【Oracle】RAC10.2.0.1升级10.2.0.5(四)

2014-11-24 09:01:04 · 作者: · 浏览: 1
oot.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/oracle/product/10.2.0/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.

数据库软件升级完毕后开始升级数据库

版本升级后,在新的版本下,字典表中某些对象的属性也需要随之改变。所以,需要继续升级一下数据库,更新数据库字典。

rac1节点:

[root@rac1 ~]# cd /u01/app/oracle/product/10.2.0/db_1/bin/

[root@rac1 bin]# ./crsctl start crs

Attempting to start CRS stack

The CRS stack will be started shortly

rac2节点:

[root@rac1 ~]# cd /u01/app/oracle/product/10.2.0/db_1/bin/

[root@rac1 bin]# ./crsctl start crs

Attempting to start CRS stack

The CRS stack will be started shortly

[oracle@rac1 ~]$ crs_stat -t

Name Type Target State Host

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

ora....B1.inst application ONLINE OFFLINE

ora....B2.inst application ONLINE OFFLINE

ora.RACDB.db application ONLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE rac1

ora....C1.lsnr application ONLINE ONLINE rac1

ora.rac1.gsd application ONLINE ONLINE rac1

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip application ONLINE ONLINE rac1

ora....SM2.asm application ONLINE ONLINE rac2

ora....C2.lsnr application ONLINE ONLINE rac2

ora.rac2.gsd application ONLINE ONLINE rac2

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip application ONLINE ONLINE rac2

[oracle@rac1 ~]$ dbua

\

\

\

\

\

\

\

\

\

\

\

至此升级完毕:

[oracle@rac1 ~]$ crs_stat -t

Name Type Target State Host

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

ora....B1.inst application ONLINE ONLINE rac1

ora....B2.inst application ONLINE ONLINE rac2

ora.RACDB.db application ONLINE ONLINE rac2

ora....SM1.asm application ONLINE ONLINE rac1

ora....C1.lsnr application ONLINE ONLINE rac1

ora.rac1.gsd application ONLINE ONLINE rac1

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip application ONLINE ONLINE rac1

ora....SM2.asm application ONLINE ONLINE rac2

ora....C2.lsnr application ONLINE ONLINE rac2

ora.rac2.gsd application ONLINE ONLINE rac2

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip application ONLINE ONLINE rac2

SQL> select comp_name,version,status from dba_registry;

COMP_NAME VERSION STATUS

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

Oracle Enterprise Manager 10.2.0.5.0 VALID

Spatial 10.2.0.5.0 VALID

Oracle interMedia 10.2.0.5.0 VALID

OLAP Catalog 10.2.0.5.0 VALID

Oracle XML Database 10.2.0.5.0 VALID

Oracle Text 10.2.0.5.0 VALID

Oracle Expression Filter 10.2.0.5.0 VALID

Oracle Rule Manager 10.2.0.5.0 VALID

Oracle Workspace Manager 10.2.0.5.0 VALID

Oracle Data Mining 10.2.0.5.0 VALID

Oracle Database Catalog Views 10.2.0.5.0 VALID

Oracle Database Packages and Types 10.2.0.5.0 VALID

JServer JAVA Virtual Machine 10.2.0.5.0 VALID

Oracle XDK 10.2.0.5.0 VALID

Oracle Database Java Packages 10.2.0.5.0 VALID

OLAP Analytic Workspace 10.2.0.5.