This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes ORacle 11gXE 32 bit  installation issue with Windows 7 x64? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "ORacle 11gXE 32 bit  installation issue with Windows 7 x64?" Watch "ORacle 11gXE 32 bit  installation issue with Windows 7 x64?" New topic

ORacle 11gXE 32 bit installation issue with Windows 7 x64?

Yuta Lolap
Ranch Hand

Joined: Jun 03, 2012
Posts: 86

I installed Oracle 11g Express Edition 32 bit on my 64 bit machine running Windows 7 Home Premium. I went to Control Panel - Administrative Tools-ODBC-USER DSN- ADD.

When i click on ADD i cant see oracle XE in the drivers list.

Please can you tell me how to move ahead and resolve this issue?

Also i heard that Windows 7 home editions do not support the ORacle 9i/10g and 11g fully.

I need to use eclipse with oracle to work on my project. Please help me!
Martin Vajsar

Joined: Aug 22, 2010
Posts: 3728

If you have successfully installed Oracle, and can connect to the database from SqlPlus, that's all you need.

Don't use ODBC to connect to Oracle. Oracle provides JDBC thin drivers, which are far better than ODBC and don't require additional setup beyond the connection string. Our Oracle FAQ contains links to JDBC drivers and also some info on the format of the connect string.
chris webster

Joined: Mar 01, 2009
Posts: 2254

There have been a lot of problems with Oracle 11g XE on Windows 7, as the 32-bit version doesn't always install or work properly and there is (still!) no 64-bit version. Check in your Windows services to see if the database (OracleServiceXE) and TNS listener services are running (OracleXETNSListener). Then use JDBC to connect to the database using the Oracle thin drivers.

If you can't get XE working, you can still try installing the Windows 64-bit version of the standard Oracle 11g database instead, which runs fine on Windows 7 (you'll need lots of RAM for this, especially as you want to use Eclipse as well!). The download site is here, and there are some introductory tutorials here.

Incidentally, for your database work I strongly recommend you download the free SQLDeveloper tool from Oracle, which gives you lots of Oracle functionality independently of your Eclipse DB plugins etc.

No more Blub for me, thank you, Vicar.
Don't get me started about those stupid light bulbs.
subject: ORacle 11gXE 32 bit installation issue with Windows 7 x64?
It's not a secret anymore!