oracle导入错误1119,比较着急：奇怪的问题：ORA－1119。27039

我没有安装过ORACLE817 FOR AIX，但在METALINK上看过一篇相关文档，ORACLE脚本在获取USER的ULIMIT时出现会问题，不知对你有无帮助。

fact: Oracle Server - Enterprise Edition 8.1.7

fact: Oracle SQL*Plus

fact: IBM RS 6000 AIX

fact: HP 9000 Series HP-UX (64-bit) 11

fact: Compaq Tru64 UNIX

symptom: Database startup fails

symptom: Unable to connect to the database

symptom: ORA-01115 : IO error reading block from file block # &

lt;num>

symptom: ORA-27092 : skgfofi: size of file exceeds file size limit of the

process

symptom: ORA-01110: data file %s:

change: Upgrade from 8.1.6 to 8.1.7

cause: <887509>887509>

: UNIX FILE SIZE LIMIT CAN CAUSE ORACLE BLOCK CORRUPTION

fix:

1.Use  ksh instead of sh or modify the oraenv script so the exec osh is not

done anymore.

Piece of the troubling part of the oraenv script:

if [ -f $ORACLE_HOME/bin/osh ] ; then

exec $ORACLE_HOME/bin/osh

else

for D in `echo $PATH | tr : " "`

do

if [ -f $D/osh ] ; then

exec $D/osh

fi

done

fi

Change this piece to:

# One line will be added, ten lines will be commented out.

echo OSH will not executed

#    if [ -f $ORACLE_HOME/bin/osh ] ; then

#        exec $ORACLE_HOME/bin/osh

#    else

#        for D in `echo $PATH | tr : " "`

#        do

#            if [ -f $D/osh ] ; then

#                exec $D/osh

#            fi

#        done

#    fi

The oraenv script is in $ORACLE_HOME/bin and in /usr/local/bin,

so make sure this change is made on both places.

2. If this happens during the connection in SQL*PLUS :

Check that the ulimit is unlimited or bigger then the largest database file

for the user connecting through BEQ or the user (usually oracle) starting

the listener process.

Restart the listener after having changed the ulimit.

.