Solved

Upgrading Oracle 10.2.0.4 to 11.2.0.1

Posted on 2013-02-05
4
308 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 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 125 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 37

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 250 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 37

Assisted Solution

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

Accepted Solution

by:
praveencpk earned 125 total points
ID: 38855109
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Simple SQL query from two tables 13 60
T-SQL: New to using transactions 9 47
add more rows to hierarchy 3 25
Procedure syntax 5 41
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

830 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