Re: Upgrade from Database 9i to 10g on Linux

On Apr 10, 1:56 pm, alex.berin..._at_gmail.com wrote:
> Hello,
>
> I am supposed to upgrade a 9i database to 10g on Linux x86 on 32bits.
>
> Things to know:
> - I want to preserve old installation. On 9i some very good DBA (not
> like me) installed the database and there are many scripts which
> automate things like backup
> - I don't need to upgrade the old database, I will create a new schema
> in 10g with new data
>
> My problems:
> 1) should I use the same user for installation? (install more Oracle
> homes) or use different users?
> 2) which tool would you recommend for this 10g installation?
> 3) I know that before the installation I could at least change the
> $ORACLE_HOME to point to another folder. Question is if this is enough
> or I should change also other variables? There is also a oraRepository
> folder in $ORACLE_BASE.
> 4) on the existing oracle user there are a few environment variables
> used by oracle. How many of these should I keep to run the Oracle 10g
> installation?
> Existing variables in 9i are:
> CLASSPATH=/oracle/ora920/JRE:/oracle/ora920/jlib:/oracle/ora920/rdbms/
> jlib:/oracle/ora920/network/jlib
> HISTFILE=/home/oracle/.bash_history
> HOME=/home/oracle
> LD_LIBRARY_PATH=/oracle/ora920/lib:/lib:/usr/lib:/usr/local/lib
> LOGNAME=oracle
> MAIL=/var/spool/mail/oracle
> ORACLE_BASE=/oracle
> ORACLE_HOME=/oracle/ora920
> ORACLE_SID=bltmdemo
> ORACLE_TERM=xterm
> ORA_NLS33=/oracle/ora920/ocommon/nls/admin/data
> PATH=/oracle/ora920/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/
> bin:/usr/X11R6/bin:/home/oracle/bin:/oracle/ora920/bin
> PWD=/home/oracle
> USER=oracle
>
> Thanks alot (as a novice),
> Alex

Here are a few good resources:

http://www.puschitz.com/InstallingOracle10g.shtml
http://download-east.oracle.com/docs/html/B15659_03/toc.htm
http://download-east.oracle.com/docs/cd/B19306_01/install.102/b15660/toc.htm

In general, I'd unset the ORACLE_HOME, LD_LIBRARY_PATH and ORA_NLS33 in the shell prior to executing the runInstaller program (OUI).

You'll also want to apply the latest patchset to the new ORACLE_HOME prior to creating the new database (if you go with creating new). If you use a pre-created database with dbca, you'll want to upgrade it to the current patchset after creation (catupgrd.sql). Check the release notes in the patchset.

If you decide to deploy the 10.2.0.3 patchset, you'll want to also apply the latest critical patch update (e.g. CPUJan2008) using OPatch. There hasn't been a critical patch update released for the 10.2.0.4 patchset yet, but a pre-release announcement *should* be issued today here:

http://www.oracle.com/technology/deploy/security/alerts.htm

(based upon left coast time). ymmv.

1. yes.
2. OUI.
3. unset $ORACLE_HOME prior to starting the runInstaller.
4. unset $ORACLE_HOME, LD_LIBRARY_PATH, ORA_NLS33.

good luck.

-bdbafh Received on Thu Apr 10 2008 - 14:59:42 CDT