oracle sculkget,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 lkfile is an instance lock file. Oracle uses this mechanism to prevent staring of second instance.