城乡住房建设厅网站,网站建设技术论坛,做网站需要什么框架,做实体店打折信息网站#x1f4e2;#x1f4e2;#x1f4e2;#x1f4e3;#x1f4e3;#x1f4e3; 哈喽#xff01;大家好#xff0c;我是【IT邦德】#xff0c;江湖人称jeames007#xff0c;10余年DBA及大数据工作经验 一位上进心十足的【大数据领域博主】#xff01;#x1f61c; 哈喽大家好我是【IT邦德】江湖人称jeames00710余年DBA及大数据工作经验 一位上进心十足的【大数据领域博主】 中国DBA联盟(ACDU)成员目前服务于工业互联网 擅长主流Oracle、MySQL、PG、高斯及Greenplum运维开发备份恢复安装迁移性能优化、故障应急处理等。 ✨ 如果有对【数据库】感兴趣的【小可爱】欢迎关注【IT邦德】 ❤️❤️❤️感谢各位大可爱小可爱❤️❤️❤️ 文章目录 前言 1.环境准备 2.yum安装依赖✨ 2.1 yum源的配置✨ 2.2 安装依赖 3. database-preinstall 4.目录及权限设置 5.环境变量 6.上传oracle安装包 7.创建GI用户 8.GI资源配置 9.绑定共享磁盘 10.创建GI目录 11.配置GI环境变量 12.上传GI安装包 13.安装 cvuqdisk 14.安装GI14.ASM创建磁盘组15.安装Oracle软件16.DBCA建库17.日常管理 前言 本文祥细阐述了ASM管理Oracle 19C单实例部署 1.环境准备
通过虚拟机克隆来提供部署需要OEL7.9的操作系统1.1 环境检查
[rootoel79 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.9 (Maipo)
[rootoel79 ~]# cat /etc/oracle-release
Oracle Linux Server release 7.9
[rootoel79 ~]# df -TH
Filesystem Type Size Used Avail Use% Mounted on
devtmpfs devtmpfs 4.3G 0 4.3G 0% /dev
tmpfs tmpfs 4.4G 0 4.4G 0% /dev/shm
tmpfs tmpfs 4.4G 11M 4.4G 1% /run
tmpfs tmpfs 4.4G 0 4.4G 0% /sys/fs/cgroup
/dev/mapper/ol-root ext4 43G 4.4G 36G 11% /
/dev/sda1 ext4 1.1G 213M 741M 23% /boot
/dev/mapper/ol-u01 ext4 52G 55M 49G 1% /u01
tmpfs tmpfs 864M 29k 864M 1% /run/user/0
/dev/sr0 iso9660 4.9G 4.9G 0 100% /run/media/root/OL-7.9 Server.x86_64
[rootoel79 ~]# free -mtotal used free shared buff/cache available
Mem: 8238 634 6916 15 687 7338
Swap: 10239 0 10239
[rootoel79 ~]# free -gtotal used free shared buff/cache available
Mem: 8 0 6 0 0 7
Swap: 9 0 9
[rootoel79 ~]#
[rootoel79 ~]#
[rootoel79 ~]# ifconfig
ens33: flags4163UP,BROADCAST,RUNNING,MULTICAST mtu 1500inet 192.168.6.20 netmask 255.255.255.0 broadcast 192.168.6.255inet6 fe80::e08:b228:bbf4:4168 prefixlen 64 scopeid 0x20linkether 00:0c:29:6b:eb:f4 txqueuelen 1000 (Ethernet)RX packets 291 bytes 28044 (27.3 KiB)RX errors 0 dropped 0 overruns 0 frame 0TX packets 260 bytes 40332 (39.3 KiB)TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0lo: flags73UP,LOOPBACK,RUNNING mtu 65536inet 127.0.0.1 netmask 255.0.0.0inet6 ::1 prefixlen 128 scopeid 0x10hostloop txqueuelen 1000 (Local Loopback)RX packets 176 bytes 13512 (13.1 KiB)RX errors 0 dropped 0 overruns 0 frame 0TX packets 176 bytes 13512 (13.1 KiB)TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0virbr0: flags4099UP,BROADCAST,MULTICAST mtu 1500inet 192.168.122.1 netmask 255.255.255.0 broadcast 192.168.122.255ether 52:54:00:d9:8d:56 txqueuelen 1000 (Ethernet)RX packets 0 bytes 0 (0.0 B)RX errors 0 dropped 0 overruns 0 frame 0TX packets 0 bytes 0 (0.0 B)TX errors 0 dropped 0 overruns 0 carrier 0 collisions 01.2 挂存储
把新添加的磁盘虚拟设备节点改成从 1 0 开始,第二个磁盘就是 1 1 重复添加磁盘的操作 20G 一个、 0.5G 七个。##打开虚拟机的配置文件.vmx,将以下内容粘贴进去scsi1:0.deviceType disk
scsi1:1.deviceType disk
scsi1:2.deviceType disk
scsi1:3.deviceType disk
scsi1:4.deviceType disk
scsi1:5.deviceType disk
scsi1:6.deviceType disk
scsi1:8.deviceType disk
disk.locking FALSE
diskLib.dataCacheMaxSize 0
diskLib.dataCacheMaxReadAheadSize 0
diskLib.DataCacheMinReadAheadSize 0
diskLib.dataCachePageSize 4096
diskLib.maxUnsyncedWrites 0
disk.EnableUUIDTRUE[rootoel79 ~]# fdisk -l | grep dev
Disk /dev/sda: 107.4 GB, 107374182400 bytes, 209715200 sectors
/dev/sda1 * 2048 2099199 1048576 83 Linux
/dev/sda2 2099200 209715199 103808000 8e Linux LVM
Disk /dev/sdg: 536 MB, 536870912 bytes, 1048576 sectors
Disk /dev/sdc: 536 MB, 536870912 bytes, 1048576 sectors
Disk /dev/sdb: 21.5 GB, 21474836480 bytes, 41943040 sectors
Disk /dev/sdd: 536 MB, 536870912 bytes, 1048576 sectors
Disk /dev/sdf: 536 MB, 536870912 bytes, 1048576 sectors
Disk /dev/sde: 536 MB, 536870912 bytes, 1048576 sectors
Disk /dev/sdi: 536 MB, 536870912 bytes, 1048576 sectors
Disk /dev/sdh: 536 MB, 536870912 bytes, 1048576 sectors
Disk /dev/mapper/ol-root: 42.9 GB, 42949672960 bytes, 83886080 sectors
Disk /dev/mapper/ol-swap: 10.7 GB, 10737418240 bytes, 20971520 sectors
Disk /dev/mapper/ol-u01: 52.6 GB, 52609155072 bytes, 102752256 sectors1.3 关闭防火墙
[rootoel79 ~]# systemctl status firewalld.service
[rootoel79 ~]# systemctl stop firewalld.service
[rootoel79 ~]# systemctl disable firewalld.service1.4 关闭selinx的安全服务
[rootoel79 ~]# cat /etc/selinux/config
修改SELINUXenforcing为SELINUXdisabled1.5 host解析
[rootoel79 ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
##新增以下内容
192.168.6.20 oel792.yum安装依赖
✨ 2.1 yum源的配置
[rootoel79 ~]# vi /etc/yum.repos.d/local.repo[server]
nameLinux
baseurlfile:///run/media/root/OL-7.9%20Server.x86_64
enabled1
gpgcheck0✨ 2.2 安装依赖
[rootoel79 ~]# yum install compat-libcap1 ksh libaio-devel glibc-devel libstdc-devel -y3. database-preinstall
## root用户下执行
[rootoel79 opt]# rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
warning: oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ################################# [100%]
Updating / installing...1:oracle-database-preinstall-19c-1.################################# [100%]该 rpm会创建oracle用户、相关用户组、以及配置系统的参数
如 /etc/security/limits.d/oracle-database-preinstall-19c.conf## 设置 oracle 口令
echo oracle | passwd --stdin oracle4.目录及权限设置
##创建目录
mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/
chown -R oracle:oinstall /u01
chmod -R 775 /u015.环境变量
## 以下内容oracle用户下执行su - oraclevi .bash_profile
export ORACLE_SIDprod
export ORACLE_BASE/u01/app/oracle
export ORACLE_HOME$ORACLE_BASE/product/19.0.0/dbhome_1
export PATH$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export CLASSPATH$ORACLE_HOME/JRE:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib##环境变量生效
source .bash_profile6.上传oracle安装包
注软件包上传到 ORACLE_HOME 目录oracle 用户解压## 校验密钥
[rootoel79 opt]# sha256sum LINUX.X64_193000_db_home.zip
ba8329c757133da313ed3b6d7f86c5ac42cd9970a28bf2e6233f3235233aa8d8 LINUX.X64_193000_db_home.zip[oracleoel79 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/19.0.0/dbhome_1chown oracle:oinstall -R LINUX.X64_193000_db_home.zip
chmod 755 -R LINUX.X64_193000_db_home.zip
unzip LINUX.X64_193000_db_home.zip7.创建GI用户
## 添加组
/usr/sbin/groupadd -g 1020 asmadmin
/usr/sbin/groupadd -g 1021 asmdba
/usr/sbin/groupadd -g 1022 asmoper## 添加grid用户
/usr/sbin/useradd -u 1102 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,asmoper,asmadmin,racdba grid## 改密码
echo grid | passwd --stdin grid## 修改oracle用户
usermod -g oinstall -G dba,asmadmin,asmdba,asmoper,backupdba,dgdba,kmdba,oper,racdba oracle8.GI资源配置
编辑资源配置在最后一行里面增加
vi /etc/security/limits.conf
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
grid hard stack 327689.绑定共享磁盘
[rootoel79 ~]# ls -l /dev/sd*
brw-rw----. 1 root disk 8, 0 Sep 3 09:55 /dev/sda
brw-rw----. 1 root disk 8, 1 Sep 3 09:55 /dev/sda1
brw-rw----. 1 root disk 8, 2 Sep 3 09:55 /dev/sda2
brw-rw----. 1 root disk 8, 16 Sep 3 09:55 /dev/sdb
brw-rw----. 1 root disk 8, 32 Sep 3 09:55 /dev/sdc
brw-rw----. 1 root disk 8, 48 Sep 3 09:55 /dev/sdd
brw-rw----. 1 root disk 8, 64 Sep 3 09:55 /dev/sde
brw-rw----. 1 root disk 8, 80 Sep 3 09:55 /dev/sdf
brw-rw----. 1 root disk 8, 96 Sep 3 09:55 /dev/sdg
brw-rw----. 1 root disk 8, 112 Sep 3 09:55 /dev/sdh
brw-rw----. 1 root disk 8, 128 Sep 3 09:55 /dev/sdifor i in b c d e f g h i; do echo KERNEL\sd*[!0-9]\,ENV{DEVTYPE}\disk\,SUBSYSTEM\block\,PROGRAM\/usr/lib/udev/scsi_id -g -u -d\$devnode\,RESULT\/lib/udev/scsi_id --whitelisted --replace-whitespace --device/dev/sd$i\, SYMLINK\asm-disk$i\, OWNER\grid\, GROUP\asmadmin\,MODE\0660\ /etc/udev/rules.d/99-oracle-asmdevices.rules; done;[rootoel79 ~]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNELsd*[!0-9],ENV{DEVTYPE}disk,SUBSYSTEMblock,PROGRAM/usr/lib/udev/scsi_id -g -u -d$devnode,RESULT36000c29653e86c5f015ab3d2e7e9bbae, SYMLINKasm-diskb, OWNERgrid, GROUPasmadmin,MODE0660
KERNELsd*[!0-9],ENV{DEVTYPE}disk,SUBSYSTEMblock,PROGRAM/usr/lib/udev/scsi_id -g -u -d$devnode,RESULT36000c29a052769eb43d01664ca55a894, SYMLINKasm-diskc, OWNERgrid, GROUPasmadmin,MODE0660
KERNELsd*[!0-9],ENV{DEVTYPE}disk,SUBSYSTEMblock,PROGRAM/usr/lib/udev/scsi_id -g -u -d$devnode,RESULT36000c29c19465340359f4408bd2a4dff, SYMLINKasm-diskd, OWNERgrid, GROUPasmadmin,MODE0660
KERNELsd*[!0-9],ENV{DEVTYPE}disk,SUBSYSTEMblock,PROGRAM/usr/lib/udev/scsi_id -g -u -d$devnode,RESULT36000c2906dc37bda2eb23b86b441831e, SYMLINKasm-diske, OWNERgrid, GROUPasmadmin,MODE0660
KERNELsd*[!0-9],ENV{DEVTYPE}disk,SUBSYSTEMblock,PROGRAM/usr/lib/udev/scsi_id -g -u -d$devnode,RESULT36000c29b6a9e99f76a60e4c1e2c47838, SYMLINKasm-diskf, OWNERgrid, GROUPasmadmin,MODE0660
KERNELsd*[!0-9],ENV{DEVTYPE}disk,SUBSYSTEMblock,PROGRAM/usr/lib/udev/scsi_id -g -u -d$devnode,RESULT36000c29b39f1155952c12d89c5823467, SYMLINKasm-diskg, OWNERgrid, GROUPasmadmin,MODE0660
KERNELsd*[!0-9],ENV{DEVTYPE}disk,SUBSYSTEMblock,PROGRAM/usr/lib/udev/scsi_id -g -u -d$devnode,RESULT36000c297eb5d57761da1c873da5cc8e4, SYMLINKasm-diskh, OWNERgrid, GROUPasmadmin,MODE0660
KERNELsd*[!0-9],ENV{DEVTYPE}disk,SUBSYSTEMblock,PROGRAM/usr/lib/udev/scsi_id -g -u -d$devnode,RESULT36000c29a6afc8636a8162bf7f92e9bdd, SYMLINKasm-diski, OWNERgrid, GROUPasmadmin,MODE0660##生效
/sbin/udevadm trigger
##查看
[rootoel79 ~]# ls -l /dev/sd*
brw-rw----. 1 root disk 8, 0 Sep 3 12:19 /dev/sda
brw-rw----. 1 root disk 8, 1 Sep 3 12:19 /dev/sda1
brw-rw----. 1 root disk 8, 2 Sep 3 12:19 /dev/sda2
brw-rw----. 1 grid asmadmin 8, 16 Sep 3 12:19 /dev/sdb
brw-rw----. 1 grid asmadmin 8, 32 Sep 3 12:19 /dev/sdc
brw-rw----. 1 grid asmadmin 8, 48 Sep 3 12:19 /dev/sdd
brw-rw----. 1 grid asmadmin 8, 64 Sep 3 12:19 /dev/sde
brw-rw----. 1 grid asmadmin 8, 80 Sep 3 12:19 /dev/sdf
brw-rw----. 1 grid asmadmin 8, 96 Sep 3 12:19 /dev/sdg
brw-rw----. 1 grid asmadmin 8, 112 Sep 3 12:19 /dev/sdh
brw-rw----. 1 grid asmadmin 8, 128 Sep 3 12:19 /dev/sdi[rootoel79 ~]# ls -l /dev/asm*
lrwxrwxrwx. 1 root root 3 Sep 3 12:19 /dev/asm-diskb - sdb
lrwxrwxrwx. 1 root root 3 Sep 3 12:19 /dev/asm-diskc - sdc
lrwxrwxrwx. 1 root root 3 Sep 3 12:19 /dev/asm-diskd - sdd
lrwxrwxrwx. 1 root root 3 Sep 3 12:19 /dev/asm-diske - sde
lrwxrwxrwx. 1 root root 3 Sep 3 12:19 /dev/asm-diskf - sdf
lrwxrwxrwx. 1 root root 3 Sep 3 12:19 /dev/asm-diskg - sdg
lrwxrwxrwx. 1 root root 3 Sep 3 12:19 /dev/asm-diskh - sdh
lrwxrwxrwx. 1 root root 3 Sep 3 12:19 /dev/asm-diski - sdi10.创建GI目录
mkdir -p /u01/app/grid/19.0.0/grid
chown -R grid:oinstall /u01/app/grid11.配置GI环境变量
##切换到 grid 用户
su - gridvi /home/grid/.bash_profile
export ORACLE_SIDASM
export ORACLE_BASE/u01/app/grid
export ORACLE_HOME/u01/app/grid/19.0.0/grid
export PATH$ORACLE_HOME/bin:$PATH:/usr/local/bin
umask 022##环境变量生效
source /home/grid/.bash_profile 12.上传GI安装包
## 校验密钥将 GI 包上传/u01/app/grid/19.0.0/grid 目录下并解压grid 用户
注意 gi 包的所有者为 grid 所属组为 oinstall[rootoel79 opt]# cp LINUX.X64_193000_grid_home.zip /u01/app/grid/19.0.0/grid
[rootoel79 opt]# chown grid:oinstall -R /u01/app/grid/19.0.0/grid
[rootoel79 opt]# chmod 775 -R /u01/app/grid/19.0.0/grid[gridoel79 ~]$ cd $ORACLE_HOME
[gridoel79 grid]$ unzip LINUX.X64_193000_grid_home.zip13.安装 cvuqdisk
[rootoel79 ~]# cd /u01/app/grid/19.0.0/grid/cv/rpm
[rootoel79 rpm]# export CVUQDISK_GRPoinstall
[rootoel79 rpm]# rpm -ivh cvuqdisk-1.0.10-1.rpm
Preparing... ################################# [100%]
Updating / installing...1:cvuqdisk-1.0.10-1 ################################# [100%]14.安装GI
[rootoel79 ~]# su - grid
[gridoel79 ~]$ cd $ORACLE_HOME
[gridoel79 grid]$ echo $ORACLE_HOME
/u01/app/grid/19.0.0/grid
[gridwl ~]$ export DISPLAY192.168.6.1:0.0
[gridwl grid]$ ./gridSetup.sh##root下执行脚本
/u01/app/oraInventory/orainstRoot.sh
/u01/app/grid/19.0.0/grid/root.sh##安装之后状态检查
[gridoel79 grid]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dgONLINE ONLINE oel79 STABLE
ora.LISTENER.lsnrONLINE ONLINE oel79 STABLE
ora.asmONLINE ONLINE oel79 Started,STABLE
ora.onsOFFLINE OFFLINE oel79 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd1 ONLINE ONLINE oel79 STABLE
ora.diskmon1 OFFLINE OFFLINE STABLE
ora.evmd1 ONLINE ONLINE oel79 STABLE
--------------------------------------------------------------------------------14.ASM创建磁盘组
##创建快闪区的磁盘组以及归档的磁盘组
[gridoel79 grid]$ asmca15.安装Oracle软件
[rootoel79 ~]# su - oracle
[oracleoel79 ~]$ cd $ORACLE_HOME
[oracleoel79 dbhome_1]$ export DISPLAY192.168.6.1:0.0
[oracleoel79 dbhome_1]$ ./runInstaller##root用户执行以下脚本
/u01/app/oracle/product/19.0.0/dbhome_1/root.sh16.DBCA建库
[rootoel79 ~]# su - oracle
[oracleoel79 ~]$ export DISPLAY192.168.6.1:0.0
[oracleoel79 ~]$ env | grep ORACLE_SID
ORACLE_SIDprod
[oracleoel79 ~]$ dbca17.日常管理
1.集群状态
[gridoel79 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dgONLINE ONLINE oel79 STABLE
ora.DATA.dgONLINE ONLINE oel79 STABLE
ora.FRA.dgONLINE ONLINE oel79 STABLE
ora.LISTENER.lsnrONLINE ONLINE oel79 STABLE
ora.asmONLINE ONLINE oel79 Started,STABLE
ora.onsOFFLINE OFFLINE oel79 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd1 ONLINE ONLINE oel79 STABLE
ora.diskmon1 OFFLINE OFFLINE STABLE
ora.evmd1 ONLINE ONLINE oel79 STABLE
ora.prod.db1 ONLINE ONLINE oel79 Open,HOME/u01/app/oracle/product/19.0.0
2.数据库的状态
[oracleoel79 ~]$ srvctl status database -d prod
Database is running.3.启动关闭顺序
关闭先关闭 rdbms 实例----关闭 ASM 实例
开启先开启 ASM 实例----再开启 rdbms 实例注意重启 linux 后ASM和RDBMS自动启动
