Dear
Readers,
My
name is Franz Devantier, creator of this blog. I am an Oracle Certified
Professional (OCP DBA 11g) Security DBA.
I will be sharing with you the basic duties of an Oracle DBA, and also
some of the undocumented, and not so well known tasks.
I will make a deal with you: If you refer me to a company that needs
database support, from a few hours per week to full time, and I am able to sign
a contract with them.
Then I will give you 10% of the
monthly contract or deal price every month.
When the contract ends, and we re-sign the contract, I will again give
you 10% of the monthly contract price.
This will go on until the company no longer employs or contracts me or
my agents to look after their databases.
I can do this, because that 10% is my
marketing budget. When we re-sign the
contract, in the future, it may depend on you giving the thumbs up again, and
that is worth 10% of the monthly contract price, to be given to you as
commission.
Oracle
Database Preinstallation – Part 9
Checking Resource
Limits for the Oracle Software Installation Users
You should check the resource
limits for each Oracle Software Installation User. Below are the recommended ranges for the
resources.
|
Resource Shell Limit
|
Resource
|
Soft Limit
|
Hard Limit
|
|
Open file descriptors
|
Nofile
|
At least 1024
|
At least 65536
|
|
Number of processes
available to a single user
|
Nproc
|
At least 2047
|
At least 16384
|
|
Size of the stack segment
of the process
|
stack
|
At least 10240 KB
|
At least 10240 KB,
At most 32768 KB
|
In
order to verify these resource limits for the Oracle Software Installation
users, you start off by logging in as the installation owner, or switching to
the installation owner.
=>
Check the soft and hard limits for the file descriptor setting, and verify that
the result is in the recommended range, as in the above table.
$
ulimit -Sn
1024
$
ulimit -Hn
65536
=>
Verify the soft and hard limits for the number of processes.
$
ulimit -Su
2047
$
ulimit -Hu
16384
=>
Verify the soft and hard limits for the stack setting
$
ulimit -Ss
10240
$
ulimit -Hs
32768
If the resource limits are not
in the recommended range, then you can update the /etc/security/limits.conf
file. It may be necessary to adjust the
values for a user or to add the values for a user. We could edit this file as the root user, and
add lines similar to the ones below, for the oracle user.
$ vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
Now you need to repeat the
process for each Oracle Software Installation Owner. The changes made to the limits.conf file take
place immediately. However if a specific
users values have been changed, those changes will only take effect, after the
user has logged out and back in again.
So before you start the installation, make sure that you log out of all
your Oracle Software Installation Owner Users, that you have changed, and log
back in again.
Franz
Devantier,
Need
a database health check?
devantierf@gmail.com
Classifieds
No comments:
Post a Comment