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:unable to connect to Cluster Synchronization Service 一、检查 CRS 状态 [root@ofc_node1 ~...
SQL>startup ORA-01078: failureinprocessing system parameters ORA-01565: errorinidentifyingfile'+DATA/db11g/spfileptgk.ora'ORA-17503: ksfdopn:10Failedtoopenfile+DATA/db11g/spfileptgk.ora ora-01031insufficientprivilegesSQL> 这里就很明显了,用户无权限 #检查用户组属发现,orace用户少了2个用户组idoracle ...
在使用Oracle 11.2.0.4 RAC版本时，遇到节点重启后数据库启动失败的问题。错误信息如下：SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/test/spfiletest.ora'ORA-17503: ksfdopn:2 Failed to open file +DATA/test/spfiletest.ora ...
ora.afc.db application ONLINE ONLINE afcdb01 ora...SM1.asm application ONLINE ONLINE afcdb01 ora...01.lsnr application ONLINE ONLINE afcdb01 ora...b01.gsd application ONLINE ONLINE afcdb01 ora...b01.ons application ONLINE ONLINE afcdb01 ora...b01.vip application ONLINE ONLINE afcdb01 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-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-15077: could not locate ASM instance serving a required diskgroup ...
今天重启后,其中一个节点数据库起不来,但集群能正常启来。 手动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 ...
卸载硬盘的时候，不小心丢失了...spfilembdb.ora这个文件，卸载重新安装oracle吧
Oracle Database - Enterprise Edition - Version 10.1.0.2 and later: Starting Database Using Spfile Located on ASM Fails With ORA-01078, ORA-01565, ORA-17503 Errors
ORA-01565: error in identifying file '+DATA/test/spfiletest.ora' ORA-17503: ksfdopn:2 Failed to open file +DATA/test/spfiletest.ora ORA-12547: TNS:lost contact 经查询发现,是因为 grid软件目录bin目录下的 oracle文件权限导致的 正常节点: ...