I installed SQL Developer 4.0 for windows 32-bit. I kept getting "Status: Failure - Test Failed: Unsupported Oracle database version" when trying to make TNS connection to remote Oracle databases. Does anyone have any solution?
I have Oracle Instant Client 22.214.171.124.0 which I downloaded from Oracle website and extracted the zip file to C:\Program Files\Oracle\instantclient_11_2. The ‘tnsnames.ora’ file has been posted to this folder as well.
The following values I set under Preferences|Database|Advanced,
· Use Oracle client – Instant Client: file:/C:/Program Files/Oracle/instantclient_11_2/
· Tnsnames Directory – C:\Program Files\Oracle\instantclient_11_2
I have manually added “C:\Program Files\Oracle\instantclient_11_2” to the PATH and TNS_ADMIN.
Do I need anything else to make a successful TNS connection?
Platform: Windows 7 32-bit
The problem probably doesn't lie with your SQL Developer installation, but with your remote databases. As noted in the installation guide, on 10g, 11g, and 12c are supported.
Version 3.2 will work with 9i I think, but support for 8i was dropped some time ago.