Shulou(Shulou.com)06/01 Report--

Oracle? Database 10g Release 2 (10.2.0) RAC for RedHat4

Upgrade from Oracle Rac 10.2.0.1 to 10.2.0.5

Upgrade Clusterware-Rolling upgrade

Upgrade database software-upgrade after deactivation

Upgrade the database

Part I: rolling upgrade of clusterware $CRS_HOME

1. System environment

Operating system version

[root@ordb1] # uname-a

Linux ordb1 2.6.9-55.ELsmp # 1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686 i386 GNU/Linux

CRS version

[oracle@ordb1 ~] $crsctl query crs softwareversion

CRS software version on node [ordb1] is [10.2.0.1.0]

[oracle@ordb1 ~] $crsctl query crs activeversion

CRS active version on the cluster is [10.2.0.1.0]

Database version:

[oracle@ordb2 ~] $sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0-Production on Tue Mar 15 09:47:45 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL > select * from gv$version

INST_ID BANNER

-

2 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Prod

2 PL/SQL Release 10.2.0.1.0-Production

2 CORE 10.2.0.1.0 Production

2 TNS for Linux: Version 10.2.0.1.0-Production

2 NLSRTL Version 10.2.0.1.0-Production

1 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Prod

1 PL/SQL Release 10.2.0.1.0-Production

1 CORE 10.2.0.1.0 Production

1 TNS for Linux: Version 10.2.0.1.0-Production

1 NLSRTL Version 10.2.0.1.0-Production

10 rows selected.

Cluster status

[oracle@ordb1] $crs_stat-t

Name Type Target State Host

Ora.orcl.db application ONLINE ONLINE ordb2

Ora....l1.inst application ONLINE ONLINE ordb1

Ora....l2.inst application ONLINE ONLINE ordb2

Ora....SM1.asm application ONLINE ONLINE ordb1

Ora....B1.lsnr application ONLINE ONLINE ordb1

Ora.ordb1.gsd application ONLINE ONLINE ordb1

Ora.ordb1.ons application ONLINE ONLINE ordb1

Ora.ordb1.vip application ONLINE ONLINE ordb1

Ora....SM2.asm application ONLINE ONLINE ordb2

Ora....B2.lsnr application ONLINE ONLINE ordb2

Ora.ordb2.gsd application ONLINE ONLINE ordb2

Ora.ordb2.ons application ONLINE ONLINE ordb2

Ora.ordb2.vip application ONLINE ONLINE ordb2

Close Node 1

$emctl stop dbconsole

TZ set to PRC

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

Http://ordb1:1158/em/console/aboutApplication

Stopping Oracle Enterprise Manager 10g Database Control...

... Stopped.

$isqlplusctl stop

ISQL*Plus 10.2.0.1.0

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Getnameinfo failed

ISQL*Plus instance on port 5560 is not running...

Srvctl stop instance-d orcl-I orcl1

Name Type Target State Host

Ora.orcl.db application ONLINE ONLINE ordb2

Ora....l1.inst application OFFLINE OFFLINE

Ora....l2.inst application ONLINE ONLINE ordb2

Ora....SM1.asm application ONLINE ONLINE ordb1

Ora....B1.lsnr application ONLINE ONLINE ordb1

Ora.ordb1.gsd application ONLINE ONLINE ordb1

Ora.ordb1.ons application ONLINE ONLINE ordb1

Ora.ordb1.vip application ONLINE ONLINE ordb1

Ora....SM2.asm application ONLINE ONLINE ordb2

Ora....B2.lsnr application ONLINE ONLINE ordb2

Ora.ordb2.gsd application ONLINE ONLINE ordb2

Ora.ordb2.ons application ONLINE ONLINE ordb2

Ora.ordb2.vip application ONLINE ONLINE ordb2

Srvctl stop asm-n orcl1

Name Type Target State Host

Ora.orcl.db application ONLINE ONLINE ordb2

Ora....l1.inst application OFFLINE OFFLINE

Ora....l2.inst application ONLINE ONLINE ordb2

