Forum Stats

  • 3,758,202 Users
  • 2,251,352 Discussions
  • 7,870,107 Comments

Discussions

i cannot using sql developer

User_Z1CSX
User_Z1CSX Member Posts: 4 Green Ribbon
edited Sep 17, 2021 2:55PM in General Database Discussions

I downloaded SQL for studying but I have this use when I am running the program i getting this message

Status: Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=r7gqdMHXT1Oj8R3TwQGiLg==)


i tried to solve it by using command line

lsnrctl stop

lsnrctl start

lsnrctl status

lsnrctl service

and still does not work

lsnrctl stop


LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 - Production on 17-SEP-2021 13:45:14

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.102)(PORT=1521)))

TNS-12541: TNS:no listener

 TNS-12560: TNS:protocol adapter error

 TNS-00511: No listener

  64-bit Windows Error: 61: Unknown error

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

Answers