DBMON job fails with "The Network Adapter could not establish the connection"

Products

• Autosys Workload Automation

Issue/Introduction

An Autosys DBMON (Database Monitoring) job fails immediately with the following error in the job log or autorep detail output: 

<java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection>

Environment

Autosys 12.1, 24.x 
Oracle Database

Cause

The error typically indicates one of the following configuration issues:

1. Incorrect JDBC Syntax: The connect_string format does not match the required Oracle Thin driver syntax for the target service or SID.
2. Network/Port Mismatch: The hostname or port in the connection string is unreachable from the machine where the job is scheduled to run.

Resolution

To resolve the connection failure, verify and update the job definition and secure credentials:

1. Update the Job Definition

Ensure the connect_string uses the correct format for an Oracle Service Name. Using the //hostname:port/service_name syntax is recommended for modern Oracle environments.

Example job definition:

jil

insert_job: dbmon_example_check
job_type: DBMON
machine: [target_agent_machine]
owner: <user1>
connect_string: "jdbc:oracle:thin:@//<hostname>:<port>/<service_name>"
monitor_cond: "job_type = 99"
monitor_type: INCREASE
tablename: aedbadmin.ujo_job
description: "Triggers on new CMD job"

2. Configure Database Credentials

Autosys requires database passwords to be stored securely. If the job uses a stored credential, ensure it is synchronized:

1. 1. Log in to the machine where the Autosys scheduler or agent is running.
   2. Execute the autosys_secure command.
   3. Select Option 5 (Manage database credentials).
   4. Enter the database user (e.g., user1) and provide the correct database password.