千家信息网

red hat6.1 部署32位 oracle 11g

发表于:2025-02-01 作者:千家信息网编辑
千家信息网最后更新 2025年02月01日,检查系统环境:[root@localhost ~]# grep MemTotal /proc/meminfo #物理内存不低于1GBMemTotal: 1491520 kB[root@localhos
千家信息网最后更新 2025年02月01日red hat6.1 部署32位 oracle 11g

检查系统环境:

[root@localhost ~]# grep MemTotal /proc/meminfo #物理内存不低于1GB

MemTotal: 1491520 kB

[root@localhost ~]# grep SwapTotal /proc/meminfo #交换分区为物理内存的1.5-2陪;物理内存为2-16GB时,交换分区与物理内存相同

SwapTotal: 2097148 kB


安装oracle依赖软件:

yum install -y binutils compat-libcap1-1.10-1 compat-libstdc++-33 gcc gcc-c++ glibc glibc glibc-devel glibc-devel ksh libgcc libgcc libstdc++ libstdc++ libstdc++-devel libstdc++-devel libaio libaio libaio-devel libaio-devel make sysstat elftils-libelf unixODBC unixODBC unixODBC-devel elfutils-libelf elfutils-libelf-devel


修改系统环境:

groupadd oinstallgroupadd dbauseradd -g oinstall -G dba oracleecho "qwe123"| passwd root --stdinmkdir /opt/oraclechown -R oracle:oinstall /opt/oracle/chmod -R 755 /opt/oracle/[root@localhost ~]# vim ~oracle/.bash_profileumask 022export ORACLE_BASE=/opt/oracleexport ORACLE_SID=/orc1export DISPLAY=:0.0export LANG=zh_CN.UTF-8[root@localhost ~]# vim /etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000  65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default =  262144net.core.wmem_max = 1048586[root@localhost ~]# vim /etc/security/limits.conforacle        soft    nproc           8192oracle        hard    nofile           65536oracle       soft    nofile          32768oracle       hard    nproc         16384[root@localhost ~]# xhost +[root@localhost ~]# su oracle[oracle@localhost root]$ cd /opt/oracle/database/[oracle@localhost database]$ ./runInstaller -jreLoc /usr/lib/jvm/jre-1.6.0


图形界面安装:

1.看到安装界面,"yes"再下一步就行了。


2.创建并配置一个数据库

3.选择服务器类型4.单实例安装

5.这里我选择"典型安装"


8.配置密码和安装路径

9.自动检查环境参数和安装


安装完成以后提示用root初始化:

添加oracle的路径:

[root@localhost ~]# vim ~oracle/.bash_profile

export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1/

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

[root@localhost bin]# dbstart /home/oracle/app/oracle/product/11.2.0/dbhome_1/


进入数据库:

[root@localhost bin]# su oracle

[oracle@localhost bin]$ sqlplus sys/Benet4.0 AS SYSDBA


SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 30 19:46:37 2014


Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to an idle instance.


SQL>


0