dbca删除db时报错ORA-01017:invalid username/password

一、环境描述 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即可