weixin_45950088的博客

1、锁定用户alter user XXX account lock;2、查询所有链接进程SELECT ‘alter system kill session ‘’’||sid||’,’||serial#||’’’;’ FROM v$session WHERE username=‘XXX’;3、删除用户drop user XXX cascade;4、创建用户create user XXX identified by XXXX;5、赋权grant dba,connect,resource to

一、创建NFS动态卷持久化存储1、创建NFS服务端[root@work03 ~]# yum install nfs-utils rpcbind -y[root@work03 ~]# systemctl start nfs[root@work03 ~]# systemctl start rpcbind[root@work03 ~]# systemctl enable nfs[root@work03 ~]# systemctl enable rpcbind[root@work03 ~]# mkdi

一、创建NFS动态卷持久化存储1、创建NFS服务端[root@work03 ~]# yum install nfs-utils rpcbind -y[root@work03 ~]# systemctl start nfs[root@work03 ~]# systemctl start rpcbind[root@work03 ~]# systemctl enable nfs[root@work03 ~]# systemctl enable rpcbind[root@work03 ~]# mkdi

1、创建PVNFS目录chown 999:999 *chmod 777 *vim mysql-pv.yamlapiVersion: v1kind: PersistentVolumemetadata: name: mysql1 labels: app: mysql_nfsspec: capacity: storage: 1Gi accessModes: - ReadWriteOnce persistentVolumeReclaimPolicy:

mysql安装解压文件tar -xvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz改名mv -v mysql-5.7.22-linux-glibc2.12-x86_64 /usr/lcoal/mysql创建用户和用户组groupadd mysqluseradd -g mysql mysql在mysql目录下创建data文件夹mkdir data 将安装目录所有者及所属组改为mysqlchown -R mysql.mysql /usr/l

1、查看当前swap大小需大于150Mfree -h2、查看当前系统信息uname -mcat /etc/redhat-release3、修改主机名vim /etc/sysconfig/networkhostname=hwxvim /etc/hosts192.168.1.4 hwx4、关闭SELINUXvim /etc/selinux/configSELI...

1、下载安装包instantclient-basic-linux.x64-18.3.0.0.0dbru.zipinstantclient-sqlplus-linux.x64-18.3.0.0.0dbru.zip2、解压安装包unzip instantclient-basic-linux.x64-18.3.0.0.0dbru.zip && unzip instantclien...

数据库自启动1、开机自启动修改oratabvim /etc/oratabheosun:/app/oracle/product/11.2.0/dbhome_1:Y变N为Y修改dbstartvim /app/oracle/product/11.2.0/dbhome_1/bin/dbstart将ORACLE_HOME_LISTNER=$1改为ORACLE_HOME_LIST...

锁进程查看被锁的表select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;查看锁进程SELECT B.USERNAME, B.SID, B.SERIAL#, LOGON_TIME FROM V...

1、下载redis包wget http://download.redis.io/releases/redis-4.0.8.tar.gz2、解压tar xzvf redis-4.0.8.tar.gz3、安装cd redis-4.0.8makecd srcmake install PREFIX=/usr/local/redis4、4.移动配置文件到安装目录下cd …/mkdir ...

解压文件tar -xvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz改名mv -v mysql-5.7.22-linux-glibc2.12-x86_64 /usr/lcoal/mysql再创建用户和用户组groupadd mysqluseradd -r -g mysql mysql将安装目录所有者及所属组改为mysqlchown -...

定时备份#!/bin/shDUMP=/mnt/mongodb/mongodb-linux-x86_64-4.0.1/bin/mongodumpOUT_DIR=/backup/mongod_bak/mongod_bak_nowTAR_DIR=/backup/mongod_bak/mongod_bak_listDATE=`date +%Y_%m_%d`DB_NAME=heosunDAYS...