Error ORA-12541: TNS: no listener
540411Oct 18 2006 — edited Oct 18 2006I can't connect to Oracle databases, I check the connection using tnsping is ok. This is my configuration for tnsnames.ora
SPI.CSAM.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.106)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = spi)
)
)
JDE.CSAM.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.109)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jde)
)
)
I connect through a firewall too, and the port 1521 is open I don't know if I need open another port
Message was edited by:
jhonnycheong
Message was edited by:
jhonnycheong
null