topic Re: Oracle ASM question in Operating System - HP-UX

Oracle ASM question

Robert-Jan Goossens — Thu, 19 Mar 2009 11:36:52 GMT

Dear all,

The storage of this system is going to be moved to a new SAN. I'm trying to find what devices are under ASM control in a system.

# su - oracle
# export ORACLE_SID=+ASM1
# export ORACLE_HOME=/u01/app/oracle/product/10.2.0/asm
# asmcmd
ASMCMD> lsdg
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED EXTERN N N 512 4096 1048576 511976 357256 0 357256 0 DATA/
MOUNTED EXTERN N N 512 4096 1048576 511976 337552 0 337552 0 FLASH/

Is there an option or an asm command to list the devices within these asm diskgroups?

Regards,
Robert-Jan

Re: Oracle ASM question

T G Manikandan — Thu, 19 Mar 2009 13:41:54 GMT

Hi Robert,

How about
1)oracleasm listdisks

2)How about querying V$ASM_DISK view to see the diskgroup and associated devices.

Re: Oracle ASM question

T G Manikandan — Thu, 19 Mar 2009 13:48:51 GMT

with v$ASM_DISK

/*disks that have a disk group name in the disk header, show a status of MEMBER. Disks that were discovered, but that have not yet been assigned to a disk group, have a status of either CANDIDATE or PROVISIONED*/

Re: Oracle ASM question

Robert-Jan Goossens — Thu, 19 Mar 2009 14:20:40 GMT

Hi TGM,

Thank you for taking the time answering this question!

I should have mentioned I'm not a dba :)

oracleasm is not installed.

SQL> select path from v$asm_disk;

will only display two devices

If i look at the io statistics of this system there should be at least 6 devices configured excluding the two root disks.

any idear?

regards,
Robert-Jan

Re: Oracle ASM question

T G Manikandan — Thu, 19 Mar 2009 14:34:24 GMT

Hi Robert,

ASMCMD>lsct

would show you the databases connected ASM clients and also would list the database names with the first field.

you can connect to each database/instance by changing and connecting to the database.

export ORACLE_SID= mostly the same as database name and connect and query for

SELECT name, header_status, path FROM V$ASM_DISK;

I think right now you just queried for a single instance/database which is
echo $ORACLE_SID

Re: Oracle ASM question

Robert-Jan Goossens — Thu, 19 Mar 2009 14:50:01 GMT

Hi TGM,

# asmcmd
ASMCMD> lsct
DB_Name Status Software_Version Compatible_version Instance_Name
DMDB CONNECTED 10.2.0.3.0 10.2.0.3.0 DMDB1
DMDB CONNECTED 10.2.0.3.0 10.2.0.3.0 DMDB1

# su - oracle
# export ORACLE_SID=DMDB
# sqlplus system/oracle@dmdb
SQL> SELECT name, header_status, path FROM V$ASM_DISK;

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

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

NAME HEADER_STATU
------------------------------ ------------
PATH
--------------------------------------------------------------------------------
DATA_0000 UNKNOWN
/dev/rdsk/c6t11d0

FLASH_0000 UNKNOWN
/dev/rdsk/c6t11d1

Regards,
Robert-JanDMDB

Re: Oracle ASM question

T G Manikandan — Thu, 19 Mar 2009 15:28:15 GMT

Robert,

dont you have the /etc/init.d/oracleasm script pls. ?

/etc/init.d/oracleasm listdisks

Re: Oracle ASM question

Robert-Jan Goossens — Thu, 19 Mar 2009 18:17:15 GMT

TGM,

Nope, can't find oracleasm file on the system.

Robert-Jan