Re: Upgrade from 8.1.6 to 8.1.7

From: Joan Hsieh <joan.hsieh_at_tufts.edu>
Date: Wed, 30 Jan 2002 09:16:35 -0800
Message-ID: <F001.00400A45.20020130090606@fatcity.com>

Hi Hamid,

We upgraded our peoplesoft db from 8.1.6 to 8.1.7 last year. This is just give you a reference check. You HAVE TO read the upgrade note do exactly what the notes said. Since all the platform is different, it might change the procedures according to your platforms.

Joan

Oracle 8.1.7 Database Upgrade

1)      Backup db 
2)      . oraenv SID
3)      run /oracle> .  . profile817 => Set new oracle home,path..etc
4)      from $OH/dbs, create soft link to parm file: 
                ln -s /oracle/admin/<SID>/pfile/init<SID>.ora 
init<SID>.ora
            ADD  _system_trip_enabled=false to init<SID>.ora (after
rollback_segments)
5)      cd $OH/rdbms/admin
6)      run another UNIX session and shutdown db under 8.1.6
7)      go back to 8.1.7 session
8)      svrmgrl
9)      connect internal
10)     startup restrict
11)     ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER,

LEVEL
10';

12)     spool <SID>_upgrade817.log
13)     run conversion script (@u0801060.sql
14)     ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT OFF'
15)     Change init<SID>.ora:   _system_trig_enabled=true 
16)     Bounce db  (shutdown, startup)
17)     update /etc/oratab with new ORACLE_HOME for database

Hamid Alavi wrote:
>
> Hi List,
> I have asked this question twice but no answer at all, I don't know may be
> is too easy or not related at all, I just want to know what I have to do for
> upgrading from Oracle 8.1.6 to 8.1.7 on Unix machine, Please if anybody have
> any URL or link or any sort or documentation let me know.
> Thanks & hope this time I get an answer.
>
> Hamid Alavi
> Office 818 737-0526
> Cell 818 402-1987
>
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> disclosure under applicable law. If you have received this message in error,
> you are prohibited from copying, distributing, or using the information.
> Please contact the sender immediately by return e-mail and delete the
> original message from your system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: hamid.alavi_at_quovadx.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.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).

Received on Wed Jan 30 2002 - 11:16:35 CST