Attempting to export from Oracle gives error.. AIX limit?

[MCubitt]

(kinda cross posted from Oracle forum)

Using UNIX AIX box holding Oracle 9i DB, used the following:

cd /oracledata/IFST/exp
ORACLE_SID=IFST; export ORACLE_SID
NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252;export NLS_LANG
exp system/oracle file=expIFST.dmp log=expIFST.log consistent=y full=y buffer=500000


The export location is not ideal but the DB is so large and /oracle allocation so small, I have no choice. Anyway.. it all goes along well and then stops:
. . exporting table B_RECADV_INVPART_TAB
EXP-00002: error in writing to export file
EXP-00002: error in writing to export fileerror closing export file expIFST.dmp
EXP-00000: Export terminated unsuccessfully

The resulting files:
-rw-rw-rw- 1 oracle dba 1073741312 21 May 16:19 expIFST.dmp
-rw-rw-rw- 1 oracle dba 23791 21 May 16:19 expIFST.log


Filesystem 512-blocks Free %Used Iused %Iused Mounted on
/dev/hd4 65536 25680 61% 2492 16% /
/dev/hd2 8060928 450656 95% 69310 7% /usr
/dev/hd9var 65536 400 100% 650 8% /var
/dev/hd3 851968 823736 4% 109 1% /tmp
/dev/hd1 65536 61656 6% 159 2% /home
/proc - - - - - /proc
/dev/hd10opt 65536 3904 95% 1214 15% /opt
/dev/redo1_lv 32768000 17966392 46% 62 1% /redolog1
/dev/redo2_lv 32768000 18273608 45% 62 1% /redolog2
/dev/archive_lv 65536000 63478832 4% 26 1% /archivelogs
/dev/oradata_lv 170393600 90950496 47% 91 1% /oracledata
/dev/oraindex_lv 170393600 113577024 34% 71 1% /oracleindex
/dev/ifsdoc_lv 403701760 401084696 1% 1239 1% /ifsdoc
/dev/oracle_lv 16777216 2804688 84% 81927 4% /oracle





I have attempted to export that single table, alone. Rows, no indexes.
The resulting dmp file is size: 132,812,800.
The log shows it was a successful export, without warnings.


Typing ulimit -a (as Oracle) I get: 2097151



Upon aborting from the full export the files are:
-rw-rw-rw- 1 oracle dba 1073741312 27 May 15:03 expIFST.dmp
-rw-rw-rw- 1 oracle dba 23791 27 May 15:03 expIFST.log

Running the individual file (again) it creates:
-rw-rw-rw- 1 oracle dba 132812800 27 May 15:07 expIFST.dmp
-rw-rw-rw- 1 oracle dba 509 27 May 15:07 expIFST.log


So it would be attempting to add 132812800 to 1073741312 which totals 1,206,554,112.

An AIX limitation? Somewhere? Help! Please!






There's no need for sarcastic replies, we've not all been this sad for that long!

 

[raztaboule]

If the ulimit you show has been set before oracle user login ( and perhaps before database was started ) i don't think it's ans OS limit.

a) nothing in errpt ?
b) check with the oracle command "dbv" that you oracle datafiles are not corrupted.
c) do it without the buffer and consistent close , just to see.....

Hope this help.

 

[MCubitt]

From the other post someone made a pertinent comment:

"I don't know how ulimit works in AIX (man ulimit!), but for me, in Tru64 (aka Digital Unix) ulimits counts blocks of 512 bytes.
So, your ulimit of 2097151 would be exactly 1073741312 bytes, and this is where your expIFST.dmp stops.
"

So I have changed soft/hard limit for Oracle to -1...

Running it again...




There's no need for sarcastic replies, we've not all been this sad for that long!

 

[MCubitt]

This worked.


There's no need for sarcastic replies, we've not all been this sad for that long!