Copying a DB from NT to Linux occurs a ORA-01516
Falko Rotter
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: ne...@falko-rotter.de
icq : 60187781
Nuno Souto
wrote:
>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'
>
You might have to use "\\" instead of "\"? *nix interprets "\" as an
escape and ignores the next character.
Cheers
Nuno Souto
nso...@optushome.com.au.nospam
Ales Voboril
as far as I know, cloning database by copying datafiles across platforms is
impossible.
Use Export/Import.
Ales
Falko Rotter <fanto...@gmx.de> wrote in message
news:9lth89$93t$1...@newsread2.nexgo.de...
Kristian Kalweit
> You might have to use "\\" instead of "\"? *nix interprets "\" as an
> escape and ignores the next character.
>
Tried it, but the same error occurs. I think oracle don't missinterprets the
given filename, because in the error message the filename is also typed
correctly.
Greetings,
Kristian.
Nuno Souto
<k.ka...@gmx.de> wrote:
>
>Tried it, but the same error occurs. I think oracle don't missinterprets the
>given filename, because in the error message the filename is also typed
>correctly.
>
Bugger. Looks like you might be stuck. Can't think of any way of
making Linux gobble the "N:" thing, which is prolly what's causing the
snag. Didn't know it checked existence of original file for logfiles.
It doesn't for data files. There is always exp/imp, but I'm guessing
you're trying to find a shortcut, given it would be same architecture
(Intel) and prolly same datafile contents?
Have you tried adding new logfiles and offline the old ones?
Cheers
Nuno Souto
nso...@optushome.com.au.nospam
Niall Litchfield
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" <fanto...@gmx.de> wrote in message
news:9lth89$93t$1...@newsread2.nexgo.de...
>
Kristian Kalweit
> Have you tried adding new logfiles and offline the old ones?
>
New logfiles are added. I also think oracle doesn't check for file
existence, only the mapping the the filename entry in the control file
fails.
Regards,
Kristian.
Kristian Kalweit
corrupt. Are the binary data between Linux and NT Oracle Version different?
Both are intel systems so I think there are no problems how the data are
stored.
Regards,
Kristian.
Hieraklion
According French Oracle Online Support, coping Oracle files from one
host to another and particular when the OS are differents is not
supported.
Use import/export.
"Au revoir" from Paris
Christophe Brault
Falko Rotter a écrit :
Billy Verreynne
> I'm left absolutely speechless.
> You cannot just copy datafiles across OS platforms.
Speechless!? I've got coffee coming out of my nose..! Never heard anything as
ignorant and naive.. Hehe.. hahahaha.. sheez.. now where is my list of
nominations for The Oracle Darwin Awards...
This one ranks near the top. Though I still expect to see someone posting that
he lost a limb or something on the sharp edge of a non-valid pointer in Pro*C.
--
Billy
Nuno Souto
<n-litc...@audit-commission.gov.uk> wrote:
>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.
>
I think he knows that, Nial. He's just playing around doing
"what-ifs".
Cheers
Nuno Souto
nso...@optushome.com.au.nospam
Nuno Souto
<vsl...@onwe.co.za> wrote:
>Speechless!? I've got coffee coming out of my nose..! Never heard anything as
>ignorant and naive.. Hehe.. hahahaha.. sheez.. now where is my list of
>nominations for The Oracle Darwin Awards...
Don't rush in yet. It's a fun exercise, nothing serious. See my reply
to Nial.
>
>This one ranks near the top. Though I still expect to see someone posting that
>he lost a limb or something on the sharp edge of a non-valid pointer in Pro*C.
>
You mean falling off the "dangling pointer"? :-)
Cheers
Nuno Souto
nso...@optushome.com.au.nospam
Nuno Souto
<k.ka...@gmx.de> wrote:
>New logfiles are added. I also think oracle doesn't check for file
>existence, only the mapping the the filename entry in the control file
>fails.
>
Stuff. Would be real fun if the darn thing started! :-)
Cheers
Nuno Souto
nso...@optushome.com.au.nospam
Paul Drake
> 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
Pete Sharman
does a STARTUP MOUNT, all it does is open the control file - it doesn't
attempt to access the datafiles themselves. Niall is in fact correct. The
datafiles are NOT useful, because Linux and NT files are different binary
beasties. There is no way to copy files from one OS to another and start
the database. You will need to export the NT database and import it into
the Linux one after doing a binary ftp of the dump file.
--
HTH. Additions and corrections welcome.
Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Now got a life back again that the book is released!
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
"Kristian Kalweit" <k.ka...@gmx.de> wrote in message
news:9ltmnb$eav$1...@newsread2.nexgo.de...
Nuno Souto
>
>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.
Exactly. The main problem with this would be "big-endian" to
"little-endian" conversions. Which are not an issue in the same CPU
architecture, same file system, different OS's, both POSIX compatible.
>
>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.
A bit of lateral thinking never hurt anyone, eh? ;-)
>I would never *ever* think about such a configuration ever being
>supportable.
>
Absolutely! Yet, if I had stuck to what is "supportable" or even
"recommended" in the last 13 years, I'd probably still be doing DBA
work of backup/restore/defrag once a week. Boring, and that's putting
it mildly.
Having said that, let's not even *think* of running any system like
this! It's just an interesting reasoning exercise.
Cheers
Nuno Souto
nso...@optushome.com.au.nospam
Nuno Souto
<peter....@oracle.com> wrote:
>datafiles are NOT useful, because Linux and NT files are different binary
>beasties.
Not if Linux is running an NTFS or other compatible file system?
After all, they are both created and read/written by using standard
C-library I/O calls. Common to both OS's. With some exceptions in NT
due to its quaint I/O optimizations, agreed.
Just curious, no-one is recommending anything here.
Cheers
Nuno Souto
nso...@optushome.com.au.nospam
Niall Litchfield
news:9ltnaj$b02$1...@ctb-nnrp1.saix.net...
I'd like to nominate my ascii ftp of a 6gb dump file across a 64k link. That
was fun!
Nuno Souto
<n-litc...@audit-commission.gov.uk> wrote:
>
>I'd like to nominate my ascii ftp of a 6gb dump file across a 64k link. That
>was fun!
>
Jeez! That woulda made watching paint dry riveting. :-D
Cheers
Nuno Souto
nso...@optushome.com.au.nospam
NCR Employee
N:\DATABASE_DEV\SYS1DEV.ORA and trying it again? You might have to put the
file in the directory you are running the startup from as there's no
pathing.
You can create the file using vi:
vi N:/\DATABASE_DEV/\SYS1DEV.ORA (using the \ to escape the /)
"Nuno Souto" <nso...@optushome.com.au.nospam> wrote in message
news:3b8247d2.9224340@news...
NCR Employee
vi "N:\DATABASE_DEV\SYS1DEV.ORA"
"NCR Employee" <ncr.em...@ncr.com> wrote in message
news:3b83...@rpc1284.daytonoh.ncr.com...
Pete Sharman
working. But hey, I've been wrong before! ;)
Unfortunately I don't have a Linux box to test this on, so I can't really
answer the question. If someone else does who doesn't mind a bit of time
playing with this, it would be interesting to see if it did work.
--
HTH. Additions and corrections welcome.
Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Now got a life back again that the book is released!
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
"Nuno Souto" <nso...@optushome.com.au.nospam> wrote in message
news:3b83855b.2604864@news...
Liz Reen
operating systems. The problems is not the file system type. That
hurdle was crossed when you copied the files. It is the internal
representation of the data which is different (think long, floating
point etc.) Linux may be a "recent" o/s, which is based on Unix which
is anything, but recent. Export/Import is the only answer.
Liz
Stephen T. Parfitt
does NOT use a 'native' internal representation for data.
Instead, it uses its own 'proprietary' internal representation. E.g.
take a look at Oracle's way of storing numbers - it's like nothing else
on this planet! It's certainly QUITE different from any native hardware
scheme for numbers that I have ever seen.
Conclusion: Oracle converts from its own storage scheme to the 'native'
hardware/operating system scheme at some point. This makes me think that
there's at least a possibility that the Linux and NT databases are
cross-compatible. But it may be wishful thinking!
Steve Parfitt
T. Schwickert
nice thread :-)
Just theoretically:
create a tablespace on nt, the same on linux using same parameters etc.
Compare them binary.
Are they the same ?
I don't think so, but I'm not sure before i've try it.
I can't do it, no oracle on nt and no linux :-)
just playing around ...
Thomas
Nuno Souto
wrote:
>>
>Hardware has nothing to do with it. These are two totally different
>operating systems. The problems is not the file system type. That
>hurdle was crossed when you copied the files. It is the internal
>representation of the data which is different (think long, floating
>point etc.) Linux may be a "recent" o/s, which is based on Unix which
>is anything, but recent. Export/Import is the only answer.
Er, I think it's exactly the opposite, Liz.
Floating point and long are *EXACTLY* the same in NT and Linux, *if*
both are running in an Intel platform. Both FP and long are driven by
the CPU architecture and have nothing whatsoever to do with the OS.
Assuming an Intel architecture:
If you use the open() and write() calls in C (the language used to
write ORACLE) in Linux to store a long and a FP in a FILE and then
close(), I can guarantee you if you FTP the file to NT in binary mode,
you will be able to write a program in NT that does a standard
C-library open(), read(), and get exactly the same data back as you
wrote in Linux.
That I can assure you works. It even works if you write the file in a
Sequent (Intel CPU) and read it in NT! Been there, done that.
However, data stored in ORACLE datafile is a little bit more than just
a FP or a long. There is the darn file headers and the block headers
and row headers. These will have different info stored in Linux and
NT. That's where the spanner is thrown...
Cheers
Nuno Souto
nso...@optushome.com.au.nospam
Nuno Souto
wrote:
>nice thread :-)
Yeah, but let's not make a habit of it. :-)
>Just theoretically:
>create a tablespace on nt, the same on linux using same parameters etc.
>Compare them binary.
>Are they the same ?
>I don't think so, but I'm not sure before i've try it.
I don't think so either. If nothing else, the info that goes into a
datafile header in Linux Oracle will be quite different from what goes
into a NT ORACLE datafile header. Not in structure, but in content.
However, the pure table data (abstracting headers and column
separators) will be exactly the same. Assuming of course the same
type of Intel CPU.
Cheers
Nuno Souto
nso...@optushome.com.au.nospam
Robert Fazio
news:3B845B33...@sympatico.ca:
> I may not be 100% correct about this, but as far as I can think Oracle
> does NOT use a 'native' internal representation for data.
I seem to recall reading somewhere that as of 8i they were supposed to start
using a datafile representation that was cross-platform capable. I know
that they have made changes to the archive logs. The hope was at least from
what I remember was that the transportable tablespace would be possible to
use on multiple platforms (someday, but not today).
I did some reading in the docs, and everywhere you can find it, they say it
won't work. But they do continue to say hardware, not OS. So I would
suggest giving it a try.
--
Robert Fazio
Senior Technical Advisor
dba...@yahoo.com