Avoid error 0509-036 when you use the 32-bit Oracle SQL*Loader

This task applies only to the Entity Move/Rename operation if you use the 32-bit SQL*Loader utility with Oracle databases in Linux® environments. Skip this task if you are using the 64-bit SQL*Loader utility.

If you use the 32-bit SQL*Loader (sqlldr) utility, the following system error might be displayed:

exec(): 0509-036 Cannot load program sqlldr because of the following errors:
        0509-026 System error: There is not enough memory available now.
Failure while executing the Oracle SQL*Loader. Exit code is 255

If the 0509-036 system error is displayed, you can set the Loader Control environment variable by opening a shell window and running the following command:

export LDR_CNTRL=MAXDATA=0x80000000 at LARGE_PAGE_DATA=Y

Tip: If you are running the IBM OpenPages® Entity Move/Rename utility as a scheduled cron job, make sure to set the Loader Control environment variable in the cron environment.

When finished, run the IBM® OpenPages Entity Move/Rename utility. See Running the entity move/rename utility interactively or Running the Entity Move/Rename utility as a scheduled task.