ERROR: ORA-12560: TNS:protocol adapter error

2
votes

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

enter image description here I don't see my listener my anymore...

  1. My listener.ora

enter image description here

  1. 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: enter image description here

And enter image description here

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

3
databaseoracleservicewindowtnsnames
What happens when you try to start the listener? Is the database up? - William Robertson
Hi Robert,Starting tnslsnr: please wait... Unable to OpenSCManager: err=5 TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error - Stefan Stef
Not seen this before but this person seemed to have the same issue: liberidu.com/blog/2015/12/07/howto-unable-to-openscmanager-err5 - William Robertson
UPDATE: I am trying the solution from the blog thank you very much Robert, now I am getting tns listener could not hand off client connection for the moment I am still debugging it. If I have more update I will write soon :) - Stefan Stef
Please don't paste screenshots. Provide error messages and settings as formatted text. - Wernfried Domscheit

3 Answers

2
votes

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
1
votes

this error appears on windows, you need to start the service associated to the instanceName.

and in addition, you need to register de instance_name or service_name to the listener ir order to be listened on listener on port 1521 or another port.

this can be done using dynamic registration with local_listener parameter pointing to IP 192.168.1.5 port 1521. with something like this: alter system set local_listener= ADDRESS = (PROTOCOL=TCP)(HOST=hostname)(PORT=1521)) ';

Regards.

0
votes

Check information in dbhome_1\NETWORK\ADMIN\tnsnames.ora

Use machine name or ip in Host and provide configured port

ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ???)(PORT = ???)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )