ITPub博客

 ORAchk Health Checks for the Oracle StackORAchk replaces the popular RACcheck tool, extending the coverage based on prioritization of top issues reported by users, to proactively scan for known problems within the area of:Oracle Database...

愤怒是幸福生活的杀手[@more@]　在喜马拉雅山脚下，生活着一种大蜜蜂。它的个头比家养的蜜蜂大许多，是世界上最凶猛的蜜蜂之一。　　凡是见到大蜜蜂巨形蜂巢的人，无不感到一种强大的震撼。但有一种鸟却不怕它，这种鸟叫蜂虎。它是大蜜蜂的天敌，蜂虎捕食大蜜蜂并不偷袭，采取的是一种光明正大的方式。它用娇小的身躯快速地掠过大蜜蜂的蜂巢，小巧的翅膀轻轻地碰触一下蜂巢就马上离开，这是为了激怒大蜜蜂。碰一次，大蜜蜂不理睬，两次就不行了，大蜜蜂被激怒了，开始对蜂虎发起了疯狂地追击，蜂虎的速度比大蜜蜂快得多，慢慢地许多大蜜蜂

SQLT Diagnostic Tool (Doc ID 215187.1)FAQ: SQLT (SQLTXPLAIN) Frequently Asked Questions (Doc ID 1454160.1)[@more@]SQLT Diagnostic Tool (Doc ID 215187.1)To BottomModified:15-Oct-2013Type:DIAGNOSTIC TOOLSLanguage:English简体中文日本語 In this DocumentMain Content Download SQLTXPLAIN (SQLT) What is SQLTXPLAIN (SQLT)? Installation SQLTXPLAIN Reference Material SQLTXPLAIN FAQ SQLTXPLAIN Webinars Best Practices Ask Questions, Get Help, And Share Your Experiences With SQLT Pro-Active Problem Avoidance

HP的一些简单命令[@more@]关机命令 shutdown -ry 0 ，关机时最后用此命令，而不要用reboot集群命令 cmhaltcl 关闭集群命令 cmruncl 运行集群命令 cmviewcl 查看集群命令 cmrunpkg -n 服务器　包名 运行配置的集群包 cmviewcl 查看群集和程序包的状态 cmrunpkg -n node 启动节点包 cmrunnode node 启动节点 cmmodpkg -e 包名　编辑包状态为自动运行状态查看文件空间大小 du -sk 目录名bdf查看系统文件使用情况 如果发现文件过大的情况，可以使用文件清空 /var/adm/wtmps

ADG 容灾切换--- 2013.10.16 22:30 -- 2013.10.17 06:30留个脚印 primary 站点执行了切换命令后，standby 站点切换 primary 不成功的恢复步骤。[@more@]Roll Back After Unsuccessful Switchover and Start OverFor physical standby databases in situations where an error occurred and it is notpossible to continue with the switchover, it might still be possible to revert the newphysical standby database back to the primary role by using the following steps:1. Connect to the new standby database (old primary), an

Oracle RAC Background processes[@more@]RAC Background Processes:1. Lock Monitor Processes ( LMON)2. Lock Monitor Services (LMS)3. Lock Monitor Daemon Process ( LMD)4. LCKn ( Lock Process)5. DIAG (Diagnostic Daemon)1. Lock Monitor Processes ( LMON)It Maintains GCS memory structures.Handles the abnormal termination of processes and instances.Reconfiguration of locks & resources when an instance joins or leaves the cluster are handled by LMON ( During reconfiguration LMON generate the trace fil

error has occured.The application will be shutdown." href="http://blog.sina.com.cn/s/blog_629f5eba01010om9.html" target="_blank">启动UltraEdit错误An error has occured.The application will be shutdown.[@more@]原文地址：error has occured.The application will be shutdown." href="http://blog.sina.com.cn/s/blog_629f5eba01010om9.html" target="_blank">启动UltraEdit错误An error has occured.The application will be shutdown.作者：chenjia107

Oracle Database Fails to Start with Error ORA-12547 [ID 1307075.1][@more@]Oracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]To BottomModified:Nov 30, 2012Type:PROBLEMStatus:PUBLISHEDPriority:3Comments (0)In this DocumentSymptomsCauseSolutionApplies to:Oracle Server - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document applies to any platform.***Checked for relevance on 17-Oct-2012*** Symptoms1. When attempting to startup database,the following error occurs

AIX 上压缩与解压缩[@more@].gzgzip –d 或 gunzipgzip.Zuncompresscompress.tartar -xvftar –cvf.cpiocpio -idumv .zipunzip 或 jar -xvf *.tar.gzgzip -dc *.tar.gz | tar xvf - **************************************************************************************************在AIX系统应用过程中，经常遇到压缩文件或者解压文件，下面就介绍一下常用的压缩与解压缩工具及使用方法。 1、tar命令：可以为文件和目录创建档案。通俗的讲就是tar命令负责将文件或文件夹打包，但是并不提供压缩。通常情况下，压缩工具不能直接对文

