Category: Oracle

FIXING DispatchingTaskScheduler:1071

  REQUEST 13c agents generates many DispatchingTaskScheduler alerts. I want to stop them to be generated.   SYMPTOMS Host=dbpilot.net Target type=Agent Target name=dbpilot.net:3872 Categories=Diagnostics Message=Internal error detected: java.lang.Throwable: oracle.sysman.gcagent.task.scheduler.DispatchingTaskScheduler:1071. Severity=Critical Event reported time=Feb 12, 2018 7:43:23 AM MSK Customer Support Identifier=10000001 Operating System=Linux Platform=x86_64 Associated…

QUERYING THE ORACLE_HOME PATH FROM A DATABASE

  REQUEST I want to get the ORACLE_HOME path by querying the database.   RELATED GETTING THE VALUE OF AN ENVIRONMENT VARIABLE THROGHT PL/SQL BLOCK   SOLUTION   DBMS_SYSTEM COL ORACLE_HOME FOR A30 VARIABLE ORACLE_HOME VARCHAR2(100); EXEC DBMS_SYSTEM.GET_ENV(‘ORACLE_HOME’,:ORACLE_HOME); PRINT ORACLE_HOME ORACLE_HOME —————————— /oracle/product/12.2.0.1   DBA_LIBRARIES…