RE: export error for duh Gurus

From: <Rajesh.Rao_at_jpmchase.com>
Date: Tue, 13 Dec 2005 17:21:50 -0500
Message-ID: <OFD599D4EC.06E068E2-ON852570D6.007AADFF@jpmchase.com>

Muh database too has been suffering from occasional similar failures. Version 9.2.0.5. Solaris 8. HAve been asked by Oracle to upgrade to the latest patchset, or to do conventional export, instead of direct. I decided to live with the occassional error. Usually, once a month.

                                                                                                                                        
                      "Spears, Brian"                                                                                                   
                      <BSpears_at_Limitedbr        To:       <mark.powell_at_eds.com>, "oracle-l" <oracle-l_at_freelists.org>                    
                      ands.com>                 cc:                                                                                     
                      Sent by:                  Subject:  RE: export error for duh Gurus                                                
                      oracle-l-bounce_at_fr                                                                                                
                      eelists.org                                                                                                       
                                                                                                                                        
                                                                                                                                        
                      12/13/2005 05:13                                                                                                  
                      PM                                                                                                                
                      Please respond to                                                                                                 
                      BSpears

It's highly sensitive production db...

I cannot implement new datapump right now..It's just the nature of the environment here. Yes the conventional exports with direct=y ... If it wakes me up again, I will try the direct=N

Note: a rerun of the export usually is successful! So I am thinking some resource contention or something.

Brian

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark D
Sent: Tuesday, December 13, 2005 4:41 PM To: oracle-l
Subject: RE: export error for duh Gurus

Brian, do you get the error on conventional exports? And to be clear I take it you are using the traditional exp utility and not the new expdp utility that is the preferred utility with 10g to use for exports.

Mark D Powell --

      From: oracle-l-bounce_at_freelists.org
      [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Spears, Brian
      Sent: Tuesday, December 13, 2005 4:23 PM
      To: oracle-l
      Subject: export error for duh Gurus

      Has anyone got ideas or run across this intermittent export error?

      Randomly getting this error in the export full.
      Metalink does not show anything related at our version so a tar
      created.

      . . exporting table                  CARTON_STATUS
      EXP-00008: ORACLE error 8103 encountered
      ORA-08103: object no longer exists
      . . exporting table           CLASS_IMPLEMENTATION         33 rows
      exported


      * oracle 10.1.0.3.0   Hpux 11.23  32bit 9000/800

      * The table exists

      * The error occurs on different tables each time

      * Check for block corruption shows no problems

      * table creation date is months back

      * normal processing in the database at this time

      * consistent=y, direct=y full=y rows=y



      Brian Spears
      From: oracle-l-bounce_at_freelists.org
      [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yongping Yao
      Sent: Tuesday, December 13, 2005 1:22 AM
      To: sjaffarhussain_at_gmail.com
      Cc: oracle-l
      Subject: Re: pga_aggregate_target

      I think Expert Oracle: Database Arichitecture Chapter 3 (or 4 I don't
      have it in hand) will help you.


      On 12/13/05, The Human Fly <sjaffarhussain_at_gmail.com> wrote:
      Hello List,

      I was little confused about the settings of pga_aggregate_target
      parameter. I was in a assumption that when we set this parameter to a
      certain value, the usage of pga wont go beond this value. I have set
      pga as 3gb to one of my business critical database. Recently, I have
      found that max pga allocation was 4+ Gb. My boss askmed me, why the
      hell it takes more than what we have defined. I explained him saying
      that oracle might taken it from the OS to finish the necessary
      request. His immediately counter question was, then what is the use
      of
      setting pga_aggregate_target parameter? When oracle allocates and
      de-allocated the memory (pga) as per requirements.
      Is it expected behaviour that oracle takes sometime more that the
      value defined for pga? If so, what is the benift of setting value for
      pga?
      Thanks for your time.


      --
      Best Regards,
      Syed Jaffar Hussain
      OCP 8i & 9i DBA,
      Banque Saudi Fransi,
      Saudi Arabia
      ----------------------------------------------------------------------------------

      "Winners don't do different things. They do things differently."
      --
      http://www.freelists.org/webpage/oracle-l





      --
      Yao Yongping
      Learning Oracle, UNIX/Linux...
      Love Reading, Classical Music, Philosophy, Economics etc.
      Blog:   http://spaces.msn.com/members/yaoyp/

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 13 2005 - 16:22:27 CST