Wednesday, January 20, 2010

Creating Database 11gR1 on ASM 11gR2

On Forums - show 10g database creating with 11gR2 ASM failed.
If we check on oracle support, we can use [ID 949073.1] ... That's helpful issue to fix.

To run older databases on 11gR2 ASM and Clusterware we need to create a persistent configuration for the nodes(pinning a node). Because Cluster configuration in 11gR2 is dynamic. This dynamic configuration is incompatible with older database releases.

On Oracle Document about "Pinning Cluster Nodes for Oracle Database Release 10.x or 11.x".

Time To Test It... (Creating Database 11gR1 on ASM 11gR2) and error.
ORA-19624: operation failed, retry possible
ORA-19870: error while restoring backup piece /oracle/product/11.1/db/assistants/dbca/templates/Seed_Database.dfb
ORA-19504: failed to create file "+DISK02"
ORA-17502: ksfdcre:4 Failed to create file +DISK02
ORA-15001: diskgroup "DISK02" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5662
ORA-06512: at line 40
Check ASM... about database compatibility.
SQL> select name, compatibility, database_compatibility, state from v$asm_diskgroup_stat;

------------------------------ --------------- --------------- -----------
then pin node, by crsctl pin css
# cd /oracle/grid2/
# cd bin/
# ./olsnodes -t -n
rhel5-test 1 Unpinned

# ./crsctl pin css -n rhel5-test
CRS-4664: Node rhel5-test successfully pinned.

# ./olsnodes -t -n
rhel5-test 1 Pinned
then create database again... and no problem.

then register my database(11gR1) in Grid.
$ srvctl add database -d orcl11gr1 -o /oracle/product/11.1/db -p +DISK02/orcl11gr1/spfileorcl11gr1.ora -y AUTOMATIC
$ srvctl add instance -d orcl11gr1 -i orcl11gr1 -n rhel5-test

$ srvctl start database -d orcl11gr1
$ srvctl status database -d orcl11gr1
Instance orcl11gr1 is running on node rhel5-test

$ ./crsstat ora.orcl11gr1
HA Resource Target State (Host)
----------- ------ -----
ora.orcl11gr1.db ONLINE ONLINE on rhel5-test


Anonymous said...

Hi Surachart,

I am planning an upgrade of an oracle RAC database 11gR1 to 11gR2 which is sharing the ASM instance (same ASM disk groups) and the clusterware with one other 11gR1 instance. can you please let me know if i need to pin the other 11gR1 instance while doing the upgrade to 11gR2 for the first one?

thank you for you help

Surachart said...

I'm curious what you want to do. You should upgrade 11gR1 Cluster -> 11gR2 Grid Infrastructure ....

After you've done ... you are upgraded RAC + ASM .... you may check "./olsnodes -t -n" ... nodes are pinned .. if not you can pin them

and then upgrade database

Anonymous said...

thank you for your quick reply. it's just that i am not clear on the different steps to followin.
here is the current environment:
1) 2 databases 11gR1 (1 RAC UPLTEST, 1 standalone UPLDEV) both using same ASM instance)
2) cluster has one home, database one home seperate
3) ASM under database home

can you please let me know the steps? basically i want to upgrade UPLTEST to 11gR2 (use SCAN and move OCR and voting under ASM).

no technical commands required just steps and order (should it be done on the 2 nodes?)

thank you for your help

Surachart said...

1. Upgrade Cluster -> Grid Infrastructure (RAC + ASM)
*** on 11gR2, ASM is used in Grid Infrastructure.

2 . If you not upgrade database. You can start database (rac) and database standalone. If error as me ... check nodes and pin them