SQLDeveloper Connection Error

asked 2017-03-28 10:03:52 -0600

Vishal Tiwari gravatar image

I recently downloaded the SQLDeveloper and try to create a new connection, but it shows an error, like;

*Status : Failure -Test failed: IO Error: the network adapter could not establish the conection.*

The field values given by me are:

Connection Name: hr Username: hr Password: oracle Connection Type: basic Role: default Hostname: localhost Port: 1521 SID: xe

Please help me resolving this.

Thank You in Advance.

edit retag flag offensive close merge delete


Do you have Oracle DB on installed on your machine and running?, if it is installed and running do you have SELinux set to enable to connect to the DB? if you do not know, try setting SELinux to permissive

aeperezt gravatar imageaeperezt ( 2017-03-28 11:48:17 -0600 )edit

Ok.. One more Question.. I just want to run SQL and PL SQL programs as I am a student and I need to do this for my study purpose. I am new to linux and don't know too much of it.. Please just help me to install and run SQL and PL SQL..

Vishal Tiwari gravatar imageVishal Tiwari ( 2017-03-28 12:25:46 -0600 )edit

You need to download OracleDB from Oracle site and install it, you can do it from here http://www.oracle.com/technetwork/dat... here is the documentation http://docs.oracle.com/cd/E17781_01/i... it will give you the steps to install.

aeperezt gravatar imageaeperezt ( 2017-03-28 20:30:53 -0600 )edit