今天检测测试库时，发现alert告警日志报错，如下： FriApr 29 12:11:34 2016 minact-scn:got error during useg scan e:376 usn:10 minact-scn:useg scan erroring out with error e:376 FriApr 29 12:14:34 2016 minact-scn:got error during useg scan e:376 usn:10 minact-scn:useg scan erroring out with error e:376 FriApr 29 12:17:34 2016 minact-scn:got error during useg scan e:376 usn:10 minact-scn:useg scan erroring out with error e:376 每3分钟会出现一次 网上找了找到解决方法，故障是由MINACT-SCNMASTER-STATUS信息写到MMON的TRACE文件的BUG引起的，BUG号11891463，解决办法如下： 1. 将隐含参数"_enable_minscn_cr"设置为false： altersystem set "_enable_minscn_cr"=false scope=spfile; 2. 重启数据库检查问题是否被解决。 3. 有时设置了"_enable_minscn_cr"参数就可以解决这个问题，有时却不能，如果没能解决，请再设置"_smu_debug_mode"参数： altersystem set "_smu_debug_mode"=134217728; 设置了上述参数后该信息不会再生成，但是这会禁用...

配置Nginx和php-fpm监控（io的监控也在压缩包里面，可以参考一下）1，准备几个文件：http://pan.baidu.com/s/1DzJeI2，将fpm.sh,nginx-check.sh放到客户端服务器上，这里放在 /home/sh/ 目录下     chmod +x fpm.sh nginx-check.sh     添加缓存目录：　　mkdir -p /usr/local/zabbix/var chown -R zabbix:zabbix /usr/local/zabbix/var3，添加zabbix_agentd配置文件，添加下面两行UserParameter=php-fpm[*],sh /home/sh/fpm.sh "$1" UserParameter=nginx[*],sh /home/sh/nginx-check.sh "$1"4，重启zabbix_agentd5，在服务器端测试一下是否能访问这些键值      zabbix_get -s 192.168.0.xx -k php-fpm[accepted_conn]　　zabbix_get -s 192.168.0.30 -k nginx[accepted_connections]6，在服务器端zabbix网页上Configuration-Templates-import导入包里的两个模板。OK，加入到你需要监控的Host上.监控脚本附件

IPMItool使用很多人希望使用IPMI做带外管理。如果直接使用是有问题的。在OS层面上，你是可以修改IPMI的设置。也就是说，对于linux来说，有专门的驱动，让你修改底层IPMI的设置，包括修改你的IPMI的用户名和密码。安装IPMItool无论是centos，还是ubuntu都可以直接安装，源里都有yum -y install ipmitoolapt-get -y install ipmitoolyum install OpenIPMI OpenIPMI-tools chkconfig ipmi on service ipmi start内核加载modprobe ipmi_msghandlermodprobe ipmi_devintfmodprobe ipmi_si这个时候，你就基本可以对IPMI进行各种设置，你web可以做到的，命令行下都应该可以实现。DELL的<channel_no>是1，HP的是2 ，超微的是1，如果提示你输入channel_no 就输入就可以。查看IPMI用户IPMItool，可以查看本地的ＢＭＣ的设置，查看本地是不需要身份验证。如果查看远程，需要提供IPMI 的用户名和密码。# ipmitool user list 1 ID Name Callin Link Auth IPMI Msg Channel Priv Limit 2 ADMIN false false true ADMINISTRATOR 重设管理员密码，2表示管理员ID，后面pwadmin就是管理员的新密码ipmitool user set password 2 pwadmi...

原来的数据库服务器使用rman进行全库的备份，然后再异地的服务器上恢复一模一样的数据库1.1      原服务器备份数据库第一步，查看数据库的实例名和DBIDconnected to target database: DB3 (DBID=2060124769, not open)第二步，进行全备份backup AS COMPRESSED BACKUPSET databaseinclude current controlfile format '/orabak/db_%d_%T_%s'plus archivelog format '/orabak/arch_%d_%T_%s' ;第三步，查看数据库文件的位置： /home/Oracle/oradata/db3/第四步，将备份文件arch_DB3_20140910_8和 db_ DB3_20140910_7复制异机上/home/oracle/orabak1.2      目标服务器上创建数据库第一步，创建实例名相同（db3）,数据库文件的位置相同（/home/oracle/oradata/db3/）的数据库。 第二步，关闭实例，启动到nomount状态。Sql>startup nomount; 第三步，设置dbid和原数据库dbid相同rman target/Recovery Manager: Release 10.2.0.5.0 - Production on Thu Sep 11 19:53:50 2014Copyright (c) 1982, 2007, Oracle.  All rights reserved.connected to target database: db3 (not mounted)RMAN> set dbid 206...

