一、环境描述 12.2 rac

问题：生产环境恢复演练，测试环境dbca删除db报错 ORA-01017:invalid username/password

二、解决方法：

（1）查看集群配置信息，对比正常环境缺少 Spfile、Password file 信息

参考文档：https://docs.oracle.com/cd/E11882_01/rac.112/e41960/srvctladmin.htm#RACAD5006

[oracle@sxsbdb02 ~]$ srvctl config database -d sxsbcdb

Database unique name: sxsbcdb

Database name: 

Oracle home: /u01/app/oracle/product/12.2.0/db_1

Oracle user: oracle

Spfile: 

Password file: 

Domain: 

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: 

Disk Groups: FRA,DATA

Mount point paths: 

Services: 

Type: RAC

Start concurrency: 

Stop concurrency: 

OSDBA group: dba

OSOPER group: oper

Database instances: sxsbcdb1,sxsbcdb2,sxsbcdb3

Configured nodes: sxsbdb01,sxsbdb02,sxsbdb03

CSS critical: no

CPU count: 0

Memory target: 0

Maximum memory: 0

Default network number for database services: 

Database is administrator managed

（2）重新配置db资源，指定spfile、passwordfile

srvctl stop database -d sxsbcdb

srvctl remove database -d sxsbcdb

srvctl add database -d sxsbcdb -o /u01/app/oracle/product/12.2.0/db_1 -spfile +data/sxsbcdb/PARAMETERFILE/spfile.1107.1080927805 -pwfile +data/sxsbcdb/PASSWORD/pwdsxsbcdb.1106.1081677991

srvctl add instance -d sxsbcdb -i sxsbcdb1 -n sxsbdb01

srvctl add instance -d sxsbcdb -i sxsbcdb2 -n sxsbdb02

srvctl add instance -d sxsbcdb -i sxsbcdb3 -n sxsbdb03

srvctl start database -d sxsbcdb

（3）重新执行dbca即可