From: Walls, Vern (Vern.Walls@parsons.com)
Date: Wed Dec 08 2004 - 17:39:40 EST
Greetings, all. It's been a while since I was active on this list....
Here's my problem:
I'm running an E450 with:
Solaris 2.6 with the latest recommended patches.
Veritas Volume Manager 2.5.1
Veritas Database Edition for Oracle 2.0
Oracle 8.1.6
We have an Oracle database which is using the Veritas quick I/O files,
which were created with the "mkqio.sh" script.
Here's my problem:
We migrating over to a new SunFire V880 system, which will be running
Solaris 8 and DiskSuite. In preparation for that, I tried copying over
the cold database files to the new server, which appeared to work fine.
Checksums on the source and target files are the same. However, when
Oracle starts up using the new datafiles, I get two errors:
ORA-01157: cannot identify/lock data file #<whatever>
ORA-27046: file size is not a multiple of logical block
size
This message is reported for 3 of the 7 datafiles for this database. The
other 4 files report no errors, including the control file.
My trouble shooting continued: On the existing source server, the
database starts fine ONLY if the file names use the linked ".dbfile.dbf"
format. If I merely rename them to the same name with out the link, I
get the same error. So the copying process is not the problem.
If I copy one of the ".dbfile.dbf" files to another filename, the byte
counts under "ls -l" are the same. Additionally, a "du -s" reports the
same number of blocks for both of the files.
But Oracle still reports the above errors.
Has anyone seen this before? How do you convert a Veritas QIO file back
to a "normal" file ?
I'll summarize.
- Vern
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:29:51 EDT