Originally posted by: sck

Hi,

Does AIX 5.3 requires reboot after changing the ulimit's (file size,core file size) of oracle user to unlimited. If not, then how that can be updated so that oracle user does not get any problem while creating the database of bigger size (in GB).

Thanks

Originally posted by: SystemAdmin

No reboot required. However you do need to stop and restart all of your processes running as the Oracle user to have them use the new limits. A reboot would essentially do the same thing, but it is not necessary.

Matt

Originally posted by: hwyguy

Another thing to consider when changing ulimits is that the user must logout and log back in again for them to take effect.

So if you changed them for the Oracle user, after you bring down all of the oracle processes, logout and login again as oracle, do a quick ulimit -a to make sure the ulimits look good, and then start bringing up oracle processes.

Hope this helps!

Originally posted by: SystemAdmin

Nither a reboot, nor you have to restart Oracle.
use this command `stopsrc s inetd` and restart it `startsrc -s inetd`

we do it most of the time for any limits that would hit the `root` limits.

Originally posted by: SystemAdmin

Nither a reboot, nor you have to restart Oracle.
use this command `stopsrc -s inetd` and restart it `startsrc -s inetd`

we do it most of the time for any limits that would hit the `root` limits.

Originally posted by: orphy

Shouldn't need to restart inetd at all for this. All you should need to
do is logout and login to get the new limits.
Orphy