如题所示的报错，其实是在使用Microsoft的笔记软件：One Note的时候遭遇的。当你试图调整最大窗体的ONE NOTE的尺寸大小的时候，ONE NOTE就会挂起，并且给你抛出一个如题所示的错误信息。具体如下：对于该问题的解决：在下次启动ONE NOTE的时候，ONE NOTE会察觉到上次是异常退出，并且向你询问处理策略，如下：选择【删除笔记本缓存】就可以解决上面的问题了。打开ONE NOTE后，需要重新开启之前的笔记本数据即可。上面的操作需要注意的是，如果是网络共享笔记本，那么没有同步的变更数据，可能就只能丢失了。所以，ONE NOTE最好使用本地的笔记本数据比较放心点。——————————————————Done。 ...继续阅读 (27)

首先，安装Sendmail：[root@ora12c-1 ~]# yum install sendmail sendmail-cf m4 Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register. Resolving Dependencies --> Running transaction check ---> Package m4.x86_64 0:1.4.16-10.el7 will be installed ---> Package sendmail.x86_64 0:8.14.7-4.el7 will be installed --> Processing Dependency: procmail for package: sendmail-8.14.7-4.el7.x86_64 --> Processing Dependency: libhesiod.so.0()(64bit) for package: sendmail-8.14.7-4.el7. ...继续阅读 (41)

不具体说明了，直接上代码：[root@oel-me software]# cd python/ [root@oel-me python]# ls Python-2.7.13.tgz Python-3.6.0.tgz [root@oel-me python]# [root@oel-me python]# mkdir Python_27 [root@oel-me python]# ls -ltr total 38416 -rw-r--r--. 1 root root 17076672 Mar 15 11:42 Python-2.7.13.tgz -rw-r--r--. 1 root root 22256403 Mar 15 11:42 Python-3.6.0.tgz drwxr-xr-x. 2 root root 6 Mar 15 11:45 Python_27 [root@oel-me python]# [root@oel-me python]# tar -xzf Python-2.7.13.tgz -C Python_27/ [root@oel-me python]# ls -ltr total 38416 -rw-r--r--. 1 root root 17076672 Mar 15 11:42 Python-2.7.13.tgz -rw-r--r--. 1 ...继续阅读 (29)

具体如下：cd $ORACLE_HOME/dbs ls -ltr | grep xxx cat xxx.ora #查看或修改参数文件 mkdir -p /u01/app/oracle/admin/xxx/{adump,bdump,cdump,udump} mkdir -p /xxx/{oradata,flash_recovery_area,arch,redolog} ls -ltr /xxx/ | grep auto ls -ltr /xxx chown -R oracle.oinstall /xxx 这里，权限不正确，会影响后面的控制文件的恢复 export ORACLE_SID=xxx export ORACLE_SID=xxx create spfile from pfile='$ORACLE_HOME/dbs/initxxx.ora'; startup nomount; rman target / restore controlfile from '/xxx/auto_controlc-2600836681-20170314-01'; alter database mount; 对于每一个备份片文件，都需要注册到RMAN catalog backuppiece 'xxxx'; run{ ...继续阅读 (38)

在使用RMAN恢复文件的时候，可能你会遇到如下所示的错误：在我的环境里，我是在恢复控制文件的时候遇到的：RMAN> restore controlfile from '/xxx/auto_controlc-2600836681-20170314-01'; Starting restore at 14-MAR-17 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=1093 devtype=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/14/2017 14:37:40 RMAN-06172: no autobackup f ...继续阅读 (40)

有时候，在使用vSphere的Console的时候可能会出现显示异常的问题。具体如下：这种现象比较容易发生在高分屏的电脑上。解决方法：以兼容性模式运行【VMware vSphere Client】注意，一定要开启【高DPI设置时禁用显示缩放】如下：如上配置以后，Console的显示就正常了。——————————————Done。 ...继续阅读 (25)

有时候，通过DBCA创建的数据库实例，有可能没有开启EM Express。EM Express，是可以后面手动开启的。下面的篇章，将呈现做到这件事的细节。在开启之前，先查看下数据库的当前状态：监听器：[oracle@ora12c-1 ~]$ lsnrctl status LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 08-MAR-2017 15:29:09 Copyright (c) 1991, 2016, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora12c-1)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 08-MAR-2017 11:36:35 Uptime 0 days 3 hr. 52 mi ...继续阅读 (32)

