aspose file tools*
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
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
Author

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

Yuta Lolap
Ranch Hand

Joined: Jun 03, 2012
Posts: 80

Hi,
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
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

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
Bartender

Joined: Mar 01, 2009
Posts: 1649
    
  14

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?