Hello,

I installed Oracle 10g on Win2003. I created a database with the same
name (Say TEST) as a v8.1.5/NT database on another server. I used a
similar init<SID>.ora for both databases, though I had to adapt some 
parameters such as 'compatible', 'log_archive_format', pool sizes
etc.. for 10g. (The control files and rollbacks are the same for 10g 
and 8i).

I created the same tablespaces (With the same sizes and datafiles)
and rollback segments (Sorry for those of you who cringe at the
words 'rollback segments' and 10g in the same sentence) in 10g as
in 8i, with the addition of SYSAUX in 10g.

I also created the same Windows directory structure for Oracle in 
Win2003  (10g) as in NT (8i), and adapted the necessary env. 
variables and/or registry parameters. 'listener.ora' and 
'tnsnames.ora' have also succesfully been adapted.

Will I be able to do a straight copy of the source 8i files into
the target 10g Oracle directory structure, and reset the logs
in the target 10g database when opening it?

I realize that an export/import may be more straightforward, but
the server hosting the source 8i database may not have the disk
space necessary for an export.




Thanks,
SAP BASIS Consultant

"SAP BASIS Consultant" <basis_consultant@hotmail.com> wrote in message 
news:dd2036f3.0411291436.39ad4650@posting.google.com...
> Hello,
>
> I installed Oracle 10g on Win2003. I created a database with the same
> name (Say TEST) as a v8.1.5/NT database on another server. I used a
> similar init<SID>.ora for both databases, though I had to adapt some
> parameters such as 'compatible', 'log_archive_format', pool sizes
> etc.. for 10g. (The control files and rollbacks are the same for 10g
> and 8i).
>
> I created the same tablespaces (With the same sizes and datafiles)
> and rollback segments (Sorry for those of you who cringe at the
> words 'rollback segments' and 10g in the same sentence) in 10g as
> in 8i, with the addition of SYSAUX in 10g.
>
> I also created the same Windows directory structure for Oracle in
> Win2003  (10g) as in NT (8i), and adapted the necessary env.
> variables and/or registry parameters. 'listener.ora' and
> 'tnsnames.ora' have also succesfully been adapted.
>
> Will I be able to do a straight copy of the source 8i files into
> the target 10g Oracle directory structure, and reset the logs
> in the target 10g database when opening it?
>
> I realize that an export/import may be more straightforward, but
> the server hosting the source 8i database may not have the disk
> space necessary for an export.
>
>
>
>
> Thanks,
> SAP BASIS Consultant

not a chance- made by different versions of the software, different headers 
different everything - scns will be out of sync

seriously, it wont work

do export over your network or set up a dblink 

On 29 Nov 2004 14:36:39 -0800, basis_consultant@hotmail.com (SAP BASIS
Consultant) wrote:

>
>Will I be able to do a straight copy of the source 8i files into
>the target 10g Oracle directory structure, and reset the logs
>in the target 10g database when opening it?

As usual the answer to this question is in the Migration Manual, which
both Dave and you haven't read.
The file structure didn't change, so likely there is a migration
assistant available which will do the task in situ for you.
The advantage of the exp/imp route is database reorganisation.

Of course you shouldn't have changed the compatible parameter, if you
want to stick to 8i functionality.


--
Sybrand Bakker, Senior Oracle DBA

SAP BASIS Consultant wrote:
> Hello,
> 
> I installed Oracle 10g on Win2003. I created a database with the same
> name (Say TEST) as a v8.1.5/NT database on another server. 
[...]
> 
> I also created the same Windows directory structure for Oracle in 
> Win2003  (10g) as in NT (8i), and adapted the necessary env. 
> variables and/or registry parameters. 'listener.ora' and 
> 'tnsnames.ora' have also succesfully been adapted.
> 
> Will I be able to do a straight copy of the source 8i files into
> the target 10g Oracle directory structure, and reset the logs
> in the target 10g database when opening it?
> 
> I realize that an export/import may be more straightforward, but
> the server hosting the source 8i database may not have the disk
> space necessary for an export.
> SAP BASIS Consultant

