Archive

Archive for March, 2014

Duplicating for standby PLS-00201: identifier ‘DBMS_RCVCAT.GETDBID’ must be declared

March 27, 2014 Leave a comment

when duplicating with

RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE;

you might encounter the following error

Starting restore at 27-MAR-14

using channel ORA_AUX_DISK_1

DBGSQL: TARGET> begin :fhdbi := dbms_rcvcat.getDbid; end;
DBGSQL: sqlcode = 6550
DBGSQL: B :fhdbi = 1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/27/2014 15:30:58
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-06550: line 1, column 17:
PLS-00201: identifier ‘DBMS_RCVCAT.GETDBID’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

to solve the above issue make sure you specify nocatalog when  when connecting with rman

Example

#rman nocatalog

Advertisements
Categories: Oracle

Oracle 12c RAC Upgrade – Best Practices

March 20, 2014 Leave a comment

Oracle 12c RAC Upgrade – Best Practices

Good webinar by Syed Jaffar Hussain about upgrading to oracle 12c 

 

Categories: Uncategorized