DBMS_SCHEDULER OPERATION GETS ORA-2800 ON A VIRTUAL SERVER (VMWARE)
plhtyukMar 17 2008 — edited Mar 18 2008Hi everyone,
We just installed Oracle 11G on a VM machine (VMWARE).
When I try to run a job (any job), I receive this error:
SQL> exec dbms_scheduler.run_job('GEN_BD', FALSE)
BEGIN dbms_scheduler.run_job('GEN_BD', FALSE); END;
*
ERROR at line 1:
ORA-02800: Requests timed out
ORA-06512: at "SYS.DBMS_ISCHED", line 154
ORA-06512: at "SYS.DBMS_SCHEDULER", line 450
ORA-06512: at line 1
But when I set use_current_session to TRUE:
SQL> exec dbms_scheduler.run_job('GEN_BD', TRUE)
PL/SQL procedure successfully completed.
But even when it complete successfully, the job do nothing.
Anyone knows what is/are the problem(s)?
Regards.
Carl
Message was edited by:
plhtyuk
Message was edited by:
plhtyuk