I installed Oracle SQL Developer from Oracle's web page. It seems to work without a Oracle client installed on my computer. How is that possible? I also installed Toad for Oracle and it seems to require Oracle client.
Why Oracle SQL Developer does not need Oracle client
oracleoracle-11g-r2oracle-sql-developertoad
Related Solutions
SQL Server uses autocommit mode by default. This cannot be changed permanently.
There are two ways implicit transactions (non-autocommit) can be turned on:
At the server level such that new sessions use it by default, using
sp_configure 'user options'-- this may or may not work depending on how SQL Developer was implemented.For a session, using
SET IMPLICIT_TRANSACTIONS ON.
Try to connect with
sqlplus SYS/PASSWORD@ORCL
If you can connect with this from command line you can connect with Sql Developer.
You have two options
Connection Type : Basic
- SID = orcl
- Username = SYS
- Password = password
- Hostname = YOUR_MACHINENAME_OR_IP
See Image
Connection Type : TNS
- Choose SID from dropdownlist. It should read your TNS File and auto complete your dropdown list.
- Username = SYS
- Password = password
The catch here. Oracle Connection string for OCI expect same argument in your tnsnames.ora file. If you use basic connection you should be able to connect from everywhere without modification. But if you need to connect with other connection types, you may need to enter your IP address in your tnsnames.ora file.
Best Answer
SQL Developer is using the so called "thin driver".
For this the JDBC driver (a file named
ojdbc6.jar) implements the complete Oracle network protocol which is usually handled by the Oracle client. It could use the another implementation: the "OCI" (or "thick") driver which would require an Oracle client to be installed. That would be necessary if e.g. Transparent Application Failover in a RAC is required.This is not something specific to SQL Developer but to any Java application using JDBC to connect to the database.