oracle学习笔记

1040阅读 0评论2014-06-15 周士昆
分类:系统运维

实验一,安装oracle数据库

步骤蛮麻烦的!有点恶心```````````````````

环境:有一个10201_database_linux32.zip压缩文件,安装一个新的操作系统。

1root用户检查操作系统安装包,如有缺失请安装

rpm -q binutils compat-db control-center gcc gcc-c++ glibc libXp-1.0.0 libstdc++ libstdc++-devel make openmotif

提示一个软件包没装哈~~我们把它装上,用rpm装上,上图是我在装了两个软件包之后的截图,所以只需要装一个就OK了!

2root用户设置核心参数,在这里修改kernel.shmmax参数即可
/etc/sysctl.conf文件中加入下列行,有就不用添加了,
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
ne t.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144

3root用户运行下列命令使其上述修改生效:

sysctl –p

4root用户在/etc/security/limits.conf文件中加入下列行:
soft    nproc   2047

hard    nproc   16384

soft    nofile  1024
hard    nofile  65536

5root用户在/etc/pam.d/login文件下方加入下列行,如果里面没有的话:在最后一行添加即可
session    required     /lib/security/pam_limits.so

 

 

6root用户创建用户和修改环境变量:
groupadd oinstall                   /
创建组用户/
groupadd dba                      /
创建组用户/
useradd -g oinstall -G dba oracle       /
创建用户,并设定用户组/
passwd oracle                             /
设定oracle用户的密码/linux需要强密码,密码自己记得哈!

oracle登陆进操作系统,编辑.bash_profile文件(.bash_profile文件为隐藏文件,其位

置在/home/oracle/.bash_profile
.bash_profile文件下方添加如下内容:

ORACLE_BASE=/oracle/app

ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      &nbs

上一篇:shell脚步
下一篇:shell