1.CentOS7 Oracle 11g 需要安装的依赖包
binutils-2.23.52.0.1-12.el7.x86_64
compat-libcap1-1.10-3.el7.x86_64
compat-libstdc++-33-3.2.3-71.el7.i686
compat-libstdc++-33-3.2.3-71.el7.x86_64
gcc-4.8.2-3.el7.x86_64
gcc-c++-4.8.2-3.el7.x86_64
glibc-2.17-36.el7.i686
glibc-2.17-36.el7.x86_64
glibc-devel-2.17-36.el7.i686
glibc-devel-2.17-36.el7.x86_64
ksh
libaio-0.3.109-9.el7.i686
libaio-0.3.109-9.el7.x86_64
libaio-devel-0.3.109-9.el7.i686
libaio-devel-0.3.109-9.el7.x86_64
libgcc-4.8.2-3.el7.i686
libgcc-4.8.2-3.el7.x86_64
libstdc++-4.8.2-3.el7.i686
libstdc++-4.8.2-3.el7.x86_64
libstdc++-devel-4.8.2-3.el7.i686
libstdc++-devel-4.8.2-3.el7.x86_64
libXi-1.7.2-1.el7.i686
libXi-1.7.2-1.el7.x86_64
libXtst-1.2.2-1.el7.i686
libXtst-1.2.2-1.el7.x86_64
make-3.82-19.el7.x86_64
sysstat-10.1.5-1.el7.x86_64
unixODBC-2.3.1-6.el7.x86_64 or later
unixODBC-2.3.1-6.el7.i686 or later
unixODBC-devel-2.3.1-6.el7.x86_64 or later
unixODBC-devel-2.3.1-6.el7.i686 or later
2.创建用户组和对应用户
groupadd oinstall
groupadd dba
groupadd oper
useradd -u -g oinstall -G dba,oper oracle
passwd oracle
3.内核参数配置 vi /ect/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
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 = 1048576
使参数生效
sysctl -p
4.安装目录创建
mkdir /u01/app/oracle
mkdir /u01/app/oraInventory
5.修改目录权限
chown -R oracle:oinstall /u01/app/
chmod -R 775 /u01/app/oracle
6.修改Oracle用户设置限制 vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
7.配置用户环境变量
export ORACLE_BASE=/u01/app/
export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/db_1
export ORACLE_SID=qijin
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LANG=C #防止安装过程出现乱码
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK #设置Oracle客户端字符集，必须与Oracle安装时设置的字符集保持一致
8.修改操作系统运行级别
systemctl set-default graphical.target
systemctl set-default multi-user.target
9.上传安装介质
10.开启操作系统图形界面
11.安装lightdm 配置XDMCPServer
yum install epel-release
yum install lightdm
yum groups mark convert "X Window system"
yum groups mark convert "MATE Desktop"
yum groupinstall "X Window system"
yum groupinstall "MATE Desktop"
vi /etc/lightdm/lightdm.conf
[XDMCPServer]
enabled=ture
port=177
systemctl start lightdm
firewall-cmd --zone=public --permanent --add-port=177/udp
12.登录图形界面后用Installer安装数据库
用oracle 用户登录
配置监听端口：1523
修改默认监听端口后需要手动注册监听
a.在tnsnames.ora 文件中指定pmon动态注册监听的目标端口
listener_alias =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.130)(PORT = 1523))
)
b. 修改参数local_listener
alter system set local_listener=listener_alias;
alter system register;
13.创建数据库表空间
create tablespace odsspace datafile '/u01/app/oracle/oradata/qijin/odsspace01.dbf' size 32700M;
create tablespace dwspace datafile '/u01/app/oracle/oradata/qijin/dwspace01.dbf' size 32700M;
create tablespace dmspace datafile '/u01/app/oracle/oradata/qijin/dmspace01.dbf' size 32700M;
14.创建数据库用户，指定默认表空间,给定权限
create user ods identified by xxx default tablespace odsspace;
create user dw identified by xxx default tablespace dwspace;
create user dm identified by xxx default tablespace dmspace;
grant connect,resource to ods;
grant connect,resource to dm;
grant connect,resource,dba to dw;
15.install client
调整防火墙策略
firewall-cmd --zone=public --permanent --add-port=1523/tcp
firewall-cmd --list-ports --permanent
firewall-cmd --reload
systemctl restart firewalld