Oracle密码带特殊字符，如”@“号，在imp,exp里的写法。 做Oracle数据导出的时候，由于用户名的密码使用的是特殊字符，所以遇到了错误代码：“EXP-00056: 遇到 ORACLE 错误 12154” windows os: exp username/"""password"""@devdb --3个双引号扩密码 linux/unix os: exp "username/"password"@devdb" --1个双引号扩密码，1个单引号扩全部

mysql查询字段中带空格的值的sql语句    　　(1)mysql replace 函数　　语法：replace(object,search,replace)　　意思：把object中出现search的全部替换为replace  代码如下     update `news` set `content`=replace(`content`,' ','');//清除news表中content字段中的空格 这样就可以直接用like查询了。 　　(2)mysql trim 函数　　语法：trim([{BOTH | LEADING | TRAILING} [remstr] FROM] str)　　以下举例说明：  代码如下   mysql> SELECT TRIM(' phpernote  ');  -> 'phpernote'  mysql> SELECT TRIM(LEADING 'x' FROM 'xxxphpernotexxx');  -> 'phpernotexxx' mysql> SELECT TRIM(BOTH 'x' FROM 'xxxphpernotexxx');  -> 'phpernote'  mysql> SELECT TRIM(TRAILING 'xyz' FROM 'phpernotexxyz');  -&...

Cannot allocate new log - Private strand flush not complete  Question:  I just upgraded to Oracle 10g release 2 and I keep getting this error in my alert logThread 1 cannot allocate new log, sequence 509Private strand flush not completeCurrent log# 2 seq# 508 mem# 0: /usr/local/o1_mf_2_2cx5wnw5_.log What causes the "private strand flush not complete" message? Answer:  This is not a bug, it's the expected behavior in 10gr2.  You can get the message suppressed by increasing thedb_writer_processes parameter.The "private strand flush not complete" is a "noise" error, and can be disregarded because it relates to internal cache redo file management.  It does not necessarily mean that you have a problem, but it depends if the error message is accompanied by other errors. You should check your transaction with used private redo size in the x$ktifp fixed table  ...

Linux windows php5.4+oracle instant clients OCI安装过程。 See the version for PHP 5.5 and Oracle Database 12c The easiest way to configure PHP to access a remote Oracle Database is to use Oracle Instant Client libraries. This note describes how to install PHP with the OCI8 Extension and Oracle Instant Client on Windows and Linux. The free The Underground PHP and Oracle Manual explains other installation options and contains more detail.OCI8 is the PHP extension for connecting to Oracle Database. OCI8 is open source and included with PHP. The name is derived from Oracle's C "call interface" API first introduced in version 8 of Oracle Database. OCI8 links with Oracle client libraries, such as Oracle Instant Client.Oracle Instant Client is a free set of easily installed libraries that allow programs to connect to local or remote Oracle Database instances. To use Instant Client an existing database is needed - Instant Client does not include one. Typically t...

检查oracle11g 报警日志时，发现有以下报错。Errors in file /data/app/oracle/diag/rdbms/hextrack/hextrack/trace/hextrack_j000_28066.trc: ORA-12012: 自动执行作业 765 出错ORA-12005: 不能安排过去时间的自动刷新检查下对应job编号的具体情况：select job,       log_user,       schema_user,       what,       LAST_DATE,       LAST_SEC,       THIS_DATE,       THIS_SEC,       NEXT_DATE,       NEXT_SEC,       INTERVAL  from dba_jobs where job = 765 JOBLOG_USERSCHEMA_USERWHATLAST_DATELAST_SECTHIS_DATETHIS_SECNEXT_DATENEXT_SECINTERVAL765NEUDDCNEUDDCbeginTable_Analysis;end;2016/11/9 0:02:1500:02:15  2016/11/9 23:00:0023:0...

创建好普通用户时，执行rm,cp,rm 命令时，并没有提示删除，覆盖。不太安全，执行时如果出错，不容易看出来。修改普通用户环境变量后，就可以正常使用了。具体如下：[cwt@web ~]$  cat .bashrc# .bashrc# Source global definitionsalias rm='rm -i'alias cp='cp -i'alias mv='mv -i'if [ -f /etc/bashrc ]; then        . /etc/bashrcfi# User specific aliases and functions[cwt@web ~]$  cat .bash_profile# .bash_profile# Get the aliases and functionsalias rm='rm -i'alias cp='cp -i'alias mv='mv -i'if [ -f ~/.bashrc ]; then        . ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATH