Wednesday, January 27, 2016

ora-31626 ora-31687 ora-31688

If your init parameter AQ_TM_PROCESSES parameter has a value of zero, remove it.


Ensure that your streams_pool_size is configured with a minimum value of 50MB and 128MB would be better then retry the job.

SQL> SHOW PARAMETER streams_pool_size

TO SET THE PARAMETER streams_pool_size

SQL> ALTER SYSTEM SET streams_pool_size=128M

SHUT DOWN & RESTART THE DATABASE


No comments:

Post a Comment

Followers