2021-10-16 oracle学习-准备环境（一）在centos7上安装oracle12c

最新推荐文章于 2024-05-15 01:11:35 发布

鹅一只

最新推荐文章于 2024-05-15 01:11:35 发布

阅读量392

点赞数

分类专栏： oracle学习-准备环境文章标签： oracle

本文链接：https://blog.csdn.net/x629242/article/details/120801333

版权

oracle学习-准备环境专栏收录该内容

3 篇文章 1 订阅

订阅专栏

一准备好软件

1 系统镜像

CentOS-7-x86_64-DVD-1708

2 数据库安装包

linux64_12201_database

3 虚拟机软件

VMware® Workstation 15 Pro

4 远程连接工具

MobaXterm_Personal_20.3

二配置虚拟机

1 安装好VMware

2 新建虚拟机

处理器：数量2、内核数量2

内存：8192MB

硬盘：80GB SCSI

网络适配器：仅主机模式

显示器：自动监测

CD/DVD驱动器：选择CentOS-7-x86_64-DVD-1708镜像

3 配置虚拟机网卡

在Windows10下-网络右击属性-更改适配器设置-VMnet1右击属性-Ipv4

ip地址： 192.168.16.10

子网掩码： 255.255.255.0

三安装centos7

1 启动虚拟机，进入安装向导

2 语音选择-选择continue

3 DATE & TIME

选择亚洲-上海 24小时制，时间改成现在的时间

4 SOFTWARE SELECTION

选择 Server with GUI

5 INSTALLATION DESTINATION

选择 I will 点击Done ，点击 + 号、挂载点/boot、大小500MB，再点击 + 号、交换分区swap、大小8192MB，再点击 + 号、挂载点/，不设置大小。

6 KDUMP

Enable 去勾

7 NETWORK & HOST NAME

Host name 设置为oracle，开启网卡、点击配置-General选项卡-勾选Auto IPv4选项卡-手动-192.168.16.66 掩码24

8 SECURITY POLICY

Apply 关闭

开始安装-自行配置好root密码和普通用户

等待安装完成

四安装远程软件MobaXterm_Personal_20.3

1 配置MobaXterm

打开后点击左上角的Session-SSH-Remote host输入192.168.16.66，

点击Specify username右边的头像-new

Name ：oracle12c

Username：root

Password：之前的密码

全部确定后勾选Specify username，下拉框选择oracle12c，点击OK

双击左边的ip地址就可以以root用户登录centos7

五配置centos7

1 配置/etc/hosts文件

vim /etc/hosts

192.168.16.66 oracle

2 关闭防火墙

systemctl stop firewalld
systemctl disable firewalld

3 关闭SElinux

vim /etc/selinux/config

7 SELINUX=disabled

4 配置软件仓库

1 新建仓库目录

mkdir /yums

2 进入光盘目录

cd /run/media/root/CentOS\ 7\ x86_64/Packages/

3 复制软件包到/yums目录

cp * /yums

4 安装依赖，创建yum源

cd /yums/
rpm -ivh deltarpm-3.6-3.el7.x86_64.rpm 
rpm -ivh python-deltarpm-3.6-3.el7.x86_64.rpm
rpm -ivh createrepo-0.9.9-28.el7.noarch.rpm
createrepo .

5 删除自带仓库

cd /etc/yum.repos.d/
rm -rf *

6 配置仓库

vim yum.local.repo

[local]
baseurl = file:///yums
gpgcheck = false
enabled = true
name = yum local repo

yum clean all

5 安装ORACLE先决条件的软件包

yum install -y bc
yum install -y compat-libcap1*
yum install -y compat-libcap*
yum install -y binutils 
yum install -y compat-libstdc++-33 
yum install -y elfutils-libelf 
yum install -y elfutils-libelf-devel 
yum install -y gcc 
yum install -y gcc-c++ 
yum install -y glibc-2.5 
yum install -y glibc-common 
yum install -y glibc-devel 
yum install -y glibc-headers 
yum install -y ksh libaio 
yum install -y libaio-devel 
yum install -y libgcc 
yum install -y libstdc++ 
yum install -y libstdc++-devel 
yum install -y make 
yum install -y sysstat 
yum install -y unixODBC 
yum install -y unixODBC-devel
yum install -y binutils*
yum install -y compat-libstdc*
yum install -y elfutils-libelf*
yum install -y gcc*
yum install -y glibc*
yum install -y ksh*
yum install -y libaio*
yum install -y libgcc*
yum install -y libstdc*
yum install -y make*
yum install -y sysstat*
yum install -y libXp*
yum install -y glibc-kernheaders
yum install -y net-tools-*

