Skip to Main Content
  • Questions
  • Oracle Listener not starting after Windows 10 update

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Peter.

Asked: June 11, 2020 - 4:14 pm UTC

Last updated: June 12, 2020 - 2:26 am UTC

Version: 11g

Viewed 10K+ times! This question is

You Asked

After running an Oracle 11g database for years on a Windows 10 machine I ran into problems after applying the latest Windows 10 update

When trying to connect to the database I get a Network Adapter error

Some commands I have tried:

tnsping xe results in:

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

lsnrctl status results in:

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

content of listener.ora file:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\User\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\User\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

ADR_BASE_LISTENER = C:\app\User

content of tnsnames,ora file:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xe.dba)
)
)

LISTENER_XE =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)


I am at a loss at what to do I have changed nothing in my set-up which has worked for years I suspect it might be something related to privileges or permission





and Connor said...

There is a service for the listener. So

1) fire up Services, and check to see if the listener service is started and running

2) if it is, you should be able to fire up a 'cmd' prompt and do:

lsnrctl status

This will show the status of the listener and what host/port it is listening on.

Compare that to what is in your tnsnames.ora entries and look for discrepancies.

If you're still stuck, post the output of "lsnrctl status" as a review, and we'll look more

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Administration

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