How to copy password file from ASM to FS

How to copy password file from ASM to FS:

Oracle Doc:

https://docs.oracle.com/database/121/OSTMG/GUID-A0A00173-DA44-43B2-92D4-72FF89ACB2A6.htm

ASMCMD Giving Errors on KFOD ( kfod.bin: No such file or directory ) (Doc ID 2022397.1)

1. Copy ASM password file to FS:

Environmental details:

+ASM1: node1.localdomain.com

+ASM2: node2localdomain.com

. oraenv 

+ASM1/+ASM2

Get the ASM password file location:

srvctl config asm

asmcmd

pwget --asm

Copy ASM password file from ASM to FS:

pwcopy '+DATA/node-clu/PASSWORD/orapwasm' '/tmp/orapwasm'

[oracle@node1 ~]$ . oraenv

ORACLE_SID = [RAC12C1] ? +ASM1

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

[oracle@node1 ~]$ asmcmd

ASMCMD> pwget --asm

+DATA/node-clu/PASSWORD/orapwasm

ASMCMD> exit

[oracle@node1 ~]$ srvctl config asm

ASM home: <CRS home>

Password file: +DATA/node-clu/PASSWORD/orapwasm

Backup of Password file: +DATA/node-clu/PASSWORD/orapwasm_backup

ASM listener: LISTENER

ASM instance count: 3

Cluster ASM listener: ASMNET1LSNR_ASM

[oracle@node1 ~]$ asmcmd

ASMCMD> cd +DATA/node-clu/PASSWORD/

ASMCMD> ls -l

Type      Redund  Striped  Time             Sys  Name

PASSWORD  UNPROT  COARSE   JUN 02 23:00:00  N    orapwasm => +DATA/ASM/PASSWORD/pwdasm.399.1106349459

ASMCMD> exit

[oracle@node1 ~]$ 

ASMCMD> pwcopy '+DATA/node-clu/PASSWORD/orapwasm' '/tmp/orapwasm'

copying +DATA/node-clu/PASSWORD/orapwasm -> /tmp/orapwasm

ASMCMD>

2. Copy Database password file to FS:

Environmental details:

RAC12C1: node1

RAC12C2: node2

. oarenv

RAC12C1/RAC12C2

Get the Database password file location:

srvctl config database -d RAC12C

asmcmd

pwget --dbuniquename RAC12C

Copy Database password file from ASM to FS:

pwcopy '+DATA/RAC12C/PASSWORD/pwdrac12c' '/tmp/orapwRAC12C'

[oracle@node1 ~]$ . oraenv

ORACLE_SID = [+ASM1] ? RAC12C1

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

[oracle@node1 ~]$ asmcmd

/u01/app/oracle/product/12.2.0.1/dbhome_1/bin/kfod: line 22: /home/oracle/%ORACLE_HOME%/bin/kfod.bin: No such file or directory

Use of uninitialized value $clus_mode in concatenation (.) or string at /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/asmcmdbase.pm line 5605.

Use of uninitialized value $clus_mode in scalar chomp at /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/asmcmdbase.pm line 5607.

Use of uninitialized value $clus_mode in string eq at /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/asmcmdbase.pm line 5640.

Use of uninitialized value $clus_mode in string eq at /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/asmcmdbase.pm line 5690.

Use of uninitialized value $clus_mode in string eq at /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/asmcmdbase.pm line 5690.

Use of uninitialized value $clus_mode in string eq at /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/asmcmdbase.pm line 5690.

Use of uninitialized value $clus_mode in string eq at /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/asmcmdbase.pm line 5769.

Use of uninitialized value $clus_mode in string eq at /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/asmcmdbase.pm line 5803.

Use of uninitialized value $clus_mode in string eq at /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/asmcmdbase.pm line 5803.

ASMCMD> exit

[oracle@node1 ~]$

Above error can be fixed using Oracle document 2022397.1

ASMCMD Giving Errors on KFOD ( kfod.bin: No such file or directory ) (Doc ID 2022397.1)

[oracle@node1 ~]$ grep OHOME /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/kfod

OHOME=%ORACLE_HOME%

[oracle@node1 ~]$

Solution:

From:

    OHOME=%ORACLE_HOME%

To:

    OHOME=$ORACLE_HOME

[oracle@node1 ~]$ grep OHOME /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/kfod

OHOME=$ORACLE_HOME

[oracle@node1 ~]$

[oracle@node1 ~]$ asmcmd

ASMCMD> pwget --dbuniquename RAC12C

+DATA/RAC12C/PASSWORD/pwdrac12c

ASMCMD> exit

[oracle@node1 ~]$ srvctl config database -d RAC12C

Database unique name: RAC12C

Database name: RAC12C

Oracle home: /u01/app/oracle/product/12.2.0.1/dbhome_1

Oracle user: oracle

Spfile: +RECO/RAC12C/PARAMETERFILE/spfile.659.1071585343

Password file: +DATA/RAC12C/PASSWORD/pwdrac12c

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools:

Disk Groups: RECO,DATA

Mount point paths:

Services:

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: oinstall

OSOPER group: oinstall

Database instances: RAC12C1,RAC12C2

Configured nodes: node1,node2

CSS critical: no

CPU count: 0

Memory target: 0

Maximum memory: 0

Default network number for database services:

Database is administrator managed

[oracle@node1 ~]$ asmcmd

ASMCMD> 

ASMCMD> cd +DATA/RAC12C/PASSWORD/

ASMCMD> ls -l

Type      Redund  Striped  Time             Sys  Name

PASSWORD  UNPROT  COARSE   SEP 01     2021  N    pwdrac12c => +DATA/RAC12C/PASSWORD/pwdrac12c.291.1082076973

PASSWORD  UNPROT  COARSE   SEP 01     2021  Y    pwdrac12c.291.1082076973

PASSWORD  UNPROT  COARSE   MAR 13     2021  Y    pwdrac12c.292.1067048971

ASMCMD> pwd

+DATA/RAC12C/PASSWORD

ASMCMD> pwcopy '+DATA/RAC12C/PASSWORD/pwdrac12c' '/tmp/orapwRAC12C'

copying +DATA/RAC12C/PASSWORD/pwdrac12c -> /tmp/orapwRAC12C

ASMCMD> exit

[oracle@node1 ~]$ ls -l /tmp/orapwRAC12C

-rw-r----- 1 oracle oinstall 6144 Aug 19 21:09 /tmp/orapwRAC12C

[oracle@node1 ~]$ 

Regards,

Mallik