setup 11 (4)

3 建立oracle組及用戶

我們建立兩個組：dba和oper,一個用戶:oracle

[root@PLSFCWEBDB /]# groupadd dba

[root@PLSFCWEBDB /]# groupadd oper

[root@PLSFCWEBDB /]# useradd –g dba –G oper oracle

[root@PLSFCWEBDB /]# id oracle

uid=500(oracle) gid=500(dba) groups=500(dba),501(oper)

[root@PLSFCWEBDB /]# passwd oracle

Changing password for user oracle.

New UNIX password:

Retype new UNIX password:

passwd: all authentication tokens updated successfully.

[root@PLSFCWEBDB /]#chown oracle.dba /u01 /data /data1 –R

[root@PLSFCWEBDB /]#chmod 755 /u01 /data /data1 –R

[root@PLSFCWEBDB /]#su – oracle

[oracle@PLSFCWEBDB ~]$ cd /u01/

[oracle@PLSFCWEBDB u01]$ ll

total 20

drwxrwxr-x 2 oracle dba 16384 Oct 28 11:09 lost+found

drwxrwxr-x 4 oracle dba  4096 Nov  3 07:55 packages

[oracle@PLSFCWEBDB u01]$ mkdir product

我們要把oracle安裝在/u01/product下，安裝文件存放在/u01/packages下麵。

 

４核心參數修改

[root@PLSFCWEBDB /]# vi /etc/sysctl.conf

加入下面幾行

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

 

sysctl –p 使用修改生效。

 

[root@PLSFCWEBDB /]# sysctl -p

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 4182161408

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

 

[root@PLSFCWEBDB /]# vi /etc/security/limits.conf

加入下面幾行：

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25072296/viewspace-697394/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25072296/viewspace-697394/