Unable To Start Oracle Scheduler Agent. Start Command Hangs.
(Doc ID 1964073.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
One server "A" that hosts a database, has a schema that submits jobs externally to another reports server "B" .
When trying to start remote scheduler agent on server "B" it hangs.
Even though the scheduler agent is down, reports are still getting submitted.
Steps to reproduce the issue:
Agent not running or agent.pid file removed
At this point , had to kill the process with ctrl+c
The server on which the scheduler agent is running has been restarted, but it didn't solve the issue.
Have tried to de-register agent and re-register using:
> schagent -unregisterdatabase databaseHost databasePort
> schagent -registerdatabase databaseHost databasePort
but this didn't solve the issue.
This setup was working fine until the scheduler was stopped and tried to restart it to do a data refresh and as part of it, had to stop the scheduler, register the agent by providing the hostname and port of the refreshed database and start the agent.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!