i cannot using sql developer

User_Z1CSX

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

EdStevens

If you get the error on 'lsnrctl start', indicating that your listener did not start, then all of your other 'lsnrctl' commands are moot. And repeating them over and over doesn't change that fundamental.

Show us the contents of your listener.ora file.

Also, it will make it much, much easier to read if you will format your code and output.

User_Z1CSX

thank you for replying this is the contents of your listener. ora file.

EdStevens

That's not even close to the contents of listener.ora. What you posted is a barely legible screen shot of Windows Explorer, apparently showing the listing of files in a directory related to SQL Dev. What made you think that was the contents of a specifically named file?

The listener.ora file is on the database server, and is located in %ORACLE_HOME%\network\admin (for windows) or $ORACLE_HOME/network/admin (for *nix).

User_Z1CSX

i do not have this location file

EdStevens

Since you say you downloaded this for your personal study, I'm going to assume you are on Windblows.

Use copy and paste to show the command and result of :

c:> set %ORACLE_HOME%
c:> dir %ORACLE_HOME%\network\admin

User_Z1CSX

EdStevens

This is hopeless. I ask you to show me outputs of specific commands, and you respond with screen shots of Windows Explorer. I give up. Have fun with your problem.