Hoy vamos a volver con una entrada rapida sobre un error basante sencillo.
Es posible que conectando a vuestro VPC rman catalog user encontreis el error
-bash-4.1$ rman catalog rmanvc3/vcpass3@TEST2 Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jul 16 15:27:12 2024 Version 19.22.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: TEST2(DBID=3270) connected to recovery catalog database recovery catalog schema version 19.23.00.00. is newer than RMAN version RMAN-07540: Cleanup is required for the VPC user schema Recovery Manager complete.
Que puedo hacer pasa solucionarlo?
Desde a version 12.x la configuracion del VPC cambio causando a los usuarios algun que otro quebradero de cabeza con los permis0s.
Afortunadamente, oracle nos dio el script dbmsrmanvpc.sql que lo soluciona.
Aunque se puede ejecutar para cada VPC, mi consejo es usarlo con todos de golpe con la opcion -all , nos conectamos como sysdba a la base de datos que contiene el catalogo
sqlplus @/as sysdba" Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 SQL> @?/rdbms/admin/dbmsrmanvpc.sql -all Checking the operating user... Passed ======================================== Upgrading the VPC user schemas registered in the base catalog of RMAN_CAT ---------------------------------------- Upgrading: RMANVC01 Synonyms... Views... Cleanup of privileges... Grant of privileges... ======================================== Upgrading the VPC user schemas registered in the base catalog of RMAN_CAT ---------------------------------------- Upgrading: RMANVC02 Synonyms... Views... Cleanup of privileges... Grant of privileges... ======================================== ======================================== Upgrading the VPC user schemas registered in the base catalog of RMAN_CAT ---------------------------------------- Upgrading: RMANVC03 Synonyms... Views... Cleanup of privileges... Grant of privileges... ---------------------------------------- Removing old VPC views in the base catalog of RMAN_CAT... ---------------------------------------- Removing old VPC views in the base catalog of RMANVC03...
Y arreglado!