ASM

Basic ASM commands

Show ASM status srvctl status asm Show more detailed ASM configuration srvctl config asm sqlplus login to ASM sqlplus / as sysasm Show which ASM clients are connected to this ASM instance select instance_name, db_name, status from v $asm_client; The only parameter that must be set for an ASM instance is INSTANCE_TYPE=ASM.  All others have …

Basic ASM commands Read More »

Oracle ASM 12.1.0.1 / 12c Maximum Disks and Disk Groups in ASM – Knowledge Needed For 1z0-068 OCE

511 disk groups 10,000 disks across all disk groups 128GB – The largest Oracle database datafile that can be created in an ASM disk group. You don’t mount an ASM disk, you mount an ASM disk group – as a result – valid values for V$ASM_DISK does not include “MOUNTED”, but “MOUNTED” is a valid …

Oracle ASM 12.1.0.1 / 12c Maximum Disks and Disk Groups in ASM – Knowledge Needed For 1z0-068 OCE Read More »

Centrify misconfiguration causes CRS-2877: Owner 'grid' of the entity 'ora.asm' does not belong to the 'asmdba' group.

or CRS-2877: Owner ‘oracle’ of the entity ‘ora.asm’ does not belong to the ‘dba’ group. External authentication is the issue.  We were using Centrify for external authentication.  Here’s the solution if you are using Centify – if you are using another external authentication, the tool service would likely change. While the Centrify is started login …

Centrify misconfiguration causes CRS-2877: Owner 'grid' of the entity 'ora.asm' does not belong to the 'asmdba' group. Read More »

12.1.0.2 Stand Alone Database Install with ASM Oracle Linux 6.X on Virtual Box

Purpose How to setup a device on Oracle Virtual Box – and use that device for a Oracle stand alone ASM database install. Assumptions Assumptions Oracle Enterprise Linux 6.6 with oracle–rdbms–server–12cR1–preinstall RPM installed – with at least 35GB free space on a pre-existing file system.  Other 6.X releases of Oracle Linux should work.  BTW, this rpm …

12.1.0.2 Stand Alone Database Install with ASM Oracle Linux 6.X on Virtual Box Read More »