Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set ulimits for Oracle 11gR2

Beauty_and_dBestApr 5 2018 — edited Apr 6 2018

11gR2

OL6

Hi ALL,

We bought  a new server for our PROD database, because the current OLD  db server is out of storage anymore.

Our current OLD server is still performing good but run out of disk space.

The CPU/Memory are almost the same for both servers.

We have cloned our database to the NEW server, and be ready for the switch cut-over to the NEW server.

Aside from init.ora, What performance parameter (Db & OS) do I need to copy from the current server to the NEW server?

Such that I will be assured that the NEW server will perform equally or better than the OLD server?

Does the fact that the new server is "NEW" assures that it will perform better?

Can I also copy the value of  ulimits config file? Are the following ulimits values acceptable?

/etc/security/limits.conf

* soft    memlock       1048576

* hard    memlock       2097152

* soft    stack          131072

* hard    stack          131072

* hard    nofile          65535

* soft    nofile          65535

* hard    nproc           65535

* soft    nproc           65535

Please help how to make our New Server ready for PROD   cut-over.

Kind regards,

jc

This post has been answered by Hans Steijntjes on Apr 6 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2018
Added on Apr 5 2018
13 comments
1,842 views