• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

8.1.7 to 9i Migration

 
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello,
I am trying to migrate 8.1.7 to 9i. Oracle 8i is installed on machine1. I installed 9i on machine 2 and copied the dB in OS level. I read through the 9i Migration document and taking every step as listed, but when I reached step 1 of 5 (Where you select the SID and press next) I am getting ORA-01034 (Oracel not available).
So I tried to start the dB from SQLPLS and I received error ORA-03113 (end-of-file communication). Thinking that I may not be able to open before migrating to 9i I mounted the dB using STARTUP MOUNT command. Now when I did step 1 of 5 it asks me to shutdown the dB first!
I cound not also test 'Net configuration assistant' (Getting ORA-12514).
I am using WIN 2000 (Version 5 with SP 4).
The question is:
1. Should I setup Net configuration before migration or after migrating
2. When copying the dB from another computer what is the first step I need to do before attempting to migrate the dB?
Thanks in advance.
Suresh
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Not that this would be much help. But instead of moving the db files, it might be much easier to use "exp" and "imp" to export then import the data.
Instead of having to manually change the control files.
Mark
 
Something must be done about this. Let's start by reading this tiny ad:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic