Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Upgrading Oracle 10.2.0.4 to 11.2.0.1

Posted on 2013-02-05
4
Medium Priority
?
364 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
Via a live example, show how to take different types of Oracle backups using RMAN.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

581 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