Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Tuesday, 9 October 2012

DBCA Not showing ASM Diskgroup in 11.2.0.1 RAC

There was a requirement to create one RAC database (11.2.0.1) running on Oracle Enterprise Linux 5.6.

DBCA was running fine for creating database until selecting the location for datafiles. When i was selecting ASM as an storage then this process is aborting clusterware services and unmounting ASM Diskgroup.


Expected is it should select the available disk group by default. But when i trying to browse the Disk group then its  aborting the clusterware services and unmounting the diskgroup from where we've executed dbca.

Error log from clusterware:


[client(7361)]CRS-1013:The OCR location in an ASM disk group is inaccessible. Details in /u01/11g_grid/grid/log/oelrac1/client/crsctl.log.
2012-10-09 12:03:00.730
[client(7400)]CRS-1013:The OCR location in an ASM disk group is inaccessible. Details in /u01/11g_grid/grid/log/oelrac1/client/crsctl.log.
2012-10-09 13:40:01.031
[client(11408)]CRS-1013:The OCR location in an ASM disk group is inaccessible. Details in /u01/11g_grid/grid/log/oelrac1/client/crsctl.log.
[client(11691)]CRS-10001:ADVM/ACFS is not supported on oraclelinux-release-5-6.0.1

[client(11724)]CRS-10001:ADVM/ACFS is not supported on oraclelinux-release-5-6.0.1

[client(11772)]CRS-10001:ADVM/ACFS is not supported on oraclelinux-release-5-6.0.1

[client(11805)]CRS-10001:ADVM/ACFS is not supported on oraclelinux-release-5-6.0.1

[client(11838)]CRS-10001:ADVM/ACFS is not supported on oraclelinux-release-5-6.0.1

[client(11871)]CRS-10001:ADVM/ACFS is not supported on oraclelinux-release-5-6.0.1



solution:

>> Edit file /tmp/.linux_release

>> change  value "enterprise-release-5-0.0.17"

[root@oelrac1 tmp]# more .linux_release 
enterprise-release-5-0.0.17
[root@oelrac1 tmp]#


>> original value "oraclelinux-release-5-6.0.1"

>> restart clusterware services on all cluster nodes one after the other

>> Run dbca, now it should create database without issues on ASM diskgroup:



- Here its selected +RACDATA asm diskgroup by default.

Thanks for reading

No comments: