Re: Attach a database in Oracle 10g

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 Received on Thu Dec 09 2004 - 16:47:45 CST