/bin/sh: sqlplus: command not found

Highlighted
Six Stars
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
Highlighted
Six Stars
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.

View solution in original post


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

Highlighted
Six Stars
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.

Highlighted
Six Stars
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.

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog