/bin/sh: sqlplus: command not found

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

 


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.


All Replies
Seven Stars JGM
Seven 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.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.