CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
Nirodha Wickramarathna
Nirodha Wickramarathna

Reputation: 291

How to create connection in SQL developer?

When I try to create a connection in SQL developer, I got an error like below.

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

enter image description here

enter image description here

But I connected Oracle Database 21c Express Edition in SQL plus like the above image.

And In the services below oracle services running enter image description here

Can anyone help me to solve this, I am new to SQL developer tool.

Upvotes: 0

Views: 1271

Answers (1)

Nirodha Wickramarathna
Nirodha Wickramarathna

Reputation: 291

Check listener service is running, see if it's listening on localhost or your PC name/IP address (lsnrctl status - I think that works on Windows, and will show you the service name too), and update the SQL Developer connection settings to match

Upvotes: 1

Related Questions