Jobs not running -- SESSION RETRYING DATABASE CONNECTION

Pradeepgaddipati

Hi all,

    Jobs are not running in DA. when i check the agentexec.log file. the log file showing the below errors.please find the attachment for complete agentexec.log file.

Fri Feb 25 07:22:53 2011 [WARNING] [AGENTEXEC 3919] Detected during the main job scheduling loop: Query returned the following warning:  [DM_SESSION_I_CONNECTED_TO_DATABASE]info:  "Successfully connected to database  on CMDBP"

[DM_SESSION_I_RETRYING_DATABASE_CONNECTION]info:  "The following error was encountered trying to get a database connection:  Could not obtain a connection

The server will retry 10 more time(s) (every 5 seconds)."

[DM_SESSION_E_DB_CONNECTION_FAILURE]error:  " "

[DM_SESSION_I_CONNECTED_TO_DATABASE]info:  "Successfully connected to database  on CMDBP"

[DM_SESSION_I_RETRYING_DATABASE_CONNECTION]info:  "The following .

Can anyone tell me what are possible reasons getting this type of errors and how to resolve the issue to make jobs run

Thanks in advance,

Thanks,

Pradeep

agentexec.logbkup

Viswa

It seems to be a problem with the connection between the Content Server and the database. Please look for the docbase log for any errors relating to database errors also look in the Oracle alert log for any errors with the help of your DBA. If possible restart your content server host and database host. It may solve the problem.