在RAC测试环境中,一个节点被测试同事重启服务器,导致此节点无法正常启动,报错信息如下: SQL>startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file "++DATA/ofcdb/spfileofcdb.ora" ORA-17503: ksfdopn:2 Failed to open file "+DATA/ofcdb/spfileofcdb.ora" ORA-...
故障现象: 启动数据库时报错,alert日志没有任何信息,提示如下 SQL>startup ORA-01078: failureinprocessing system parameters ORA-01565: errorinidentifyingfile'+DATA/db11g/spfileptgk.ora'ORA-17503: ksfdopn:10Failedtoopenfile+DATA/db11g/spfileptgk.ora ORA-01017: invalid username/password; logon denied S...
今天重启后,其中一个节点数据库起不来,但集群能正常启来。 手动startup报错: SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA_VG/sldb/spfilesldb.ora' ORA-17503: ksfdopn:2 Failed to open file +DATA_VG/slcard/spfilesldb.ora ORA-12547:...
Oracle Database - Enterprise Edition - Version 11.2.0.2 to 12.2.0.1 [Release 11.2 to 12.2]: RAC Database Can't Start: ORA-01565, ORA-17503: ksfdopn:10 Failed to open
ORA-17503: ksfdopn:2 Failed to open file +DATA/test/spfiletest.ora ORA-12547: TNS:lost contact 经过查询得知，问题是由于grid软件目录下bin目录的oracle文件权限设置不当导致的。正常节点的权限设置为：-rwsr-s--x. 1 grid oinstall 210188960 4月 14 17:30 oracle，-rwxr-x---. 1 grid ...
ORA-17503: ksfdopn:2 Failed to open file +DATA/test/spfiletest.ora ORA-12547: TNS:lost contact 经查询发现,是因为 grid软件目录bin目录下的 oracle文件权限导致的 正常节点: [grid@sldb2 bin]$ll oracle* -rwsr-s--x. 1 grid oinstall 210188960 4月 14 17:30 oracle ...
ORA-17503:ksfdopn:2 Failed to open file +DATA/sztech/spfilesztech.ora ORA-15001:diskgroup "DATA"...
ORA-17503: ksfdopn:2 Failed to open file +DATA_VG/slcard/spfilesldb.ora ORA-12547: TNS:lost contact 经google搜索是因为 grid软件目录bin目录下的 oracle文件权限导致的 正常节点sldb2: [grid@sldb2 bin]$ll oracle* -rwsr-s--x. 1 grid oinstall 209914479 10月 28 17:30 oracle ...
根据MOS How to troubleshoot ORA-01565 being reported in alert log (文档 ID 1950208.1)查询出来是由于$ORACLE_HOME/dbs/init$ORACLE_SID和OCR 中的配置(srvctl config db -d racdb1)查询出来的结果不一致导致的。 解决:将两者配置修改为一致即可。
Hi, DB is on Oracle Cloud, and i shut down the db but not at startup i am facing below errors: ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/<sid>_fra144/spfile<sid>.ora' ORA-17503: ksfdopn:10 Failed to open file +DATA/...