红帽子 mysql 安装教程,红帽linux安装 orcle数据库步骤

  • Post author:
  • Post category:linux


linux系统安装虚拟机时 要求

swap:3G

tmp:4G

主盘30G

Oracle目前最新的版本是11g R2版本,网上不少安装介绍都是9i或者10g的,我按照介绍RHEL5.5上安装Oracle 11gR2总是有问题,之后看官方文档介绍了,在光盘的doc目录下有。

Oracle 11g R2数据库安装硬件配置要求:

最小内存 1 GB of RAM

虚拟内存容量

Oracle Database 11g Release 2 (11.2) for Linux x86:

Asianux 2.0

Asianux 3.0

Oracle Enterprise Linux 4.0 Update 7 or later

Oracle Enterprise Linux 5.0

Red Hat Enterprise Linux 4.0 Update 7 or later

Red Hat Enterprise Linux 5.0

SUSE Linux Enterprise Server 10.0

SUSE 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/bin

startx启动图形界面进入安装目录

配置图形界面

$ xhost fully_qualified_remote_host_name

$ xhost localhost

切换安装用户

su orcale

执行安装

./runInstaller

安装完毕后用root用户执行两个脚本

[root@c app]# /u01/app/oraInventory/orainstRoot.sh

更改权限/u01/app/oraInventory.

添加组的读取和写入权限。

删除全局的读取, 写入和执行权限。

更改组名/u01/app/oraInventory 到 oinstall.

脚本的执行已完成。[root@c app]# /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_2

Enter the full pathname of the local bin directory: [/usr/local/bin]:

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.

[root@c app]#