oracle 10g versus oracle 11gR2
Hey,
I need to setup a new environment for new applications.
The current question:
Are we going to stay on 10g or are we moving on to 11g R2 ?
Wat would be the considerations ?
The pros ?
The contras ?
We currently have a few oracle 10g (and 1 old 9i) database.
All these databases are in EU and US.
But now, we are going to Russia and Malaysia.
What would be the extra considerations for that ?
I need to setup a new environment for new applications.
The current question:
Are we going to stay on 10g or are we moving on to 11g R2 ?
Wat would be the considerations ?
The pros ?
The contras ?
We currently have a few oracle 10g (and 1 old 9i) database.
All these databases are in EU and US.
But now, we are going to Russia and Malaysia.
What would be the extra considerations for that ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The Oracle Enterprise Manager tools are far better in 11G then in 10G. 11G is no longer bleeding edge it has been in production quite a while now. The cost for 11G is the same as the cost of 10G.
If you just need a alot of facts then you might look at:
http://www.oracle.com/oms/enterprisemanager11g/it-decision-maker-067869.html
If you just need a alot of facts then you might look at:
http://www.oracle.com/oms/enterprisemanager11g/it-decision-maker-067869.html
When talking about going to Russia and Malaysia, you have to ask yourself if you will need to change character sets. That might drive the decision as to whether or not you stay or migrate to 11g.
ASKER
it's not so much changing character sets, it's the actual storing of the malei/russian characters
and the issue of allowing just cyrillic or of allowing all character sets
this is still a issue, test cyrillic and test again with unicode ?
if we test it with unicode is the testing also done for cyrillic ?
and the issue of allowing just cyrillic or of allowing all character sets
this is still a issue, test cyrillic and test again with unicode ?
if we test it with unicode is the testing also done for cyrillic ?
I advice you reading the following article before upgrade - IMHO
http://www.darc.com/lantern/August_2010/articles/upgrade.htm?msource=41137
1. 11GR2 seems like a significant re-write and should be extra cautious during upgrade preparation.
2. With Oracle….ALWAYS read the release notes….and then read them again……and then again.
http://www.darc.com/lantern/August_2010/articles/upgrade.htm?msource=41137
1. 11GR2 seems like a significant re-write and should be extra cautious during upgrade preparation.
2. With Oracle….ALWAYS read the release notes….and then read them again……and then again.
ASKER
upgrade ?
where did i mention upgrade ????
please read the comments carefully, this is for a new environment and new applications
so please no more commenting about upgrades ... this is not for the agents of the matrix :)
where did i mention upgrade ????
please read the comments carefully, this is for a new environment and new applications
so please no more commenting about upgrades ... this is not for the agents of the matrix :)
sorry, I read this "Are we going to stay on 10g or are we moving on to 11g R2 ?"
as meaning should you upgrade or not.
as for new applications, I guess I took it as a given you should use 11gR2.
You have no dependencies, so no cons at all unless you happen to develop an
app that runs into a bug that was introduced in 11g
as meaning should you upgrade or not.
as for new applications, I guess I took it as a given you should use 11gR2.
You have no dependencies, so no cons at all unless you happen to develop an
app that runs into a bug that was introduced in 11g
Oops! after reading your question and following comments thought it is about upgrade.
Anyways, If looking for highly stable db server, I would go with 10.2.0.4 (tested and work great without any issues). And if ready take on some unknown bugs as they come, then I would go with leading edge (bleeding edge) 11GR2 - IMHO.
Anyways, If looking for highly stable db server, I would go with 10.2.0.4 (tested and work great without any issues). And if ready take on some unknown bugs as they come, then I would go with leading edge (bleeding edge) 11GR2 - IMHO.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
bleeding ? had enough of that this morning
just restored a failed production database due to a failed mirror (both disks same time)
"What are the odds of that on a 8 year old windows server someone asked ?"
Answer: 100%, it's just a matter of time.
I agree that when starting with a 11gR2 you wouldn't need to upgrade from 10g
But I thought that a little too obvious to mention ... :)
back to the Q
well i can't find any real cons for the oracle 11GR2.
Except this for dev: See new Q: https://www.experts-exchange.com/questions/26440969/Oracle-10-2-0-4g-and-11gR2-software.html
a new server for the 11gR2 or stick it next to the 10g databases on the older server (1 year old)
The production server will be a new server exclusive for this 11gR2
just restored a failed production database due to a failed mirror (both disks same time)
"What are the odds of that on a 8 year old windows server someone asked ?"
Answer: 100%, it's just a matter of time.
I agree that when starting with a 11gR2 you wouldn't need to upgrade from 10g
But I thought that a little too obvious to mention ... :)
back to the Q
well i can't find any real cons for the oracle 11GR2.
Except this for dev: See new Q: https://www.experts-exchange.com/questions/26440969/Oracle-10-2-0-4g-and-11gR2-software.html
a new server for the 11gR2 or stick it next to the 10g databases on the older server (1 year old)
The production server will be a new server exclusive for this 11gR2
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
not using very much, just partitioning
In that case I would go with 11gR2 - IMO. BTW recently we got request to upgrade some of our db's to 11gR2 and will be in same boat with in next few more days :) Good luck.
ASKER
i just need some docs to wipe the table clean off with people thinking they should stay stuck with 10g :)
there are always some paths which i haven't thought of yet
i'm fishing for extra arguments