- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle ASM question
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2009 04:36 AM
тАО03-19-2009 04:36 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2009 06:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2009 06:48 AM
тАО03-19-2009 06:48 AM
Re: Oracle ASM question
/*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*/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2009 07:20 AM
тАО03-19-2009 07:20 AM
Re: Oracle ASM question
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2009 07:34 AM
тАО03-19-2009 07:34 AM
Re: Oracle ASM question
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=
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2009 07:50 AM
тАО03-19-2009 07:50 AM
Re: Oracle ASM question
# 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2009 08:28 AM
тАО03-19-2009 08:28 AM
Re: Oracle ASM question
dont you have the /etc/init.d/oracleasm script pls. ?
/etc/init.d/oracleasm listdisks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2009 11:17 AM
тАО03-19-2009 11:17 AM
Re: Oracle ASM question
Nope, can't find oracleasm file on the system.
Robert-Jan