Ora....SM1.asm application OFFLINE OFFLINE

Ora....B1.lsnr application ONLINE ONLINE ordb1

Ora.ordb1.gsd application ONLINE ONLINE ordb1

Ora.ordb1.ons application ONLINE ONLINE ordb1

Ora.ordb1.vip application ONLINE ONLINE ordb1

Ora....SM2.asm application ONLINE ONLINE ordb2

Ora....B2.lsnr application ONLINE ONLINE ordb2

Ora.ordb2.gsd application ONLINE ONLINE ordb2

Ora.ordb2.ons application ONLINE ONLINE ordb2

Ora.ordb2.vip application ONLINE ONLINE ordb2

Srvctl stop nodeapps-n ordb1

[oracle@ordb1] $crs_stat-t

Name Type Target State Host

Ora.orcl.db application ONLINE ONLINE ordb2

Ora....l1.inst application OFFLINE OFFLINE

Ora....l2.inst application ONLINE ONLINE ordb2

Ora....SM1.asm application OFFLINE OFFLINE

Ora....B1.lsnr application OFFLINE OFFLINE

Ora.ordb1.gsd application OFFLINE OFFLINE

Ora.ordb1.ons application OFFLINE OFFLINE

Ora.ordb1.vip application OFFLINE OFFLINE

Ora....SM2.asm application ONLINE ONLINE ordb2

Ora....B2.lsnr application ONLINE ONLINE ordb2

Ora.ordb2.gsd application ONLINE ONLINE ordb2

Ora.ordb2.ons application ONLINE ONLINE ordb2

Ora.ordb2.vip application ONLINE ONLINE ordb2

Upgrade Node 1 CRS

. / ruinstaller

The installer has detected that your Cluster Ready Services (CRS) installation is distributed across the following nodes:

Ordb1

Ordb2

Because the software consists of local identical copies distributed across each of the nodes in the cluster, it is possible to patch your CRS installation in a rolling manner, one node at a time.

To complete the installation of this patchset, you must perform. The following tasks on each node:

1. Log in as the root user.

2. As the root user, perform. The following tasks:

A. Shutdown the CRS daemons by issuing the following command:

/ oracle/product/10.2.0/crs/bin/crsctl stop crs

B. Run the shell script. Located at:

/ oracle/product/10.2.0/crs/install/root102.sh

This script. Will automatically start the CRS daemons on the

Patched node upon completion.

3. After completing this procedure, proceed to the next node and repeat.

[root@ordb2 ~] # / oracle/product/10.2.0/crs/bin/crsctl stop crs

Stopping resources.

Successfully stopped CRS resources

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

[root@ordb2 ~] # / oracle/product/10.2.0/crs/install/root102.sh

Creating pre-patch directory for saving pre-patch clusterware files

Completed patching clusterware files to / oracle/product/10.2.0/crs

Relinking some shared libraries.

Relinking of patched files is complete.

WARNING: directory'/ oracle/product/10.2.0' is not owned by root

WARNING: directory'/ oracle/product' is not owned by root

WARNING: directory'/ oracle' is not owned by root

Preparing to recopy patched init and RC scripts.

Recopying init and RC scripts.

Startup will be queued to init within 30 seconds.

/ etc/profile: line 55: ulimit: max user processes: cannot modify limit: Operation not permitted

Starting up the CRS daemons.

Waiting for the patched CRS daemons to start.

This may take a while on some systems.

.

10205 patch successfully applied.

Clscfg: EXISTING configuration version 3 detected.

Clscfg: version 3 is 10G Release 2.

Successfully deleted 1 values from OCR.

Successfully deleted 1 keys from OCR.

Successfully accumulated necessary OCR keys.

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

Node:

Node 2: ordb2 ordb2-priv ordb2

Creating OCR keys for user 'root', privgrp' root'..

Operation successful.

Clscfg-upgrade completed successfully

Creating'/ oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration

Setting CRS configuration values in / oracle/product/10.2.0/crs/install/paramfile.crs

