Re: Copying a DB from NT to Linux occurs a ORA-01516 - may be possible?

Falko Rotter wrote:

> Hi,
>
> we want to copy a oracle 8.1.6 win nt database to
> a oracle 8.1.7 on suse linux 7.2
>
> we copied all files on the linux server and mounted
> the database successfully with "startup mount" in the
> server manager.
>
> now we want to rename the datafiles with
> --> alter database rename file 'N:\DATABASE_DEV\SYS1DEV.ORA' to
> '/usr/local/database_dev/SYS1DEV.ORA'
> but the server manager occours the error
>
> ORA-01511: error in renaming log/datafile
> ORA-01516: Non existent log/datafile 'N:\DATABASE_DEV\SYS1DEV.ORA'
>
> what's the reason for this ? the filename is written correctly.
> (rename succeed under nt with the same syntax)
>
> Regards,
> Falko Rotter

Interesting.
Do you have FAT16, FAT32 or NTFS partitions on the Linux box? I'm beginning to think that you might just me able to open a database created on NT, moved over to Linux
(or on a dual boot machine). Mounting NTFS partitions in Linux as read-write has always lead to stability problems for my systems - but I'd be willing to take a shot at it.

So for all of the sceptics out there - I wonder if the file system is still windows, that an instance, Oracle on Linux, may be able to mount these datafiles.

worth a try - just out of curiousity.
I would never *ever* think about such a configuration ever being supportable.

Paul Received on Tue Aug 21 2001 - 13:05:44 CDT