Password File Maintenance ASM, RAC

Prior 11GR2:
ASM password file needs to be updated on both instances whenever changes are made.
11GR2:
Starting with oracle 11Gr2 ASM password file will be updated on both nodes

SQL> select * from v$version;

BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
PL/SQL Release 11.2.0.1.0 – Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 – Production
NLSRTL Version 11.2.0.1.0 – Production

SQL> select * from gv$pwfile_users order by inst_id;

INST_ID USERNAME SYSDB SYSOP SYSAS
———- —————————— —– —– —–
1 SYS TRUE TRUE TRUE
1 ASMSNMP TRUE FALSE FALSE
2 SYS TRUE TRUE TRUE
2 ASMSNMP TRUE FALSE FALSE
SQL> create user rchemik identified by rakesh;

User created.

SQL> grant sysasm to rchemik;

Grant succeeded.

SQL> select * from gv$pwfile_users order by inst_id;

INST_ID USERNAME SYSDB SYSOP SYSAS
———- —————————— —– —– —–
1 SYS TRUE TRUE TRUE
1 ASMSNMP TRUE FALSE FALSE
1 RCHEMIK FALSE FALSE TRUE
2 SYS TRUE TRUE TRUE
2 ASMSNMP TRUE FALSE FALSE
2 RCHEMIK FALSE FALSE TRUE

6 rows selected.
SQL> drop user rchemik;

User dropped.

SQL> select * from gv$pwfile_users order by inst_id;

INST_ID USERNAME SYSDB SYSOP SYSAS
———- —————————— —– —– —–
1 SYS TRUE TRUE TRUE
1 ASMSNMP TRUE FALSE FALSE
2 SYS TRUE TRUE TRUE
2 ASMSNMP TRUE FALSE FALSE

RAC file:

The change in password file update is only for ASM , rac database password still needs to updated on both instances whenever change is made.

12C:

Starting Oracle 12c, ASM supports password file in a diskgroup. You can store the oracle database password file directly in an ASM diskgroup. This support is available for password file of the ASM cluster as well.

Ref:https://prutser.wordpress.com/2011/01/14/clustered-asm-and-rac-password-file-maintenance/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s