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,480 points
791 views

2 answers to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,000 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 420 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,000 points
56 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,000 points
104 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.