Centos 7 安装 oracle11G

1 网络不通时，增加 nameserver , 然后重启。

vi /etc/resolv.conf

增加

nameserver 114.114.114.114

service network restart

2 安装依赖包

2.1 先安装pdksh
centos7没有相关安装包可用，可下载pdksh的rpm包

wget  http://vault.centos.org/5.11/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpm
rpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm

2.2 安装其他依赖

yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel expat gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++-devel make pdksh sysstat unixODBC unixODBC-devel

2.3 检查所有依赖是否安装完整

rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel expat gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++-devel make pdksh sysstat unixODBC unixODBC-devel | grep "not installed"

3、添加oracle用户组和用户

groupadd oinstall
groupadd dba
groupadd asmadmin
groupadd asmdba
useradd -g oinstall -G dba,asmdba oracle -d /home/oracle

查看oracle用户

id oracle

为oracle 用户设置密码

passwd oracle      密码

4、优化系统内核

vim /etc/sysctl.conf

net.ipv4.ip_local_port_range = 9000 65500
fs.file-max = 6815744
kernel.shmall = 10523004
kernel.shmmax = 6465333657  ---其中kernel.shmmax为内存的一半，比如内存为4G，则      kernel.shmmax=210241024*1024=2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=1048576
fs.aio-max-nr = 1048576

使参数生效

sysctl -p

5.限制oracle用户的shell权限

vim /etc/security/limits.conf
oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  1024
oracle              hard    nofile  65536

6、创建oracle相关目录

mkdir /data/apps/oracle/product/11.2.0
mkdir /data/apps/oracle/oradata
mkdir /data/apps/oracle/inventory
mkdir /data/apps/oracle/fast_recovery_area
chown -R oracle:oinstall /data/apps/oracle
chmod -R 775 /data/apps/oracle
mkdir -p /home/oracle/apps/inventory
chown -R oracle:oinstall /home/oracle/apps/inventory

7、配置oracle用户环境变量 vi /home/oracle/.bash_profile (51文件位置)

切换用户

su oracle
vim /home/oracle/.bash_profile

填加环境变量

export ORACLE_SID=orclzjy
export ORACLE_HOME=/data/apps/oracle/product/11.2.0
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/.local/bin:$HOME/bin

使环境变量生效

source /home/oracle/.bash_profile

8、解压安装包
如果安装包在root用户下，现切换到root用户

unzip p13390677_112040_Linux-x86-64_1of7.zip -d /data
unzip p13390677_112040_Linux-x86-64_2of7.zip -d /data
unzip p13390677_112040_Linux-x86-64_3of7.zip -d /data

然后执行

mkdir -p /data/etc/

cp /data/database/response/* /data/etc
vim /db/etc/db_install.rsp

修改如下信息

oracle.install.option=INSTALL_DB_SWONLY
DECLINE_SECURITY_UPDATES=true
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/home/oracle/apps/inventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/data/apps/oracle/product/11.2.0
ORACLE_BASE=/data/apps/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba

9 安装
先切换到oracle

su oracle
cd /data/database

./runInstaller -silent -ignorePrereq -responseFile /data/etc/db_install.rsp

切换 su

sh /home/oracle/apps/inventory/orainstRoot.sh
sh /data/apps/oracle/product/11.2.0/root.sh

10配置静默监听 如不执行，重新刷新source

su oracle

netca /silent /responsefile /data/etc/netca.rsp

查看监听端口

 netstat -tnulp | grep 1521

12、静默创建数据库

vim /data/etc/dbca.rsp
GDBNAME = "orcl"
SID = "orcl"
SYSPASSWORD = "syspwd"
SYSTEMPASSWORD = "systempwd"
SYSMANPASSWORD = "sysmanpwd"
DBSNMPPASSWORD = "dbsnpwd"
DATAFILEDESTINATION =/data/apps/oracle/oradata
RECOVERYAREADESTINATION=/data/apps/oracle/fast_recovery_area
CHARACTERSET = "AL32UTF8"
TOTALMEMORY = "9830"

注：其中TOTALMEMORY 设置为总内存的80%（410240.8）

在root用户下执行(如果没有权限)

chown -R oracle:oinstall /data/etc/dbca.rsp

执行静默建库 切换 oracle 用户

dbca -silent -responseFile /data/etc/dbca.rsp

13、创建用户供远程连接
开放1521端口

firewall-cmd --zone=public --add-port=1521/tcp --permanent
firewall-cmd --reload

14、登录到oracle，测试

sqlplus / as sysdba
select status from v$instance;

create user zuser identified by zpwd
grant dba to zuser;