Shulou(Shulou.com)06/01 Report--

1. Check the memory condition

two。 Check the swap situation

3. View disk space

4./tmp directory space is larger than 400MB

1. Create a user group

two。 Create a user

3. Set a password for oracle users

# mkdir-p / u01/app/oracle/product/11.2.0/db_1

# chown-R oracle:dba / u01/app # #-R: specify this file and subordinate files

(1) vi / etc/sysctl.conf

Fs.file-max = 6815744 # # the maximum number of file handles a process can open

Kernel.shmmni = 4096 # # maximum number of shared memory segments

Kernel.sem = 250100128 # # semaphore set by 32000

Net.core.rmem_default = 262144 # # default receive buffer size

Net.core.wmem_default = 262144 # # default send buffer size

(2) after modification: the sysctl-p setting takes effect.

two。 Configure resource usage

Oracle soft nproc 2047

Oracle soft nofile 1024

# su-oracle

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

Export ORACLE_SID = test

4.OS kernel parameter:shmmax

Dealing with problems where process restrictions are not met (root) # vi / etc/profile

...

If [$USER = "oracle"] | | [$USER = "grid"]; then

If [$SHELL = "/ bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi...

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.