Can anyone help on this .Unable to resolve this issue ..
Regards Pradeep Goud On Thursday, October 6, 2016 at 4:43:33 PM UTC+5:30, pradeep palem wrote: > > 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 jenkinsci-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/da9650cc-73eb-421a-84ba-e348a16ab64f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
