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.

May 31, 2011 Posted by | Oracle | 1 Comment

HttpContext.Current return null in IIS 7

One of my team member was complaining to me that, the application works good at his development system but, when deployed to QC, the particular page throws a null exception.

I found that, the code ‘HttpContext.Current.Session[Constant.SortDirection]’ is causing the error and the Current is null.

Inorder to fix this issue, the Session state should be set properly for the application in IIS.

Earlier, Session state was disabled because of which, the Current object is null. After setting the Session state, it worked correctly.

May 31, 2011 Posted by | C#.NET, IIS 7 | 2 Comments