My Oracle Support Banner

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 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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:

$ /u01/app/oracle/Client/stop_agent.sh
Agent not running or agent.pid file removed

$ /u01/app/oracle/Client/start_agent.sh
>> hangs
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.

Changes

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.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.