Database cannot be shut down ?

[Chris Fung]

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,

[Aashish Raj · Accepted solution]

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

Thanks
AR

[Tom Geudens]

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

[T G Manikandan]

#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