Monday, November 6, 2017

Change SYSASM password in RAC environment.



grid@orcldev211:[/u01/app/11.2/grid_home/dbs] $ orapwd file=orapw+ASM password=Oracle

OPW-00005: File with same name exists - please delete or rename


grid@orcldev211:[/u01/app/11.2/grid_home/dbs] $ ls
ab_+ASM1.dat  hc_+ASM1.dat  init.ora  orapw+ASM

Note: Now you can either delete the existing file or use Force=Y parameter to overwrite existing file. I chose to rename existing file.


grid@orcldev211:[/u01/app/11.2/grid_home/dbs] $ mv "orapw+ASM" "orapw+ASM_BAK"

Create a  new password file:




grid@orcldev211:[/u01/app/11.2/grid_home/dbs] $ orapwd file=orapw+ASM password=Oracle

grid@orcldev211:[/u01/app/11.2/grid_home/dbs] $ ls -ll
total 20
-rw-rw----. 1 grid oinstall 1098 May 17 13:35 ab_+ASM1.dat
-rwxrwxr-x. 1 grid oinstall 1544 Oct 21 15:18 hc_+ASM1.dat
-rwxrwxr-x. 1 grid oinstall 2851 May 15  2009 init.ora
-rw-r-----. 1 grid oinstall 1536 Oct 21 16:41 orapw+ASM
-rw-r-----. 1 grid oinstall 1536 Jan 18  2016 orapw+ASM_BAK

grid@orcldev211:[/u01/app/11.2/grid_home/dbs] $ . oraenv
ORACLE_SID = [+ASM1] ?
The Oracle base remains unchanged with value /u01/app/grid
grid@orcldev211:[/u01/app/11.2/grid_home/dbs] $ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Fri Oct 21 16:41:52 2016

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL>

No comments:

Post a Comment