ORA-17503 是 Oracle 数据库中的一个错误代码,通常与文件打开失败有关。下面我将根据您的要求,分点解释这个错误。 1. ORA-17503 错误的含义 ORA-17503 错误表示 Oracle 数据库尝试打开一个文件时失败。这个错误通常与底层操作系统层面的文件访问问题有关,如文件权限不足、文件路径错误、文件不存在或文件损坏等。
ORA-00210: cannot open the specified control file ORA-00202: control file: '+DATA/posdb/controlfile/current.260.822142153' ORA-17503: ksfdopn:2 Failed to open file +DATA/sharkdb/controlfile/current.260.822142153 ORA-15001: diskgroup "DATA" does not exist or is not mounted ORA-15055: unable ...
ORA-17503: ksfdopn:2 Failed to open file '+DG/SID/orapwsid' ORA-15173: entry 'orapwsid' does not exist in directory 'sid' ORA-06512: at line 4 ORA-06512: at "SYS.X$DBMS_DISKGROUP",line 665 ORA-06512: at line 2 最近12c环境好多报这个错误,然后去对应的asm磁盘组找不到该密码文件,重...
ORA-27300: OS system dependent operation:open failed with status: 13 ORA-27301: OS failure message: Permission denied ORA-27302: failure occurred at: sskgmsmr_7 ORA-17503: ksfdopn:2 Failed to open file +DATA/dg/PASSWORD/pwddg ORA-27300: OS system dependent operation:open failed with status...
ORA-12547 ORA-17503(RAC)解决 1.报错内容: 下午看到一个文件夹似乎权限有问题然后就执行chown -R ... 结果: Enter user-name: ERROR: ORA-12547: TNS:lost contact [oracle@racnode1 ~]$ sqlplus "/as sysdba" SQL*Plus: Release 11.2.0.2.0 Production on Mon Jan 21 17:03:25 2013 Copyright...
Now the alert log of the ASM instance has the following errors for the first 2 databases only...they show up once a day: Errors in file /oracle/diag/asm/+asm/+ASM2/trace/+ASM2_ora_12644.trc: ORA-17503: ksfdopn:2 Failed to open file +ORA_DATA_DGWPRD1/dgwprd1/spfiledgwprd1.ora...
导致引发了两个错误:分别是ORA-01565,ORA-17503和ORA-15077 在重启时候报错如下 SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+ASM1/rsdb/spfilersdb.ora' ORA-17503: ksfdopn:10 Failed to open file +ASM1/rsdb/spfilersdb.ora ORA-15077: could...
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-00210: cannot open the specified control file ORA-00202: control file: '+DATA/posdb/controlfile/current.260.822142153' ORA-17503: ksfdopn:2 Failed to open file +DATA/sharkdb/controlfile/current.260.822142153 ORA-15001: diskgroup "DATA" does not exist or is not mounted ...
ORA-01565: errorinidentifyingfile'+DATA/db11g/spfileptgk.ora'ORA-17503: ksfdopn:10Failedtoopenfile+DATA/db11g/spfileptgk.ora ora-01031insufficientprivilegesSQL> 这里就很明显了,用户无权限 #检查用户组属发现,orace用户少了2个用户组idoracle