Oracle 11g R2数据库安装
Oracle目前最新的版本是11g R2版本,网上不少安装介绍都是9i或者10g的,我按照介绍RHEL5.5上安装Oracle 11gR2总是有问题,之后看官方文档介绍了,在光盘的doc目录下有。Oracle 11g R2数据库安装硬件配置要求:最小内存 1 GB of RAM虚拟内存容量Available RAM
Swap Space Required
Between 1 GB and 2 GB
1.5 times the size of RAM
Between 2 GB and 16 GB
Equal to the size of RAM
More than 16 GB
16 GB
硬盘空间要求
Installation Type
Requirement for Software Files (GB)
Enterprise Edition
3.95
Standard Edition
3.88
Installation Type
Requirement for Data Files (GB)
Enterprise Edition
1.7
Standard Edition
1.5
Oracle 11g R2数据库支持的操作系统Oracle Database 11g Release 2 (11.2) for Linux x86:Asianux 2.0Asianux 3.0Oracle Enterprise Linux 4.0 Update 7 or laterOracle Enterprise Linux 5.0Red Hat Enterprise Linux 4.0 Update 7 or laterRed Hat Enterprise Linux 5.0SUSE Linux Enterprise Server 10.0SUSE Linux Enterprise Server 11.0需要的软件包支持:这里只列出Asianux 3, Oracle Enterprise Linux 5.0, and Red Hat Enterprise Linux 5.0的要求,检查一下系统是否安装过这些包,没有的话在Redhat的光盘上都有。binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
elfutils-libelf-devel-static-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-common-2.5
glibc-devel-2.5
glibc-headers-2.5
kernel-headers-2.6.18
ksh-20060214
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.2
libgomp-4.1.2
libstdc++-4.1.2
libstdc++-devel-4.1.2
make-3.81
sysstat-7.0.2
unixODBC-2.2.11
unixODBC-devel-2.2.11创建Oracle用户The Oracle Inventory group (typically, oinstall)The OSDBA group (typically, dba)The Oracle software owner (typically, oracle)The OSOPER group (optional. Typically, oper)# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# /usr/sbin/useradd -g oinstall -G dba oracle
# passwd oracle修改内核参数修改 /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应用配置# /sbin/sysctl -p修改用户限制修改 /etc/security/limits.conf 文件,加上下面的参数oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536修改用户验证选项修改/etc/pam.d/login文件加上如下参数session required pam_limits.so修改用户配置文件修改/etc/profile文件加入如下参数:if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi安装目录配置# mkdir -p /u01/
# chown -R oracle: oinstall /u01/# chmod -R 775 /u01/修改用户bash shell$ vi .bash_profile增加export ORACLE_BASE=/u01/app
export ORACLE_HOME=$ORACLE_BASE/oracle
export ORACLE_SID=liusuping
export PATH=$ORACLE_HOME/bin: $PATH: $HOME/binstartx启动图形界面进入安装目录配置图形界面$ xhost fully_qualified_remote_host_name$ xhost localhost切换安装用户su orcale执行安装./runInstaller安装完毕后用root用户执行两个脚本# /u01/app/oraInventory/orainstRoot.sh
更改权限/u01/app/oraInventory.
添加组的读取和写入权限。
删除全局的读取, 写入和执行权限。更改组名/u01/app/oraInventory 到 oinstall.
脚本的执行已完成。# /u01/app/oracle/product/11.2.0/dbhome_2/root.sh
Running Oracle 11g root.sh script...The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_2Enter the full pathname of the local bin directory: :
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
#安装完毕
http://bbs.hh010.com/xwb/images/bgimg/icon_logo.png 该贴已经同步到 goodluck的微博 顶顶 学习了
页:
[1]