（李嘉诚）教五年内买车买房——理财篇[@more@]（李嘉诚）教五年内买车买房——理财篇假设你的月收入只有2000元，你也可以过得很好。我帮你把钱分成五份。第一份600元，第二份400元，第三份300元，第四份200元，第五份500元。第一份，用来做生活费。这么少的生活费，每天只能够分到十几元。早餐一份煮米丝，一个鸡蛋，一杯豆浆。中餐一份快餐，一个水果。晚餐自己开个小灶，煮点饭，加俩菜，睡前一杯奶。这样一月的伙食大概是500-600。不过，如果你还年轻，身体暂时还没有太多问题，这样的食谱，够你数年内不会有健康问题。第二份，用来交

DBWR_IO_SLAVES [@more@]DBWR_IO_SLAVESIf it is not practical to use multiple DBWR processes, then Oracle provides a facility whereby the I/O load can be distributed over multiple slave processes. The DBWR process is the only process that scans the buffer cache LRU list for blocks to be written out. However, the I/O for those blocks is performed by the I/O slaves. The number of I/O slaves is determined by the parameter DBWR_IO_SLAVES.DBWR_IO_SLAVES is intended for scenarios where you cannot use m

shell 脚本注意事项[@more@]1，一定要加上相应环境变量。2，crontab 定义每隔多少分钟执行一次的格式如下：*/6 * * * * ls -al >~/123.txt(每隔6分钟执行一次)

[转] 孩子的家庭教育很重要[@more@] 一、孩子把水、牛奶等撒了一桌子。错误做法：训孩子：“你怎么这么笨？连个杯子都拿不住。”更有甚者顺手给孩子一巴掌。结果：大人和孩子都很生气，事情一团糟，孩子学会通过发脾气、打人解决问题。正确做法：安慰孩子：“孩子，没事，我知道你不是故意的，下次注意啊。你把桌子擦干净好吗？”结果：孩子得到的谅解，马上向大人道歉，并高兴的把桌子擦干净。孩子学会宽容。[/url][/url]二、孩子考试不及格。错误做法：训孩子：“你看你，考这么点分，你也不嫌丢人？你看谁谁，人

From Tom[@more@]Submitted on 11-Oct-2012 9:48 Central time zoneTom's latest followup | Bookmark | BottomLast updated 11-Oct-2012 17:01You AskedTom, We are moving from older version of Oracle to new verion 11.2.0.3. The DBA's want to load 11.2.0.3 on dev and set compatibility to 10. whatever. then put 11.2.0.3 on production and set compability tha same. After this is working they want to increase compaibilty to 11.2 in dev and if it works out, they will do the same on production. They want to do

From asktomhow does Exadata *not* require a DBA??? It is a fast, big machine, but just a fast big machine. It is not magic, you still need administrators [@more@]Submitted on 5-Nov-2012 11:13 Central time zoneTom's latest followup | Bookmark | BottomLast updated 5-Nov-2012 11:35You AskedHello Tom: In the last few years we have seen how the number of information systems has increased, but also the automation of database administration processes. Now with the new Exadata and SaaS technologies it s

时间 2012.10.25 08:50 -- 2012.10.25 11:10emc 存储故障，导致 11.2.0.2 linux RAC 数据库停机[@more@]一大帮领导站在身后督战，太锻炼人了。

转载[@more@]Char devices are accessed through names in the filesystem. Those names are called special files or device files or simply nodes of the filesystem tree; they are conventionally located in the /dev directory. Special files for char drivers are identified by a "c" in the first column of the output of ls -l . Block devices appear in /dev as well, but they are identified by a "b." The focus of this chapter is on char devices, but much of the following information appli

DBV-00201: Block, DBA 1175408467, marked corrupt for invalid redo application [@more@]问题：　　　一个朋友在做数据库异机恢复时，整个 restore , recover 过程都顺利进行，数据库也可以正常 open 。 但是他对一些数据文件执行 dbv 时报以下错误。DBV-00201: Block, DBA 1175408467, marked corrupt for invalid redo application DBV-00201: Block, DBA 1175408468, marked corrupt for invalid redo application DBV-00201: Block, DBA 1175408469, marked corrupt for invalid redo application DB

AdbeRdr1010_zh_CN.zipFileCombiner_xp500.com.rar[@more@]

SPB[@more@]手工把 plan 改为 accepted 状态；只有处于 accepted 状态的 plan 才可能被用来执行 sql :variable v_sql_handle varchar2(30);variable v_plan_name_full varchar2(30);variable v_plan_name_index varchar2(30);exec :v_sql_handle := 'SYS_SQL_0993bcb3526c1c35';exec :v_plan_name_full := 'SQL_PLAN_a8qny22gsbtd494ecae5c';exec :v_plan_name_index := 'SQL_PLAN_a8qny22gsbtd40893a4b2';variable v_report clob;exec :v_report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE(sql_handle => :v_sql_handle);prin