Moving Oracle 8.1.7 database from 2.6 to 2.8 Solaris in another machine
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Moving Oracle 8.1.7 database from 2.6 to 2.8 Solaris in another machine

Hybrid View

  1. #1
    Join Date
    Jul 2002
    Posts
    205
    Hi,

    We are planning to move 8.1.7 database from Solaris 2.6 to 2.8. The 2.8 Solaris is installed in another Machine.

    What is the easiest way.?

    SK

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Oracle817 on 2.8 should recognize all the oracle files (init.ora,controlfiles,redo log files,data files) from 2.6 if the OS is configured similar to 2.6 (32 -bit not 64-bit) and filesystem layout is same as before(If not you might need to recreate the controlfile). So, cold backup would be sufficient.

    You can test this, if you want by recreating the controlfile with system,rbs,redologs,init.ora and couple of datafiles(not all of the datafiles).

    Reddy,Sam

  3. #3
    Join Date
    Jul 2002
    Posts
    205
    Good input.

    But what about the Oracle software, binaries etc..? It needs to be copied from old machine (here Solaris 2.6 ) to the new machine (here Solaris 2.8) OR we need to reinstall the Oracle from CD in new machine...?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you would have to relink the software

    look $ORACLE_HOME/bin/relink

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I would advise you reinstall software from CDs and create a test database as part of install and then delete the instance with dbconfig asst. (test database is not needed as such, just to make sure are the net8 components are operational.

    Don't copy the oracle software from 2.6 to 2.8.
    Reddy,Sam

  6. #6
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    You could copy all necesary filesystems from the old box to the new one and reload pw-syscall.

    Cheers

    Angel

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by sreddy
    I would advise you reinstall software from CDs and create a test database as part of install and then delete the instance with dbconfig asst. (test database is not needed as such, just to make sure are the net8 components are operational.

    Don't copy the oracle software from 2.6 to 2.8.
    I would do it this way.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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



Click Here to Expand Forum to Full Width