Six Stars dgm
Six Stars

/bin/sh: sqlplus: command not found

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars dgm
Six Stars

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

Problème résolu :

 

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

  • ORACLE_HOME
  • PATH

 

Now it's ok.

3 REPLIES
Six Stars JGM
Six Stars

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

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

Six Stars dgm
Six Stars

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

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.

Six Stars dgm
Six Stars

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

Problème résolu :

 

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

  • ORACLE_HOME
  • PATH

 

Now it's ok.