Mallik034: Copy password file from FS to ASM diskgroup

Sunday, June 2, 2024

Copy password file from FS to ASM diskgroup:

[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

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>

Mallik034