[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 549
  • Last Modified:

Looking for a Light-Weight Oracle Database System

I am currently running against Oracle 11g databases, and since I do a lot of application testing, including testing production deployments of staging data.  

I have done a little research on Oracle Lite, Berkeley DB, Oracle XE, but without the experience it is difficult for me to pick a direction.  I don't have the experience in this area of Oracle, and I would like opinions on the better direction to take.  The choice that I need to make would need to work as seamlessly as possible in a .NET/C# web environment.

I would love to hear some anecdotal advice from anyone that has useful experience in this area.

TIA,
Bob
0
Bob Learned
Asked:
Bob Learned
  • 12
  • 10
  • 9
3 Solutions
 
slightwv (䄆 Netminder) Commented:
Oracle XE should work for most of what you are likely to encounter.

There are just a few hard-core things that it won't do.
0
 
Bob LearnedAuthor Commented:
Thanks for responding Steve.  I am looking for something that would closely resemble Oracle, but be easy for a non-DBA to manage.  I see where Oracle Lite is dead, and you are pointed to Berkeley DB, but that it is not a relational database system, but a key-value pair system.

My head is thinking the XE would be a good choice, but I am not sure if I need a separate ADO.NET provider from the Oracle.DataAccess.dll.

System Properties Comparison Berkeley DB vs. Redis vs. SQLite
http://db-engines.com/en/system/Berkeley+DB%3BRedis%3BSQLite
0
 
slightwv (䄆 Netminder) Commented:
I don't believe XE comes with the ODAC (Where ODP.Net now resides).

If you are testing code that will eventually run against Oracle, test with Oracle.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
sdstuberCommented:
I set my wife's office up with XE and it's been running flawlessly for years.  The only down time was when I upgraded her from 10g to 11g.   Also nice - it has a free (as in beer) license, including for production use.
0
 
Bob LearnedAuthor Commented:
I found this reference that suggests that I am going to have problems with XE and Windows 2008 R2 Server VM and 64-bit:

Tutorial #2: Installing Oracle XE 11G for Windows 7 64 bits.
http://www.hanmiaojuan.com/2013/03/install-oracle-xe-11g-for-windows7-64bits.html
0
 
Bob LearnedAuthor Commented:
Also, testing with Oracle requires DBA approval, and that requires I give up my first-born male child (which I don't have).
0
 
slightwv (䄆 Netminder) Commented:
>>testing with Oracle requires DBA approval

Ya lost me?  Do you mean on your 'official' test servers?

Thought getting around that is what you are after with Oracle XE?

It's not light-weight but I wanted to throw it out there:
Oracle has a pretty liberal Education and Development license.  As long as the testing you are doing is opened up to the World on a test server you might be able to use a full-blown install of whatever the DBA has.
0
 
sdstuberCommented:
I can't help with the child-sacrifice; but for the install itself,  on Win7, you can simply ignore the missing file error.  I have XE running on just about every windows machine in my house (whether my family members like it or not.)  And 64bit hasn't been a problem yet.

 I've never tried on Win2008 though, so good luck there.
0
 
slightwv (䄆 Netminder) Commented:
>> that suggests that I am going to have problems with XE and Windows 2008 R2

Maybe.  I'll let Sean post to that one.  [edit: caught typing]

I'm running Full Enterprise Edition.  Only had XE back on my Windows XP box.
0
 
sdstuberCommented:
If you can't get an install in windows,  could you create a linux vm and install XE there?

You'll be getting less "light-weight" by adding the extra layers but it should run
0
 
Bob LearnedAuthor Commented:
I have test servers, but they are very tightly controlled, and QA team doesn't like us developers messin' in their pool (if you understand what I mean).  I would like something that I could be lord and master over.  That would alleviate a lot of my testing stress.  

Setting up a new database environment without a good reason is frowned upon here, so the DBA's usually say NO!! so vehemently that I quit asking.  Since this type of request is so outside of their comfort zones, I am pretty sure what the answer is going to be without asking.  I asked them about Oracle XE, and I haven't heard anything negative yet, so I don't think they care if I come up with something myself.  This comes down to the stress of being an Oracle DBA in a high-profile marketing company that depends so much on their DBA's.
0
 
sdstuberCommented:
well, do you really need to be "lord and master"  or even need a completely new database?

If you were given a schema (or set of schemas) of your own in an existing, not production, database, would that be sufficient?
0
 
slightwv (䄆 Netminder) Commented:
XE is the simplest form of an Oracle Database.  The installer also installs the database.

It really only saves you one extra step over a more full version(Running the database configuration assistant and selecting some options).
0
 
Bob LearnedAuthor Commented:
"If you were given a schema (or set of schemas) of your own in an existing, not production, database, would that be sufficient?"
That type of request, while it sounds simple, takes a lot of justification to get passed through, and I don't have the time or desire to jump through those hoops, so I am thinking that if it is easy to install something light-weight, then yes I do NEED to be lord and master.
0
 
sdstuberCommented:
In that case, give XE a try.  Either it'll work on 2008 or it won't.  If it does - go hog wild.
If it doesn't then, no worse off than you are now.

Sorry about your environment.  We have some dev systems that are for nothing more than POC type activity.  Users, data  and code regularly loaded and blown away.  The database's sole purpose in life is to be a home for temporary testing.  If somebody did something bad - on purpose or accidental.  The whole thing would simply be dropped and recreated.  No loss.
0
 
Bob LearnedAuthor Commented:
I was intrigued by an in-memory database system, like Redis, or SQLite, but I have zero experience with those systems.  I am thinking that it would take a lot of learning to "shim" in something like that into my automated test systems.
0
 
slightwv (䄆 Netminder) Commented:
>>I was intrigued by an in-memory database system

FYI:
Oracle bought Times-Ten a while back.  Not sure how much like a normal Oracle database is but...
0
 
sdstuberCommented:
TimesTen is getting more tightly integrated with the main Oracle db and inheriting features; but I'd go with XE.  It's very simple to install and maintain; plus, it's a standard RDBMS so it should behave like you want it to with respect to your applications.

Last time I had to mess with TimesTen, it was significantly different enough to be not very useable for most of our purposes.
0
 
Bob LearnedAuthor Commented:
Thanks Steve, since I am in "research mode" right now, I am open to any ideas, and I hadn't heard about Times-Ten, so it is another avenue to investigate.

Oracle TimesTen In-Memory Database
http://www.oracle.com/technetwork/database/database-technologies/timesten/overview/index.html
0
 
slightwv (䄆 Netminder) Commented:
I'm with Sean:  Go with XE (Or full blown Oracle).

It will be a much safer bet your code with work when it hits a real Oracle DB as the back end.
0
 
Bob LearnedAuthor Commented:
Since I have Virtual Box installed, I found this VM from Oracle for Times-Ten:

Oracle TimesTen VM (for Oracle VM VirtualBox)
http://www.oracle.com/technetwork/database/database-technologies/timesten/downloads/index.html
0
 
Bob LearnedAuthor Commented:
Also, as a developer, I was trying to find that elusive dream system that wouldn't require me to become a DBA in order to get something up and running.
0
 
sdstuberCommented:
If you've got VirtualBox installed already,  I'd go with the one of the Oracle Enterprise Edition vms

http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html


If has TimesTen in it too, so if you want to play with it as well, you can
0
 
slightwv (䄆 Netminder) Commented:
>>Oracle TimesTen VM (for Oracle VM VirtualBox)

I see that and raise you (They have several):
http://www.oracle.com/technetwork/community/developer-vm/index.html?ssSourceSiteId=ocomhu

>>that wouldn't require me to become a DBA in order to get something up and running.

XE is probably it.
0
 
sdstuberCommented:
>>> wouldn't require me to become a DBA

ok, now I retract the TimesTen and Oracle Enterprise Edition stuff.

We're back to plain old XE.

Again though, if you have virtual box, install a Linux vm and XE there.  
You'll be Lord and master of everything then, not just the db.
0
 
sdstuberCommented:
It's been a while since CORE, but you can see slightwv and I are still pretty much in synch
0
 
Bob LearnedAuthor Commented:
I remember Steve very well from the CORE!!

I am downloading the .ova file now, and I found instructions for importing OVA files into Virtual Box.

How to Import/Export OVA Files in VirtualBox
http://www.maketecheasier.com/import-export-ova-files-in-virtualbox/
0
 
slightwv (䄆 Netminder) Commented:
Sorry Bob but I removed my name and location from your post...

Granted it can be derived from my screen name but I still don't like it out there like that.
0
 
Bob LearnedAuthor Commented:
Understood...just playing it a little too fast and loose, my friend!!
0
 
slightwv (䄆 Netminder) Commented:
lol... no problems!
0
 
Bob LearnedAuthor Commented:
Thank you very much--Steve and Sean--that was definitely food for thought.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 12
  • 10
  • 9
Tackle projects and never again get stuck behind a technical roadblock.
Join Now