To change the ASM SYS Password

Things tried:

SQL> password
Changing password for SYS
Old password:
New password:
Retype new password:
ERROR:
ORA-00600: internal error code, arguments: [15051], [], [], [], [], [], [], []

 http://www.cndba.cn/dave/article/820

SQL> select INSTANCE_NAME from v$instance;

INSTANCE_NAME
----------------
+ASM

SQL> ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>;
ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>
*
ERROR at line 1:
ORA-01109: database not open 

 

The following error also might occur:
SQL> alter user sys identified by ;
alter user sys identified by
*
ERROR at line 1:
ORA-01031: insufficient privileges

Solutionhttp://www.cndba.cn/dave/article/820

       We can not change the password for ASM databases via alter user command.
       The password should be the one provided when the password file was created,also REMOTE_LOGIN_PASSWORDFILE should be set to EXCLUSIVE on all instances.

       If you want to change the password then you would need to recreate the password file using the orapwd utility 
 http://www.cndba.cn/dave/article/820

Recreate the password file for the ASM instance as follows: http://www.cndba.cn/dave/article/820

1.  Set the ORACLE_HOME and ORACLE_SID to the ASM instance
2.  connect /as sysdba from sqlplus
3.  If the value of the "remote_login_passwordfile" parameter in the pfile or spfile is EXCLUSIVE, you must shutdown your instance
4.  RENAME or DELETE the existing password file PWD<SID>.ora( In Windows) / orapw<SID> ( in UNIX) 
5.  Issue the command: http://www.cndba.cn/dave/article/820

WINDOWS:

orapwd file=<ORACLE_HOME>/database/PWD<SID>.ora password=<sys_password>

UNIX:

orapwd file=<ORACLE_HOME>/dbs/PWD<SID> password=<sys_password>

 

 

http://www.cndba.cn/dave/article/820

       The passwordfile can be recreated for ASM while ASM instance is up. Usually for normal DB instances, we recommended that DB instances be shutdown before changing the passwordfile.

 

 

 http://www.cndba.cn/dave/article/820

 

 

 http://www.cndba.cn/dave/article/820

From Oracle

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

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

Email: dvd.dba@gmail.com

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

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

聊天 群：40132017   聊天2群：69087192

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

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle 11g