4 Replies Latest reply: Jan 4, 2013 2:25 PM by Srini Chavali-Oracle RSS

    expdp hangs at DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ

    840710
      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
          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
            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
              --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
                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