[Rijke111]

Hello,

I am not an experienced user of listener.

When I try to start the listener, I get the following error:


LSNRCTL> start
Starting tnslsnr80: please wait...

TNSLSNR80 for 32-bit Windows: Version 8.0.4.0.0 - Production
System parameter file is C:\orawin95\net80\admin\listener.ora
Log messages written to C:\orawin95\net80\log\listener.log
Trace information written to C:\orawin95\net80\trace\listener.trc
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=192)(HOST=127.0.0.1)(P ORT=1521))
Attempted to listen on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
TNS-12560: TNS: protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 161: Unknown system error



I am running the listener on a M$ W2K machine, in M$ Win 98 it was running correct.

Does anybody know how to solve this issue,

Thanx in advance,

Regards,
Ray

[Ruudboy]

Don't know exactly what goes wrong there..
But can't you remove the ADRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1)) part from the listener.ora?
Normally you just need the TCP part.

Groetjes

[Rijke111]

Hoi,

I've already tried to do that, but the problem is that I have more Listener.ora files.

Is it that when the first Listener.ora file doesn't work the next one takes over??

Thanks already for your reply.

Groeten,
Raymond

[Rijke111]

Hoi,

I just renamed the rest of the Listener.ora files.
It did not work.

It still comes up with:

Attempted to listen on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))

This is what my Listener.ora says:

LISTENER =
(ADDRESS_LIST =
# (ADDRESS =
# (PROTOCOL = TCP)
# (Host = *.*.*.*)
# (Port = 1521)
# )
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
# (ADDRESS =
# (PROTOCOL = SPX)
# (Service = CACST W95_lsnr)
# )
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(SID_NAME = ORCL)
)

)

Is there something wrong with this file???

Thanks in advance.

Groeten,
Raymond

[Ruudboy]

Are you sure it's using the correct listener.ora file?
You can see this by typing 'lsnrctl status'

[Rijke111]

Here is the status:

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521) )
TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown system error

So I think it is using the correct Listener.ora file.

Thanks,
Raymond

[Ruudboy]

Hmm that's strange..

Here's what I found on Metalink about this problem:

Problem Description:
====================

You cannot start the listener on Windows NT.

When trying to start the listener from the LSNRCTL80 prompt, you are see the
following errors:

TNS-12560: "protocol adapter error"
Cause: A generic protocol adapter error occurred.
Action: Check addresses used for proper protocol specification. Before
reporting this error, look at the error stack and check for
lower level transport errors. For further details, turn on
tracing and reexecute the operation. Turn off tracing when the
operation is complete.

TNS-00530: "protocol adapter error"
Cause: A generic protocol adapter error occurred.
Action: For further details, turn on tracing and reexecute the operation.

32-Bit Windows error:38:file name too long


Solution Description:
=====================

Delete the protocols in your "listener.ora" file that you do not use.

Edit the "listener.ora" file and look at the protocol section. Make sure that
only the protocols that you use on your system are there (i.e., TCP, IPC, ...)
and that there are no entries listed for SPX or NMP (named pipes).


Explanation:
============

In this case, the SPX protocol was listed first in the "listener.ora" file
which was not being used and since the adapter was installed for SPX, the
listener was failing on trying to start up SPX.


-----------------------------------------------------------------------------------
Failed to start service, TNS-12560, TNS-00530 when create new listener
services

Problem:
To recreate Oracle TNS listener service on Windows NT, you delete the
service entry in registry. When using lsnrctl to start the listener,
you get the following errors:

LSNRCTL> start
Starting tnslsnr: please wait...

Failed to start service, error 3.

TNS-00530: Protocol adapter error

The Listener service is not recreated and the Listener would not start.
You are using a valid listener.ora file and protocol adapters.


Solution:
After you delete the Listener service from registry, you have to reboot NT
for it to take effect. Then you can use lsnrctl to start the Listener,
which would re-create the listener service.


Explanation:
The Listener service is marked 'disabled', but it still exists after you
delete the service from registry.



Don't know if this helps, but I can't think of anything else.

Ruud