I can login using this command:
But not this one: (where 192.168.0.240) is my IP
I am absolutely sure that my ip address (server's adress) is
192.168.0.240. So why am I getting the following error?
ORA-12541: TNS:no listener
I get a connection timeout when trying to connect from other computers.
lsnrctl statusgives me the following:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 18.104.22.168.0 - Produ ction Start Date 23-OCT-2013 15:27:35 Uptime 0 days 21 hr. 37 min. 20 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File C:\app\pc2\product\11.2.0\dbhome_2\network\admin\liste ner.ora Listener Log File c:\app\pc2\diag\tnslsnr\pc2-PC\listener\alert\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "local" has 1 instance(s). Instance "local", status READY, has 1 handler(s) for this service... Service "localXDB" has 1 instance(s). Instance "local", status READY, has 1 handler(s) for this service... The command completed successfully