ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_****

Error: Errors in file /u01/app/oracle/diag/rdbms/bpay/bpay/trace/bpay_j000_24499.trc: ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_586″ ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512: at “SYS.DBMS_STATS”, line 47207 ORA-06512: at “SYS.DBMS_STATS_ADVISOR”, line 882 ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 20059 ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 22201 ORA-06512: at “SYS.DBMS_STATS”, line 47197 Cause: It’s a known bug, the advisory…

Oracle Error: No listener – LISTENER failing to start upon windows startup

Case: Today morning on my development machine (Windows 10 ) I can’t login to the oracle schema with toad or from my application showing Oracle Error : No listener. Upon further investigation found that listener is not starting Automatically though its service configured to run automatically. Workaround: To resolve the “No Listener”, restarted workstation several times after changes…