Friday, September 17, 2010

run root.sh script to configure Oracle Grid Infrastructure 11.2.0.2

After I struggled to Upgrade Oracle Database 11.2.0.1 to 11.2.0.2, I fixed some... for using "rootupgrade.sh" and done with oracle database upgrading. but I felt curious some
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
My database is 11.2.0.2, but some...
$ /oracle/product/11.2.0/grid_new/bin/crsctl stat res ora.orcl.db -p | grep VERSION
VERSION=11.2.0.1.0
# /oracle/product/11.2.0/grid_new/bin/crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.2.0]
# /oracle/product/11.2.0/grid_new/bin/crsctl query has softwareversion
Oracle High Availability Services version on the local node is [11.2.0.1.0]
so, I'd like to run "root.sh" and add old resources.
$ /oracle/product/11.2.0/grid_new/bin/crsctl stat res -p > /tmp/old_resourses
start to run "root.sh"
# mv /etc/oracle/olr.loc /etc/oracle/olr.loc.bak
# /oracle/product/11.2.0/grid_new/root.sh
Running Oracle 11g root script...

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/product/11.2.0/grid_new

Enter the full pathname of the 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 Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /oracle/product/11.2.0/grid_new/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'oracle', privgrp 'oinstall'..
Operation successful.
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Check failed, or completed with errors.
PROT-29: The Oracle Cluster Registry location is already configured
Replace of older local-only OCR failed
CRS-4664: Node oel successfully pinned.
Adding daemon to inittab
ACFS-9459: ADVM/ACFS is not supported on this OS version: '2.6.35.4'
oel 2010/09/18 00:03:28 /oracle/product/11.2.0/grid_new/cdata/oel/backup_20100918_000328.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
then add resources by manual, Example:
$ export ORACLE_HOME=/oracle/product/11.2.0/grid_new
$ export CRS_HOME=/oracle/product/11.2.0/grid_new
$ export ORA_CRS_HOME=/oracle/product/11.2.0/grid_new
$ /oracle/product/11.2.0/grid_new/bin/srvctl add listener -l LISTENER -o /oracle/product/11.2.0/grid_new
$ /oracle/product/11.2.0/grid_new/bin/srvctl add asm -l LISTENER -p +DATA/asm/asmparameterfile/registry.253.729824635 -d +DATA
$ /oracle/product/11.2.0/grid_new/bin/srvctl add database -d orcl -o /oracle/product/11.2.0/dbhome_2 -p +DATA/orcl/spfileorcl.ora -y AUTOMATIC
and then check
# /oracle/product/11.2.0/grid_new/bin/crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.2.0]
# /oracle/product/11.2.0/grid_new/bin/crsctl query has softwareversion
Oracle High Availability Services version on the local node is [11.2.0.2.0]
$ /oracle/product/11.2.0/grid_new/bin/crsctl stat res ora.orcl.db -p | grep VERSION
VERSION=11.2.0.2.0
After used this idea, I feel everything well for me. However this post, I just curious about Oracle HAS version on the local node.

2 comments:

Don Seiler said...

Maybe it was this bug?

Standalone GI: init.ohasd/ohasd not updated after 11201 to 11202 upgrade (Doc ID 1233183.1)

Surachart said...

Thank you so much.

I think It's bug... sure :)


Standalone GI: init.ohasd/ohasd not updated after 11201 to 11202 upgrade [ID 1233183.1]