ORA-01031: insufficient privileges when stopping ASM instance
Hi!
I installed oracle enterprise linux (5.4) and oracle grid 11.2 for standalone server on my server. After installing the database software I created a database in my ASM instance.
For my next step I wanted to test some ASM crash szenarios. Firstly I just wanted to stop the ASM instance:
[oracle@db11gr2 ~]$ . oraenv
ORACLE_SID = [+ASM] ? +ASM
The Oracle base for ORACLE_HOME=/opt/oracle/product/11.2.0/grid is /opt/oracle
[oracle@db11gr2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 28 10:29:36 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
SQL> shutdown
ORA-01031: insufficient privileges
SQL>
What goes wrong here?
[oracle@db11gr2 ~]$ id
uid=500(oracle) gid=500(oinstall) Gruppen=500(oinstall),501(dba),502(oper),503(asmadmin)
The oracle user has the required roles. The oracle sqlplus has the following privilegs:
[oracle@db11gr2 bin]$ ls -l sqlplus
-rwxr-x--x 1 oracle oinstall 6873 15. Dez 13:55 sqlplus
For my database I can login as sysdba and start/stop it...
Thanks
Markus