There is a known bug in Oracle 11g (fixed in 11.2.0.1 PSU 2, and 11.2.0.2 onward) which Oracle RAC database that starts with svrctl command won't make use of HugePage, and will get into swap space in Linux
One work around is as follow
File: /etc/init.d.ohash or /sbin/init.d/ohasd
Looks for similar line and replace with following
start()
{
$ECHO -n $"Starting $PROG: "
ulimit -n 131072 # Or higher
ulimit -l 50000000 # Or higher
}
Related link (needs Oracle Metalink support contract and login)
https://support.oracle.com/CSP/main/article?cmd=show&type=BUG&id=9251136
Bug 9251136: INSTANCE WILL NOT USE HUGEPAGE IF STARTED BY SRVCTL
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=983715.1
11gR2 Grid Infrastructure Does not Use ULIMIT Setting Appropriately [ID 983715.1]
Please use following PayPal donate if my post helped
No comments:
Post a Comment