Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

upgrading oracle database 8i to 11g

Posted on 2011-03-22
4
Medium Priority
?
741 Views
Last Modified: 2012-05-11
I've been given the task of explaining the advantages of upgrading our ancient oracle 8i to 11g.
 We use the DB to serve a few web sites - a few thousand online users but rarely more than 70-100 at a time. We do not use the DB anywhere near it's capabilities but Oracle was the choice the company made years ago and I'm stuck with it.

I realize there must be innumerable changes since 8i but we would be interested in just a couple of areas:
- new SQL commands for more efficient retrieval of data
- better maintenance tools for recovery and monitoring the DB

Can anyone come up with a short list?

We're using Windows 2003 Server OS. Is 11g compatible with that? Could we go with 10g and save some money?

I am not a DBA but am required to perform many of those duties. I'm basically a programmer and web designer who happens to be using an Oracle DB.

HELP!
Thanks
0
Comment
Question by:uomobello
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35194031
Personally you made the right choice!

11g is leaps and bounds better in performance over 8i.

There are some 'new' sql commands but unless performance is bad, why rewrite any code?

Monitoring is also night and day.  The latest Grid Control has a lot of new info.

If you license the options, it also has some very good Wizards to analyze the database and offer advice.

As far as saving money with 10g, not likely.

Yes, 2003 is supported.  Go 64Bit if you can!
0
 

Author Comment

by:uomobello
ID: 35198412
Thanks for the input. I too think it's a good idea to upgrade but this will be expensive for us and Oracle is used for an area that doesn't generate all that much money for us (we're a book publisher and the DB is used solely for our interactive websites).

The owner of the company is a hard-sell so I have to give him as many reasons as I can for spending the cash. Am I right in thinking we will eventually be forced to upgrade Oracle when we want to upgrade the OS to Win Server 2008 or above?
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1500 total points
ID: 35198494
I honestly don't know when 8i will no longer run on a specific OS.  I've never tried on 2003, let alone on 2008.

Oracle is really good about letting you test any of it's products.  The best 'hard-sell' is to download the version you think will work best for you, install it and run performance testing.

It's hard to argue with the hard numbers.

If all you are doing is relatively simple DML you might be able to get by with Standard Edition or Standard One.

https://shop.oracle.com/pls/ostore/f?p=ostore:product:5071319643097215::NO:RP,3:P3_LPI,P3_PROD_HIER_ID:4508969204091805719879,4509958287721805720011

I don't know what other DB products you are thinking about but...

I will say that feature for feature Oracle and SQL Server are VERY  competitive.  Don't let one vendor tell you theirs is SO much cheaper than the other.  I'll put money on it that you can get them for about the same money.


0
 

Author Closing Comment

by:uomobello
ID: 35208339
While this was a fairly thorough answer I was hoping for more specific information regarding specific Oracle tools available on 11g and not available on 8i ... not an easy thing to do, I admit.

Really appreciate how fast the response was!
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question