Solved

database upgradation from 9i to 11g

Posted on 2010-11-10
3
685 Views
Last Modified: 2013-12-19
hi i want to upgrade database from 9i to 11g on ibm aix server, what should be the steps and after upgradation how do apply dst patches and bug fixing patches.
0
Comment
Question by:nirvairghuman
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
sridharv9 earned 84 total points
Comment Utility
Install 11g and apply all available patches and then upgrade the database server. So that you don't have to deal with patches after the upgrade.

Check this link http://blogs.oracle.com/UPGRADE/ for more information and also for Q&A.
0
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 166 total points
Comment Utility
you can upgrade from 9i to 11gR2

Instructions will be included with the installation files  but are also available from otn

http://download.oracle.com/docs/cd/E11882_01/server.112/e17222/toc.htm
0
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 166 total points
Comment Utility
installation instructions for each patch are included with each patch

often there is little more than invoking opatch for the oracle home your are patching

since patches are only available from the Oracle Support site (formerly known as metalink) the actual instructions may not be reproduced here.  But, as stated, the full instructions are included in each patch's zip file
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

743 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

17 Experts available now in Live!

Get 1:1 Help Now