Unable To Start Oracle Scheduler Agent. Start Command Hangs.
Last updated on DECEMBER 06, 2016
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms