How to create connection in SQL developer?

Question

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==)

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

And In the services below oracle services running

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

Have you installed the Oracle database server product and created a database locally; or have you only installed the SQL Developer client? Is there an existing database you've been asked to connect to - and been given connection info for? See this (old but still relevant) post. — Alex Poole
– Alex Poole, Commented Oct 27, 2022 at 13:49
Put orcl in Service name field instead of SID, if it's the name of the PDB you are trying to connect to. — p3consulting
– p3consulting, Commented Oct 27, 2022 at 17:44
@p3consulting what is the username and password I need to use? — Nirodha Wickramarathna
– Nirodha Wickramarathna, Commented Oct 28, 2022 at 2:15
@NirodhaWickramarathna - the error means it can't connect to port 1521 on localhost, which means you don't have a listener running (or, less likely, you have a local firewall blocking it). It isn't getting as far as asking a listener to resolve a specific SID or service name, never mind checking user credentials. Again, SQL Developer is not a database. Do you have a database, on your PC or that you've been told to connect to? — Alex Poole
– Alex Poole, Commented Oct 28, 2022 at 7:38
OK. 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. — Alex Poole
– Alex Poole, Commented Oct 28, 2022 at 15:21

Nirodha Wickramarathna · Accepted Answer · 2022-10-28 15:29:54Z

1

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

answered Oct 28, 2022 at 15:29

Nirodha Wickramarathna

2911 gold badge7 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create connection in SQL developer?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related