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.
cancel
Showing results for 
Search instead for 
Did you mean: 

Database cannot be shut down ?

SOLVED
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:

Quote

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

Unquote

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,

Chris,
3 REPLIES
Aashish Raj
Valued Contributor
Solution

Re: Database cannot be shut down ?

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

Thanks
AR
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 http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xb0c3a2db8513d6118ff40090279cd0f9,00.html
for instructions on how to increase it.

Regards,
Tom
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.

Thanks