Tuesday, June 14, 2022

PL/SQL package DBNAME.DBMS_RCVCAT version 19.06.00.00. in RCVCAT database is not current

 
 
 
When trying to connect to catalog database from rman I am getting below error
 
 
HOSTNAME:dbname:/home/oracle $ rman target /
 
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 14 11:50:16 2022
Version 19.9.0.0.0
 
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
 
connected to target database: DBNAME (DBID=3401445687)
 
 
RMAN> connect catalog user/pass@catalogdb
 
connected to recovery catalog database
PL/SQL package DBNAME_EXA_RMAN.DBMS_RCVCAT version 19.06.00.00. in RCVCAT database is not current
PL/SQL package DBNAME_EXA_RMAN.DBMS_RCVMAN version 19.06.00.00 in RCVCAT database is not current
 
 

Reason :

 There is a version mismatch between the RMAN-executable and the RMAN-catalog SCHEMA


Solution :
 
HOSTNAME:dbname:/home/oracle $ rman target /
 
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 14 11:50:16 2022
Version 19.9.0.0.0
 
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
 
connected to target database: DBNAME (DBID=3401445687)
 
 
RMAN> connect catalog user/pass@catalogdb
 
connected to recovery catalog database
PL/SQL package DBNAME_EXA_RMAN.DBMS_RCVCAT version 19.06.00.00. in RCVCAT database is not current
PL/SQL package DBNAME_EXA_RMAN.DBMS_RCVMAN version 19.06.00.00 in RCVCAT database is not current
 
RMAN>
 
RMAN> upgrade catalog;
 
recovery catalog owner is DBNAME_EXA_RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade
 
-- give same command again
 
RMAN> upgrade catalog;
 
recovery catalog upgraded to version 19.09.00.00.00
DBMS_RCVMAN package upgraded to version 19.09.00.00
DBMS_RCVCAT package upgraded to version 19.09.00.00.
 
RMAN> exit
 
 
Refer:
 
Pl/Sql Package Rman.Dbms_rcvcat Version xxxxx In Rcvcat Database Is Not Current (Doc ID 1365435.1)

Thursday, June 9, 2022

How to find OEM Weblogic server and OEM Console URL 13c

 

During the Installation time of the OEM there is a file called "setupinfo.txt" will be created where we can fine the OEM url's


$ORACLE_HOME/oms/install/setupinfo.txt

(OR) 

we can find the ports from the below output too

$OMS_HOME/bin emctl status oms -details



Auto Scroll Stop Scroll