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
• 6,870 points
1,022 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,240 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?
0 votes
add ORACLE_HOME  in jenkins global variable.
answered Mar 26 by hal
Thanks, @Hal, that was helpful

Related Questions In DevOps & Agile

0 votes
1 answer
0 votes
1 answer
+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,100 points

edited Oct 17, 2018 by lina 643 views
+13 votes
2 answers
0 votes
1 answer
+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,240 points
70 views
0 votes
1 answer

unable to build .Net project using NUGet

you just need the developer pack for ...READ MORE

answered Apr 3, 2018 in DevOps & Agile by ajs3033
• 7,240 points
124 views