/bin/sh: sqlplus: command not found

[Anonymous]

Hello,

I'm using TAC 6.3 and below is the version of java on my job server

[user1@Server01 ~]$ java -version
java version "1.8.0_144"
Java(TM) SE Runtime Environment (build 1.8.0_144-b01)
Java HotSpot(TM) 64-Bit Server VM (build 25.144-b01, mixed mode)

My job simply excute a command (only one command)

When I change the command in my job to :

"touch /home/user1/touch.csv"

I have the file my server, the job execute normaly

[User1@Server01 ~]$ ls -ltr touch*
-rw-r--r-- 1 user1 user1 0 28 sept. 12:56 touch.csv
[User1@Server01 ~]$

When I change the command to

"sqlplus"

After job execution, I have the error message :

/bin/sh: sqlplus: command not found

When I connect to the server with user1, I can see the sqlplus is installed on the server.

Can anyone help please?

Sincerely

dgm

[Anonymous]

try giving the full path to your sqlplus binary -- if this works you would just need to add it to your PATH env var 

[Anonymous]

Hi JCM,

Thanks for your message.

[user1@Server01 ~]$ echo $PATH
...:/opt/oracle/na/11.2/bin:....
[user1@Server01 ~]$

When I connect to the linux server, I can see that the path to bin folder is there.

[user1@Server01 ~]$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 28 17:10:10 2017

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name:

I think that's why when I type "sqlplus" from any folder, I have an answer.

[Anonymous · Accepted solution]

Problème résolu :

I included in the tsystem component of talend two environment variables:

• ORACLE_HOME
• PATH

Now it's ok.