Operating System - Linux
1820540 Members
3397 Online
109626 Solutions
New Discussion юеВ

Oracle 8i on RH 7.2 - problem importing dmp file > than 2G

 
Francisco Mancardi_1
Frequent Advisor

Oracle 8i on RH 7.2 - problem importing dmp file > than 2G

I'm using ext3, and after uncompress i've got
a oracle dmp file > than 2G (it cames from an Oracle on AIX). The imp starts ok, but after a while ends with errors.

Anyone out there know if the Oracle 8.1.7 for
linux has file size limits ?

best regards

Francisco
3 REPLIES 3
Mark Grant
Honored Contributor

Re: Oracle 8i on RH 7.2 - problem importing dmp file > than 2G

Kerenel versions 2.2.1 and earlier restricted ext3 to 2GB. However, ext3 can now address up to around 4 tera. You need to upgrade your kernel or change to reiserfs.
Never preceed any demonstration with anything more predictive than "watch this"
Steven E. Protter
Exalted Contributor

Re: Oracle 8i on RH 7.2 - problem importing dmp file > than 2G

I thought(probably wrong) that Red Hat 7.x shipped with ext3 fs as a default and the 2 GB limit turned off.

Seems either I am wrong or someone changed the install options.

There are procedures concerning this at http://www.tldp.org

There are good kernel upgrade procedures at http://www.redhat.com

I would first try up2date

It will let you upgrade to a 2.4 kernel. You need to pick the latest stable version with an even number as the next two digits. 2.4.20 for example. I've had boot problems with odd numbers and Red Hat 7.3

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Claudio Cilloni
Honored Contributor

Re: Oracle 8i on RH 7.2 - problem importing dmp file > than 2G

I'm not so sure, but I think if you split your 2GB+ file into small pieces (using 'split' command) you should be able to import it using arguments VOLSIZE and FILE (with multiple filenames) of the 'imp' command.

Ask for more informations, if you need.

Ciao
Claudio