Unable to use jenkins to run oracle script on remote DB

Question

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

Answer 1

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

Comments

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."

Answer 2

add ORACLE_HOME  in jenkins global variable.

Comments

Thanks, @Hal, that was helpful