about sql developer

by Lulwa
(Bahrain)



Hello,


I've a macbook pro OS X 10.9.2

and i want to use sql developer app, but it need jdk 7 to get it work.
I've download the latest java version from their website even though it didn't work.
so i google searched and i downloaded oracle's java version 6

but even though it didn't work probably. when I want to create a connection it doesn't work ( Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection )

what should I do?
I need to study and practice sql.

looking forward to hear from you soon,
regards.

Comments for about sql developer

Average Rating starstarstarstarstar

Click here to add your own comments

Mar 02, 2015
Rating
starstarstarstarstar
Connecting via SQL Developer
by: Anonymous

Connection to Oracle via SQL Developer can be slightly more complicated than when connecting via SQL*Plus as SQL Developer gives you more connection types to choose from: Basic, TNS, LDAP, Advanced and Local/Bequeath.

Depending on which connection type you use determines what information you need to provide to connect to Oracle.

If you select the Basic connection type you need to provide the hostanme, the port and either a service name (as specified in the database parameter file) or the database SID. For example if you have an Oracle database installed on the same machine sa SQL Developer, the parameters will probably be:-

Hostname: localhost
Port: 1521
Service name: orcl.home

With the TNS coonection type, SQL Developer uses TNSNAMES to resolve database aliases. In that case the parameter is likely to be:

Network alias: ORCL

The LDAP connection type is for use when you have a directory server. The Advanced connection type is used for JDBC connections and the Local/Bequeath connection type can be used when both the Oracle database and the client (SQL Developer) are on the same machine but this method can't be used to connect to a pluggable database (just the container database) in Oracle 12c and above.

Read the section on Net Services in rhe database administration guide - see http://docs.oracle.com/cd/E11882_01/install.112/e27508/netv2.htm#DFSIG247 - for more inforamtion about the various methods of connecting to the database.

One final tip: test your connection strings using SQL*Plus first o ensure they are correct.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Oracle Questions.