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>
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-lReceived on Tue Feb 23 2010 - 08:34:18 CST