有时候，启动数据库的时候可能看到如题所示的报错，具体如下：ora-01157: cannot identify/lock data file 6 - see DBWR trace file ora-01110: data file 6: '/data/xxxxx/xxxx.dbf'这个时候，最好去检查下出问题的数据文件，很可能它们真的不存在了。——————一般发生该问题的场景是：一些架构中，数据库的数据文件放在mount挂起来的挂载点，而挂载信息又没有写到启动文件中，例如：/etc/fstab。因此，重启系统之后，忘了先挂载，而直接启动数据库，当然就发生这类的错误了。——————Done。 ...继续阅读 (32)

本文为Oracle Database 12c Release 2的安装文档，参考了官方文档：Database Installation Guide：http://docs.oracle.com/database/122/LADBI/在我的环境里，有一台RHEL 7.3的服务器，用来完成本次12cR2的安装，它的主机名为：ora12-1。创建需要的基础目录（个人习惯）[root@ora12c-1 ~]# mkdir -p /script/shell [root@ora12c-1 ~]#安装前检查（Checklist）运行等级：[root@ora12c-1 ~]# runlevel N 5 [root@ora12c-1 ~]#LONG BIT：[root@ora12c-1 ~]# getconf -a | grep --color LONG_BIT LONG_BIT 64 [root@ora12c-1 ~]#内核与版本号：[root@ora12c-1 ~]# uname -a Linux ora12c-1 3.10.0-514.el7.x86_64 #1 SMP Wed Oct 19 11:24:13 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux [root@ora12c-1 ~]# [root@ ...继续阅读 (38)

该错误发生在数据库DBCA建库的时候。具体错误如下：发生该错误的时候，后台日志会如下显示：OUI的日志：INFO: Read: 35% complete WARNING: Skipping line: 35% complete INFO: Read: 38% complete WARNING: Skipping line: 38% complete INFO: Read: DBCA Operation failed. INFO: DBCA Operation failed. WARNING: Skipping line: DBCA Operation failed. INFO: Read: Look at the log file "/home/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details. INFO: Look at the log file "/home/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details. WARNING: Skipping line: Look at the log file "/home/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further deta ...继续阅读 (40)

如果想要卸载，可以使用【runInstaller】，具体如下：删除前，先查看下当前的情况：[oracle@ora12c-1 ~]$ env | grep HOME HOME=/home/oracle ORACLE_HOME=/home/app/oracle/12c/release_2/db_1 [oracle@ora12c-1 ~]$ du -sh $ORACLE_HOME 7.2G /home/app/oracle/12c/release_2/db_1 [oracle@ora12c-1 ~]$进入安装介质的目录，运行【runInstaller】：[root@ora12c-1 ~]# su - oracle Last login: Wed Mar 8 11:00:11 CST 2017 on pts/0 [oracle@ora12c-1 ~]$ cd /software/oracle/database/ [oracle@ora12c-1 database]$ [oracle@ora12c-1 database]$ ./runInstaller -deinstall -home $ORACLE_HOME Checking for required space in /tmp directory ... Space check on /tmp directory passe ...继续阅读 (31)

有时候，可能出现这样的情况：1. MySQL复制的主从机器位于不同的网段这种情况下，如果使用Keepalive做VIP资源，则可能出现主从两边VIP都启动的情况，正确的情况下VIP应该只能在其中一端活跃。这种情况下，就可以通过自定义脚本去解决该场景下的问题。这一次的代码更新，也发布到了Github上：https://github.com/adamhuan/linux-script/tree/master/MySQL/MySQL%20MasterHA_%E5%A2%9E%E5%BC%BA以下是我对之前自己写的 针对MHA架构的 自定义脚本变更后的样子：文件：do_mha.sh#!/bin/bash # Script Name: MySQL_MHA_Enhance_shell.sh # About: auto register in MySQL Replication # Script Type: Bash Shell # OS: RHEL6 / CentOS6 # Architecture: MySQL MasterHA # Auther: adamhuan # Blog: d-prototype.com # -------------------------- # variable and file path # Part:: this script str_mha_app ...继续阅读 (26)

本文呈现如何部署MySQL Group Replication的多写模式：Multi-Primary。在我的环境里有三台服务器：[root@mysql-manager ~]# cat /etc/hosts #127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 #::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 # Local 127.0.0.1 localhost # Pub 192.168.147.129 mysql-manager 192.168.147.132 mysql-node-1 192.168.147.133 mysql-node-2 [root@mysql-manager ~]#数据库版本：MySQL 5.7.17[root@mysql-manager ~]# cat ~/.bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific enviro ...继续阅读 (25)

该错误一般发生在配置MySQL的组复制的场景中。具体的报错信息如下：mysql> start group_replication; ERROR 3092 (HY000): mysql>解决方法：mysql> set global group_replication_allow_local_disjoint_gtids_join=ON; Query OK, 0 rows affected (0.00 sec) mysql> start group_replication; Query OK, 0 rows affected (2.09 sec) mysql>————————————————————————————————Done。 ...继续阅读 (34)

具体错误信息如下：mysql> desc people; +----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | id | int(11) | YES | | NULL | | | name | varchar(50) | YES | | NULL | | | location | varchar(400) | YES | | NULL | | +----------+--------------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> mysql> insert into people values(1,'red queen','umbraller'); ERROR 3098 (HY000): Unknown error 3098 mysql>出现该错误的原因是，目标数据表没有主 ...继续阅读 (33)

在给MySQL安装插件的时候，你可能会遇到如题所示的报错。更详细的错误输出如下：mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; ERROR 1126 (HY000): mysql> mysql>造成该问题的原因是，MySQL的配置文件指定的plugin_dir中，找不到你要安装的【*.so】文件。比方说，在我的环境里是这样的：[root@mysql-node-1 ~]# cat /etc/my.cnf [mysqld] datadir=/data/mysql/db_data plugin-dir=/data/mysql/plugin_data log-error=/data/mysql/log_data/mysql-error.log socket=/data/mysql/run/mysql.sock pid-file=/data/mysql/run/mysql.pid user=mysql port=3306 # for replication server_id=2 gtid_mode=ON enforce_gtid_consistency=ON master_info_repository=TABLE relay_log_info_repository=TABLE ...继续阅读 (42)

今天，在找MySQL的分析与挖掘工具的时候，发现了如题所示的工具：MySQL Sniffer。该工具是奇虎360，内部团队HULK中的大牛们开发的，基于MySQL协议，实时抓取MySQL的数据包，来获得相关的诸如访问DB，命令耗时，用户，… 等信息。该工具的官方代码托管页面为：https://github.com/Qihoo360/mysql-sniffer这里，我参考官方的帮助文档，在自己的环境里玩玩：https://github.com/Qihoo360/mysql-sniffer/blob/master/README_CN.md一、安装依赖包：yum install -y glib2-devel libpcap-devel libnet-devel二、上传编译好的二进制文件到服务器：[root@mha1 c++]# pwd /script/c++ [root@mha1 c++]# ls mysql-sniffer [root@mha1 c++]# [root@mha1 c++]# ls -ltr total 196 -rwxr-xr-x 1 root root 199583 Mar 3 14:42 mysql-sniffer [root@mha1 c++]#三、查看帮助信息，并使用：帮助信息：[root@mha1 c++]# ./mysql-sniffer - ...继续阅读 (36)

有时候在使用YUM的时候，你会出现如题所示的问题，具体如下：[root@mha1 c++]# yum install -y glib2-devel libpcap-devel libnet-devel Loaded plugins: fastestmirror, refresh-packagekit, security Determining fastest mirrors * extras: mirrors.163.com * remi-safe: mirrors.thzhost.com * updates: mirrors.aliyun.com LocalPercona | 2.9 kB 00:00 ... LocalPercona/primary_db | 16 kB 00:00 ... http://download.fedorapro ...继续阅读 (47)

