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

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

book

Article ID: 408032

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine Automic SaaS

Issue/Introduction

SQLPlus jobs fail with Error: 45 occurs during the initialization of SQL*Plus when executing scripts via the Agent. This issue impacts both Windows and Linux Agents and occurs when the SQL script does not properly terminate without an explicit EXIT command., leading to an initialization failure.

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.