Remote connection receives ORA-12224 TNS:no listener
552758Oct 4 2007 — edited Oct 10 2007We have recently moved the server, gave it a new IP address, and new name. When I try to make a connection from a remote server I receive the error ORA-12224 TNS: no listener.
I've checked that the listener is running on the db server, and verified that the tnsnames.ora files were updated. I tried using the server name in the host field as well as the IP and still no luck.
When I run lsnrctl status on the db server I get the following output:
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.3.0 - Produc
tion
Start Date 04-OCT-2007 09:52:27
Uptime 0 days 0 hr. 55 min. 55 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:\oracle\ora92\network\admin\listener.ora
Listener Log File C:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DBS1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DBS1)(PORT=8080))(Presentation=H
TTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DBS1)(PORT=2100))(Presentation=F
TP)(Session=RAW))
Services Summary...
Service "XXXX" has 2 instance(s).
Instance "XXXX", status UNKNOWN, has 1 handler(s) for this service...
Instance "XXXX", status READY, has 1 handler(s) for this service...
The command completed successfully
I've rebooted the server, restarted the listener, but I still receive the error. We are on oracle v 9.0.2
Any ideas?