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
