ERROR: ORA-12560: TNS:protocol adapter error

Question

Hi after I had a Windows update today my Oracle database doesn't start any more. I tried different solutions with the same topic on this website but so far nothing has worked.

1. When I connect with SQL*Plus I get:

   ERROR: ORA-12560: TNS:protocol adapter error

2. When I check my services

I don't see my listener my anymore...

3. My listener.ora

4. lsnrctl services && lsnrctl status (both)

TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown error

In the end:

Nothing has changed before the update...

Everything worked great until the update...

UPDATE 20/07/2019 12:03

After I tried the solution: liberidu.com/blog/2015/12/07/howto-unable-to-openscmanager-err5

Now I am getting: a new service:

And

When I am connecting with sql/plus I am still getting the message: ERROR: ORA-12560: TNS:protocol adapter error

But when I connect with PlSQL Developer I am getting:ORA-12518, TNS:listener could not hand off client connection

Answer 1

Check if you RUN the CMD as ADMINISTRATOR, in my case after run cmd as administrator, it works.

Run CMD Without Admin (got error TNS-00530):

C:\Users\me>LSNRCTL.EXE start

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 01-AUG-2020 17:43:44

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

Starting tnslsnr: please wait...

Unable to OpenSCManager: err=5
TNS-12560: TNS:protocol adapter error
 TNS-00530: Protocol adapter error

Run CMD as Admin:

C:\WINDOWS\system32>LSNRCTL.EXE start

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 01-AUG-2020 17:36:24

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

Starting tnslsnr: please wait...

Enter User's password :
TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
...
...
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Services Summary...
Service "ORCL" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully