Hi sujatha I am not sure But I guess your target database is 9i and you are trying to connect from 8i rman exe, this may be causing problem otherwise it may be bug in 8i. Try to work from catalog server.
Hope this may help you thanks Banarasi Babu OCP, DBA -----Original Message----- Sent: Monday, February 17, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Hi Everyone, I have a recovery catalog database in version 9.2.0 (Solaris). I now need to backup a 8.1.5 target database (Solaris) using the 9.2.0 catalog db, however I am running into some problems which I can't solve nor find a solution to. These are the steps I have followed: 1) In the 9.2 catalog database I created a new user (rman8i) and a new tablespace. I know I didn't have to create a new tablespace, but the database is not mine and I wanted to keep everything seperate. 2) I granted resource, connect and recovery_catalog_owner to the rman8i user. 3) On the target (8.1.7) database server, I created the SQLNet link successfully 4) On the target (8.1.7) database server, I invoked rman and connected to the catalog as follows: **************************************************************************** ****** Recovery Manager: Release 8.1.5.0.0 - Production RMAN> connect catalog rman8i/rman8i@rcat9 RMAN-06008: connected to recovery catalog database RMAN-06428: recovery catalog is not installed RMAN> **************************************************************************** ****** 5) I then tried to create the catalog. It doesn't give a very descriptive error reason, but it failed: ***************************************************************** RMAN-06444: dbms_rcvcat package body created with compilation errors RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-06433: error installing recovery catalog RMAN> **************************************************************** 6) I then log out and log back in and try to connect to the catalog. This produces the following error: ************************************************************************ RMAN> connect catalog rman8i/rman8i@rcat9 RMAN-06008: connected to recovery catalog database RMAN-06099: error occurred in source file: krmk.pc, line: 20686 RMAN-06097: text of failing SQL statement: declare vsn varchar2 ( 20 ) ; begin vsn := dbms_rcvcat . getPackageVersion ; :pkg_vsn:pkg_vsn_i := vsn ; if vsn is not null then :pkg_vsnub4 := to_number ( substr ( vsn , 1 , 2 ) || substr ( vsn , 4 , 2 ) || substr ( vsn , 7 , 2 ) ) ; end if ; end ; RMAN-06004: ORACLE error from recovery catalog database: ORA-04068: existing state of packages has been discarded ORA-04063: package body "RMAN8I.DBMS_RCVCAT" has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 RMAN> *************************************************************************** Am I doing anything wrong in the above process??? ... Has anyone been through this before - or know of any bug???? I did try and drop/delete everything I did and redo it all, but it didn't work either. Sorry for the lengthy mail and thanks in advance for your help Cheers Sujatha ------------------------------------------- Sujatha Madan Database Administrator Custom Management Centre Optus Business Operations 'yes' OPTUS PH # +61 2 9775 9868 Mobile # +61 402 354 347 FAX # +61 2 9775 9510 Email [EMAIL PROTECTED] WEB http://www.optusbusiness.com.au/ ------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
