--Configure the maximum number of Oracle open files limit
The Solaris operating system has a limit on the number of open files, and the Db_files parameter setting of the database is limited by the parameters of the operating system.
Such an environment check error occurred during the SOLARIS10 installation of 12c:
Soft limit:maximum Open File Descriptors-this is a prerequisite condition to test whether the Soft Limit for "Maximum O Pen file descriptors "is set correctly.
Expected value:1024
Actual value:256
--View parameter limits:
bash-3.2# ulimit-a
Core file size (blocks,-c) Unlimited
Data seg Size (Kbytes,-D) Unlimited
File size (blocks,-f) Unlimited
open Files (-N)
Pipe Size (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#
# #建议使用第三种方法:
(1) Modify/etc/system parameters
This method is not recommended for use on SOLARIS10, but this approach is still valid.setting parameters in/etc/system is globally valid, that is, all users are affected. And after Setup, the system needs to be restarted to take effect.
The Setup method is to 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 (effective immediately, once the current shell exits the setting is invalidated)
The Ulimit command can only modify the settings of the current shell and its child processes, and it will take effect immediately, ' once the current shell exits the setting is invalidated. The-s parameter is used to set the soft limit, and the-H parameter sets the hard limit '.
Ulimit-s-N 65536
Ulimit-h-N 65536
The open files in the--ulimit command display a soft limit that can be displayed with the Prctl command, which 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.5k-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.0mb-deny 13110
Privileged 125TB Max Deny-
System 125TB Max Deny-
....
...
...
(3) use Project (Immediate, permanent)
Project is a new addition to SOLARIS10, and you can set parameter values for a user or group of users by setting the project parameter. Can take effect immediately after setup.
' However, the root user's results are only affected by the parameters in the/etc/system and are not affected by project user.oracle, and the root user does not belong to this project. ‘
The following are examples of settings:
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 user belongs 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::::p rocess.max-file-descriptor= (Basic,65534,deny), (Priv,65535,deny)
Set the basic and privilege values to 65534 and 65535, respectively, and not over the maximum hard limit of 65535 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 Unlimited
File (blocks) Unlimited Unlimited
Data (Kbytes) Unlimited Unlimited
Stack (Kbytes) 10240 Unlimited
Coredump (blocks) Unlimited Unlimited
Nofiles (descriptors) 256 65536
Vmemory (Kbytes) Unlimited Unlimited
bash-3.2#
The root user's results are only affected by the parameters in the/etc/system and are not affected by project user.oracle, and the 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 Unlimited
File (blocks) Unlimited Unlimited
Data (Kbytes) Unlimited Unlimited
Stack (Kbytes) 10240 Unlimited
Coredump (blocks) Unlimited Unlimited
Nofiles (descriptors) 65534 65535
Vmemory (Kbytes) Unlimited Unlimited
bash-3.2$
Encountered when installing Oracle 12c on SOLARIS10: Soft limit:maxmum Open File descriptors error
