Re: Question about Oracle 10g install

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sun, 27 Jan 2008 21:14:53 +0100
Message-ID: <479CE63D.7060006@gmail.com>


Michael O schrieb:
> On Jan 27, 9:29 am, "charlie cs" <charli..._at_hotmail.com> wrote:

>> After the installation, everything works fine.  But when going over his
>> configuration, i noticed that he did not put
>>
>> session required /lib/security/pam_limits.so
>> in /etc/pam.d/login
>>
>> as required by Oracle documents.

>
> Please provide a reference to the Oracle document that tells you it is
> required but doesn't explain why?
>
> Michael O
> http://blog.crisatunity.com
>

I can not quite follow, there is a url to oracle documentation, http://download.oracle.com/docs/cd/B19306_01/install.102/b15667/pre_install.htm#BABCHAED and they said,
<quote>
To improve the performance of the software on Linux systems, you must increase the following shell limits for the oracle user </quote>
The oracle documentation don't goes in detail, how it may improve the performance, however, it seems to be obvious - as long as you don't hit the limits, you can happy live with defaults, howerver, if your system is a busy one, you may need a little bit more resources but you won't get additional, if you don't set the limits as documented. The purpose of limits.conf in linux is comparable with resource_limit in oracle - here is the link to documentation:
http://www.faqs.org/docs/securing/chap5sec44.html Putting the pam_limits.so in the /etc/pam.d/login has nothing to do with oracle installation, it should be in every proper configured linux system, which utilize pam ( and this is the standard if i am not wrong).

Best regards

Maxim Received on Sun Jan 27 2008 - 14:14:53 CST

Original text of this message