DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Upgrading 8.1.6 to 8.1.7.4

  1. 03-04-2003, 10:50 AM #1
    gaegoori
    gaegoori is offline Member
    Join Date
    Jun 2001
    Posts
    243

    Upgrading 8.1.6 to 8.1.7.4

    I'm in the process of upgrading from 8.1.6 to 8.1.7.4 on Windows NT.
    Can anyone check if I'm doing it right on upgrading the database?

    1. Backup the database.
    2. Deinstall 8.1.6 since I would like to use same ORACLE_HOME.
    3. Install 8.1.7 and apply patch set for 8.1.7.4.
    4. move physical datafiles to the right location and recreate the control files?
    5. how about the logical datafiles? how do I upgrade this?
    Reply With Quote Reply With Quote
  2. 03-04-2003, 11:05 AM #2
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Don't do anything yet! I'm working from memory - I think you need EITHER to run the migration utility (after 8.1.7 installation), in which case you need 8.1.6 still available OR you neeed to exp/imp - don't think a physical file copy will work.

    Can someone confirm?
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
  3. 03-04-2003, 11:11 AM #3
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: Upgrading 8.1.6 to 8.1.7.4

    Originally posted by gaegoori
    I'm in the process of upgrading from 8.1.6 to 8.1.7.4 on Windows NT.
    Can anyone check if I'm doing it right on upgrading the database?

    1. Backup the database.

    >> Do that.

    2. Deinstall 8.1.6 since I would like to use same ORACLE_HOME.

    >> Not needed you can install in the same home.

    3. Install 8.1.7 and apply patch set for 8.1.7.4.

    >> Do that.

    4. move physical datafiles to the right location and recreate the control files?

    >> Not required. Use the migration utility to upgrade.

    5. how about the logical datafiles? how do I upgrade this?

    >> There is no such thing as logical datafiles
    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  4. 03-04-2003, 11:11 AM #4
    tycho
    tycho is offline Member
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234
    Hi,

    You can not go to 8174 directly. Read the file that came with the 8174 patch. You first have to install 8170 and then upgrade to 8174.

    This is special for 8174 lower patch levels could be done in a single step.

    Tycho
    Reply With Quote Reply With Quote
  6. 03-04-2003, 11:14 AM #5
    gaegoori
    gaegoori is offline Member
    Join Date
    Jun 2001
    Posts
    243
    After installing new 8.1.7 database and apply patch for 8.1.7.4, can I just run the u080160.sql scripts to upgrade my 8.1.6 database to new 8.1.7.4 database? I'm getting confuse reading threads that's been posted here.
    Reply With Quote Reply With Quote
  7. 03-04-2003, 11:27 AM #6
    mike2000
    mike2000 is offline Senior Member
    Join Date
    Sep 2002
    Posts
    411
    you might have to run catalog.sql,catproc.sql to upgrade you dictionary to 8.1.7.4.
    Reply With Quote Reply With Quote
  8. 03-04-2003, 11:33 AM #7
    gaegoori
    gaegoori is offline Member
    Join Date
    Jun 2001
    Posts
    243
    I understand that I need to install Oracle base 8.1.7 database first and then apply patch set to upgrade to 8.1.7.4. Now, how do I upgrade my 8.1.6 database to 8.1.7.4 database instead of using Database Migration Assistant? I should move my physical datafiles to the right locations and run the u801060.sql script? then what about the logical datafiles? do I have to recreate all the tablespace in the database?
    Reply With Quote Reply With Quote
  9. 03-04-2003, 11:55 AM #8
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    gaegoori, I don't understand why you want to avoid using the DB Migration Assistant? And I'm not sure why you want to move the db files? (and the concept of the logical files escapes both Amar and me!)

    What I did (and I've found some of it on paper now):
    - COLD, FULL MACHINE BACKUP
    - Leave 8.1.6 in place
    - I installed 8.1.7.0 to a different home (Amar says that's not necsessary).
    - Run the migration assistant, it finds the db no problem
    - Test a bit
    - Install the 8.1.7.4 patch and do all the manual tasks involved (yes, it includes running catalog & catproc - and more besides)
    - Test again
    Last edited by DaPi; 03-04-2003 at 12:35 PM.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
  11. 03-04-2003, 12:52 PM #9
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by gaegoori
    I understand that I need to install Oracle base 8.1.7 database first and then apply patch set to upgrade to 8.1.7.4. Now, how do I upgrade my 8.1.6 database to 8.1.7.4 database instead of using Database Migration Assistant? I should move my physical datafiles to the right locations and run the u801060.sql script? then what about the logical datafiles? do I have to recreate all the tablespace in the database?
    I think gaegoori you are upto something or just fascinated about upgrading the DB manually...

    You have got the easiest scenario for upgradation as compared to upgrading on different machines or different Operating Systems. The steps that you want to perform are good for such cases.

    If you are doing it on test machines then go ahead, but don't play with your Prod DB.

    And the term logical datafiles is bugging me. I bet you never read the concepts or did you ?
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  12. 03-04-2003, 01:17 PM #10
    badrinathn
    badrinathn is offline Advisor
    Join Date
    Jan 2001
    Posts
    642
    Hi,

    I recently did a similar migration: This was my plan
    -----------------------------------------------------
    ----------------------------------------------------
    Date: 1/25/03- Saturday
    Start time: ?
    Host: MMC-XMANUPRD1
    Instance/SID: Prod61
    Oracle Home: F:\oracle\ora81

    Download/ Copy the Oracle installation/ Patch files to MMC-XMANUPRD1
    Export prod61 database ( Save on K:\prod61 as prod61.dmp).
    Run the sql's to get the Control files, Redolog files and Datafiles on Prod61 database.
    Run the sql to get the Users, tablespaces, datafiles and tables on Prod61 database.
    Make sure we have 8.1.6 EE CD ( The current version CD to be inserted into the CD Drive- If required for fall back).
    Shutdown the database, listener etc
    Verify the database is down.
    Backup the control files, redologs, datafies from the DB directories.
    Backup all the files under $OH/network/admin directory
    Uninstall Oracle 816
    Install Oracle 8.1.7 ( Use the custom option and NO STARTUP DB)
    Run the u080106.sql
    Start up 8.1.7
    Check the DB
    Shutdown the DB
    Apply the patch 8.1.7.4 (use the patch installation readme doc)
    Startup up the DB and Listener

    Hope this helps.
    There is always a better way to do the things.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width