用powercenter做数据抽取的时候,有时候会报一下错误?
-1116:ORA-01116: error in opening database file 209
ORA-01110: data file 209: '/dev/vg_jzpt/rlvjzpt31'
ORA-27041: unable to open file
HPUX-ia64 Error: 23: File table overflow
Additional information: 3
请高手解决!!!
-1116:ORA-01116: error in opening database file 209
ORA-01110: data file 209: '/dev/vg_jzpt/rlvjzpt31'
ORA-27041: unable to open file
HPUX-ia64 Error: 23: File table overflow
Additional information: 3
请高手解决!!!
nfile是系统允许在同一时间打开的最大文件数,是file descriptor table的slots数量,可以调到很大。
maxfiles是单个进程可以打开的最大文件数,根据应用来定,一般开到2048或4096就够了。