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;

ORACLE 10G + FEDORA 10 + FEDORA 11

No encontre en ninguna pagina como instalar oracle 10 en fedora 10 o fedora 11 , asi que practicando y leyendo lo pude conseguir y lo mejor funciona muy bien!!.

Es una mezcla de instalaciones que vi , tanto para instalar oracle 11 en fedora 11 como oracle 10 en fedora 7. La pizca esta en encontrar los paquetes que faltan.

Bueno comenzemos y que sea solo un copy/paste:

1 - Editar /etc/sysctl.conf

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144

2 - /sbin/sysctl -p

3 -Editar  /etc/security/limits.conf y añadir


oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  1024
oracle              hard    nofile  65536

4 - editar /etc/pam.d/login y añadir

session    required     pam_limits.so

5 - editar /etc/selinux/config y modificar

SELINUX=disabled

6 - ahora , por mas que no muestre error hacemos esto : ponemos el dvd de fedora 10 o 11 y ejecutamos:

cd /media/dvd/Fedora

rpm -Uvh setarch-*
rpm -Uvh --force tcl-*
rpm -Uvh compat-db-*
rpm -Uvh --force libXau-devel-*

yum install libXp libaio
yum install compat-libstdc++* compat-libf2c* compat-gcc* compat-libgcc*

Esto nos mostrar algun error o no depende si es fedora 10 o 11 , pero no importa funciona bien.

7 - Lo de siempre creamos directorios:

mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01

8 - Editamos el /etc/redhat-release :

redhat-3

9 - creamos usuaiors y grupos:

groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin

useradd -g oinstall -G dba,oper,asmadmin oracle
passwd oracle

9 - Nos loguemos como usuario oracle y editamos el .bash_profile

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=TSH1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
 ulimit -p 16384
 ulimit -n 65536
else
 ulimit -u 16384 -n 65536
fi
fi

Ejecutamos como usuario oracle :

./runInstaller

Y work!!!

CLONAR ORACLE 32 bit a 64 bit

Una vez que clonaron con el comando duplicate de rman una base de datos oracle , tendran que hacer lo siguiente para que no les tire error y se compilen los objetos para un s.o de 64 bit.

sql>connect / as sysdba
sql>shutdown immediate;
sql>startup migrate;
sql> @$ORACLE_HOME/rdbms/admin/utlirp.sql
sql>shutdown immediate;
sql> startup
sql>
sql> @$ORACLE_HOME/rdbms/admin/utlrp.sql
sql> connect system/password

hay que hacer rsto para que los pl/sql se compilen en 64 bit