How To Create An SYSASM User On Release 11g

On release 11g and onwards, you need to create an ASM user and grant the SYSASM role. The purpose of the SYSASM role is to provide a level of separation between the RDBMS & ASM credentials.

The SYSASM role, which has full capability on the ASM instance, is authenticated through the OSASM user group, similar to the SYSDBA roles, which is authenticated through OSDBA.

1) The following example shows how to connect as SYSASM and configure a new user for SYSASM role:

+ASM:oracle> export ORACLE_SID=+ASM

+ASM:oracle>sqlplus "/as sysasm"

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Oct 1 15:44:00 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user ASMUSER identified by oracle;

User created.

SQL> grant SYSASM, SYSOPER to ASMUSER;

Grant succeeded.

SQL> exit

2) Then connect as ASMUSER:

+ASM:oracle> export ORACLE_SID=+ASM

+ASM:oracle>sqlplus "ASMUSER/oracle as sysasm"

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Oct 1 15:45:26 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$pwfile_users;

USERNAME SYSDBA SYSOPE SYSASM
------------------------------ ------ ------ ------
SYS TRUE TRUE TRUE
ASMUSER FALSE TRUE TRUE

From Oracle

-------------------------------------------------------------------------------------------------------

Blog： http://blog.csdn.net/tianlesoftware

Email: [e-mail]

DBA1 群：62697716(满); DBA2 群：62697977(满) DBA3 群：62697850(满)

DBA 超级群：63306533(满); DBA4 群： 83829929 DBA5群： 142216823

聊天 群：40132017 聊天2群：69087192

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请