将用户加为EM的管理员

  ORACLE导出时ORA-20446:错误解决  

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.

在网上都写着是 '导出导入使用的用户名'  都为一个固定的,特别容易产生误导,此为你使用导出导入的时登陆的用户名.可以解决此错误,经过多次测试

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值