Howard J. Rogers wrote:
> Greg Doherty wrote:
>
>> Sorry about being vague.
>>
>> Here are the specifics:
>>
>> The database was originally called asfserver located at
>> E:\Oracle\oradata\asfserver\
>> It is a version 8.1 database.
>>
>> I would like to set up this database on a new Oracle 10g (ver 10.1)
>> server
>> at C:\Oracle\product\10.1.0\oradata\asfserver
>> I have the CTL, DBF and LOG files.
>>
>> What actions/commands do I need to perform to mount this database on my
>> server so that I can access it via SQLPlus, ODBC, etc.
>>
>> TIA,
>> - Greg
>
>
>
> Right. That puts rather a different perspective on it. There's no easy
> way of doing it. The steps I outlined before assumed E: was still E: and
> (rather more importantly) 8i was still 8i.
>
> You can't simply attach a 10g instance/service to an 8i database. Not
> without fireworks, anyway. You'll have to upgrade the thing properly,
> following all the steps in the Oracle 10g upgrade documentation (see
> http://tahiti.oracle.com).
>
> The move from E: to C: is trivial: you get to the mount state, and you
> issue lots of
>
> alter database rename file 'e:\wherever\filename' to
> 'c:\wherever\filename';
>
> commands. Use select name from v$datafile to see where the control file
> *thinks* the files are, and to check that you've correctly told the
> controlfile about their en masse relocation. Then you alter database open.
>
> But you'll have to do all of that with an 8i instance. Once you've got
> it working as an 8i database, then think about upgrading.
>
> Regards
> HJR
Sorry: I should have said, you won't even be able to mount the database,
of course, until you've (a) created the service as I mentioned last
time, and (b) edited the contents of the init.ora or the spfile so that
the CONTROL_FILES parameter is set to point to the new location of the
control file (can't remember if I mentioned that last time or not).
Regards
HJR
Received on Thu Dec 09 2004 - 16:57:49 CST