[oracle@ordb1 ~] $crsctl query crs softwareversion

CRS software version on node [ordb1] is [10.2.0.5.0]

[oracle@ordb1 ~] $crsctl query crs activeversion

CRS active version on the cluster is [10.2.0.5.0]

[oracle@ordb2 ~] $crsctl query crs activeversion

CRS active version on the cluster is [10.2.0.5.0]

[oracle@ordb2 ~] $crsctl query crs softwareversion

CRS software version on node [ordb2] is [10.2.0.5.0]

Part II: database software upgrade

Pre-upgrade version:

Select comp_name,version,status from dba_registry

COMP_NAME VERSION STATUS

-

Oracle Database Catalog Views 10.2.0.1.0 VALID

Oracle Database Packages and T 10.2.0.1.0 VALID

Ypes

Oracle Workspace Manager 10.2.0.1.0 VALID

JServer JAVA Virtual Machine 10.2.0.1.0 VALID

Oracle XDK 10.2.0.1.0 VALID

Oracle Database Java Packages 10.2.0.1.0 VALID

Oracle Expression Filter 10.2.0.1.0 VALID

Oracle Data Mining 10.2.0.1.0 VALID

Oracle Text 10.2.0.1.0 VALID

COMP_NAME VERSION STATUS

-

Oracle XML Database 10.2.0.1.0 VALID

Oracle Rules Manager 10.2.0.1.0 VALID

Oracle interMedia 10.2.0.1.0 VALID

OLAP Analytic Workspace 10.2.0.1.0 VALID

Oracle OLAP API 10.2.0.1.0 VALID

OLAP Catalog 10.2.0.1.0 VALID

Spatial 10.2.0.1.0 VALID

Oracle Enterprise Manager 10.2.0.1.0 VALID

Oracle Real Application Cluste 10.2.0.1.0 VALID

Close dbconsole,isqlplus,asm, database

Node 1:

Emctl stop dbconsole

Isqlplusctl stop

Node 2:

Emctl stop dbconsole

Isqlplusctl stop

Node 1:

Srvctl stop instance-d orcl-I orcl1

Srvctl stop instance-d orcl-I orcl2

Srvctl stop asm-n ordb1

Srvctl stop asm-n ordb2

Srvctl stop nodeapps-n ordb1

Srvctl stop nodeapps-n ordb2

Upgrade Node ORACLE Software

. / ruinstaller

[root@ordb2 ~] # sh / oracle/product/10.2.0/db_1/root.sh

Running Oracle 10g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= / oracle/product/10.2.0/db_1

Enter the full pathname of the local bin directory: [/ usr/local/bin]:

The file "dbhome" already exists in / usr/local/bin. Overwrite it? (YBO)

[n]: y

Copying dbhome to / usr/local/bin...

The file "oraenv" already exists in / usr/local/bin. Overwrite it? (YBO)

[n]: y

Copying oraenv to / usr/local/bin...

The file "coraenv" already exists in / usr/local/bin. Overwrite it? (YBO)

[n]: y

Copying coraenv to / usr/local/bin...

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.

Srvctl start nodeapps-n ordb1

Srvctl start nodeapps-n ordb2

Srvctl start asm-n ordb1

Srvctl start asm-n ordb2

[oracle@ordb1] $crs_stat-t

Name Type Target State Host

Ora.orcl.db application OFFLINE OFFLINE

Ora....l1.inst application OFFLINE OFFLINE

Ora....l2.inst application OFFLINE OFFLINE

Ora....SM1.asm application ONLINE ONLINE ordb1

Ora....B1.lsnr application ONLINE ONLINE ordb1

Ora.ordb1.gsd application ONLINE ONLINE ordb1

Ora.ordb1.ons application ONLINE ONLINE ordb1

Ora.ordb1.vip application ONLINE ONLINE ordb1

Ora....SM2.asm application ONLINE ONLINE ordb2

Ora....B2.lsnr application ONLINE ONLINE ordb2

Ora.ordb2.gsd application ONLINE ONLINE ordb2

