This discussion is archived
4 Replies Latest reply: Jan 4, 2013 12:25 PM by Srini Chavali-Oracle RSS

expdp hangs at DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ

840710 Newbie
Currently Being Moderated
My database version is 11.2.0.1.0 and my expdp hangs at DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ

No errors found in alert log.Below are the details:

Export: Release 11.2.0.1.0 - Production on Thu Jan 3 04:33:43 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_FULL_01": "/******** AS SYSDBA" dumpfile=qp1live_full_exp_010313_043338.dmp logfile=qp1live_full_exp_010313_043338.log full=yes compression=all exclude=statistics,OBJECT
_GRANT directory=EXPDIR
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 170.3 MB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/AUDIT_OBJ
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/AUDIT_OBJ
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ


bash-3.00$ expdp attach=SYS_EXPORT_FULL_01

Export: Release 11.2.0.1.0 - Production on Thu Jan 3 23:05:21 2013


Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Job: SYS_EXPORT_FULL_01
Owner: SYS
Operation: EXPORT
Creator Privs: TRUE
GUID: D270D69B60712A63E044001517D1BB98
Start Time: Thursday, 03 January, 2013 21:34:54
Mode: FULL
Instance: qp1live
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND /******** AS SYSDBA dumpfile=test_exp.dmp logfile=test_exp.log full=y status=60
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /opt/oracle/admin/qp1live/dpdump/test_exp.dmp
bytes written: 4,096

Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: SYS
Object Name: WEEKEND_WINDOW
Object Type: DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Completed Objects: 16
Worker Parallelism: 1

Please let me know in case of any more information.

Thanks in advance for you help...
  • 1. Re: expdp hangs at DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
    DB Newbie
    Currently Being Moderated
    1.check the space in corresponding File_system.
    2.Export> CONTINUE_CLIENT
    3.select * from dba_datapump_jobs;
    4.--Find the jobs(if you want to kill)

    SET lines 200
    COL owner_name FORMAT a10;
    COL job_name FORMAT a20
    COL state FORMAT a11
    COL operation LIKE state
    COL job_mode LIKE state

    SELECT owner_name, job_name, operation, job_mode,
    state, attached_sessions
    FROM dba_datapump_jobs
    WHERE job_name NOT LIKE 'BIN$%'
    ORDER BY 1,2;

    Regards,
    Db

    Edited by: DB on Jan 4, 2013 2:15 PM
  • 2. Re: expdp hangs at DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
    840710 Newbie
    Currently Being Moderated
    Hi DB,

    1.File system have enough space.
    2.Export> CONTINUE_CLIENT is done almost 12 hours back(still no luck)
    3. No jobs is not availble to kill

    here is the output for your query

    SYS on qp1live>/

    OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE ATTACHED_SESSIONS
    ---------- -------------------- ----------- ----------- ----------- -----------------
    SYS SYS_EXPORT_FULL_01 EXPORT FULL EXECUTING 1


    and database is 4gb in size.
  • 3. Re: expdp hangs at DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
    DB Newbie
    Currently Being Moderated
    --Kill the job you are interested in
    SET serveroutput on
    SET lines 100
    DECLARE
    h1 NUMBER;
    BEGIN
    -- Format: DBMS_DATAPUMP.ATTACH('<job_name>','<owner_name>');
    h1 := DBMS_DATAPUMP.ATTACH('SYS_IMPORT_SCHEMA_01','SCHEMA_USER');
    DBMS_DATAPUMP.STOP_JOB (h1,1,0);
    END;
    /
  • 4. Re: expdp hangs at DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    First, you should not invoke expdp using SYSDBA privilege - pl see the first Note section in the Docs

    http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm#i1012781

    Retry the export with SYSTEM account.

    Pl enable TRACE to determine what the export process is hung on

    Export/Import DataPump Parameter TRACE - How to Diagnose Oracle Data Pump [ID 286496.1]

    HTH
    Srini

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points