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-29701
故障现象: 启动数据库时报错,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...
SQL> startup nomount ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/RACDB/spfileRACDB.ora' ORA-17503: ksfdopn:2 Failed to open file +DATA/RACDB/spfileRACDB.ora ORA-12547: TNS:lost contact SQL> exit Disconnected 依据网上说,为$GRID_HOME/bin/...
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 ...
在oracle11.2.0.4 RAC上重启节点后,发现一个节点的数据库启动失败 报错为: SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/test/spfile…
ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/AFC/spfileafc1.ora' ORA-17503: ksfdopn:2 Failed to open file +DATA/AFC/spfileafc1.ora ORA-15077: could not locate ASM instance serving a required diskgroup ...
问启动oracle node2错误: ORA-29701:无法连接到群集同步服务EN最近的工作中需要基于Oracle连接到SQLserver...
今天重启后,其中一个节点数据库起不来,但集群能正常启来。 手动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 ...
RAC 11G R2 ORA-01078 ORA-01565 ORA-17503 ORA-12547错误,前几天搭建的RAC测试环境:oel6.7 grid和database都是11.2.0.4.0 今天重启后,其中一个节点数据库起不来,但集群能正常启来。手动startup报错:SQL>startupORA-01078:failureinprocessingsyste
ORA-01565:error in identifying file '+DATA/sztech/spfilesztech.ora'ORA-17503:ksfdopn:2 Failed to...