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
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
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>
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
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
.
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
February 17, 2022 - 4:29 pm UTC
You're welcome