This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions
  • 7,916,821 Comments

Discussions

IO Error: The Network Adapter could not establish the connection

User_IQS4Z
User_IQS4Z Member Posts: 5 Green Ribbon

I am doing the activities of the course "Oracle Database 19c: SQL workshop) and I am asked to create a connection from SQL developer to the ora1 account (this count contains the schemas I need for the course) .

I write the following data as indicated to me in the practice:


Name: myconnection

username: ora1

password: xxxx (I hide the password)

hostname: localhost

port:1 521

service name: PDBORCL

When I test the connection , I get this error:

Status: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=R5V5/Nl/SUquPyzNoanDtg==)

On the course help, suggested me that I check the status of the listener,

$lsnrctl status

But if I type this command on my terminal, I get the follow error:

"lsnrtl" is not recognized as an internal or external command, program or executable batch file.

How can I fix this error?

Note: I have no previously installed any Oracle Database

Thanks in advance!

Best Answers

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Master Product Manager NC, USAPosts: 8,927 Employee
    Answer ✓

    That indicates you should have an installation of Oracle Database on your personal machine.

    Do you?

  • cormaco
    cormaco Member Posts: 2,071 Silver Crown
    Answer ✓

    "lsnrtl" is not recognized as an internal or external command, program or executable batch file.

    You mistyped lsnrctl here.

  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown
    Answer ✓

    So, when you typed the correct command, what was the result? If it was still "is not recognized as an internal or external command, program or executable batch file.",


    Then just like any other command that returns that error, it is because the executable ('lsnrctl' in this case) is not located in any directory that is part of your system PATH. Either you have not installed Oracle database on this machine (the one where you issued 'lsnrctl'), or you have failed to set the system environment variable PATH. Actually, that should have been done by the installation, if on Windows.

    You said, "I also believe that I should have installed an Oracle Database". Well either you did or you didn't. And it's not something trivial that you would have done without knowing for sure. If you are relying on the installation of SQL Dev, then no you have not installed an Oracle database. SQL Dev is just an IDE - a client. It is not a database, and does not have a database bundled in with it.

Answers