Re: sanity check

From: Deepak Thapliyal <deepakthapliyal_at_yahoo.com>
Date: Fri, 16 Nov 2001 12:32:42 -0800
Message-ID: <F001.003C7B86.20011116111021@fatcity.com>

Hi Bill,

You are missing a BIG thing as u are trying to open a older version of the database(815,816) using higher version oracle binaries(817).

U need to upgrade your lower release databases first!

its quite straight forward .. here is a brief high level for you ..

 install binaries in new home for 817
 copy old init to dbs and remove obselete parameters  set env vars for newly installed 817(including SID)  start sql*plus and connect as internal and run   --> @uold_release.sql
{ where uold_release.sql is the release from which you are upgrading}

e.g for upgrading from 815 2 817 use: @u0801050.sql e.g for upgrading from 815 2 817 use: @u0801060.sql  

for detailed step by step instructions refer to enclosed link :

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a86632/migupgra.htm#24532

hth
Deepak

• "Thater, William" <ThaterW_at_telergy.net> wrote:
  > i have a development server with 815, 816, 817
  > installed [don't ask.].
  > we have suspended development at this point in time
  > and shut down the
  > server.
  >
  > AFAIK, if i move the correct init<SID>.ora files
  > into the dbs directory
  > for 817, it should read the control files for the
  > other versions and
  > open the databases. am i missing anything here?
  >
  > and yes i know i could just try it and i would if i
  > was given the
  > chance. [again don't ask.]
  >
  > --
  > --
  > Bill "Shrek" Thater ORACLE DBA
  > Telergy,Inc. thaterw_at_telergy.net
  >
  

  ---

  
  > You gotta program like you don't need the money,
  > You gotta compile like you'll never get hurt,
  > You gotta run like there's nobody watching,
  > It's gotta come from the heart if you want it to
  > work.
  >
  

  ---

  
  > This login session: $13.76, but for you: $11.88.
  >
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Thater, William
  > INET: ThaterW_at_telergy.net
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Do You Yahoo!?
Find the one for you at Yahoo! Personals http://personals.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: deepakthapliyal_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Nov 16 2001 - 14:32:42 CST