[Root @ qs-xezf-db2 ~] # Su-Oracle
-Bash: ulimit: open files: cannot modify limit: The operation is not allowed.
[Oracle @ qs-xezf-db2 ~] $
Linux has default ulimit restrictions on users. The/etc/sysconfig/limits. conf file can be used to configure users' hard configurations and soft configurations. Hard configurations are limited. When the modification exceeds the upper limit, an error such as "operation not allowed" will occur.
This is the recommended value on the Oracle official website. It is set to the following value. It will be OK after login.
[Oracle @ qs-xezf-db2 ~] $ CAT/etc/sysconfig/limits. conf
Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
[Root @ qs-xezf-db1 ~] # Su-Oracle
[Oracle @ qs-xezf-db1 ~] $
Oracle official website address:
Http://download.oracle.com/docs/cd/B19306_01/install.102/b15667/pre_install.htm#CIHFICFD
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Online Resources: http://tianlesoftware.download.csdn.net
Video: http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Dba1 group: 62697716 (full); dba2 group: 62697977 (full)
Dba3 group: 62697850 super DBA group: 63306533;
Chat group: 40132017
-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.