Re: Oracle Migration Questions

1. You'd have to do a fresh *install* of 8.1.7 + Patchset 1 or higher on the F15K. Copying an OUI-installed ORACLE_HOME [and attempting to relink it] is not supported.
2. You can copy the Database Files and just startup the database. [unless you change the mount points / directory names in which case you must do an ALTER DATABASE RENAME FILE before you OPEN the database].

Hemant K Chitale

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, 04 June, 2002 7:18 AM

> Migrating 35 Oracle 8.1.7.1 instances, all on external EMC disk, from:
>
> Sun E10K domain running Solaris 8 maint 04/01
>
> to:
>
> Sun F15K domain running Solaris 8 maint 02/02
>
> These instances support CRP, conversion and development for the Banner ERP
> -- Higher Ed from SCT Corp. Apps will be installed on F15K with Forte for
> Java and MicroFocus COBOL.
>
> Questions:
> 1) Would you relink Oracle binaries on F15K?
> 2) Would you export/import from E10K to F15K?
>
> DBA, Server Support, App Dev and ERP Project Management disagree on
> procedure, even though we're in the midst of our second complete migration
> of three Sun Enterprise servers in the past six months and all have been
> gloriously successful!
>
> Thanks in advance for weighing in on this!!
>
> Carole Stephenson
> University of Illinois at Urbana-Champaign
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephenson, Carole
> INET: stephnsn_at_uillinois.edu
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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).