Re: Trouble with ASM

  • From: thierry gascard <tgascard@xxxxxxxxx>
  • To: David Fitzjarrell <oratune@xxxxxxxxx>
  • Date: Tue, 23 Feb 2010 15:45:18 +0100

Hello David,

[root@dbyac43: ~]# id grid
uid=1100(grid) gid=1000(oinstall)
groups=1200(asmadmin),1201(asmdba),1202(asmoper),1000(oinstall)
[root@dbyac43: ~]# id oracle
uid=1101(oracle) gid=1000(oinstall)
groups=1201(asmdba),1300(dba),1301(oper),1000(oinstall)

oracle doesn't need asmadmin group.
It works perfectly well in others server with the same configuration.

ASM  is a part of grid infrastructure in 11gR2 and i use Oracle Clusterware.
I can't install it with oracle user.




2010/2/23 David Fitzjarrell <oratune@xxxxxxxxx>

> 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@xxxxxxxxx>
> *To:* Oracle-L@xxxxxxxxxxxxx; thierry gascard <tgascard@xxxxxxxxx>
> *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@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@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@dbyac43: ~]# /etc/init.d/oracleasm status
> Checking if ASM is loaded: yes
> Checking if /dev/oracleasm is mounted: yes
>
> [root@dbyac43: ~]# /etc/init.d/oracleasm listdisks
> BDD_YAC_DISK1
>
> [root@dbyac43: ~]# /etc/init.d/oracleasm querydisk -d BDD_YAC_DISK1
> Disk "BDD_YAC_DISK1" is a valid ASM disk on device [120, 1]
>
> [root@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.
>
>
>
>
>
>

Other related posts: