Should You Upgrade Oracle 10gR2 to 11g? Pros, Cons, and Practical Tips

Topic: Whether to upgrade Oracle 10gR2 to 11g, with arguments for and against.

Pro – Upgrade

Peng Xiaobo: Upgraded more than ten production databases from 10g to 11g in July; 11g brings optimizer improvements and many new features that benefit DBAs, though minor issues were encountered.

When moving from 10g to 11g, using UTL_TCP, UTL_HTTP, UTL_SMTP or UTL_MAIL triggers the ORA-24247 error. The solution is documented in MOS ID 1209644.1.

If the program uses the wm_concat function, it must be replaced because it is an internal Oracle function that may change without notice.

Yang Jianrong: Some customers still run older versions (e.g., 8) for years due to stability; upgrades are usually driven by business needs. Discusses differences between 10g and 11g RAC, ADG usage in telecom, and migration experiences from 8 to 11.

Mr. Cai Hao: The 11g SPA DBReplay tool greatly assists the upgrade, though coordinating business cooperation remains the main challenge.

Er Dan: Upgrading keeps the DBaaS environment up‑to‑date.

Zhou Weiwei: 11g Active Data Guard provides valuable business extensions.

Yi Piao Yin: Emphasizes thorough testing before upgrade and notes that some bugs or patch issues may arise.

Con – Do Not Upgrade

Bai Shan: A database should serve the business; if 10g is sufficient, there is no need to upgrade. Mentions migrations to MySQL, DM, and even non‑relational alternatives.

Wu Dang Deputy Director: The cost of upgrading is too high; prefer to stay unchanged.

Roger Wan: Stable production systems should remain as they are.

Li Depeng: Upgrade only when new functionality or bugs that require 11g are present; otherwise it adds cost and risk.

Neutral – Depends on Situation

Mao Mao: The decision depends on how controllable the system’s risk is; upgrades can introduce new bugs while fixing old ones.

Zhang Feng: Business‑driven upgrades are essential; stability is paramount, especially for systems with steady workloads that may no longer be under active development.

BlackMoon: For many businesses, only ADG is a real necessity for upgrading.

Meng Xiang: Upgrade if risks are well managed; otherwise the consequences can be severe.

Extended Q&A

Seven: As a junior DBA facing many database types, asks how to focus learning—whether to cast a wide net or specialize. Responses suggest a "one‑specialty‑many‑skills" approach, becoming versatile, learning development skills, and ensuring proper backup strategies.