Search This Blog

Monday, August 16, 2010

Reset 11gR2 ASM password

In order to change the ASM password using 11gR2 you must do the following.

1. Create a new password file under the +ASM home.

cp orapw+ASM orapw+ASM.old

2. Create new password file after removing the old one.


orapwd file=orapw+ASM password=****** entries=5 force=y

Because we are using sysasm, that information gets lost when you would choose to recreate the password file. So you have to issue another grant SYSASM to sys after doing that.

3. Grant sys to sysadm.

> sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 16 16:31:04 2010


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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option


SQL> GRANT SYSASM TO sys;


Grant succeeded.


SQL> exit

No comments:

Post a Comment