Solved

Upgrading Oracle 10.2.0.4 to 11.2.0.1

Posted on 2013-02-05
4
305 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 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 125 total points
Comment Utility
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 36

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 250 total points
Comment Utility
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 36

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 250 total points
Comment Utility
0
 
LVL 12

Accepted Solution

by:
praveencpk earned 125 total points
Comment Utility
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

728 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now