`
byebyegov5qq
  • 浏览: 1214396 次
文章分类
社区版块
存档分类
最新评论

User does not exist: ORA-06512: at "SYSMAN.MGMT_USER", line 122 ORA-06

 
阅读更多

from:http://hi.baidu.com/kilyyan2191/blog/item/3c7f34067cd7f577020881a3.html

问题现象:
1,使用lagebo用户登录到oracle10g的EM页面,执行“导出到导出文件”时,报错如下:
ORA-20204: User does not exist: LAGEBO
ORA-06512: 在 "SYSMAN.MGMT_USER",
line 122 ORA-06512: 在 "SYSMAN.MGMT_JOBS",
line 139 ORA-06512: 在 "SYSMAN.MGMT_JOBS",
line 78 ORA-06512: 在 line 1
如下图所示:


解决办法分析:
1,在OEM的设置页面,将要执行导出操作的用户lagebo添加到oracle的管理员组里去,就可以导出了。

解决步骤:
(中文)版本:
1,登录OEM
2,使用sys作为dba登录

3,右上角点击“设置”

4,在管理员页面“创建”管理员。

5,选择或者输入lagebo用户的名称和密码,如果点击手电筒图标,则会自动填上密码,之后点击“完成”。

6,复查信息:

7,完成之后,即会看到lagebo用户已经是管理员中的一员了。

8,注销sys用户后,再次使用lagbeo用户登录OEM,则会成功执行“导出到导出文件”功能。

(英文)版本
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.

1- login as user SYSTEM (or user SYS) to the ‘Enterprise Manager 10g
Database Control’
2- At the top right, click on the link ‘Setup’
3- On the page ‘Administrators’, click on the button ‘Create’
4- On the page ‘Create Administrator: Properties’, add the user who will run the Export/Import DataPump job
5- Click on the button: ‘Finish’
6- On the page ‘Create Administrator: Review’, click on the button: ‘Finish’
7- On the page ‘Administrators’, confirm that the user has been added.
8- At the top right, click on the link ‘Logout’

Now login as the user who will run the Export/Import DataPump job (LAGEBO),
and re-create the DataPump job.


分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics