Home » RDBMS Server » Networking and Gateways » Re: asp page says: ORA-12224: TNS:no listener
Re: asp page says: ORA-12224: TNS:no listener [message #66633] Tue, 17 September 2002 03:27 Go to next message
Peter
Messages: 62
Registered: August 2000
Member
I solved the error by bypassing a firewall, don't know which port is responsible, for sure not a standard IP port (20,21,80)

Report message to a moderator

Re: asp page says: ORA-12224: TNS:no listener [message #141946 is a reply to message #66633] Wed, 12 October 2005 19:48 Go to previous messageGo to next message
chewy_fruiti
Messages: 2
Registered: October 2005
Junior Member
May I know how to bypass the firewall?

Report message to a moderator

Re: asp page says: ORA-12224: TNS:no listener [message #142278 is a reply to message #141946] Fri, 14 October 2005 01:17 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


@Peter

The default port for Oracle Listener is 1521. Did you turn firewall off ? If so then the server is under security threat.


@chewy_fruiti

Go to the firewall options and give exception on the above specified port number or on the port number assigned to listener.

And the error number mentioned in the subject says this
Quote:


TNS-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.

Report message to a moderator

Previous Topic: data transfer from excel to oracle
Next Topic: SQL Plus Login issue
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 09:21:14 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.