Home > problem-cause-solution > ORA-15032 Problem while dropping disks from disk group in (HPUX 11.31 ASM 11gR2 standalone db)

ORA-15032 Problem while dropping disks from disk group in (HPUX 11.31 ASM 11gR2 standalone db)


ORA-15032 Problem while dropping disks from disk group in ASM.

PROBLEM:

SQL> ALTER DISKGROUP DATA DROP DISK DATA_0003;

 

Diskgroup altered.

 

SQL>

SQL>

SQL>

SQL> SELECT name, header_status, path FROM V$ASM_DISK

2  ;

 

NAME                           HEADER_STATU PATH

—————————— ———— ——————————

FORMER       /dev/rdisk/disk14

DATA_0001                      MEMBER       /dev/rdisk/disk15

DATA_0002                      MEMBER       /dev/rdisk/disk16

DATA_0003                      MEMBER       /dev/rdisk/disk17

DATA_0004                      MEMBER       /dev/rdisk/disk38

DATA_0005                      MEMBER       /dev/rdisk/disk39

DATA_0006                      MEMBER       /dev/rdisk/disk40

DATA_0007                      MEMBER       /dev/rdisk/disk41

DATA_0008                      MEMBER       /dev/rdisk/disk42

DATA_0009                      MEMBER       /dev/rdisk/disk43

DATA_0010                      MEMBER       /dev/rdisk/disk44

DATA_0011                      MEMBER       /dev/rdisk/disk45

DATA_0012                      MEMBER       /dev/rdisk/disk46

DATA_0013                      MEMBER       /dev/rdisk/disk47

 

14 rows selected.

 

SQL> SELECT name, type, total_mb, free_mb, required_mirror_free_mb, usable_file_mb FROM V$ASM_DISKGROUP;

 

NAME                           TYPE     TOTAL_MB    FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB

—————————— —— ———- ———- ———————– ————–

DATA                           EXTERN    5888000    5748724                       0        5748724

 

SQL>

SQL>

SQL> ALTER DISKGROUP DATA rebalance wait;

ALTER DISKGROUP DATA rebalance wait

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15001: diskgroup “DATA” does not exist or is not mounted

 

 

SQL> ALTER DISKGROUP DATA rebalance;

ALTER DISKGROUP DATA rebalance

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15001: diskgroup “DATA” does not exist or is not mounted

 

SQL>

 

 

CAUSE :

To be honest I cannot find the real cause, only the side effect. I tried running asmca, if it caused this, but cannnot reproduce the case. All I know is I had rebooted the OS, and then login to asmcmd, made some alterations, run asmca, and after a while I got this error.

trlogdb01:/dev/rdisk#ll

total 0

crw-r—–   1 bin        sys         13 0x00000a Oct 13 16:48 disk14

crw-r—–   1 bin        sys         13 0x00000b Oct 13 16:53 disk15

crw-r—–   1 bin        sys         13 0x00000c Oct 13 16:53 disk16

crw-r—–   1 bin        sys         13 0x00000d Oct 13 16:53 disk17

crw-r—–   1 bin        sys         13 0x000000 May 13 12:44 disk3

crw-r—–   1 bin        sys         13 0x00000f Oct 13 16:56 disk38

crw-r—–   1 bin        sys         13 0x000010 Oct 13 16:56 disk39

crw-r—–   1 bin        sys         13 0x000006 May 13 12:44 disk3_p1

crw-r—–   1 bin        sys         13 0x000007 May 13 12:44 disk3_p2

crw-r—–   1 bin        sys         13 0x000008 May 13 12:44 disk3_p3

crw-r—–   1 bin        sys         13 0x000001 May 13 12:44 disk4

crw-r—–   1 bin        sys         13 0x000011 Oct 13 16:56 disk40

crw-r—–   1 bin        sys         13 0x000012 Oct 13 16:56 disk41

crw-r—–   1 bin        sys         13 0x000013 Oct 13 16:53 disk42

crw-r—–   1 bin        sys         13 0x000014 Oct 13 16:53 disk43

crw-r—–   1 bin        sys         13 0x000015 Oct 13 16:53 disk44

crw-r—–   1 bin        sys         13 0x000016 Oct 13 16:53 disk45

crw-r—–   1 bin        sys         13 0x000017 Oct 13 16:53 disk46

crw-r—–   1 bin        sys         13 0x000018 Oct 13 16:56 disk47

crw-r—–   1 bin        sys         13 0x000002 May 13 12:44 disk5

crw-r—–   1 bin        sys         13 0x000003 May 13 12:44 disk5_p1

crw-r—–   1 bin        sys         13 0x000004 May 13 12:44 disk5_p2

crw-r—–   1 bin        sys         13 0x000005 May 13 12:44 disk5_p3

 

 

SOLUTION:

trlogdb01:/dev/rdisk#chown oracle:dba disk14 disk15 disk16 disk17

trlogdb01:/dev/rdisk#ll

total 0

crw-r—–   1 oracle     dba         13 0x00000a Oct 13 16:48 disk14

crw-r—–   1 oracle     dba         13 0x00000b Oct 13 16:53 disk15

crw-r—–   1 oracle     dba         13 0x00000c Oct 13 16:53 disk16

crw-r—–   1 oracle     dba         13 0x00000d Oct 13 16:53 disk17

crw-r—–   1 bin        sys         13 0x000000 May 13 12:44 disk3

crw-r—–   1 oracle     dba         13 0x00000f Oct 13 16:56 disk38

crw-r—–   1 oracle     dba         13 0x000010 Oct 13 16:56 disk39

crw-r—–   1 bin        sys         13 0x000006 May 13 12:44 disk3_p1

crw-r—–   1 bin        sys         13 0x000007 May 13 12:44 disk3_p2

crw-r—–   1 bin        sys         13 0x000008 May 13 12:44 disk3_p3

crw-r—–   1 bin        sys         13 0x000001 May 13 12:44 disk4

crw-r—–   1 oracle     dba         13 0x000011 Oct 13 16:56 disk40

crw-r—–   1 oracle     dba         13 0x000012 Oct 13 16:56 disk41

crw-r—–   1 oracle     dba         13 0x000013 Oct 13 16:53 disk42

crw-r—–   1 oracle     dba         13 0x000014 Oct 13 16:53 disk43

crw-r—–   1 oracle     dba         13 0x000015 Oct 13 16:53 disk44

crw-r—–   1 oracle     dba         13 0x000016 Oct 13 16:53 disk45

crw-r—–   1 oracle     dba         13 0x000017 Oct 13 16:53 disk46

crw-r—–   1 oracle     dba         13 0x000018 Oct 13 16:56 disk47

crw-r—–   1 bin        sys         13 0x000002 May 13 12:44 disk5

crw-r—–   1 bin        sys         13 0x000003 May 13 12:44 disk5_p1

crw-r—–   1 bin        sys         13 0x000004 May 13 12:44 disk5_p2

crw-r—–   1 bin        sys         13 0x000005 May 13 12:44 disk5_p3

 

 

 

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

Blog do PHP

Oracle DBA for rookies!

nimaidba

Welcome to the world of Oracle with me....

Tech

News and reviews from the world of gadgets, gear, apps and the web

WordPress.com

WordPress.com is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.

%d bloggers like this: