Copy password file from FS to ASM diskgroup

Copy password file from FS to ASM diskgroup:

1. Verify passwordile available on FS 

[oracle@oraclenode1 ~]$ ll /tmp/orapwRAC12C

-rw-r----- 1 oracle oinstall 6144 Jun  2 11:01 /tmp/orapwRAC12C

2. set the enviroment and copy the password file from FS to ASM diskgroup 

[oracle@oraclenode1 tmp]$ . oraenv

ORACLE_SID = [RACSb1] ? RACSB1

The Oracle base remains unchanged with value /u01/app/oracle

[oracle@oraclenode1 tmp]$

[oracle@oraclenode1 tmp]$ asmcmd -p

ASMCMD [+] > pwcopy --dbuniquename RACSB '/tmp/orapwRAC12C' '+DATA/RACSB/PASSWORD/orapwRACSB'

ASMCMD [+] >

3. Verify the password file on ASM diskgroup

 

[oracle@oraclenode1 ~]$ . oraenv

ORACLE_SID = [oracle] ? +ASM1

The Oracle base has been set to /u01/app/oracle

[oracle@oraclenode1 ~]$ asmcdm -p

ASMCMD [+] > cd +DATA/RACSB/PASSWORD/

ASMCMD [+DATA/RACSB/PASSWORD] > ls -l

Type      Redund  Striped  Time             Sys  Name

PASSWORD  UNPROT  COARSE   JUN 02 11:00:00  N    orapwracsb => +DATA/RACSB/PASSWORD/pwdracsb.309.1170587277

PASSWORD  UNPROT  COARSE   JUN 02 11:00:00  Y    pwdracsb.309.1170587277

ASMCMD [+DATA/RACSB/PASSWORD] >

4. Verify the database connection using password file 

[oracle@oraclenode1 ~]$ sqlplus sys/Mallik123#@RACSB as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Jun 2 11:10:38 2024

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

Last Successful login time: Sun Jun 02 2024 11:00:35 +05:30

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>