Oracle bug solved: ORA-20446 Error
I downloaded an Oracle 11g and want to see what new features are available. After the installation, enable EM and find that the feature is excellent. It is used to import data from another database. Set to import data from the test database immediately, but the following error is reported:
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
I searched on baidu and found only one record. Another guy encountered the same question as me. No one answered the question.
You have to find one on Metalink. This is an Oracle BUG (Bug 5925681). The solution is provided and tested successfully. By the way, I also answered the old man's question. It is estimated that he does not have a Metalink account.
There are two solutions:
1. Apply the fix for the bug
Or
2. Use the following workaround
Login as sysman user to the database and execute the following :-
Execute MGMT_USER.MAKE_EM_USER ('strmadmin'); // The username of the user whose import permission needs to be exported is marked in red.
Blog attachment: some people may not start to enable sysman users. In this case, you can use the following statement to enable sysman user: alter user sysman identified by sysman;
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian