Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Upgrading Oracle 10.2.0.4 to 11.2.0.1

Posted on 2013-02-05
4
Medium Priority
?
342 Views
Last Modified: 2013-08-31
Hi,
I have to upgrade Oracle 10.2.0.4 to 11.2.0.1 on a test system Windows 2003. Database is not that complex. I never upgraded oracle previously but other than that I have very good oracle knowledge and working experience. Challenge at the moment is that I am tied up with lot of other works plus I have to do it urgently without having time to look on internet.

Please give me simple steps e.g. in Oracle 11g installation folder open setup.exe etc etc.

regards,
Baber.
0
Comment
Question by:baberamin
  • 2
4 Comments
 
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 total points
ID: 38854887
Depending on your knowledge:

If the database is small and not complex:
export the 10g database and import into an 11g database.

Other way:
Install 11g and run the Database Upgrade Assistant:
http://docs.oracle.com/cd/E11882_01/server.112/e10897/software.htm#BABEAGDG
0
 
LVL 38

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 1000 total points
ID: 38854974
i wouldn't upgrade it on a win 2003.
2003 is out of support middle of 2015.

so you'd have to upgrade again in 2 years, and you already indicated you have little time

get a 2008 first and optionally check if your vendors support it
oracle supports it.

one thing i came across in all upgrades.
it's never quick and simple
0
 
LVL 38

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 1000 total points
ID: 38854990
0
 
LVL 12

Accepted Solution

by:
Praveen Kumar Chandrashekatr earned 500 total points
ID: 38855109
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

971 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