Unable to use jenkins to run oracle script on remote DB

0 votes

I am trying to run sql command at remote server as my screenshot using sqlplus-script-runner plugin. But this error comes up.

ERROR: ORACLE_HOME directory [10.53.253.161:1521/u01/app/oracle/product/12.1.0/dbhome_1] does not exist!

How can I configure Oracle_hme of remote database

enter image description here

May 3, 2018 in DevOps & Agile by shubham
• 7,340 points
5,958 views

2 answers to this question.

0 votes

Try putting the Oracle_home path same as on your local machine and also include the remote ip on the instance.

answered May 3, 2018 by ajs3033
• 7,300 points
Does it work. Does that plugin runs scripts on remote Db's?
Yeah, that sqlplus-script runner plugin will work but you have to follow the above steps.
I've multiple sql scripts in repo. Is there anyway I can pass filescript path to filescript field dynamically?
what is the meaning of  "also include the remote ip on the instance."
+1 vote
add ORACLE_HOME  in jenkins global variable.
answered Mar 27, 2019 by hal
Thanks, @Hal, that was helpful

Related Questions In DevOps & Agile

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

what is api token in jenkins and how to use for github webhook

Hi@Anil, GitHub webhook is used to trigger jenkins ...READ MORE

answered May 27, 2020 in DevOps & Agile by MD
• 95,460 points
2,106 views
+3 votes
4 answers

Unable to build docker image

It looks like the dev dependencies were ...READ MORE

answered Oct 11, 2018 in DevOps & Agile by lina
• 8,220 points

edited Oct 17, 2018 by lina 5,744 views
+3 votes
1 answer

Unable to find the TargetArguments path While configuring dot cover in VSTS

For your unable to find the TargetArguments ...READ MORE

answered Mar 27, 2018 in DevOps & Agile by ajs3033
• 7,300 points
1,089 views
+15 votes
2 answers

Git management technique when there are multiple customers and need multiple customization?

Consider this - In 'extended' Git-Flow, (Git-Multi-Flow, ...READ MORE

answered Mar 27, 2018 in DevOps & Agile by DragonLord999
• 8,450 points
3,919 views
+2 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP