Oracle 10g, Export problem through OEM（轉）

ubject: Export/Import DataPump - Submitting DataPump Job via OEM Database Control Fails with ORA-20204 in SYSMAN.MGMT_USER
Doc ID: Note:294680.1 Type: PROBLEM
Last Revision Date: 29-DEC-2004 Status: PUBLISHED

The information in this article applies to:
- Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.0
- Oracle Server - Personal Edition - Version: 10.1.0.2 to 10.2.0.0
- Oracle Server - Standard Edition - Version: 10.1.0.2 to 10.2.0.0
This problem can occur on any platform.

ERRORS
——

ORA-20204: User does not exist: SCOTT
ORA-06512: at “SYSMAN.MGMT_USER”, line 121
ORA-06512: at “SYSMAN.MGMT_JOBS”, line 109
ORA-06512: at “SYSMAN.MGMT_JOBS”, line 48
ORA-06512: at line 1

SYMPTOMS
——–

1. In SQL*Plus, you create a directory object, and grant the read and write
privilege on that directory, and the DBA privilege to SCOTT:

connect system/manager
create directory my_dir as ‘/home/datapump’;
grant read, write on directory my_dir to scott;

grant dba to scott;
column grantee format A20
column privilege like grantee
column table_name like grantee
column granted_role like grantee

select * from dba_role_privs where grantee=’SCOTT’;

GRANTEE GRANTED_ROLE ADM DEF
——————– ——————– — —
SCOTT DBA NO YES

select * from dba_sys_privs where grantee=’SCOTT’;

GRANTEE PRIVILEGE ADM
——————– ——————– —
SCOTT CREATE TABLE NO
SCOTT CREATE SESSION NO
SCOTT UNLIMITED TABLESPACE NO

select grantee,table_name,privilege from dba_tab_privs where grantee=’SCOTT’;

GRANTEE TABLE_NAME PRIVILEGE
——————– ——————– ——————–
SCOTT MY_DIR WRITE
SCOTT MY_DIR READ

2. You log in as user SCOTT to the ‘Oracle Enterprise Manager 10g
Database Control’ on the URL: http://my_host.my_domain:5500/em

3. You try to submit an export DataPump job:
- On the main Database Summary page, click on the link ‘Maintenance’
- On the main Database Maintenance page, click under ‘Utilities’ on the link
‘Export to files’
- On the page ‘Export: Export Type’, select ‘Schemas’, provide the Host
Credentials (OS username/password) to submit a job, and click on ‘Continue’
- On the page ‘Export: Schemas’ (step 1), add the SCOTT schema, and click on
‘Next’
- On the page ‘Export: Options’ (step 2), specify the Directory Object ‘MY_DIR’
and change the name of the Log file to a file that does not already exist,
and click on ‘Next’
- On the page ‘Export: Files’ (step 3), specify the Directory Object ‘MY_DIR’
and change the name of the Dump file to a file that does not already exist,
and click on ‘Next’
- On the page ‘Export: Schedule’ (step 4), specify the Job Name (e.g. EXP_1),
and click on ‘Next’
- On the page ‘Export: Review’ (step 5), click on ‘Submit Job’

4. The submit of the job fails with:

Export Submit Failed

ORA-20204: User does not exist: SCOTT
ORA-06512: at “SYSMAN.MGMT_USER”, line 121
ORA-06512: at “SYSMAN.MGMT_JOBS”, line 109
ORA-06512: at “SYSMAN.MGMT_JOBS”, line 48
ORA-06512: at line 1

CAUSE
—–

The user SCOTT does not have the privileges (such as MGMT_USER) to submit
the job.

FIX
—

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.

—————————————-