Sujatha
Look at your step 4. It should read:
On the CATALOG database server, I invoked RMAN and connected to the
TARGET database and catalog database.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Sunday, February 16, 2003 9:54 PM
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: DENNIS WILLIAMS
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).
