DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-04031 error

  1. 12-21-2004, 08:35 AM #1
    rammi65
    rammi65 is offline Junior Member
    Join Date
    Dec 2004
    Posts
    15

    ORA-04031 error

    Hi
    my oracle version is 8.1.6 on tru64.
    I am getting following error while resync the recovery manager.

    RMAN-06099: error occurred in source file: krmk.pc, line: 20146
    RMAN-06097: text of failing SQL statement: declare vsn varchar2 ( 20 ) ; begin vsn := dbms_rcvman . getPackageVersion ; kg_vsnkg_vsn_i := vsn ; if vsn is not null then kg_vsnub4 := to_number ( substr ( vsn , 1 , 2 ) || substr ( vsn , 4 , 2 ) || substr ( vsn , 7 , 2 ) ) ; end if ; end ;
    RMAN-06003: ORACLE error from target database: ORA-04031: unable to allocate 15384 bytes of shared memory ("shared pool","DBMS_RCVMAN","PL/SQL MPCODE","BAMIMA: Bam Buffer")
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at line 1

    RMAN-06438: error executing package DBMS_RCVMAN in TARGET database

    Please help!!
    rammi
    Reply With Quote Reply With Quote
  2. 12-21-2004, 08:47 AM #2
    mike9
    mike9 is offline Advisor
    Join Date
    Mar 2002
    Posts
    534
    Which is the amout of RAM?
    How large is your swap space?
    Reply With Quote Reply With Quote
  3. 12-21-2004, 09:36 AM #3
    Aljaz
    Aljaz is offline Junior Member
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82
    It looks like that your shared pool is to small.

    What is the the size of large pool?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width