修改asm口令

gycixput發表於2014-06-25

Recreate the password file for the ASM instance as follows:

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.ora( In Windows) / orapw ( in UNIX) 
5. Issue the command:

WINDOWS:

orapwd file=/database/PWD.ora password=

UNIX:

orapwd file=/dbs/orapw password=


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.

In 11.2 you can use asmcmd to change the password for single instance environment as follows

 

$ export ORACLE_SID=+ASM

$ asmcmd

ASMCMD> passwd sys
Enter old password (optional): ******
Enter new password: ******

 In Cluster environment 

ASMCMD> orapwusr --modify --password sys

Enter password: ******
ASMCMD> exit

NOTE: This is not applicable for SYSASM privilege.


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24585765/viewspace-1193185/,如需轉載,請註明出處,否則將追究法律責任。

相關文章