ORA-12012: error on auto execute of job # ORA-44003: invalid SQL name

Es un bug

Lo podes parar de esta forma , pero no se va a ejecutar mas el auto_space_advisor:

SQL> execute dbms_scheduler.disable('AUTO_SPACE_ADVISOR_JOB');

o

Aplicar el Patch 4519934 .

Si lo necesitan me avisan.

Aplicacion:

unzip  p4519934_10201_LINUX.zip

Connect as SYS
Then run rdbms/admin/prvtdadv.plb
Then run rdbms/admin/prvtspcu.plb

RMAN-06429: TARGET database is not compatible with this version of RMAN

In general, the rules of RMAN compatibility are as follows:

The RMAN catalog schema version should be greater than or equal to the catalog database version.
The RMAN catalog is backwards compatible with target databases from earlier releases.
The versions of the RMAN executable and the target database should be the same.

MY DB:

BD REPOSITORY:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Prod

SQL> select * from rcver;

VERSION
------------
10.02.00.0

BD TARGET:

Oracle Database 11g Release 11.2.0.1.0 - 64bit Production


You can upgrade the catalog schema ,do the following:

1. Connect to target and catalog using the 11.2.0.1 RMAN executable.
2. Run this command two times: RMAN> upgrade catalog;
3. Run the RMAN duplication again.


RMAN> upgrade catalog;

recovery catalog owner is RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade

RMAN> upgrade catalog;
recovery catalog upgraded to version 11.02.00.01
DBMS_RCVMAN package upgraded to version 11.02.00.01
DBMS_RCVCAT package upgraded to version 11.02.00.01

and ready!!.

Notes:
if show the next mistake:


error creating rc_offline_range
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-01031: insufficient privileges.

you need do the next as user sys:

grant RECOVERY_CATALOG_OWNER to rman;

and run again upgrade catalog;