Re: Trouble with ASM

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Tue, 23 Feb 2010 06:34:18 -0800 (PST)
Message-ID: <269695.58745.qm_at_web65403.mail.ac4.yahoo.com>


I'll take a guess that you installed ASM with user grid rather than user oracle.  Did you put oracle in the asmadmin group?  If so then a simple

newgrp asmadmin

before trying to create your database should fix your problem.  You should, though, have installed ASM as oracle.
 
David Fitzjarrell





________________________________
From: thierry gascard <tgascard_at_gmail.com>
To: Oracle-L_at_freelists.org; thierry gascard <tgascard_at_gmail.com>
Sent: Tue, February 23, 2010 8:46:03 AM
Subject: Trouble with ASM

Hello, 

I need some ideas..
I use ASM with an oracle database in 11gR2 with RH5 and asmlib  :  2.6.18-164.el5 x86_64 x86_64 x86_64 GNU/Linux

[root_at_dbyac43: ~]# rpm -qa --qf "%{NAME}-%{VERSION}-%{RELEASE}.%{ARCH}.rpm\n" | grep asm
oracleasm-support-2.1.3-1.el5.x86_64.rpm
oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpm
oracleasmlib-2.0.4-1.el5.x86_64.rpm

[root_at_dbyac43: ~]#  df -ha
Filesystem            Size  Used Avail Use% Mounted on
....
tmpfs                  24G  208M   24G   1% /dev/shm
none                     0     0     0   -  /proc/sys/fs/binfmt_misc
sunrpc                   0     0     0   -  /var/lib/nfs/rpc_pipefs
oracleasmfs              0     0     0   -  /dev/oracleasm

[root_at_dbyac43: ~]# /etc/init.d/oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes

[root_at_dbyac43: ~]# /etc/init.d/oracleasm listdisks
BDD_YAC_DISK1

[root_at_dbyac43: ~]# /etc/init.d/oracleasm querydisk -d BDD_YAC_DISK1
Disk "BDD_YAC_DISK1" is a valid ASM disk on device [120, 1]

[root_at_dbyac43: ~]# ls -l /dev/oracleasm/disks
total 0
brw-rw---- 1 grid asmadmin 120, 1 Feb 23 14:05 BDD_YAC_DISK1

create database with user oracle : 
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
....
NOTE: MARK has subscribed
Errors in file /yacast/app/oracle/diag/rdbms/test/TEST/trace/TEST_rbal_7281.trc:
ORA-15183: ASMLIB initialization error [driver/agent not installed]
WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
Errors in file /yacast/app/oracle/diag/rdbms/test/TEST/trace/TEST_rbal_7281.trc:
ORA-15183: ASMLIB initialization error [driver/agent not installed]
SUCCESS: diskgroup BDD_YAC was mounted
Errors in file /yacast/app/oracle/diag/rdbms/test/TEST/trace/TEST_ora_7237.trc:
ORA-01501: CREATE DATABASE failed
ORA-00301: error in adding log file '+BDD_YAC' - file cannot be created

vi /yacast/app/oracle/diag/rdbms/test/TEST/trace/TEST_rbal_7281.trc
ERROR: asm_version error. err: driver/agent not installed rc:2
ORA-15183: ASMLIB initialization error [driver/agent not installed]
ORA-15183: ASMLIB initialization error [driver/agent not installed]

I' m not able to load libasm.so with user oracle, but not problem with user grid.
I 've already reinstalled rpm and asm disk.

If someone have an idea, it could help.

Thank you

Thierry.


      

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 23 2010 - 08:34:18 CST

Original text of this message