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,890 points
1,264 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,280 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 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,110 points

edited Oct 17, 2018 by lina 865 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,280 points
87 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,280 points
152 views
+13 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 26, 2018 in DevOps & Agile by DragonLord999
• 8,380 points
148 views
0 votes
1 answer