SCO UNIX 6.0 2GB limitation...

irontech

I've installed SCO UNIX 6.0 (eval license), restore my oracle + printers everything. system works fine.

But, i still encounter the problem for 2GB single file size limitation.
1) original tar, only support up to 2GB. (I use tar cvf /temp/test * )
    - should be able to solved by using /u95/bin/cpio

2) oracle (7.3.4) export command seem can't jump over 2GB on Unix 6.

On /u95/bin directory, no tar, only cpio. I could use /u95/bin/dd command to write file size more than 2GB...

I still can't figure out how to use the /u95/bin/ulimit command. When I check, everything are unlimited, include file(blocks) also.

Unix 6 TCP looks better than OSR 5, change host name/IP no need to relink kernel, just tcp stop& start will do, users logon while after restart Unix 6, users still can continue the previous disconnected session.

Unix 6 auto configure any backup tape, compare with OSR5 need manually keyin SCSI ID/LUN/Host etc..

Unix 6 KDE not much surprise, need to enable manually.

Unix 6 can configure "Dedicated memory", to reserve for some other program usage/purpose. This is great feature even I have not tested it out.

Unix 6, still same as OSR 5.0.7, failed to installed Oracle 7.3.4

Still need some time to explore more new features on Unix 6...

irontech

今天作个实验， 用(Oracle 7.3.4) exp system/manager file=database.dmp log=test.log full=y, 都不可以超过2GB.当它跑到2137483647(file size)时就停了,说EXP-00002: error in writing to export file.. 有点被骗的感觉。

有那位高手可以帮忙吗？
SCO 6只有 /u95/bin 里头的command 可以写超过2GB 的 file.
http://wdb1.sco.com/kb/showta?ta ... 5623565&pgnum=1


就像我用这写出3GB的 file
/u95/bin/dd if=/dev/zero of=/temp/size/gb count=6144000

如果我只用普通 dd if=/dev/zero of=/temp/size/gb count=6144000  那也只可以写出2GB的 file

CNL

only VxFS filesystem support > 2G

irontech

CNL, its VxFS already....  i can use /u95/bin/dd to generate file in /u/oracle/dmp larger than 2GB, i did it on 3GB. But somehow, other conventional command couldn't do that.

The other thing, Oracle 7.3.4 installation, will facing the same issue on 5.0.6 & 5.0.7, which installed somewhere until TNS part will failed.

CNL

1 oracle 7.3.4 not support file > 2G, you must use pipe to imp or exp
2 install 7.3.4, you must select relink oracle execute option,
   you also need replace crt0.0,crt1.0 with 5.0.5 and  replace back after install oracle
3 osr6, only some commands support large file operation(NOT ALL),
such as:
cat(C)     du(ADM)         pathchk(C)
     chgrp(C)   ff(ADM)         pax(C)
     chmod(C)   find(C)         pwd(C)
     chown(C)   fsck(ADM)       rcp(TC)
     cksum(C)   fsdb(ADM)       rm(C)
     cmp(C)     ln(C)           rmdir(C)
     compress(C)        ls(C)           sum(C)
     cp(C)      mkdir(C)        touch(C)
     cpio(C)    mkfs(ADM)       ulimit(C)
     dd(ADM)    mv(C)           uncompress(C)
     df(ADM)    ncheck(ADM)     zcat(C)

CNL

in addition, osr6 you must apply osr6 MP1

irontech

How to use this (pipe to imp/exp)? (i'm not very good in oracle)

"oracle 7.3.4 not support file > 2G, you must use pipe to imp or exp"

Relink oracle execute option? Ok, let me try again n let u know.

CNL

How to use this (pipe to imp/exp)?

such as follow: (use pipe & split (2000m)

1. 
   
2. $ /etc/mknod exp_pipe p
   
3. $ split -b 2000m exp_pipe _your_expfile_headname_ &
   
4. $ exp .... file=exp_pipe
   
5. $ rm exp_pipe
   
6. then you may get dmp files like these:
   
7. _your_expfile_headname_aa,
   
8. _your_expfile_headname_ab,
   
9. ...
   
10. 
    
11. $ /etc/mknod imp_pipe p
    
12. $ cat _your_expfile_headname_aa ...ab ..ac ... > imp_pipe &
    
13. $ imp ... file=imp_pipe
    
14. $ rm imp_pipe
    

复制代码