SQL plus from command line returns: Error 45 initializing SQL*Plus
search cancel

SQL plus from command line returns: Error 45 initializing SQL*Plus

book

Article ID: 408032

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine Automic SaaS

Issue/Introduction

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

 

Environment

Automic Automation Engine 24.X

Oracle client (OCI): 19.27.0.0.0

Cause

Issue.

Resolution

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

Additional Information

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