[Sunhelp] System error message 22 (File size More then 2GB)

[Sampath K Kari]

Hi Aamir,

Solaris 2.5.1 has this 2GB maximum file limitation which is resolved with 2.6
where filesystems are mounted wiith largefile option.

In ur case, with 2.5.1 u can go for a work around to  take the oracle export
backup in the below manner.

Assuming  the output export dump file name is export.full.test.Z   and  named
pipe creation directory as /var, and export file creation in /export/oracle
directory below.

1) Create a named pipe, say, test1 and give the appropriate
ownership/permissions needed for oracle to write to this file.
        mknod  /var/test1 p

2) modify the export backup script of oracle like below:

       a) Before the exp command, insert the command:    compress </var/test1
>/export/oracle/export.full.test.Z &
        b) In the exp command use the output file as /var/test1

Note to import:

Use the script like below

uncompress </export/oracle/export.full.test.Z  >/var/test1 &
imp command with input file as /var/test1


Hope this helps. All the best.

Regards,
Sampath
From: "Aamir Ilyas" <amirpew at hotmail.com>

> To: sunhelp at ohno.mrbill.net
> Date: Sun, 22 Aug 1999 15:24:49 PKT
> Subject: [Sunhelp] System error message 22 (File size More then 2GB)
> Reply-To: sunhelp at sunhelp.org
>
> Hi! Sunhulp's
>
> I am facing problem on ORACLE 7.2.3 install on SUN Ultra-E450 with Solaris
> 2.5.1.
> The problem was occur when I execute ORACLE exp command for entire Database
> When file size is greater then 2GB its display the massage!
>
> EXP-00015: error on row 37349 of table MIS_CA_CATS, column EDITION, datatype
> 1
> EXP-00222:
> System error message 22
> EXP-00002: error in writing to export file
> EXP-00002: error in writing to export file
> EXP-00000: Export terminated unsuccessfully
>
> After this message I supposed that the problem is for ulimit. And I changed
> my ulimit
> # ulimit -f 4097148
> # ulimit -d 4097148
> # ulimit -s 4097148
> # ulimit -v 4097148
> #
> # ulimit -a
> time(seconds)        unlimited
> file(blocks)         unlimited
> data(kbytes)         4294705145
> stack(kbytes)        unlimited
> coredump(blocks)     unlimited
> nofiles(descriptors) 64
> vmemory(kbytes)      unlimited
>
> After these steps I am again execute ORACLE exp and its give me the same
> problem.
> How can I create file on ufs more then 2,3GB.
>
> Pl. helps me on it as soon as possible.
>
> Regards
> Aamir Ilyas
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
> --__--__--
>
> _______________________________________________
> SunHELP maillist  -  SunHELP at sunhelp.org
> http://www.sunhelp.org/mailman/listinfo/sunhelp
>
> End of SunHELP Digest