Oracle Jobs are aborting with error "sqlplus not found"
Article ID: 220320
Updated On:
Products
Issue/Introduction
We see all the programs are getting aborted in one of our production instance, below is error in the log.
-----------------------
Compute default parameters
-----------------------
/var/opt/AUTOMIC/DUAS/COMPANY_NODE/bin/bin_oapp/ux_orapps.ksh[499]: sqlplus: not found [No such file or directory]
End of the PL/SQL procedure call to compute default parameter values with code 127
--------------------------------------------------------------------------------
The concurrent program REQIMPORT can not be submitted by Dollar Universe.
Cause : could not compute default parameter values for REQIMPORT.
--------------------------------------------------------------------------------
Error: Status control error: 1
The execution of the concurrent program generated errors.
Environment
Release : 6.10.X
Component : DOLLAR UNIVERSE
Cause
Check for error in Job Log and universe.log on the node
Error message:
Job Log
/var/opt/AUTOMIC/DUAS/COMPANY_NODE/bin/bin_oapp/ux_orapps.ksh[499]: sqlplus: not found [No such file or directory]
End of the PL/SQL procedure call to compute default parameter values with code 127
Universe.log
|ERROR|X|OAP|p.t| uxoapp_syn_launch_sqlplus | An error occured during the SQL statement execution (SQL exit code: -1)
Cause: The sqlplus is not accessible to the manager via PATH.
Resolution
To resolve issue, please carry out below steps:
- Login to system as user running the Job/Task and load the Dollar Universe environment
[root@NODENAME TST600_NODENAME]# . ./unienv.ksh
DUAS environment loaded for Company TST600 Node NODENAME.
- Load the OEBS environment:
. $UNI_DIR_NODEFILES/unienv_oapp_specific.ksh
[root@NODENAME TST600_NODENAME]# . $UNI_DIR_NODEFILES/unienv_oapp_specific.ksh
E-Business Suite Environment Information
----------------------------------------
RUN File System : /d02/eBS/fs1/EBSapps/appl
PATCH File System : /d02/eBS/fs2/EBSapps/appl
Non-Editioned File System : /d02/eBS/fs_ne
DB Host: HOSTNAME Service/SID: VIS
Sourcing the RUN File System ... - Check that sqlplus can be launched correctly as the PATH should be updated when loading the OEBS environment file
[root@NODENAME TST600_NODENAME]# sqlplus
SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jul 26 11:42:09 2021 - In case "The command not found" is thrown, set the sqlplus command path in OEBS profile sourced in $UNI_DIR_NODEFILES/unienv_
oapp_specific.ksh
Feedback
