DBCA过程中出现了ORA-01503 ORA-01158错误
查看alter日志文件得到下面的内容:
sculkget: failed to lock /opt/oracle/product/11.2.0/db_1/dbs/lkVOICE exclusive
sculkget: lock held by PID: 2365
ORA-09968: unable to lock file
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 2365
Errors in file /opt/oracle/diag/rdbms/ninvoicesd/VOICESD/trace/VOICESD_ora_12505.trc:
ORA-01158: database already mounted
ORA-1503 signalled during: Create controlfile reuse set database "VOICE"
可以看出出错误问题在建立lkVOICE文件时,到相关目录下查看:
[oracle@CentOS-1 ~]$ cd $ORACLE_HOME
[oracle@CentOS-1 db_1]$ cd dbs
[oracle@CentOS-1 dbs]$ ls
hc_DBUA0.dat hc_VOICESD.dat lkVOICE spfileVOICE.ora
hc_VOICE.dat init.ora orapwVOICE
[oracle@CentOS-1 dbs]$ ls -l
total 28
-rw-rw----. 1 oracle oinstall 1544 Nov 12 11:19 hc_DBUA0.dat
-rw-rw----. 1 oracle oinstall 1544 Nov 12 11:19 hc_VOICE.dat
-rw-rw----. 1 oracle oinstall 1544 Nov 12 11:21 hc_VOICESD.dat
-rw-r--r--. 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r-----. 1 oracle oinstall 24 Aug 30 2012 lkVOICE
-rw-r-----. 1 oracle oinstall 1536 Aug 30 2012 orapwVOICE
-rw-r-----. 1 oracle oinstall 3584 Nov 12 11:19 spfileVOICE.ora
[oracle@CentOS-1 dbs]$ rm lkVOICE
[oracle@CentOS-1 dbs]$ ls -l
total 24
-rw-rw----. 1 oracle oinstall 1544 Nov 12 11:19 hc_DBUA0.dat
-rw-rw----. 1 oracle oinstall 1544 Nov 12 11:19 hc_VOICE.dat
-rw-rw----. 1 oracle oinstall 1544 Nov 12 11:21 hc_VOICESD.dat
-rw-r--r--. 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r-----. 1 oracle oinstall 1536 Aug 30 2012 orapwVOICE
-rw-r-----. 1 oracle oinstall 3584 Nov 12 11:19 spfileVOICE.ora
删除后DBCA恢复正常。
NOTE: The lk file is an instance lock file. Oracle uses this mechanism to prevent staring of second instance.
查看alter日志文件得到下面的内容:
sculkget: failed to lock /opt/oracle/product/11.2.0/db_1/dbs/lkVOICE exclusive
sculkget: lock held by PID: 2365
ORA-09968: unable to lock file
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 2365
Errors in file /opt/oracle/diag/rdbms/ninvoicesd/VOICESD/trace/VOICESD_ora_12505.trc:
ORA-01158: database already mounted
ORA-1503 signalled during: Create controlfile reuse set database "VOICE"
可以看出出错误问题在建立lkVOICE文件时,到相关目录下查看:
[oracle@CentOS-1 ~]$ cd $ORACLE_HOME
[oracle@CentOS-1 db_1]$ cd dbs
[oracle@CentOS-1 dbs]$ ls
hc_DBUA0.dat hc_VOICESD.dat lkVOICE spfileVOICE.ora
hc_VOICE.dat init.ora orapwVOICE
[oracle@CentOS-1 dbs]$ ls -l
total 28
-rw-rw----. 1 oracle oinstall 1544 Nov 12 11:19 hc_DBUA0.dat
-rw-rw----. 1 oracle oinstall 1544 Nov 12 11:19 hc_VOICE.dat
-rw-rw----. 1 oracle oinstall 1544 Nov 12 11:21 hc_VOICESD.dat
-rw-r--r--. 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r-----. 1 oracle oinstall 24 Aug 30 2012 lkVOICE
-rw-r-----. 1 oracle oinstall 1536 Aug 30 2012 orapwVOICE
-rw-r-----. 1 oracle oinstall 3584 Nov 12 11:19 spfileVOICE.ora
[oracle@CentOS-1 dbs]$ rm lkVOICE
[oracle@CentOS-1 dbs]$ ls -l
total 24
-rw-rw----. 1 oracle oinstall 1544 Nov 12 11:19 hc_DBUA0.dat
-rw-rw----. 1 oracle oinstall 1544 Nov 12 11:19 hc_VOICE.dat
-rw-rw----. 1 oracle oinstall 1544 Nov 12 11:21 hc_VOICESD.dat
-rw-r--r--. 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r-----. 1 oracle oinstall 1536 Aug 30 2012 orapwVOICE
-rw-r-----. 1 oracle oinstall 3584 Nov 12 11:19 spfileVOICE.ora
删除后DBCA恢复正常。
NOTE: The lk file is an instance lock file. Oracle uses this mechanism to prevent staring of second instance.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16381228/viewspace-776375/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16381228/viewspace-776375/