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.