Until today, it was possible to enter Toad for Oracle, everything was fine.

Today this error came out.

How to get rid of it? What should I do to go in and work normally with Toad for Oracle?

I need Toad for Oracle now! Please, help!

Mistake:

  • So start the wiretapping on the machine where the database is located: lsnrctl start - 0xdb
  • But how to do it? - Gadget
  • Go to the machine where the base is, under the user who installed this base, and type in the cmd window. Then type - tnsping orcl. If OK, then everything is fine. - 0xdb
  • The following happened: C: \ Users \ Samsung> tnsping orcl TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 24-NOV-2016 18:52:39 Copyright (c) 1997, 2014, Oracle. All rights reserved. Parameter files used: D: \ app \ Samsung \ product \ 12.1.0 \ dbhome_1 \ network \ admin \ sqlnet.ora TNSNAMES adapter used to resolve the alias An attempt was made to communicate with (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = DESKTOP-IF7IKOP) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))) TNS-12541: TNS: no listener C: \ Users \ Samsung> - Gadget
  • I meant - type from the first comment, tnsping later. - 0xdb 2:49

2 answers 2

Very strange solution number 1 (only enough until the next reboot): http://konurbaev-e.blogspot.ru/2013/03/ora-12560-tnsprotocol-adapter-error.html

    Solution of the problem number 2:

    Start Oracle Services (Computer Management - Services - Start Oracle Services)

    After that, it came to go ..