Upgrading MySQL Binary or Package-based Installations on Unix/Linux
How to upgrade MySQL binary and package-based installations on Unix/Linux. In-place and logical upgrade methods are d...
Physical backups consist of raw copies of the directories and files that store database contents. Thistype of backup is suitable for large, important databases that need to be recovered quickly whe...
Linux系统创建只读用户
一、创建用户1234useradd -s /bin/bash dbmon----Aix系统:useradd -s /usr/bin/ksh -m -G oinstall dbmon;
二、设置密码1234echo "@dbmon_123p" | passwd --stdin dbmon----Aix系统:passwd dbmon;
...
Centos7.9安装Mysql8.0(二进制)
MySQL :: MySQL 8.0 Reference Manual :: 2.2 Installing MySQL on Unix/Linux Using Generic Binaries
一、查看glibc版本1ldd --version|head -1
二、卸载旧的版本及配置文件1234567for i in $(rp...
一、查看磁盘123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475[root@dbrecover ~]# df -h文件系统 容量 ...
一、关闭防火墙1234systemctl status firewalld.servicesystemctl stop firewalld.servicesystemctl disable firewalld.service
二、关闭SeLinux12345sed -i "s/SELINUX=enforcing/SELINUX=disabled/" /etc/selin...
Centos7.9安装Redis
一、下载下载地址：http://redis.io/download，下载最新稳定版本。
二、配置YUM123456789101112131415161718mkdir /opt/yumcp -r /run/media/admin/CentOS\ 7\ x86_64/* /opt/yumyum clean allyum makecache---配置本地YU...
Oracle Database Statistics Gathering
一、查看统计信息1234567891011select a.column_name, b.num_rows, a.num_distinct Cardinality, round(a.num_distinct / b.num_rows * 100, 2) selectivit...
Oracle12c单实例安装
一、安装规划1.介质
安装前介质准备
软件
版本
安装包
Centos
7.6
CentOS-7-x86_64-DVD-1810.iso
Oracle12c
12.2.0.1
linuxx64_12201_database.zip
Rlwrap
0.45
rlwrap-0.45.2.tar.gz
2.目录及实例
属性
值
备注
...
由于对系统文件的暴力删除，导致Oracle Inventory缺失，需要重新创建Oracle Central Inventory参照文档: Steps To Recreate Central Inventory(oraInventory) In RDBMS Homes ( Doc ID 556834.1 )。
– Search – Note: This is INTERNAL ...
