Transactions terminate when operating the ORACLE Parallel Server in parallel mode. The ORACLE Alert file contains the following entries:
ORA-00600: internal error code, arguments: [1193], [6]
ORA-09952: scgcmn: lk_open_convert unexpected return: open failed
Additional information: 22
The parameter setting of the resource parameter of the distributed lock manager is too small and causes the error.
SolutionStop all instances of the database, stop the lock manager (lkshut) and start it with a higher -r parameter (lkstart).
Notes on lock manager configuration can be found in the file readmedlm.doc in the directory $ORACLE_HOME/pso/doc. You should not make the lock manager parameters unnecessarily high, to keep the memory consumption and startup time within sensible limits.
If the problem occurs during the ORACLE import (imp), you can leave the lock manager parameters unchanged and perform the import in exclusive mode: Stop all instances of the database and restart the database instance via which the import is to run with "STARTUP EXCLUSIVE". After the import, stop the instance and restart the database in parallel mode (STARTUP PARALLEL).
Additional key words
ORA-600, ORA-9952, DLM, Distributed Lock Manager, lkstart
ORACLE 7.1.6
No comments:
Post a Comment