create localhost connection in Oracle SQL Developer Tool

Question

I want to create localhost connection in Oracle SQL Developer tool my credentials are

username : SYSTEM
password : SYSTEM
Hostname :localhost or 127.0.0.1
port     : 1521
sid      : xe

When i connect i gives error The Network Adapter could not establish connection

Is the server running locally? Can you get a connection if you telnet localhost 1521? — beny23
– beny23, Commented Feb 26, 2014 at 9:27
check if the listener is running, e.g. use cmd -> tnsping XE — smnbbrv
– smnbbrv, Commented Feb 26, 2014 at 9:30
@user3331920 Please, show the content of your tnsnames.ora file. — Yaroslav Shabalin
– Yaroslav Shabalin, Commented Feb 26, 2014 at 10:56

Nagaraj S · Accepted Answer · 2014-02-26 09:28:59Z

1

The Network Adapter could not establish connection is caused because:

The database host name or port number is wrong.
The listener process (service) is not running. You can re-start it with the "lsnrctl start" command or on Windows by starting the listener service.

answered Feb 26, 2014 at 9:28

Nagaraj S

13.5k6 gold badges35 silver badges53 bronze badges

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

Comments

Amarnath Balasubramanian · Accepted Answer · 2014-02-27 11:48:26Z

1

you have either the wrong SQL Developer URL or you have a basic SQL*Net connectivity issue! This error is most likely caused by one of these factors:

You are using the wrong URL
The wrong port number or IP address (or DNS host name) was used
The listener is not configured properly
The listener process (service) is not running. You can re-start it with the "lsnrctl start" command or on Windows by starting the listener service.

For a step by step checklist, see the notes on troubleshooting an Oracle connection problem.

answered Feb 27, 2014 at 11:48

9,5028 gold badges37 silver badges62 bronze badges