Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-09968: unable to lock file

937555Feb 6 2013 — edited Feb 6 2013
Hello,

I am using Oracle 11g in my Windows machine. I wrote a multithreaded program that will be inserting into Oracle database so I was getting this exception before-

ORA-12519: TNS:no appropriate service handler found


So after going through various article on the internet. I found that the solution for above exception is to increase the number of processes- So I followed the below thing and it works fine for me after that.

cmd>sqlplus / as sysdba
sqlplus>alter system set processes=300 scope=spfile;
sqlplus>shut immediate;
sqlplus>startup



Now after some more time, I increased the processes to something like below

alter system set processes=1000000 scope=spfile;


And since then whenever I am starting up my Oracle database, it is giving me this exception below and it is happening since one day. I am not sure how to fix this problem?


ORA-10997: another startup/shutdown operation of this instance inprogress
ORA-09968: unable to lock file


Can anyone help me with this?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2013
Added on Feb 6 2013
21 comments
15,292 views