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