SQL*Plus returns Error 45 initializing on Windows and Linux Agents

Products

• CA Automic Workload Automation - Automation Engine
• Automic SaaS

Issue/Introduction

 

SQLPlus jobs fail with "Error 45 initializing SQLPlus" when executed by the OS Agent. This issue occurs when the job script terminates without an explicit EXIT command.

sqlplus <user>/<password>@<Oracle_DB>:1521/<DB> @C:\Automic\Agents\sql.txt 
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jul 31 10:30:05 2025
Version 19.27.0.0.0
Copyright (c) 1982, 2024, Oracle.  All rights reserved.
Last Successful login time: Thu Jul 31 2025 10:29:58 +00:00
Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.7.0.25.01
  COUNT(*)
----------
      1323
SQL> Error 45 initializing SQL*Plus
Internal error

 

Environment

• Automic Automation Engine v24.4.1 HF1 and earlier (Windows)
• Automic Automation Engine v24.4.4 HF2 and v24.4.5 (Linux)
• Oracle client (OCI) 19.x, 21.x

Cause

• Windows: The Windows OS Agent failed to deliver EOF to programs reading from stdin. (Defect DE173981)
• Linux: A regression introduced in the Linux Agent causes stdin to open as write-only, preventing the SQL*Plus process from receiving a clean EOF. (Defect DE209903)

Resolution

• Workaround: Add the EXIT; command to the end of the SQL script. This ensures SQL*Plus terminates properly and prevents Error 45.
• Fix Status:
  • Windows: Fixed in Automation Engine 24.4.1 HF2 (available)
  • Linux: Fixed in Automation Engine 24.4.5 HF2 (available), 26.1.0 (September 2026)

Subscribe to this article to receive updates on the status of this fix: How to subscribe to Broadcom articles.

Additional Information

• If the issue persists after applying the workaround, please contact Support. To speak with a customer representative or a Support Engineer see Contact Support. Scroll to the bottom of the page and click on your respective region.