But to get from 8.1.5 to 10g will at minimum require a stop at 8.1.7.4. 
Which implies at least two migrations (or upgrades, I never could 
remember the subtle difference), in addition to another complete Oracle 
home install (plus patch).  This could get a little tricky.

If you don't have enough disk space for an export, you are in real trouble.

As a side note, the jump from Windows NT 4.0 to W2k3 server might be 
non-trivial as well.

-Mark Bole

Mark Bole <makbo@pacbell.net> wrote in message news:<5XPqd.51737$QJ3.37764@newssvr21.news.prodigy.com>...
> SAP BASIS Consultant wrote:
> > Hello,
> > 
> > I installed Oracle 10g on Win2003. I created a database with the same
> > name (Say TEST) as a v8.1.5/NT database on another server. 
>  [...]
> > 
> > I also created the same Windows directory structure for Oracle in 
> > Win2003  (10g) as in NT (8i), and adapted the necessary env. 
> > variables and/or registry parameters. 'listener.ora' and 
> > 'tnsnames.ora' have also succesfully been adapted.
> > 
> > Will I be able to do a straight copy of the source 8i files into
> > the target 10g Oracle directory structure, and reset the logs
> > in the target 10g database when opening it?
> > 
> > I realize that an export/import may be more straightforward, but
> > the server hosting the source 8i database may not have the disk
> > space necessary for an export.
> > SAP BASIS Consultant
> 
> But to get from 8.1.5 to 10g will at minimum require a stop at 8.1.7.4. 
> Which implies at least two migrations (or upgrades, I never could 
> remember the subtle difference), in addition to another complete Oracle 
> home install (plus patch).  This could get a little tricky.

8.1.5 to 10g is not supported as FULL=Y (export and Import). However,
if all the users are pre-created in the target 10g database then
schema level import is an option. I would still favor upgrading to
8.1.7 and then do a full export to 10g. I think this is lesser of the
two evils.

> 
> If you don't have enough disk space for an export, you are in real trouble.
> 
> As a side note, the jump from Windows NT 4.0 to W2k3 server might be 
> non-trivial as well.

I have not tested copying NT/2000/XP files directly to 2003 to see if
it works. It may or may not but since 2003 comes in 64 bit flavor also
(Which OP did not mention if he is on 32 or 64 bit 2003)... I would be
very hesitant in doing it as Oracle does not support 32bit database on
64bit 2003. Plus Oracle ships separate software for 2003 32bit and
64bit.

Regards
/Rauf

rs_arwar@hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0411300503.760b08fc@posting.google.com>...
> Mark Bole <makbo@pacbell.net> wrote in message news:<5XPqd.51737$QJ3.37764@newssvr21.news.prodigy.com>...
> > SAP BASIS Consultant wrote:
> > > Hello,
> > > 
> > > I installed Oracle 10g on Win2003. I created a database with the same
> > > name (Say TEST) as a v8.1.5/NT database on another server. 

stuff deleted..

> 8.1.5 to 10g is not supported as FULL=Y (export and Import). However,
> if all the users are pre-created in the target 10g database then
> schema level import is an option. I would still favor upgrading to
> 8.1.7 and then do a full export to 10g. I think this is lesser of the
> two evils.
> 
> > 
> > If you don't have enough disk space for an export, you are in real trouble.
> > 
> > As a side note, the jump from Windows NT 4.0 to W2k3 server might be 
> > non-trivial as well.
> 
> I have not tested copying NT/2000/XP files directly to 2003 to see if
> it works. It may or may not but since 2003 comes in 64 bit flavor also
> (Which OP did not mention if he is on 32 or 64 bit 2003)... I would be
> very hesitant in doing it as Oracle does not support 32bit database on
> 64bit 2003. Plus Oracle ships separate software for 2003 32bit and
> 64bit.
> 


Thanks to all those who posted. Using a shared drive, I exported and
imported the database as recommended.
> Regards
> /Rauf