Installing Oracle SQL Developer in Win 7 to a Oracle 9i Database

Steps:

1. extract Oracle instant client to C:\instantClient
2. extract Oracle SQL Developer to C:\SQLDeveloper
3. copy tnsnames.ora to  C:\instantClient
4. launch Oracle SQL Developer
5. goto Tools>Preferences
6. goto Database>Advanced
7. change Tnsnames Directory to C:\instantClient
8. check Use Oracle Client
9. click Configure…
10. change client Type to Instant Client
11. Change Client Location to C:\instantClient
12. Click OK (Don’t Click Test, the library hasnt yet loaded.  the test result will be failed.)
13. Oracle SQL Developer will restart
14. goto Tools>Features
15. uncheck all optional features to increase the start runtime except Database>Oracle SQL Developer – SSH Support
16. Click Apply Changes
17. Click OK
18. Oracle SQL Developer will restart
19. Add Connections
20. Fill in Connection Name, Username and Password
21. Change Connection Type to TNS
22. Select Network Alias
23. Click Save and Connect

Related Links:

http://www.oracle.com/technetwork/topics/winx64soft-089540.html

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index-098778.html