Hi
I am thinking about using the Oracle 10g Express Edition and Data Services.
I walked through the Supported Platforms and other documents for 3.2 Service Pack 2. But no specific information I can get about it.
My Question:
For DS3.2-SP2, on a Win7-64bit-Oracle10g Express, can DI host its repository on the XE’s database?
If it is not supported then is DS14.0 going to support this or nope?
ganeshxp 
(BOB member since 2008-07-17)
There’s 2 sides to this:
Will it work? Yes, we use Oracle XE for the repository on our laptops to run vmware setups of DS 3.2 for testing throwaway stuff, patches, sandpit type work before applying and it works fine. I’ve installed DS4.0 on Oracle XE too (including the IPS) but haven’t really tested it so far.
Is it supported? Whilst it will run unless SAP support it then I’d advise you to avoid running any production or development environments on it.
rollinsa (BOB member since 2006-07-11)
Hi
Awesome thanks for your reply.
Could you please help me with Windows OS Version that helped you achiving this path?
I am getting an OCI error:
Error:
Database access error. Reason Loading shared object failed. First tried to
load library oci and failed because of error: [ is not a valied Win32
application.
]. Second tried to load library oci.dll and failed because of error: [ is not
a vaild Win32 application.
].
Cannot verify DB login information. [INS00104]
Am I missing something?
I used Win7
Note:
By the way this is also all about our Sanbox environments only.
ganeshxp (BOB member since 2008-07-17)
There are issues with Oracle client software running when applications get stored in directories with punctuation marks this caused issues when the 64bit versions of Windows 7 and Windows Server 2008 came along as they put 32-bit applications in folders c:\program files(x86)\etc…
They patched this for Oracle 9i, 10g and 11g standard and enterprise but I don’t believe it was ever patched for the Express Edition.
Oracle 10g XE doesn’t support Windows 7 or Server 2008, the upcoming 11g Express Edition thats in Beta right now does although only the 32-bit version is available for download right now – haven’t tested if this bug is fixed in that (I’d hope so). You can either download 11g Express Edition from http://www.oracle.com/technetwork/database/express-edition/11gxe-beta-download-302519.html
The other work around is to install DI and XE into a different folder that doesn’t contain those brackets () or run a vmware image with 32bit windows xp or server 2003.
You may also have some issues getting to the XE homepage to configure the database on Windows 7 – this thread discuss a workaround http://forums.oracle.com/forums/thread.jspa?threadID=2201312&tstart=0
rollinsa (BOB member since 2006-07-11)
Haha the one thing I just suspected. By the way I already know that x86 folder issue. I chose seperate folders only for them.
By the way again what OS Version you used for 12.2 & 14.0 versions please?
So yes I already went up for a level of a VM Image request.
Awesome buddy thanks for your time/explanations
ganeshxp (BOB member since 2008-07-17)
For 3.2 - I’m using Windows Server 2003 32-bit with Oracle XE 10g
For 4.0 - I’m using Windows Server 2008 R2 64-bit with Oracle XE 10g
We’re on Vmware (hence the server versions) as this is a sandpit I like the snapshot feature to try things, destroy and return to previous snapshot functionality which for me is the point of these throw-away environments.
rollinsa (BOB member since 2006-07-11)