Upgrade to Oracle 11g

We are upgrading from Oracle 9i to Oracle 11g from raw devices.
Also, I was told that I need to install Oracle 10 Client (not the database) because some of the forms run inOracle 8i although we have Oracle 9i database. Can you explain what does it mean by installing Oracle 10g Client but not the database, and what the different steps in installing client not the database? Also, if you could, please provide some steps or procedures to follow (links to look for) upgrading to Oracle 11g!

Thanks in advance!
lium1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>what does it mean by installing Oracle 10g Client but not the database

Oracle installers allow you to just install the 'client' pieces without installing the server software.

>>if you could, please provide some steps or procedures to follow (links to look for) upgrading to Oracle 11g!


The docs are always the best place to start:
Oracle® Database Upgrade Guide

http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm
0
 
Steve WalesConnect With a Mentor Senior Database AdministratorCommented:
Having just done a couple of these myself, you can also refer to Note 837570.1 at MOS in case you need to do it manually:

Complete Checklist for Manual Upgrades to 11gR2

DBUA - The Database Upgrade Assistant certainly made it easier on one server I was working on.  The other involved moving between servers, to new disk configurations and a manual upgrade was easier.

Make sure your backups are good before doing anything and if at all possible, test on your test server first!
0
 
HuaMinChenConnect With a Mentor Business AnalystCommented:
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
lium1Author Commented:
slightwv,

Just one thing, what the different between client pieces and server software? Can you elaborate a little more, please?
0
 
lium1Author Commented:
shwales,

Where can I look for Note 837570.1 at MOS that you mentioned?
0
 
lium1Author Commented:
sjwales,
 
Where can I look for Note 837570.1 at MOS that you mentioned?
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>Can you elaborate a little more, please?

The server software contains all the binaries and files necessary to create, administer and maintain Oracle databases on a server as well as the client software.

The Client software contains what is necessary to connect to an Oracle database and optionally some utilities to perform various actions.

>>Where can I look for Note 837570.1 at MOS that you mentioned?

That is an Oracle Support document id number.  To view it, you need a valid Oracle Support contract.  Then you can log in to view it:  support.oracle.com/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.