Oracle 安装前准备

[root@localhost Desktop]# groupadd -g 110 oinstall 用来安装oracle软件
[root@localhost Desktop]# groupadd -g 111 dba 数据库维护管理
[root@localhost Desktop]# groupadd -g 112 asmadmin
[root@localhost Desktop]# groupadd -g 114 asmdba
[root@localhost Desktop]# groupadd -g 115 asmoper
 
 
useradd -g oinstall -G dba,asmdba oracle
passwd oracle
 
useradd -g oinstall -G dba,asmdba,asmadmin,asmoper grid
passwd grid
 
 
[root@localhost Desktop]# su - grid
[grid@localhost ~]$ vi .bash_profile
 
 
export ORACLE_BASE=/u01/oracle
export GRID_HOME=/u01/grid/11g
export ORACLE_HOME=$GRID_HOME
export ORACLE_SID=+ASM
PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
 
[root@localhost Desktop]# su - oracle
[oracle@localhost ~]$ vi .bash_profile
export ORACLE_BASE=/u01/oracle
export DB_HOME=/u01/oracle/11g
export ORACLE_HOME=$DB_HOME
export ORACLE_SID=updb
PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
 
 
 
[root@localhost Desktop]# mkdir /u01/oracle/11g -p
[root@localhost Desktop]# mkdir /u01/grid/11g -p
[root@localhost Desktop]# mkdir /u01/oraInventory -p
[root@localhost Desktop]# chown grid.oinstall /u01/ -R
[root@localhost Desktop]# chown oracle.oinstall /u01/oracle/ -R
 
 
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 = 1048576
 
 
 
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
oracle hard stack 32768
 
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
grid hard stack 32768
 
 
 
[root@localhost Desktop]# vi /etc/sysconfig/ntpd
# Drop root to id ‘ntp:ntp‘ by default.
OPTIONS="-u ntp:ntp -p /var/run/ntpd.pid -g"
OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"
[root@localhost Desktop]# /etc/init.d/ntpd restart
Shutting down ntpd: [FAILED]
Starting ntpd: [ OK ]
[root@localhost Desktop]# chkconfig ntpd on
 
 
 
 
 
 
 

Oracle 安装前准备

上一篇:SQL Server与MySQL数据库对比


下一篇:两种读取微信xml消息的方式比较