topic Re: Database cannot be shut down ? in Operating System - HP-UX

Database cannot be shut down ?

Chris Fung — Thu, 27 Jun 2002 00:28:58 GMT

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,

Re: Database cannot be shut down ?

Aashish Raj — Thu, 27 Jun 2002 03:22:27 GMT

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

Thanks
AR

Re: Database cannot be shut down ?

Tom Geudens — Thu, 27 Jun 2002 03:26:32 GMT

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

Re: Database cannot be shut down ?

T G Manikandan — Thu, 27 Jun 2002 04:42:36 GMT

#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