2 Replies Latest reply: Jun 11, 2012 10:45 AM by 926275 RSS

    Export problem in RAC database (two node) setup

    926275
      i'm not able to do any backup like RMAN,export... While doing export following error is coming on the oracle 10.2.0.3.0 RAC database (two node) on windows server 2003...

      UDE-00008: operation generated ORACLE error 31623
      ORA-31623: a job is not attached to this session via the specified handle
      ORA-06512: at "SYS.DBMS_DATAPUMP", line 2745
      ORA-06512: at "SYS.DBMS_DATAPUMP", line 3712
      ORA-06512: at line 1
      i checked the status of the components- but all the components are in valid status only.. but there are 137 invalid objects in the database... while running utlirp.sql in open mode, it tells to shut the database & run at startup migrate mode...

      please provide me the possible solution for this issue.. it is a very critical situation...
        • 1. Re: Export problem in RAC database (two node) setup
          Dean Gagne-Oracle
          Very critical situations should not be entered here, you should file a Service Request with Oracle support. This is a volunteer forum and is only monitored by people who may or may not have the answer you are looking for.

          Do you know what the invalid objects are? Are any of them owned by SYS? Can you run export with cluster=n to see if it is a cluster issue?

          Dean
          • 2. Re: Export problem in RAC database (two node) setup
            926275
            below are the invalid objects....

            SQL> select count(*) from dba_objects where status='INVALID';

            COUNT(*)
            ----------
            137

            SQL> select object_name,object_type,status from dba_objects where status='INVALID';

            OBJECT_NAME
            --------------------------------------------------------------------------------
            OBJECT_TYPE STATUS
            ------------------- -------
            DBA_HIST_FILESTATXS
            SYNONYM INVALID

            DBA_HIST_SQLSTAT
            SYNONYM INVALID

            DBA_HIST_SQLBIND
            SYNONYM INVALID


            OBJECT_NAME
            --------------------------------------------------------------------------------
            OBJECT_TYPE STATUS
            ------------------- -------
            DBA_HIST_SYSTEM_EVENT
            SYNONYM INVALID

            DBA_HIST_WAITSTAT
            SYNONYM INVALID

            DBA_HIST_LATCH
            SYNONYM INVALID


            OBJECT_NAME
            --------------------------------------------------------------------------------
            OBJECT_TYPE STATUS
            ------------------- -------
            DBA_HIST_LATCH_MISSES_SUMMARY
            SYNONYM INVALID

            DBA_HIST_DB_CACHE_ADVICE
            SYNONYM INVALID

            DBA_HIST_ROWCACHE_SUMMARY
            SYNONYM INVALID


            OBJECT_NAME
            --------------------------------------------------------------------------------
            OBJECT_TYPE STATUS
            ------------------- -------
            DBA_HIST_SGASTAT
            SYNONYM INVALID

            DBA_HIST_SYSSTAT
            SYNONYM INVALID

            DBA_HIST_SYS_TIME_MODEL
            SYNONYM INVALID


            OBJECT_NAME
            --------------------------------------------------------------------------------
            OBJECT_TYPE STATUS
            ------------------- -------
            DBA_HIST_OSSTAT
            SYNONYM INVALID

            DBA_HIST_PARAMETER
            SYNONYM INVALID

            DBA_HIST_SEG_STAT
            SYNONYM INVALID


            OBJECT_NAME
            --------------------------------------------------------------------------------
            OBJECT_TYPE STATUS
            ------------------- -------
            DBA_HIST_DLM_MISC
            SYNONYM INVALID

            DBA_HIST_INST_CACHE_TRANSFER
            SYNONYM INVALID

            DBA_HIST_ACTIVE_SESS_HISTORY
            SYNONYM INVALID


            OBJECT_NAME
            --------------------------------------------------------------------------------
            OBJECT_TYPE STATUS
            ------------------- -------
            DBA_HIST_TABLESPACE_STAT
            SYNONYM INVALID

            DBA_HIST_SERVICE_STAT
            SYNONYM INVALID

            DBA_HIST_SERVICE_WAIT_CLASS
            SYNONYM INVALID




            137 rows selected.

            SQL> spool off

            some sys ojects are also invalid... please give mr the suggestion..