When installing ORACLE 12c on solaris10, the following error occurs: Soft limit: maxmum open file descriptors, filedescriptors.
-- Configure the maximum number of opened oracle files
The Solaris operating system has a limit on the number of opened files. The db_files parameter settings of the database are limited by the operating system parameters.
An environment check error occurs during installation of 12c in solaris10:
Soft Limit: maximum open file descriptors-This is a prerequisite condition to test whether the soft limit for "maximum open file descriptors" is set correctly.
Expected Value: 1024
Actual Value: 256
-- View parameter restrictions:
Bash-3.2 # ulimit-
Core file size (blocks,-c) unlimited
Data seg size (kbytes,-d) unlimited
File size (blocks,-f) unlimited
Open File (-n) 256
Pipe size (512 bytes,-p) 10
Stack size (kbytes,-s) 10240
Cpu time (seconds,-t) unlimited
Max user processes (-u) 28565
Virtual memory (kbytes,-v) unlimited
Bash-3.2 #
# The third method is recommended:
(1) modify the/etc/system parameter
On Solaris10, this method is not recommended, but it is still valid. Parameters set in/etc/system are globally valid, that is, all users are affected. After the configuration, the system must be restarted to take effect.
You can add the following two parameters to the/etc/system file and then restart the system.
Set rlim_fd_cur = 1024
Set rlim_fd_max = 65535
(2) Use the ulimit command to modify the modification (effective immediately. Once the current SHELL exit setting is invalid)
The ulimit command can only modify the settings of the current SHELL and its sub-processes. The setting takes effect immediately. 'once the current SHELL exits, the setting becomes invalid. The-S parameter is used to set the soft limit, and the-H parameter is used to set the hard limit '.
Ulimit-S-n 65536
Ulimit-H-n 65536
-- In the ulimit command, open files displays Soft Limits. You can use the prctl command to display Hard limits, that is, the privileged value.
Bash-3.2 # prctl-I process $
Process: 13110: bash
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
Process. max-address-space
Privileged 16.0EB max deny-
System 16.0EB max deny-
Process. max-file-descriptor
Basic 256-deny 13110
Privileged 65.5 K-deny-
System 2.15G max deny-
Process. max-core-size
Privileged 8.00EB max deny-
System 8.00EB max deny-
Process. max-stack-size
Basic 10.0 MB-deny 13110
Privileged 125 TB max deny-
System 125 TB max deny-
....
...
...
(3) Use the project (effective immediately, permanent)
Project is a new feature of Solaris10. You can set the project parameter to a user or a group of users. The setting takes effect immediately.
'However, the result of the root user is only affected by parameters in/etc/system, but not by project user. oracle. the root user does not belong to this project .'
The following is a configuration example:
Bash-3.2 #: // #> projadd user. oracle (Create project user. oracle)
Bash-3.2 #:/#> id-p oracle
Uid = 100 (oracle) gid = 1 (other) projid = 100 (user. oracle) (oracle users belong to project user. oracle)
Bash-3.2 #: // #> projmod-a-K "process. max-file-descriptor = (basic, 65534, deny)" user. oracle
Bash-3.2 #: // #> projmod-a-K "process. max-file-descriptor = (priv, 65535, deny)" user. oracle
Bash-3.2 #: // #> grep 'user. oracle'/etc/project
User. oracle: 100 :::: process. max-file-descriptor = (basic, 65534, deny), (priv, 65535, deny)
Set the values of basic and privilege to 65534 and 65535 respectively. The maximum hard limit of 65535 cannot be exceeded in/etc/system;
Bash-3.2 #:/#> tail-2/etc/system
Set rlim_fd_cur = 1024
Set rlim_fd_max = 65535
Bash-3.2 # plimit $
13110: bash
Resource current maximum
Time (seconds) unlimited
File (blocks) unlimited
Data (kbytes) unlimited
Stack (kbytes) 10240 unlimited
Coredump (blocks) unlimited
Nofiles (descriptors) 256 65536
Vmemory (kbytes) unlimited
Bash-3.2 #
Root user results are only affected by parameters in/etc/system, but not by project user. oracle. root user does not belong to this project.
Bash-3.2 # su-oracle
Oracle Corporation SunOS 5.10 Generic Patch January 2005
-Sh: TEMP =/tmp: is not an identifier
$ Bash
Bash-3.2 $ plimit $
14704: bash
Resource current maximum
Time (seconds) unlimited
File (blocks) unlimited
Data (kbytes) unlimited
Stack (kbytes) 10240 unlimited
Coredump (blocks) unlimited
Nofiles (descriptors) 65534 65535
Vmemory (kbytes) unlimited
Bash-3.2 $
Add other resource restrictions as follows:
-- Modify other parameters as shown above:
Noexec_user_stack = 1
Semsys: seminfo_semmni = 100
Semsys: seminfo_semmns = 1024
Semsys: seminfo_semmsl = 256
Semsys: seminfo_semvmx= 32767
Shmsys: shminfo_shmmax = 4294967295
Shmsys: shminfo_shmmni = 100
Rlim_fd_max= 65536
Rlim_fd_cur= 4096
Maxuprc = 16384
Max_nprocs = 3000
Projmod-a-K "project. max-sem-ids = (priv, 100, deny)" user. oracle
Projmod-a-K "process. max-sem-nsems = (priv, 256, deny)" user. oracle
Projmod-a-K "project. max-shm-memory = (priv, 4294967295, deny)" user. oracle
Projmod-a-K "project. max-shm-ids = (priv, 100, deny)" user. oracle
