Oracle手动安装数据库

Oracle手动安装数据库

2019年8月21日18:55

Oracle手动安装数据库

1安装rpm包

挂载iso镜像

mount loop -p -t iso9660 /光盘路径/挂载路径到/etc/yum.repo.d文件夹下新建新repo

vi package.repo

[yum名称]

name = Instructor Server Repository

baseurl=file://路径

enabled=1

gpgcheck=0

依赖包为

yum -y install

gcc

gcc-c++

make

binutils

compat-libstdc++-33

elfutils-libelf

elfutils-libelf-devel

elfutils-libelf-devel-static

glibc

glibc-common

glibc-devel ksh

libaio

libaio-devel

libgcc

libstdc++

libstdc++-devel

numactl-devel

sysstat

unixODBC

unixODBC-devel

kernelheaders

pdksh

pdksh

pcre-devel

readline

rlwrap

2建立用户和组

groupadd oinstall

groupadd oper

groupadd dba

useradd -g oinstall -G dba oracle

passwd oracle

3新建目录

mkdir -p /u01/app/oracle

chmod 775 -R /u01

chown -R oracle:oinstall /u01

mkdir /oradata

chmod 775 /oradata

chown oracle:oinstall /oradata/

4修改/etc/sysctl.conf

vi /etc/sysctl.conf（root）

fs.file-max = 6815744

kernel.sem = 250 32000 100 128 kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

net.ipv4.conf.all.rp_filter = 2

net.ipv4.conf.default.rp_filter = 2

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500 sysctl -p 执行生效

5修改/etc/security/limits.conf

vi /etc/security/limits.conf（root）oracle soft nofile 1024

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft stack 10240

oracle hard stack 32768

oracle hard memlock 134217728

oracle soft memlock 134217728

6配置解析文件/etc/hosts

vi /etc/hosts

IP hostname

7修改环境变量

vi ~/.bash_profile (oracle)

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0

export ORACLE_SID=sid

export PATH=$PATH:/u01/app/oracle/product/11.2.0/bin

source .bash_profile 生效

8上传软件并解压

9静默安装数据库软件

在/database/response/下修改db_install.rsp文件,不清楚的选项可以为空，选默认

vi db_install.rsp

[root@db response]# cat db_install.rsp | grep -v '^#' | grep -v '^$'

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_s chema_v11_2_0

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=db

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/var/app/oracle/oraInventory

SELECTED_LANGUAGES=en,zh_CN

ORACLE_HOME=/var/app/oracle/product/11.2.0/dbhome_1

ORACLE_BASE=/var/app/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.isCustomInstall=false

oracle.install.db.customComponents=oracle.server:11.2.0.1.0,