Parameter DML_LOCKS=0 prevented the immediate shutdown of db
sgalaxyOct 21 2009 — edited Oct 21 2009Hi,
I experimented with the value of dml_locks db parameter and what influence had on the db setting to the value =0.
The result was that i could not shutdown the db in immediate mode. The error message "ORA-00062:DML full-table lock cannot be acquired; DML_LOCKS is 0".
Finally, I tried the shutdown it in abort mode which although it succedded, the db afterwards could not startup because of the error "ORA-00214: control file 'string' version string inconsistent with file 'string' version string".
I followed the metalink note: 1014751.6 and tried to save my test db...
My question is:
Was there any other way to shutdown normally the db without provoking the inconsistency of control files...????
Note: I use DB 10g v.2 on WinXP platform. Also, i use 4 control files (the default 3 control files on disk C and I created the 4th on disk D some months ago....)
Thanks,
Sim