Password file creation filed with below error
$ orapwd file='+DATAC1/DEVDB_OCI/PASSWORD/orapwdevdb' dbuniquename='DEVDB_oci'
Enter password for SYS:
OPW-00010: Could not create the password file. This resource has a Password File.
Looks password file details added to srvctl , check srvctl config
$ srvctl config database -d DEVDB_oci
Database unique name: DEVDB_oci
Database name: DEVDB
Oracle home: /u02/app/oracle/product/19.0.0.0/dbhome_2
Oracle user: oracle
Spfile: +DATAC1/DEVDB_OCI/PARAMETERFILE/spfile.339.1079736451
Password file: /u02/app/oracle/product/19.0.0.0/dbhome_2/dbs/orapwdevdb11
Domain: db.devdb.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATAC1,RECOC1
Mount point paths: /acfs01
Services: DEVDB_obi,DEVDB_xa
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: racoper
Database instances: DEVDB11,DEVDB12
Configured nodes: racnode01,racnode02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
Remove pwfile details from srvctl config:
$ srvctl modify database -d DEVDB_oci -pwfile
Check srvctl config:
$ srvctl config database -d DEVDB_oci
Database unique name: DEVDB_oci
Database name: DEVDB
Oracle home: /u02/app/oracle/product/19.0.0.0/dbhome_2
Oracle user: oracle
Spfile: +DATAC1/DEVDB_OCI/PARAMETERFILE/spfile.339.1079736451
Password file:
Domain: db.devdb.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATAC1,RECOC1
Mount point paths: /acfs01
Services: DEVDB_obi,DEVDB_xa
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: racoper
Database instances: DEVDB11,DEVDB12
Configured nodes: racnode01,racnode02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
Lets try adding password file:
$ orapwd file='+DATAC1/DEVDB_OCI/PASSWORD/orapwdevdb' dbuniquename='DEVDB_oci'
Enter password for SYS:
Add pwfile to srvctl config again:
$ srvctl modify database -d DEVDB_oci -pwfile '+DATAC1/DEVDB_OCI/PASSWORD/orapwdevdb'
$ srvctl config database -d DEVDB_oci
Database unique name: DEVDB_oci
Database name: DEVDB
Oracle home: /u02/app/oracle/product/19.0.0.0/dbhome_2
Oracle user: oracle
Spfile: +DATAC1/DEVDB_OCI/PARAMETERFILE/spfile.339.1079736451
Password file: +DATAC1/DEVDB_OCI/PASSWORD/orapwdevdb
Domain: db.devdb.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATAC1,RECOC1
Mount point paths: /acfs01
Services: DEVDB_obi,DEVDB_xa
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: racoper
Database instances: DEVDB11,DEVDB12
Configured nodes: racnode01,racnode02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
No comments:
Post a Comment