topic Re: Error While making database up in Operating System - HP-UX

Error While making database up

Sandeep Malav — Wed, 25 Feb 2009 16:03:01 GMT

Hi,
I had got databease from my company's another location which i had uploaded in server & I want to make this database up & use
When ever I run script to up the database i get following error

21:45:43 SERVER : SYSTEM ERROR: Invalid blocksize 20992 in database /cfadata2/c701/db/pondyqad. (4521)
21:45:43 SERVER : ** The server terminated with exit code 2. (800)
21:45:43 SERVER : SYSTEM ERROR: Invalid blocksize 20992 in database /cfadata2/c701/db/pondybcs. (4521)
21:45:43 SERVER : ** The server terminated with exit code 2. (800)

Re: Error While making database up

Patrick Wallek — Wed, 25 Feb 2009 16:12:08 GMT

What kind of database?

What type of server did it come from?

What operating system was running on the other server?

How did you "uploaded" it to your server?

Re: Error While making database up

Sandeep Malav — Fri, 27 Feb 2009 10:01:26 GMT

What kind of database?
it's oracle database

What type of server did it come from?
HP - Unix

What operating system was running on the other server?
HP - Unix

How did you "uploaded" it to your server?
through ftp

Re: Error While making database up

Kuang Chen — Tue, 03 Mar 2009 20:53:17 GMT

It look like datafile trasfer incompleted.
Have you setup Binary transfer on ftp?

Make sure you have same OS version of HPUX and make sure shutdown your database before ftp data files, and make the target server directory structure have be same like source database.

-KC

Re: Error While making database up

Ben Dehner — Mon, 09 Mar 2009 18:17:48 GMT

If you're doing a simple file transfer, the database revision levels must be the same. In paricular, if trying to open a 9i database using 10g binaries (without doing an upgrade), the datafiles will appears corrupted to the 10g system. And the 10g binaries will actually corrupt the files on the startup attempt.

This is especially important if the file system layout is different. You will need to rename the datafiles, or rebuild the control files, using the original source version before being able to upgrade the database.

Since you're doing a (hopefully binary!) ftp transfer, it isn't important that the OS version or the file system versions match. The datafile layout is binary compatible between different OS versions and architectures. I've moved data files from an 11.11 PA-RISC to 11.23 Itanium without problems.