RE: Help! Emergency! Upgrade 8.1.6 to 8.1.7

From: Johnson Poovathummoottil <joni_65_at_yahoo.com>
Date: Fri, 15 Jun 2001 10:15:17 -0700
Message-ID: <F001.0032B96B.20010615102558@fatcity.com>

We are curently upgrading from 8.1.6 to 8.1.7.

We have currently done it successfully on our test and development machines and are doing it on the production machine this weekend.
We did not use the ODMA as we could use the manual process from our client machines.
We have solaris 2.7

The steps we follow are

• Install 8.1.7 software.
• Backup database.
• Init.ora change Job_queue_processes=0
• create symbolic links in 8.1.7/dbs to init.ora
  -copy password file to 8.1.7/dbs
  
• system tablespace to have 75M free space
• shutdown instance 8.1.6
• Modify oratab file entry to point to 8.1.7
• Upgrade DB set oracle env to 8.1.7 startup restrict spool to some log run u0801060.sql spool off shutdown immediate
• startup normal
• varify functioning of database

Well sofar we have not had any problems

HTH JOHNSON JOB

---

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Johnson Poovathummoottil
  INET: joni_65_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 Jun 15 2001 - 12:15:17 CDT