直接上代码：[root@center-me python]# python array.py ['b', 'c', 'a', 'f', 'g', '3', '2', '1'] ['1', '2', '3', 'a', 'b', 'c', 'f', 'g'] [root@center-me python]# [root@center-me python]# cat array.py list_a = ["b","c","a","f","g","3","2","1"] list_b = list_a[ : ] list_b.sort() print list_a print list_b [root@center-me python]#——————————————Done。 ...继续阅读 (22)

在我的环境中有两台服务器：Master:10.158.1.112Standby:10.158.1.113出问题的时候：备库的情况：SYS@enmy --> set linesize 400 SYS@enmy --> col name for a65 SYS@enmy --> select name,thread#,sequence#,to_char(first_time,'yyyy-mm-dd hh24:mi:ss') "First",to_char(next_time,'yyyy-mm-dd hh24:mi:ss') "Next",applied from v$archived_log,(select max(sequence#) "SEQ#" from v$archived_log where applied='YES') b where sequence# between b.seq#-5 and b.seq#+9 order by sequence#; NAME THREAD# SEQUENCE# First Next APPLIED -------------------------- ...继续阅读 (22)

首先，用NPM安装GITBOOK支持：[root@ndb2-1 ~]# npm install gitbook -g npm WARN deprecated ignore@3.1.2: several bugs fixed in v3.2.1 npm WARN deprecated tough-cookie@2.2.2: ReDoS vulnerability parsing Set-Cookie https://nodesecurity.io/advisories/130 npm WARN deprecated node-uuid@1.4.7: use uuid module instead npm WARN engine escodegen@1.8.1: wanted: {"node":">=0.12.0"} (current: {"node":"0.10.46","npm":"2.15.1"}) npm WARN engine esprima@3.1.3: wanted: {"node":">=4"} (current: {"node":"0.10.46","npm":"2.15.1"}) npm WARN engine web-resource-inliner@2.0.0: wanted: {"node":">=4.0.0"} (current: {"node":"0.10 ...继续阅读 (19)

NPM，官方网站：https://www.npmjs.com/官方文档页：https://docs.npmjs.com/安装介质：https://github.com/nodesource/distributions1. SETUP脚本：URL：https://rpm.nodesource.com/setup下载下来，然后执行。最后，你会看到这样的提示：The NodeSource Node.js Linux distributions GitHub repository contains information about which versions of Node.js and which Linux distributions are supported and how to use the install scripts. https://github.com/nodesource/distributions ================================================================================ ================================================================================ Continuing i ...继续阅读 (25)

