Unable to run sqlplus commands from jenkins

Question

I have a shell script at Unix Server which contain sqlplus commands to do some validation.and I can run script using putty and see required result.In Unix server I have set up Oracle path and Library path in .bash_profile file. So when I start putty , it get loaded and can understand sqlplus command.

Now Challenge is

when I call that shell script from Jenkins(Windows node) then I get error "sqlplus command not found". Here I call .bash_profile file first then my shell script which have sqlplus commands.

Please help.

Do you use something like cygwin on windows? If not you can call your bash_profile whatever you want, but it is not going to source your commands. Add the location of the binaries to your windows Path as well — Rik
– Rik, Commented Dec 29, 2016 at 19:24
Windows machine is at some remote location and it keep changing as per availability... — shashank srivastava
– shashank srivastava, Commented Jan 2, 2017 at 8:24
First of all, the binary needs to be on the windows node as well. Then you can either run it from its abolute path C:\path\to\sqlplus\on\windows\node, or if you use powershell to run the commands, see this post or from bat, see this post. If it is a freestyle job, you can put it in the code area as well. Start with SET PATH=%PATH%;c:\path\to\sqlplus\on\windows\node — Rik
– Rik, Commented Jan 4, 2017 at 9:35
Additionally you can coinfigure the windows node "Manage Jenkins -> Manage Nodes -> 'Windows node' -> Configure - > Node properties" And add the path there — Rik
– Rik, Commented Jan 4, 2017 at 9:38

Community · Accepted Answer · 2017-05-23 12:33:48Z

0

Set up the PATH as an environment variable in your Jenkins job definition. More details here:

How to set up environment variables in Jenkins

edited May 23, 2017 at 12:33

CommunityBot

11 silver badge

answered Dec 30, 2016 at 0:56

codeforester

43.8k21 gold badges122 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

shashank srivastava Over a year ago

I have setup env variable in jenkins jobs which I used in my bash_profile (Path,Librarypath)..still getting error "sqlplus command not found".

Collectives™ on Stack Overflow

Unable to run sqlplus commands from jenkins

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related