Error Using Jenkins to execute oracle script at remote database?

Question

I am using sqlplus-script-runner plugin to run my sql command at remote server as my screenshot, but I got error:

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

Do you know how to config Oracle_home of remote db ?

taibc · Accepted Answer · 2017-05-25 02:16:57Z

3

I found the answer: Oracle_home is oracle path on my local machine and include the remote ip on the instance

answered May 25, 2017 at 2:16

taibc

9233 gold badges16 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dave M. · Accepted Answer · 2017-05-23 09:51:12Z

-1

Try changing your url to 10.53.253.161:1521/u01/app/oracle/product/12.1.0

Does Jenkins user have visibility to that folder?

answered May 23, 2017 at 9:51

Dave M.

13210 bronze badges

5 Comments

taibc Over a year ago

I still get error. I can access db using pls sql developer with tnsname as below (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.53.253.161)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = test12cp1) ) )

taibc Over a year ago

I can access ftp to that path, too

Dave M. Over a year ago

Is ORACLE_HOME variable setted on remote computer?

taibc Over a year ago

yes, at server 10.53.253.161, ORACLE_HOME is set to /u01/app/oracle/product/12.1.0/dbhome_1

taibc Over a year ago

I tried to change instance to " (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.53.253.161)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = test12cp1) ) )", but still got the same error

Collectives™ on Stack Overflow

Error Using Jenkins to execute oracle script at remote database?

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related