RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row due to ORA-04031 shared memory issue

Rman backup failed while checking to connect the Rman client thrown with the error of ORA-04031 Shared memory issue .

 rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Fri Mar 21 03:28:58 2014

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

connected to target database: TEST (DBID=92535020)

RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row

RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows

ORACLE error from target database:

ORA-04031: unable to allocate 36424 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","krbmror")

Cause :

ORA - 04031 RMAN not able to connect to database due to shared memory issue 

Solution:

1.Add more space to shared memory to take effect with Rman .

Check the shared memory allocated for database and assign more if needed else try to flush shared memory and connect again via RMAN it will allow to take connection.

SQL > show parameter shared;

shared_pool_reserved_size            big integer 10M

shared_pool_size                     big integer 200M

SQL > alter system set shared_pool_size=400M scope=spfile;

Bounce database to take effect .

Add more space to shared_pool_size for permanent solution 

2. Else flush shared_pool and check connecting Rman again 

SQL> alter system flush shared_pool;

System altered.

==============================================================

rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Fri Mar 21 03:44:29 2014

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

connected to target database: TEST (DBID=92535020)

RMAN> exit