Hi,I got the following error message when trying to connect to rman:
/u01/oradba/rman/config > rman
Recovery Manager: Release 10.2.0.3.0 - Production on Thu May 21 14:14:01 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: PROD (DBID=1824257732)
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-19921: maximum number of 64 rows exceeded
I went online and every where searching for it but couldn't find a solution and then i immediately remembered that i had my laptop connect at home with another session that was already connected to rman. So i checked out ps command to see any other rman command connected and yup i was right. I killed it:
/u01/oradba/rman/config > ps -aef|grep rman
oracle 165 22875 0 21:45:59 pts/8 4:41 rman
oracle 19379 6839 0 14:14:54 pts/13 0:00 grep rman
prodnj54db1*PROD-(oracle)
/u01/oradba/rman/config > kill -9 165
prodnj54db1*PROD-(oracle)
/u01/oradba/rman/config > rman
Recovery Manager: Release 10.2.0.3.0 - Production on Thu May 21 14:15:04 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: PROD (DBID=1824257732)
RMAN> connect rcvcat rman/rmanpasswd@rmancat
connected to recovery catalog database
RMAN>
The kill command did the trick.
Hope this helps. Do let me know if this helped you out.
===========================================================
Oracle Error :: RMAN-06901
WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
Cause
Informational message only.
Action
No action required.