Listener error, log included

I'm no longer able to log into an oracle database I had set up weeks ago, and I need some help troubleshooting. I'm very new to this, I'd appreciate any help with terminology as well as helping identify a cause or solution.

I'm unable to log into my database named ORCL through SQL Plus or the Enterprise Manager Console. When I supply a username, password, and host I receive "ORA-12541: TNS:no listener".

I checked the listener status and receive this:

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fullcomputername)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
LSNRCTL>

I checked the listener.log file, and think it appears to have failed a few days after my installation. See below log:

28-JUN-2008 23:55:15 * ping * 0
28-JUN-2008 23:55:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=(P ROTOCOL=TCP)(HOST=fullcomputername)(PORT=1521)))(VERSION=169869568)) * status * 0
28-JUN-2008 23:55:22 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=fullcomputername)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2462)) * establish * orcl * 0
28-JUN-2008 23:55:22 * service_update * orcl * 0
28-JUN-2008 23:59:22 * service_update * orcl * 0
28-JUN-2008 23:59:41 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\bin\emagent.exe)(HOST=fullcomput ername)(USER=OraUser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2496)) * establish * orcl * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 2: No such file or directory
28-JUN-2008 23:59:41 * service_died * orcl * 12547
TNS-12547: TNS:lost contact
28-JUN-2008 23:59:56 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\bin\emagent.exe)(HOST=fullcomput ername)(USER=OraUser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2498)) * establish * orcl * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 29-JUN-2008 00:44:42

Copyright (c) 1991, 2005, Oracle. All rights reserved.

System parameter file is C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Log messages written to C:\oracle\product\10.2.0\db_1\network\log\listener.log
Trace information written to C:\oracle\product\10.2.0\db_1\network\trace\listener.trc
Trace level is currently 0

Started with pid=428
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
TNS-12560: TNS:protocol adapter error
TNS-00583: Valid node checking: unable to parse configuration parameters

I'm not too sure what other information is relevant, I'd appreciate any and all help. What can I check and test?

Regards

Here's some more information regarding:

'TNS-12505: TNS:listener does not currently know of SID given in connect descriptor'

My listener.ora file
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = fullcomputername)(PORT = 1521))
)
)

And my tsnames.ora file

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fullcomputername)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

do you have a listener runing?

When I try to force start the service, it automatically stops and gives the error.

"The Listener service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

dway,

even i faced the same issue. You just stop the listener, stop the oracle service and then restart the oracle serviceand the listener.

Knitty, thanks for your reply.

I restarted the OracleService and Listener service, and still faced the same errors. When I manually stop all Oracle services and try logging in I still get a no listener error. When I try logging on as SYSTEM, it gives me a protocol adapter error. I find that very strange....

Any other suggestions?

dway,

how ur connecting to the database? just by username system or system@connect_string??

I can log on as SYSTEM, without supplying a host string. Any attempt to authenticate with ORCL gives the listener error.

can you attach below command out put from command prompt

lsnrctl status

mvdreddy, I have already done so on my first post. Here it is again for good measure:

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-JUL-2008 08:03
:58

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fullcomputername)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
LSNRCTL>