Skip to Main Content
  • Questions
  • TNS-12560: TNS:protocol adapter error while creating listener

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Subbarao.

Asked: January 24, 2022 - 9:24 am UTC

Last updated: February 17, 2022 - 4:29 pm UTC

Version: 19c

Viewed 1000+ times

You Asked

Dear Sir,

I have one issue while creating listener / starting listener

I am able to create a listener from the net manager but not netca. Even if it is created through net manager but not able to start the listener as it gives the same message "TNS-12560: TNS:protocol adapter error"

I am able to access the database from the server and not able to access using tns. I tried even easy connect but no vain.

my listener status (lsnrctl status) displays the following error message.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=EFF-LPT-206)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error

Request you to suggest the reason.

Regards & Thanks
Subbarao Dasari

and Chris said...

What happens when you run:

lsnrctl start

Rating

  (6 ratings)

Comments

LISTENER error while starting

Subbarao Dasari, January 27, 2022 - 5:03 am UTC

The following error message is displayed when the listener start command is executed.

TNS-12560: TNS:protocol adapter error

Regards

Chris Saxon
January 27, 2022 - 11:10 am UTC

Ensure that the environment variables are set correctly. In particular, ensure ORACLE_HOME, PATH, LD_LIBRARY_PATH, and ORACLE_SID are all pointing to where you've installed the Oracle software.

MOS support note 2065022.1 discusses this in detail.

LISTENER error while starting

A reader, January 29, 2022 - 6:06 am UTC

Dear Sir

Only LD_LIBRARY_PATH was missing and I set it correctly. But the same error message


Regards

Connor McDonald
January 31, 2022 - 1:53 am UTC

Give us the full output of 'lsnrctl start'

LISTENER error while starting

Subbarao Dasari, February 01, 2022 - 5:57 am UTC

Microsoft Windows [Version 10.0.19044.1415]
(c) Microsoft Corporation. All rights reserved.

C:\WINDOWS\system32>cd\orcl19c

C:\orcl19c>echo %LD_LIBRARY_PATH%
c:\orcl19c\lib\

C:\orcl19c>ECHO %ORACLE_HOME%
C:\orcl19c\

C:\orcl19c>LSNRCTL START

LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 01-FEB-2022 11:23:38

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

Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error

C:\orcl19c>

TNSPING is successful returns

C:\orcl19c>TNSPING TAMS80

TNS Ping Utility for 64-bit Windows: Version 19.0.0.0.0 - Production on 01-FEB-2022 11:26:09

Copyright (c) 1997, 2019, Oracle. All rights reserved.

Used parameter files:
C:\orcl19c\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.80)(PORT = 1521)) (CONNECT_DATA = (SER
VER = DEDICATED) (SID = oracle)))
OK (50 msec)

C:\orcl19c>

Chris Saxon
February 01, 2022 - 2:58 pm UTC

If TNSPING is successful, the listener is running! Do you have multiple homes on the server?

LISTENER error while starting

Subbarao Dasari, February 04, 2022 - 10:50 am UTC

Dear sir

I have only one home.

Regards

Connor McDonald
February 07, 2022 - 2:41 am UTC

Well now we know at least you're running Windows!

Start => Run => services.msc

Make sure the "OracleTNS..." service is running, and also the "OracleDB..." service is running where "DB" is the name of your database.

And also, make sure that 192.168.0.80 is the IP address of your host - otherwise you could easily just be pointing to another machine

LISTENER error while starting

Subbarao Dasari, February 07, 2022 - 4:35 am UTC

I am getting errors while running listener service from service.msc

"Listener services on local computer started and then stopped. some services stop automatically, if they are not in use by others services or programs"

The ip address (192.168.0.80) is not my host. I am able to connect to another server database from my host, but not my database.

Same error when I try to tnsping of localhost as shown below.


C:\>tnsping localtns

TNS Ping Utility for 64-bit Windows: Version 19.0.0.0.0 - Production on 07-FEB-2022 10:04:23

Copyright (c) 1997, 2019, Oracle. All rights reserved.

Used parameter files:
C:\orcl19c\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER
= DEDICATED) (SID = dsrdb)))
TNS-12541: TNS:no listener


regards
Subbarao Dasari

.

Connor McDonald
February 10, 2022 - 4:51 am UTC

Sounds like its all in a bit of a mess.

I would start with netca to define your listener from scratch

LISTENER error while starting

Subbarao Dasari, February 17, 2022 - 4:38 am UTC

Thank you for your support

Due to some urgent to make the database up. I have installed oracle afresh on the server and restored the backup.

Thank you for your valuable input and support

Regards
Subbarao Dasari
Chris Saxon
February 17, 2022 - 4:29 pm UTC

You're welcome

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database