JG Vimalan's Blog

It is all about coding!

Configuring Oracle SQL Developer in Windows 64 bit OS

Oracle Sql Developer is a powerful tool for accessing Oracle databases.

The developers who are familiar with Sql Server Management Studio will certaily like this tool.

The steps given below is for developers having difficulty in using SQL Developer on Windows 64 bit OS.

STEP 1:

Ensure that, you have latest version of JDK installed in your system.

You can get the JDK from the location given below,

http://java.sun.com/javase/downloads/index.jsp

While downloading JDK, select the operating system as Windows 64 bit

STEP 2:

Download SQL Developer (for Windows 64 bit) from the following location,

http://www.oracle.com/technology/software/products/sql/index.html

STEP 3:

Extract the zip file. Locate the sqldeveloper.exe and double click it.

It will ask you to locate the java.exe file.

Now, browse to the location where the JDK is installed and locate the java.exe file.

Usually, it will be like,

C:\Program Files\Java\jdk1.6.0_21\bin\java.exe

STEP 4:

Set the TNS names correctly in the tnsnames.ora file. The file is usually located in a location as shown below,

C:\app\<User name>\product\11.2.0\client_1\network\admin

STEP: 5

Now, launch the SQL Developer.exe.

STEP: 6

Provide the database details you wish to connect to.

Advertisements

May 31, 2011 - Posted by | Oracle

1 Comment »

  1. Thanks for posting!

    Comment by Raghu | May 31, 2011 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: