Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
Showing results for 
Search instead for 
Did you mean: 

Database cannot be shut down ?

Go to solution
Chris Fung
Frequent Advisor

Database cannot be shut down ?

Dear all,

we just encounter a database shutdown problem. we are using Oracle 8.1.7 Enterprise edition. I 've created a testing database in which the "processes" parameter is set to 50 initially. Then, I created a datafiles which is 2000MB. After that, each time I want to shutdown the database, the following message will prompt:


ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/dbalv02/oradata/data01.dbf'
ORA-27092: skgfofi: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 512001


However, I am unable to alter the current session to increate the no. of processes !! So what can I do?? Shutdown abort or ?? I am afraid I will lose the data stored in that data file.

Attached please find the init.ora file for your reference.

Thanks for help,

Aashish Raj
Valued Contributor

Re: Database cannot be shut down ?

Increase the ulimit of your environment and then shutdown the database.

Tom Geudens
Honored Contributor

Re: Database cannot be shut down ?

Hi Chris,
I think you are running into the "ulimit" parameter as well. Take a look at,,0xb0c3a2db8513d6118ff40090279cd0f9,00.html
for instructions on how to increase it.

A life ? Cool ! Where can I download one of those from ?
T G Manikandan
Honored Contributor

Re: Database cannot be shut down ?

#ulimit -f
is for the files.

#you should set increase the ulimit value of files.
you can set it to unlimited

#ulimit -f unlimited

Also you can look your soft and hard limit values using
#ulimit -aS
#ulimit -aH

ulimit -f (this is for files)
ulimit -n (no of files)
ulimit -d (maxdsiz)
ulimit -s (maxssiz)

I have seen a note that when your Oracle datafile is larger than the value of your ulimit there is possiblity for a corruption of the datafile.