我没有安装过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.
.