A Windows job utilizing SQL*Plus returns the following return code, although the SQL statement completes successfully.
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
Automic Automation Engine 24.X
Oracle client (OCI): 19.27.0.0.0
Issue.
Public Title:
SQLPLUS command from a Windows Job ends with error message " Error 45 initializing SQL*Plus ".
Public Description:
A problem has been fixed where the Java-based OS Agent did not deliver EOF to a program that tried to read from stdin. This caused the message "Error 45 initializing SQL*Plus" if you forgot to add EXIT in your sql file.
Component: Agent Windows
Automic Automation Engine 24.4.1 HF2 - Available
Update to a fixed version listed below or a newer version if available.
Article title: How to register to Broadcom Software Product updates and Critical Alerts
https://knowledge.broadcom.com/external/article?articleId=133819
Defect ID: DE173981