topic Re: /bin/sh: sqlplus: command not found in Talend Studio

/bin/sh: sqlplus: command not found

Anonymous — Thu, 28 Sep 2017 16:33:01 GMT

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

Re: /bin/sh: sqlplus: command not found

Anonymous — Thu, 28 Sep 2017 16:41:37 GMT

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

Re: /bin/sh: sqlplus: command not found

Anonymous — Thu, 28 Sep 2017 18:20:48 GMT

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.

Re: /bin/sh: sqlplus: command not found

Anonymous — Fri, 29 Sep 2017 15:21:02 GMT

Problème résolu :

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

ORACLE_HOME
PATH

Now it's ok.