Error ORA-20446 creating an export job

While trying to do an export in my Oracle 11g test database today I received the following errors,

————————————
ORA-20446: The owner of the job is not registered
ORA-06512: at “SYSMAN.MGMT_JOBS”, line 168
ORA-06512: at “SYSMAN.MGMT_JOBS”, line 86
ORA-06512: at line 1
————————————

It turns out that this is a bug in 11g, and while there is a fix available for it, there is also a simple workaround.
Logon as SYSMAN using SQL*Plus and execute the following command:

SQL> execute MGMT_USER.MAKE_EM_USER(‘<USERNAME>’);

Where <USERNAME> is of course the username/userid for the user who is trying to create the export job.

2 thoughts on “Error ORA-20446 creating an export job

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s