Receiving ORA-00055: maximum number of DML locks exceeded during activation (4247628)

지금 지원 담당자와 채팅

반품

피드백 제출됨

이 문서로 해당 문제가 해결되었습니까?

평가 결과 선택

제목

Receiving ORA-00055: maximum number of DML locks exceeded during activation
설명

The following error is received when activating Shareplex config:

4 16-Jan-02 19:03 Error 1 Yes Error
Reason: Unexpected Oracle error: ORA-00055: maximum number of DML locks exceeded.
원인

Shareplex will lock all tables in config during activation if the total number of tables in config file exceeds the value specified for init.ora parameter DML_LOCKS.
해결 방안

RESOLUTION 1:
Increase the init.ora parameter DML_LOCKS to a higher than the number of tables in the config file and bounce the database for the new parameter to take effect. Reactivate config.

RESOLUTION 2:
Use live option to activate config, Shareplex will then lock one table at a time.

sp_ctrl> activate config live

피드백 제출됨

이 문서로 해당 문제가 해결되었습니까?

평가 결과 선택

권장 콘텐츠

제품:: SharePlex
5.3.2, 5.3.3, 5.3, 5.3.1, 5.1.7, 5.2, 5.1.6, 5.1.5, 5.1.4, 5.1.3, 5.1.2, 5.1, 5.1.1, 5.0, 4.5.14, 4.5.13, 5.0.1, 5.2.0, 4.5.12, 4.5.11, 4.5.10, 4.5.9, 4.5.8, 4.5.7, 4.0.17.1, 4.0.16.16, 4.5.6, 4.5.5, 4.0.16.15, 4.0.16.14, 4.6.0, 4.5.4, 4.5.3, 5.0.0, 4.0.16.12, 4.0.16.11, 4.5.2, 4.5.1, 4.0.16.8, 4.0.16.5, 3.2.12.21, 3.2.12.19, 4.0.16.3, 3.2.12.18, 4.0.16, 3.2.12.6, 3.2.12.5, 3.2.12.16, 3.2.12.13, 3.2.12.9, 3.2.12.4, 4.0.16.1, 3.2.12.15, 3.2.12.11, 3.2.12.8, 3.2.12.3, 3.2.12.14, 3.2.12.12, 3.2.12.10, 3.2.12.7, 3.2.12.2, 3.2.12.1, 3.2.12, 4.5, 4.0, 3.2

제목