ORA-20446: The owner of the job is not registered ORA-06512: 在 "SYSMAN.MGMT_JOBS", line 168 ORA-06512: 在 "SYSMAN.MGMT_JOBS", line 86 ORA-06512: 在 line 1
解决:
Login as sysman user to the database and execute the following :-
使用plus命令行工具,使用sysman 登录系统,执行以下语句
执行以下语句 execute MGMT_USER.MAKE_EM_USER('所导出导入使用的用户名');
必须要有exectue
以上命令的目的就是把此用户加为EM的管理员,也可如下操作:
In the Enterprise Manager Console, add the user who will run the Export/Import
DataPump job as an Administrator who can login to Enterprise Manager to perform
management tasks like set Blackouts, email notification schedules.
- login as user SYSTEM (or user SYS) to the ‘Enterprise Manager 10g
Database Control’
- At the top right, click on the link ‘Setup’
- On the page ‘Administrators’, click on the button ‘Create’
- On the page ‘Create Administrator: Properties’, add the user who will run
the Export/Import DataPump job
- Click on the button: ‘Finish’
- On the page ‘Create Administrator: Review’, click on the button: ‘Finish’
- On the page ‘Administrators’, confirm that the user has been added.
- At the top right, click on the link ‘Logout’
Now login as the user who will run the Export/Import DataPump job (SCOTT),
and re-create the DataPump job.
在网上都写着是 '导出导入使用的用户名' 都为一个固定的,特别容易产生误导,此为你使用导出导入的时登陆的用户名.可以解决此错误,经过多次测试