ASM Configuration

[Former Member]

Hello,

How can I identify if I'm using Oracle ASM feature on my Database?

Thanks

[fidel_vales]

Do the following from your RDBMS database:

SELECT

    'Automatic storage management (ASM)' NAME,

    DECODE(COUNT(*), 0, 'No', 'Yes') VALUE

  FROM

    V$ASM_CLIENT

  WHERE

    ROWNUM = 1

[marcbaumann]

hi,

if the file_name path starts with a "+" then you use ASM for your database:

select file_name from dba_data_files;

Regards Marc

[former_member188883]

Hi Ruben,

Few basic checks in init<SID>.ora file

look out for parameter INSTANCE_TYPE=ASM

On OS level look out for oracle groups oinstall, asmdba, asmadmin, and asmoper.

Hope this helps.

Regards,

Deepak Kori

[Reagan]

Hello

Major Differences between Installations with and without ASM
OS User 'ora<dbname>'
With Oracle ASM the OS user 'ora<dbname>' should not be defined any longer. 
Almost every file or directory is now owned by user 'oracle' with its primary group 
'oinstall'. SAP BR*Tools are started from the environment of the OS user '<sapsid>adm'

Check the first document available here.

Regards

RB