Stack Overflow
Stack Overflow

Questions tagged [ora-12541]

ORA-12541: TNS no listener

An ORA-12541 error occurs when the listener for the destination server is down or unreachable when you try to connect.

Cause: Listener for the source repository has not been started.

Action: Start the Listener on the machine where the source repository resides.

16 questions
7
votes
7 answers

Using oracle db through ssh tunnel. Error "ORA-12541: TNS:no listener"

Hello I've got a problem accessing Oracle DB from our datacenter through a tunnel. We've got a pretty standard datacenter with one machine being accessible from the outside (I put it's IP in the /etc/hosts file as dc) and the Oracle DB inside. The…
Jakub Troszok
  • 99,267
  • 11
  • 41
  • 53
4
votes
4 answers

Why do I get a "no listener" error when using Rails with Oracle?

I am using Rails 2.3.5 and Oracle 10 as my database, use "oracle_adapter" , and ruby-oci8 to connect to the Oracle host. I get this exception: Completed in 463ms (View: 18, DB: 166) | 200 OK [http://192.168.30.128/auctions?page=1] /!\ FAILSAFE /!\ …
qichunren
  • 4,405
  • 7
  • 37
  • 48
4
votes
10 answers

Ora 12154 error

I recently deploy one web application in one of my development servers. I'm using oracle, asp.net and c#. When I run the application in the server everything works fine, but when I try to run the application outside of the server (using my pc, for…
Hugo Assanti
  • 421
  • 1
  • 8
  • 16
3
votes
4 answers

ODP .NET TNS:no listener

I'm currently trying to connect to an Oracle database. I can connect fine on my development machine, but when I deploy to my Win2k3 sp2 server I get the following error. Faile to open connection... Oracle.DataAccess.Client.OracleException ORA-12541:…
jreddy
  • 143
  • 2
  • 8
2
votes
1 answer

Oracle XE 18C Express Edition Ora-12541 : TNS : No listener

I installed Oracle XE 18C Express Edition on my Windows 10 and successefully connected to the pluggable database XEPDB1 the first time.After that, all my temptations to connect to this database have failed. The error I receive is : Ora-12541 : TNS :…
Ifada
  • 25
  • 1
  • 5
1
vote
1 answer

Connect Oracle DB using service_name instead of SID using ojdbc14.jar driver in WebLogic Server 6.1 SP1 with JDK 3

While Working on a legacy application that first file date back to year 2005. It used to create connection pool that is mapped to DataSource that application connects with, URL: jdbc:oracle:thin:@host.test.intranet:1521:service_name Driver…
Vishesh
  • 133
  • 3
  • 11
1
vote
2 answers

Error when tring to connect adodb to Oracle

I have installed WAMP server. When trying to connect to Oracle it gives this error: ORA-12541: TNS:no listener Anyone know how to solve this?
maxjackie
  • 22,386
  • 6
  • 29
  • 37
1
vote
1 answer

when we try to connect our programme with oracle it is giving error

when i try to connect our programme with oracle with this command sqlplus crbt/crbt@crbt_new here crbt is the username and crbt_new is the password. it is giving error this SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jan 4 10:32:42…
user556761
  • 251
  • 3
  • 5
  • 9
1
vote
0 answers

Try moving EZCONNECT to the first position in NAMES.DIRECTORY_PATH in the sqlnet.ora file

When I try to drop a procedure in Oracle 12C I get a message saying statement procesing all the time. I restarted the Oracle server from linux Oracle OS. I now get this exception ORA-12541: TNS:no listener Items Checked TNS_ADMIN environment…
MRddnn
  • 23
  • 1
  • 7
1
vote
2 answers

ORA-12541 error when deploying SSIS package to a server

I am connecting SSIS to Oracle OLEDB connection using below connection string.. Data Source=Server_Name;User ID=U_Id;Password=Pwd;Provider=MSDAORA.1; It works on my machine but when i run on SSIS server using C:\Program Files (x86)\Microsoft SQL…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
0
votes
0 answers

ORA-12541: TNS: no listener

I have a VM in Oracle VM Virtual Box running Windows XP. In this VM, I have install Visual Studio .net 2003 with nhibertante ORM to connect to BBDD Oracle 12.2. Oracle database is hosts in my physical machine with Windows 11 SO. The network…
ddelafuente
  • 3
  • 2
0
votes
1 answer

connect to oracle db computer in a LAN in asp.net

Im trying to connect to a oracle 11g db on a LAN system in asp.net. But Im getting ORA-12541: TNS:no listener error. I made following changes in the files ..... sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (BEQ, TCPS, NTS) NAMES.DIRECTORY_PATH=…
praveenb
  • 10,549
  • 14
  • 61
  • 83
0
votes
0 answers

TNS-12541: TNS:no listener on entering ./sqlplus anju/XXXX@999.000.0.000/ORA12C

I get the listener error when I run this command:- ./sqlplus anju/XXXX@999.000.0.000/ORA12C I did start my listener still it doesn't work. SNRCTL for Linux: Version 12.2.0.1.0 – Production on 14-MAY-2020 10:21:14 Copyright (c) 1991, 2016, Oracle.…
Anjana
  • 1
0
votes
2 answers

Error While making http request from Oracle DB Trigger - java.sql.SQLException: ORA-29273: HTTP request failed ORA-12541: TNS:no listener

I'm using below code to make http call via Oracle DB trigger create or replace TRIGGER TEST_TABLE_TRIGGER AFTER INSERT OR UPDATE OF VALUE ON TEST_TABLE for each row DECLARE req utl_http.req; res utl_http.resp; buffer varchar2(4000); url…
VGH
  • 305
  • 6
  • 20
0
votes
1 answer

Excel Macro to connect to Oracle Database

I have below excel macro to connect to oracle database. But, one executing the code, I get the error message - "Run-time error '-2147467259 (80004005)': ORA-12541:TNS:no listener" Please help me resolve this error message. I have 'Oracle SQL…
TausifAhmed
  • 9
  • 1
  • 4
1
2