Category Archives: ORA Database Error Messages

ORA-31635: unable to establish job resource synchronization

oracle

ORA-31635: unable to establish job resource synchronization
Cause: A lock used in synchronizing Data Pump resources during job creation and deletion could not be obtained during job creation. This indicates that a process for some other Data Pump job has not released the lock due to an internal error
Action: Eliminate the processes for any failed Data Pump job and try to create the new job again. If the error continues to occur, contact Oracle Customer Support and report the error

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31634: job already exists

oracle

ORA-31634: job already exists
Cause: Job creation or restart failed because a job having the selected name is currently executing. This also generally indicates that a Master Table with that job name exists in the user schema. Refer to any following error messages for clarification
Action: Select a different job name, or stop the currently executing job and re-try the operation (may require a DROP on the Master Table)

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31633: unable to create master table “string.string”

oracle

ORA-31633: unable to create master table "string.string"
Cause: Job creation failed because a Master Table and its indexes could not be created, most commonly due to the pre-existance of a table with the same name (job name) in the user schema. Refer to any following error messages for clarification
Action: Select a different job name, DROP the existing table, or eliminate any problems indicated by the following error messages

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31632: master table “string.string” not found, invalid, or inaccessible

oracle

ORA-31632: master table "string.string" not found, invalid, or inaccessible
Cause: A Master Table is required but no such table exists, or the content is not consistent with that of a valid Master Table, or the table is not accessible. Refer to any following error messages for clarification
Action: Make sure a valid Master Table exists, and eliminate any problems indicated by the following error messages

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31631: privileges are required

oracle

ORA-31631: privileges are required
Cause: The necessary privileges are not available for operations such as: restarting a job on behalf of another owner, using a device as a member of the dump file set, or ommiting a directory object associated with any of the various output files. Refer to any following error messages for additional information
Action: Select a different job to restart, try a different operation, or contact a database administrator to acquire the needed privileges

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31630: a job name is required to attach a job for user string

oracle

ORA-31630: a job name is required to attach a job for user string
Cause: No job name was supplied for an attach and the user has either no jobs executing or mutiple jobs executing
Action: Provide a job name for attach to use in selecting an executing job, or to use for restarting a stopped job

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31629: unable to allocate additional memory

oracle

ORA-31629: unable to allocate additional memory
Cause: A dynamic memory allocation failure occurred
Action: Report this problem to a database administrator

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31628: error getting worker process exception

oracle

ORA-31628: error getting worker process exception
Cause: Attempt to get a worker process exception failed
Action: Refer to any following error messages for possible actions. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31627: API call succeeded but more information is available

oracle

ORA-31627: API call succeeded but more information is available
Cause: The user specified job parameters that yielded informational messages
Action: Call DBMS_DATAPUMP.GET_STATUS to retrieve additional information

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31626: job does not exist

oracle

ORA-31626: job does not exist
Cause: An invalid reference to a job which is no longer executing, is not executing on the instance where the operation was attempted, or that does not have a valid Master Table. Refer to any following error messages for clarification
Action: Start a new job, or attach to an existing job that has a valid Master Table

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/