Ora.ordb2.ons application ONLINE ONLINE ordb2

Ora.ordb2.vip application ONLINE ONLINE ordb2

Oracle Database 10.2 Upgrade Status Utility 03-16-2011 09:39:53

.

Component Status Version HH:MM:SS

Oracle Database Server VALID 10.2.0.5.0 00:07:47

JServer JAVA Virtual Machine VALID 10.2.0.5.0 00:02:19

Oracle XDK VALID 10.2.0.5.0 00:00:40

Oracle Database Java Packages INVALID 10.2.0.5.0 00:00:54

Oracle Text VALID 10.2.0.5.0 00:00:33

Oracle XML Database VALID 10.2.0.5.0 00:01:35

Oracle Real Application Clusters VALID 10.2.0.5.0 00:00:02

Oracle Workspace Manager VALID 10.2.0.5.0 00:00:04

Oracle Data Mining VALID 10.2.0.5.0 00:00:33

OLAP Analytic Workspace VALID 10.2.0.5.0 00:00:19

OLAP Catalog VALID 10.2.0.5.0 00:00:56

Oracle OLAP API VALID 10.2.0.5.0 00:01:45

Oracle interMedia VALID 10.2.0.5.0 00:05:34

Oracle Expression Filter VALID 10.2.0.5.0 00:00:54

Spatial VALID 10.2.0.5.0 00:00:41

Oracle Rule Manager VALID 10.2.0.5.0 00:00:05

Oracle Enterprise Manager VALID 10.2.0.5.0 00:00:07

.

Oracle Database 10.2 Upgrade Status Utility 03-16-2011 09:39:53

.

Component Status Version HH:MM:SS

Oracle Database Server VALID 10.2.0.5.0 00:07:47

JServer JAVA Virtual Machine VALID 10.2.0.5.0 00:02:19

Oracle XDK VALID 10.2.0.5.0 00:00:40

Oracle Database Java Packages VALID 10.2.0.5.0 00:00:54

Oracle Text VALID 10.2.0.5.0 00:00:33

Oracle XML Database VALID 10.2.0.5.0 00:01:35

Oracle Real Application Clusters VALID 10.2.0.5.0 00:00:02

Oracle Workspace Manager VALID 10.2.0.5.0 00:00:04

Oracle Data Mining VALID 10.2.0.5.0 00:00:33

OLAP Analytic Workspace VALID 10.2.0.5.0 00:00:19

OLAP Catalog VALID 10.2.0.5.0 00:00:56

Oracle OLAP API VALID 10.2.0.5.0 00:01:45

Oracle interMedia VALID 10.2.0.5.0 00:05:34

Oracle Expression Filter VALID 10.2.0.5.0 00:00:54

Spatial VALID 10.2.0.5.0 00:00:41

Oracle Rule Manager VALID 10.2.0.5.0 00:00:05

Oracle Enterprise Manager VALID 10.2.0.5.0 00:00:07

.

Total Upgrade Time: 00:24:50

DOC > #

DOC > #

DOC >

DOC > The above PL/SQL lists the SERVER components in the upgraded

DOC > database, along with their current version and status.

DOC >

DOC > Please review the status and version columns and look for

DOC > any errors in the spool log file. If there are errors in the spool

DOC > file, or any components are not VALID or not the current version

DOC > consult the Oracle Database Upgrade Guide for troubleshooting

DOC > recommendations.

DOC >

DOC > Next shutdown immediate, restart for normal operation, and then

DOC > run utlrp.sql to recompile any invalid application objects.

DOC >

DOC > #

DOC > #

DOC > #

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup

ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size 1272600 bytes

Variable Size 155190504 bytes

Database Buffers 8388608 bytes

Redo Buffers 2920448 bytes

Database mounted.

Database opened.

If there are invalid components after the upgrade is complete, you can refer to the following documentation:

Metalink original text:

After upgrade CATPROC and CATALOG comps are INVALID even if only user invalid objects are found [ID 745183.1]

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.