RMAN-06429: TARGET database is not compatible with this version of RMAN
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



RMAN-06429: TARGET database is not compatible... Expand / Collapse
Message
Posted 12/17/2009 3:02:56 AM Post #171
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
Hi,

My archive log destination directory was getting filled up and i got alert that thresholds had been reached. I didn't know why until i looked at the archive log script backup log.   This is what it showed in the log:

RMAN-06003: ORACLE error from target database:
ORA-04031: unable to allocate 41152 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: "SYS.DBMS_RCVMAN"

RMAN-06438: error executing package DBMS_RCVMAN in TARGET database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06429: TARGET database is not compatible with this version of RMAN


 

I tried to login to rman manually to see what was going on and got the same error:


# rman

Recovery Manager: Release 10.2.0.3.0 - Production on Thu Dec 17 00:36:09 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> connect target /

ORACLE error from target database:
ORA-04031: unable to allocate 41152 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: "SYS.DBMS_RCVMAN"

error executing package DBMS_RCVMAN in TARGET database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06429: TARGET database is not compatible with this version of RMAN

RMAN> exit

I then logged into sqlplus to check the rman packages to see because there was no recent upgrades of any kind.

# sqlplus '/ as sysdba'

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Dec 17 00:36:31 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> SQL> select dbms_rcvman.getpackageversion from dual;
select dbms_rcvman.getpackageversion from dual
                                          *
ERROR at line 1:
ORA-04031: unable to allocate 41152 bytes of shared memory ("shared
pool","DBMS_RCVMAN","PL/SQL MPCODE","BAMIMA: Bam Buffer")

I tried flushing my shared_pool and then checked to see how large my shared_pool was:


SQL> alter system flush shared_pool;

System altered.

SQL> select dbms_rcvman.getpackageversion from dual;
select dbms_rcvman.getpackageversion from dual
                                          *
ERROR at line 1:
ORA-04031: unable to allocate 41152 bytes of shared memory ("shared
pool","DBMS_RCVMAN","PL/SQL MPCODE","BAMIMA: Bam Buffer")


SQL> show parameter shared_pool


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
shared_pool_reserved_size            big integer 10M
shared_pool_size                     big integer 200M

Shared_pool size was small .. so i increased it and that fixed the problem:

 

SQL> alter system set shared_pool_size=300m;

System altered.

SQL> select dbms_rcvman.getpackageversion from dual;

GETPACKAGEVERSION
--------------------------------------------------------------------------------
08.00.04.00

backup is now running ok.

Hope this helps.

Posted 3/1/2011 9:57:24 AM Post #546
 

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie
This was an excellent posting! Thanks for taking the time and sharing this solution. It was directly applicable to a problem experienced this morning.
Posted 3/2/2011 9:43:31 AM Post #547
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
Your Welcome!  I'm so glad it helped.  I'm trying to make sure to write up post similar to this to help fellow dba's resolve issues faster.
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 5:40am

Powered By InstantForum.NET v4.1.4 © 2012
Execution: 0.079. 10 queries. Compression Disabled.
Contextual Links