Rman issue with oracle patch

From: <GKor_at_rdw.nl>
Date: Tue, 16 Apr 2002 03:28:20 -0800
Message-ID: <F001.00445174.20020416032820@fatcity.com>

Hi list

The setting : A NT server upgraded to Oracle 81732 with the target database installed on it.

                        A NT server with Oracle 81730 and the RMAN catalog installed.

i did the following after applying the 81732 patch

After creating/installing new oracle and rman executable user should do

     the following 
          sqlplus '/ as sysdba'; 
            %ORACLE_HOME%\rdbms\admin\dbmsrman.sql 
            %ORACLE_HOME%\rdbms\admin\prvtrmns.plb 
     If using catalog, then they should upgrade the catalog 
           rman catalog <user/passwd_at_alias> 
           upgrade catalog; 
           upgrade catalog;

this was executed with the new rman executable just installed.

After that the hotbackup fails with the following error messages :

RMAN-03022: compiling command: backup
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1,
column 21:

PLS-00302: component 'LOCKFORCKPT' must be declared ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
RMAN-06097: text of failing SQL statement: begin dbms_rcvcat . lockForckpt ; end ;
RMAN-06099: error occurred in source file: krmk.pc, line: 2121

anyone with a clue what happened ?

thanks

g.g. kor
rdw ict the netherlands

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: GKor_at_rdw.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Apr 16 2002 - 06:28:20 CDT