Create Passwordfile inside DiskGroup for RAC database and add to srvctl

Create Passwordfile inside DiskGroup for RAC database and add to srvctl:

Steps:

1. Check database status:

2. Check database configuration:

3. Create passwordfile inside diskgroup 

4. Add passwordfile into srvctl config:

1. Check database status:

[oracle@oraclenode1 dbs]$ srvctl status database -d TESTDB

Instance TESTDB1 is running on node oraclenode1

Instance TESTDB2 is running on node oraclenode2

[oracle@oraclenode1 dbs]$

2. Check database configuration:

[oracle@oraclenode1 dbhome_1]$ srvctl config database -d TESTDB

Database unique name: TESTDB

Database name: TESTDB

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

Oracle user: oracle

Spfile: +DATA/TESTDB/PARAMETERFILE/spfileTESTDB.ora

Password file:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools:

Disk Groups: DATA,RECO

Mount point paths:

Services:

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: oinstall

OSOPER group: oinstall

Database instances: TESTDB1,TESTDB2

Configured nodes: oraclenode1,oraclenode2

CSS critical: no

CPU count: 0

Memory target: 0

Maximum memory: 0

Default network number for database services:

Database is administrator managed

[oracle@oraclenode1 dbhome_1]$

3. Create passwordfile inside diskgroup 

[oracle@oraclenode1 dbs]$ orapwd file='+DATA/TESTDB/PASSWORD/orapwTESTDB' dbuniquename='TESTDB'

Enter password for SYS:

[oracle@oraclenode1 dbs]$

[oracle@oraclenode1 ~]$ asmcmd -p

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

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

Type      Redund  Striped  Time             Sys  Name

PASSWORD  UNPROT  COARSE   MAR 16 17:00:00  N    orapwtestdb => +DATA/TESTDB/PASSWORD/pwdtestdb.349.1099502001

PASSWORD  UNPROT  COARSE   MAR 16 17:00:00  Y    pwdtestdb.349.1099502001

ASMCMD [+DATA/TESTDB/PASSWORD] >

4. Add passwordfile into srvctl config:

[oracle@oraclenode1 dbs]$ srvctl modify database -d TESTDB -pwfile '+DATA/TESTDB/PASSWORD/orapwTESTDB'

[oracle@oraclenode1 dbs]$ srvctl config database -d TESTDB

Database unique name: TESTDB

Database name: TESTDB

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

Oracle user: oracle

Spfile: +DATA/TESTDB/PARAMETERFILE/spfileTESTDB.ora

Password file: +DATA/TESTDB/PASSWORD/orapwTESTDB

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools:

Disk Groups: DATA,RECO

Mount point paths:

Services:

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: oinstall

OSOPER group: oinstall

Database instances: TESTDB1,TESTDB2

Configured nodes: oraclenode1,oraclenode2

CSS critical: no

CPU count: 0

Memory target: 0

Maximum memory: 0

Default network number for database services:

Database is administrator managed

[oracle@oraclenode1 dbs]$

Regards,

Mallik