Home » RDBMS Server » Networking and Gateways » ora-12224: tns:no hay ningun receptor (ORACLE 11G on Windows Server 2012)
ora-12224: tns:no hay ningun receptor [message #673369] Sat, 17 November 2018 07:13 Go to next message
Messages: 1
Registered: November 2018
Junior Member

Good Lords, someone of you could help me with this problem:

-- now-12224: tns: there is no receiver

-- ora-12224: tns:no hay ningun receptor

... I can not connect to the BD from the system ... the listener is up. Apparently it is a damage in the BD but I would not know how to repair it.
Re: ora-12224: tns:no hay ningun receptor [message #673370 is a reply to message #673369] Sat, 17 November 2018 07:48 Go to previous message
Michel Cadot
Messages: 68597
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-12224: TNS:no listener
 *Cause: The connection request could not be completed because the listener
 is not running.
 *Action: Ensure that the supplied destination address matches one of
 the addresses used by the listener - compare the TNSNAMES.ORA entry with
 the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
 go by way of an Interchange). Start the listener on the remote machine.
Post what you did when you get the error.
Post the tnsnames.ora (client side)
Post the sqlnet.ora (client side)
Post the listener.ora (server side)
Post the result of
lsnrctl status
Before, Please read How to use [code] tags and make your code easier to read.

[Updated on: Sat, 17 November 2018 07:51]

Report message to a moderator

Previous Topic: Interoperating different releases of database and HS gateway
Next Topic: ORA-12514: TNS
Goto Forum:

Current Time: Tue Feb 27 04:03:25 CST 2024