Re: Copying a DB from NT to Linux occurs a ORA-01516

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 21 Aug 2001 13:26:58 +0100
Message-ID: <3b825393$0$234$ed9e5944@reading.news.pipex.net>

I'm left absolutely speechless.

You cannot just copy datafiles across OS platforms.

What you need to do is to export the 8.1.6 database. Create a new 8.1.7 database on the new machine and then import from the export created above.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

"Falko Rotter" <fantomas99_at_gmx.de> wrote in message
news:9lth89$93t$1_at_newsread2.nexgo.de...


>

> 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

>

> _________________________________________

>

> - Software Developer -

>

> Rotter & Kalweit Softwaredesign GbR

> Friemarer Straße 38

>

> 99867 Gotha

> GERMANY

>

> mail:         news_at_falko-rotter.de

> icq :         60187781

>

>

Received on Tue Aug 21 2001 - 07:26:58 CDT