Jenkins sqlplus script runner plugin error ORA-12541: TNS:no listener

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Jenkins sqlplus script runner plugin error ORA-12541: TNS:no listener

rakesh reddy
Hi ,

We are getting the below error while we we try to run basic command through sqlplus script runner plugin. Please help me.

Using ORACLE_HOME =/u01/ora/10.2.0/db_1
--------------------------------------------------------------------------
Getting SQLPlus version
Process exited with status 0
--------------------------------------------------------------------------
--------------------------------------------------------------------------
Using ORACLE_HOME =/u01/ora/10.2.0/db_1
--------------------------------------------------------------------------
Running defined script on apps/********@hlmcm
Temp script:/tmp/temp-script-15059305636003383707752329208328.sql
--------------------------------------------------------------------------

SQL*Plus: Release 10.2.0.1.0 - Production

Process exited with status 1
java.lang.RuntimeException: Process exited with error
	at org.jenkinsci.plugins.sqlplusscriptrunner.SQLPlusRunner.invoke(SQLPlusRunner.java:249)
	at org.jenkinsci.plugins.sqlplusscriptrunner.SQLPlusRunner.invoke(SQLPlusRunner.java:16)
	at hudson.FilePath.act(FilePath.java:996)
	at hudson.FilePath.act(FilePath.java:974)
	at org.jenkinsci.plugins.sqlplusscriptrunner.SQLPlusRunnerBuilder.perform(SQLPlusRunnerBuilder.java:98)
	at hudson.tasks.BuildStepMonitor$1.perform(BuildStepMonitor.java:20)
	at hudson.model.AbstractBuild$AbstractBuildExecution.perform(AbstractBuild.java:779)
	at hudson.model.Build$BuildExecution.build(Build.java:206)
	at hudson.model.Build$BuildExecution.doRun(Build.java:163)
	at hudson.model.AbstractBuild$AbstractBuildExecution.run(AbstractBuild.java:534)
	at hudson.model.Run.execute(Run.java:1728)
	at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
	at hudson.model.ResourceController.execute(ResourceController.java:98)
	at hudson.model.Executor.run(Executor.java:405)
ERROR: Process exited with error
Checking console output

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 20 18:02:43 2017

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12541: TNS:no listener


SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

Thanks,
Rakesh.

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/3e5289d8-8249-4fcb-ad1b-74bbd168b06c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: Jenkins sqlplus script runner plugin error ORA-12541: TNS:no listener

s mishra
Hi Rakesh,

TNSNAMES.ORA is configuration file that defines databases addresses for establishing connections to them.

You have to create under /u01/ora/10.2.0/db_1/network/admin and define the TNSNAMES.ORA file.

TNSNAMES.ORA 

NADB=
 (description=
   (address_list=
     (address = (protocol = TCP)(host = 10.254.3.198)(port = 1521))
   )
 (connect_data =
   (service_name=NADB)
 )
)


Thanks,
Sameek Mishra

On Thursday, September 21, 2017 at 4:40:18 AM UTC+5:30, rakesh reddy wrote:
Hi ,

We are getting the below error while we we try to run basic command through sqlplus script runner plugin. Please help me.

Using ORACLE_HOME =/u01/ora/10.2.0/db_1
--------------------------------------------------------------------------
Getting SQLPlus version
Process exited with status 0
--------------------------------------------------------------------------
--------------------------------------------------------------------------
Using ORACLE_HOME =/u01/ora/10.2.0/db_1
--------------------------------------------------------------------------
Running defined script on apps/********@hlmcm
Temp script:/tmp/temp-script-15059305636003383707752329208328.sql
--------------------------------------------------------------------------

SQL*Plus: Release 10.2.0.1.0 - Production

Process exited with status 1
java.lang.RuntimeException: Process exited with error
	at org.jenkinsci.plugins.sqlplusscriptrunner.SQLPlusRunner.invoke(SQLPlusRunner.java:249)
	at org.jenkinsci.plugins.sqlplusscriptrunner.SQLPlusRunner.invoke(SQLPlusRunner.java:16)
	at hudson.FilePath.act(FilePath.java:996)
	at hudson.FilePath.act(FilePath.java:974)
	at org.jenkinsci.plugins.sqlplusscriptrunner.SQLPlusRunnerBuilder.perform(SQLPlusRunnerBuilder.java:98)
	at hudson.tasks.BuildStepMonitor$1.perform(BuildStepMonitor.java:20)
	at hudson.model.AbstractBuild$AbstractBuildExecution.perform(AbstractBuild.java:779)
	at hudson.model.Build$BuildExecution.build(Build.java:206)
	at hudson.model.Build$BuildExecution.doRun(Build.java:163)
	at hudson.model.AbstractBuild$AbstractBuildExecution.run(AbstractBuild.java:534)
	at hudson.model.Run.execute(Run.java:1728)
	at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
	at hudson.model.ResourceController.execute(ResourceController.java:98)
	at hudson.model.Executor.run(Executor.java:405)
ERROR: Process exited with error
Checking console output

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 20 18:02:43 2017

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12541: TNS:no listener


SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

Thanks,
Rakesh.

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/52589d45-4f4b-4fbe-9e7a-cf33e84925a7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.