Hi All, I am trying to run the oracle sql script which sits in aws rds from jenkins server(AWS linux).I have instlled sql*plus on my jenkins server . I can able to connect database and execute quires manually from my command prompt .i,e Jenkins server.
When i am trying to execute thru Jenkins am facing errors but the build got success. I configured *SQLPlus Script Runner Plugin <https://wiki.jenkins-ci.org/display/JENKINS/SQLPlus+Script+Runner+Plugin>* and followed the same instructions plugin installation page. https://wiki.jenkins-ci.org/display/JENKINS/SQLPlus+Script+Runner+Plugin I tried below approaches: username:abc pwd:123 hostname::qa.xx.xx..amazonaws.com portno:1521 SID:QA 1. when i configured sql plus running plugin with hostaname:qa.xx.xx..amazonaws.com user:abc pwd:123 script to run :/var/jenkins/workspace/db/scripts/test/sql ERROR: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus Finished: SUCCESS 2.when i configured sql plus running plugin with hostaname:QA user:abc pwd:123 script to run :/var/jenkins/workspace/db/scripts/test/sql ERROR: ORA-12154: TNS:could not resolve the connect identifier specified 3. when i configured sql plus running plugin with hostaname:qa.xx.xx..amazonaws.com:1521:QA user:abc pwd:123 script to run :/var/jenkins/workspace/db/scripts/test/sql ERROR: ORA-12545: Connect failed because target host or object does not exist Please correct me if i am missing any where or help me out . Please find the attachment for more info. Thanks in advance Regards, Pradeep -- You received this message because you are subscribed to the Google Groups "Jenkins Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/e0d4fa00-e913-489c-989e-ccb576436dc2%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Error log.docx
Description: MS-Word 2007 document
