Translate into your own language

Friday, April 15, 2016

ORA-15001: diskgroup "'+DATA_DISK" does not exist or is not mounted after OS Patching

We regularly encounter this type of error when Linux admin apply the patch on database server.
But when the Linux team confirms and you try to start the database you can see the below error:

Note- It has nothing to do with the database

ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA_DISK/DBNAME/spfileDBNAME.ora'
ORA-17503: ksfdopn:10 Failed to open file +DATA_DISK/DBNAME/spfileDBNAME.ora
ORA-15056: additional error message
ORA-15001: diskgroup "'+DATA_DISK" does not exist or is not mounted

No need to worry here. We can simply match the "oracleasm" and "kernal" version.
if it does not match then immediatly contact Linux team who performed the patch.
Below are the simple steps for matching:

[oracle@host1~]$ uname -a
Linux tryprorarac2c.intra.searshc.com 2.6.18-408.el5xen #1 SMP Fri Dec 11 14:07:27 EST 2015 x86_64 x86_64 x86_64 GNU/Linux

[oracle@host1 ~]$ rpm -qa |grep oracleasm
oracleasmlib-2.0.4-1.el5
oracleasm-support-2.1.8-1.el5
oracleasm-2.6.18-408.el5-2.0.5-1.el5
[oracle@host1~]$ uname -r
2.6.18-408.el5xen
[oracle@host1~]$

Linux team will update the oracleasm version to match with the kernal version and then we can start the database successfully.

Now match the "oracleasm" and "kernal" version again and verify again. We can see it matches perfectly.

[oracle@host1~]$ rpm -qa |grep oracleasm
oracleasm-2.6.18-408.el5xen-2.0.5-1.el5
oracleasmlib-2.0.4-1.el5
oracleasm-support-2.1.8-1.el5
[oracle@host1~]$ uname -r
2.6.18-408.el5xen

No comments:

Post a Comment