6 修改LINUX的内核文件

vim /etc/sysctl.conf

kernel.shmmax = 277495689510912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
fs.file-max = 6815744
kernel.shmall = 4294967296
net.ipv4.tcp_max_tw_buckets = 6000
net.ipv4.ip_local_port_range = 9000 65500
net.ipv4.tcp_tw_recycle = 0
net.ipv4.tcp_tw_reuse = 1
#net.core.somaxconn = 262144
net.core.netdev_max_backlog = 262144
net.ipv4.tcp_max_orphans = 262144
net.ipv4.tcp_max_syn_backlog = 262144
net.ipv4.tcp_synack_retries = 2
net.ipv4.tcp_syn_retries = 1
net.ipv4.tcp_fin_timeout = 1
net.ipv4.tcp_keepalive_time = 30
net.ipv4.tcp_keepalive_probes = 6
net.ipv4.tcp_keepalive_intvl = 5
net.ipv4.tcp_timestamps = 0
fs.aio-max-nr = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2

生成系统参数

sysctl -p

7 修改磁盘配额

vim /etc/security/limits.conf

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

8 限制使用进程数

vim /etc/pam.d/login

session required /lib/security/pam_limits.so
session required pam_limits.so

9 添加环境变量

vim /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

加载配置

source /etc/profile

10 创建文件目录和相应的用户

groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba,oper oracle

修改oracle用户密码

passwd oracle

11 配置ORACLE用户的环境变量

su - oracle
vim .bash_profile

export EDITOR=vi
export TMP=/tmp  
export TMPDIR=$TMP
export ORACLE_SID=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1
export INVENTORY_LOCATION=/u01/oraInventory
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin:$PATH:$HOME/bin
umask 022

加载配置

source .bash_profile

六安装oracle12c

1 上传oracle12c到/u01目录

在MobaXterm左边的路径里进入/u01/，点击第三个绿色的向上箭头，找到oracle12c的压缩包，点击打开，开始上传直到上传完成。

2 解压oracle12c压缩包

cd /u01
chown -R oracle:oinstall linuxx64_12201_database.zip
su - oracle
cd /u01
unzip linuxx64_12201_database.zip

3 将安装界面映射到Windows里

export DISPLAY=192.168.16.10:0.0
cd /u01/database/
./runInstaller

4 开始安装

I wish 去勾点击next
Install 选中点击next
Single 选中点击next
Enterprise 选中点击next
点击next
点击next
Database Operator 改成dba 点击next
点击Install

出现Execute Configuration窗口时将里面的两条脚本复制到linux里去分别执行

/u01/oraInventory/orainstRoot.sh
/u01/app/oracle/product/12.2.0/db_1/root.sh
连续三回车

完成后点击OK-Close

七配置监听器

export DISPLAY=192.168.16.10:0.0
su - oracle
netca

点击yes
点击next到出现finish点击finish为止

查看监听器安装情况

lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 17-OCT-2021 19:01:25

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                17-OCT-2021 19:01:21
Uptime                    0 days 0 hr. 0 min. 4 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

大功告成

鹅一只

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
打赏
0
评论
2021-10-16 oracle学习-准备环境（一）在centos7上安装oracle12c

一准备好软件1 系统镜像CentOS-7-x86_64-DVD-17082 数据库安装包linux64_12201_database3 虚拟机软件VMware® Workstation 15 Pro4 远程连接工具MobaXterm_Personal_20.3二配置虚拟机1 安装好VMware2 新建虚拟机处理器：数量2、内核数量2内存：8192MB硬盘：80GB SCSI网络适配器：仅主机模式显示器：自动监测CD/DVD驱动器
复制链接

扫一扫