有时候，在Linux删除一个大文件的时候，你会发现磁盘空间并没有释放出来。比方说下面这样的情况：磁盘空间满：[root@mha1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_mha1-lv_root 42G 42G 0 100% / tmpfs 7.9G 88K 7.9G 1% /dev/shm /dev/sda1 485M 37M 423M 8% /boot [root@mha1 ~]#最后，找到占用磁盘空间的是一个日志文件：nohup.out，如下：[root@mha1 ~]# cd /script/ [root@mha1 script]# ls mha nohup.out shell [root@mha1 script]# [root@mha1 script]# du -sh * 44K mha 16K nohup.out 15G shell [root@mha1 script]# cd shell/ [root@mha1 shell]# ls call_do_mha.sh do_mha.sh d ...继续阅读 (15)

大概的报错如题所示，更详细的内容如下：文本：E297: Write error in swap file E303: Unable to open swap file for "xxxxx", recovery impossible然后，画面会变成：E297: Write error in swap file "/etc/hosts" 11L, 264C Press ENTER or type command to continue其实，回车后就可以编辑了；但是，肯定是有问题的。虽然可以编辑，但是无法保存："/etc/hosts" "/etc/hosts" E514: write error (file system full?) "/etc/hosts" "/etc/hosts" E514: write error (file system full?) Press ENTER or type command to continue如果你做过编辑，但无法保存，那么退出的时候要强制退出（:q!），否则会出现这样的错误：E37: No write since last change (add ! to override)查看SWAP的使用情况：[root@mha1 ~]# swapon -s Filename Type ...继续阅读 (21)

直接上代码：[root@center-me ~]# a="1" [root@center-me ~]# b="abcd1" [root@center-me ~]# [root@center-me ~]# if [[ $b =~ "$a" ]]; then echo yes; else echo no; fi yes [root@center-me ~]# [root@center-me ~]# a="2" [root@center-me ~]# if [[ $b =~ "$a" ]]; then echo yes; else echo no; fi no [root@center-me ~]#——————————————Done。 ...继续阅读 (22)

我们知道，DHCP可以动态的分配IP地址。但是，我们怎么知道DHCP到底分配出了哪些地址？难道去网段里面去扫描？这当然是可行的方法之一，但是，有更好的方法。DHCPD服务，会将已经分配出去的IP的相关信息记录在一个文件里面：/var/lib/dhcpd/dhcpd.leases具体如下：[root@center-me ~]# cat /var/lib/dhcpd/dhcpd.leases # The format of this file is documented in the dhcpd.leases(5) manual page. # This lease file was written by isc-dhcp-4.2.5 lease 10.158.1.104 { starts 3 2017/02/15 06:43:38; ends 3 2017/02/15 12:43:38; tstp 3 2017/02/15 12:43:38; cltt 3 2017/02/15 06:43:38; binding state free; hardware ethernet 00:50:56:84:67:c1; } lease 10.158.1.103 { starts 3 2017/02/15 06:52:30; ends 3 2017/02/15 ...继续阅读 (21)

ASMCMD命令的帮助信息：[vcdgrid@oracle scripts]$ asmcmd help asmcmd [-V] [-v ] [--privilege ] [-p] [command] asmcmd_no_conn_str Starts asmcmd or executes the command asmcmd [-V] [-v ] [--privilege ] [-p] [command] The environment variables ORACLE_HOME and ORACLE_SID determine the instance to which the program connects, and ASMCMD establishes a bequeath connection to it, in the same manner as a SQLPLUS / AS SYSASM. The user must be a member of the OSASM group. Specifying the -V option prints the asmcmd version number an ...继续阅读 (35)

在初始化MySQL数据库的时候，你可能会遇到如题所示的报错。该报错的具体情况如下：[root@ndb1-1 mysql_data]# mysql_install_db --defaults-file=/etc/my.cnf --user=mysql FATAL ERROR: please install the following Perl modules before executing /usr/bin/mysql_install_db: Data::Dumper [root@ndb1-1 mysql_data]#这个情况，可以通过安装缺少的Perl包（rpm）来解决。具体如下：命令：1. yum list | grep perl-Module-Install2. yum install -y perl-Module-Install[root@ndb1-1 mysql_data]# yum list | grep perl-Module-Install perl-Module-Install.noarch 1.06-4.el7 @ISO [root@ndb1-1 mysql_data]# [root@ndb1-1 mysql_data]# yum install -y perl-Module-Ins ...继续阅读 (30)

由于前面写过ndb 7.4.11的安装：MySQL Cluster 7.4.11：Install on RHEL6 Update8官方对NDB 7.4 的安装文档：https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-install-linux-rpm.html所以本文只是粗略的总结一下不同以及异常处理，大体的步骤其实是一样的。————————————————一、上传并解压安装介质：在官方，其实已经找不到7.4.12的安装介质了，我将自己提前下好的介质上传了，方便下载：链接：http://pan.baidu.com/s/1bpMQcNH 密码：v0cp服务器上的操作：上传与解压[root@ndb1-1 ~]# ls -ltr /software/mysql_cluster/ total 351420 -rw-r--r-- 1 root root 359854080 Feb 24 21:19 MySQL-Cluster-gpl-7.4.12-1.el6.x86_64.rpm-bundle.tar [root@ndb1-1 ~]# cd /software/mysql_cluster/ [root@ndb1-1 mysql_cluster]# tar -xf M* [root@ndb1-1 mysql_cluster]# ls My ...继续阅读 (27)

报错如题所示，更详细的内容如下：在ZABBIX的日志文件【/etc/zabbix/zabbix_server.conf，可以找到配置的日志文件的位置】中，你可以看到很多类似标题所示的报错28106:20170227:112642.572 database is down: reconnecting in 10 seconds 28106:20170227:112652.572 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 28106:20170227:112652.572 database is down: reconnecting in 10 seconds 28106:20170227:112702.573 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 28106:20170227:112702.573 databas ...继续阅读 (39)