ORA-00059: maximum number of DB_FILES exceeded
Hi guys,
We have reached to the limit of data files in our production DB and currently we cannot add data files.
Today we have a maintenance window and I want to increase the parameter DB_FILE and boune the DB.
Following some details:
DB version : 10.2.0.4
OS version: Sun Sparc Solaris 5.10 64 bit
DB_FILE=10000
Code:
PROD> ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 8192
coredump(blocks) unlimited
nofiles(descriptors) 65000
vmemory(kbytes) unlimited
I wanted to consult with you how to configure now the parameter DB_FILE?
Increasing to 15,000? maybe more?
Thanks in advance :)