dbca 过程中错误ORA-01503 ORA-01158解决

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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16381228/viewspace-776375/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16381228/viewspace-776375/