-
Hello DBAs:
We have a datafile block corruption error when trying to create an index for a table.
We created this table, pumped in rows and tried creating an index when it errors with ora-01114 and 27063.. Increased tablesize (new datafile, extended datafile and so on..)Tried all options, such as analyze on the table and it fails. Moved the same table to different tablespace and still it fails to analyze completely, but can estimate to 15-20%.. One of our dba's suspect due to ulimit not set as unlimited for all the options..
oracle@CG_JDA1:/home/oracle_> ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000
How can I set all these to unlimited.. Should I login as root and do it ??
Secondly, how will this solve?
I am unable to gain access to metalink, today..
Thanks, ST2000
-
You can check the man page on ulimit. What I normally do is edit the /etc/security/limits file and set value to -1 for all parameters. These changes will not take effect for the user until they log off and back onto the system.
dkm
