ITPub博客

Organizational entrenchment and disruption Software-defined networks Bigger data and storage Hybrid cloud services Client and server architectures Internet of things IT appliance madness Operational complexity Virtual data centersIT demand[@more@]Gartner’s recommendations include: -Prepare for organizational disruptions – externally and internally generated. -Software networks are coming; begin updating skills now. -Hybrid cloud services are evolving rapidly. -Internet of things will be here;

公司发了内部文档，IT项目需要DBA支持NoSQL 。有一篇有意思的文档 《Hard truths about the NoSQL revolution》，有些感触。不管怎样，还是要学一下滴。[@more@]Hard truths about the NoSQL revolution - By Peter WaynerNoSQL hard truth No.1: JOINs mean consistencyNoSQL hard truth No.2: Tricky transactionsNoSQL hard truth No.3: Databases can be smartNoSQL hard truth No.4: Too many access modelsNoSQL hard truth No.5: Schema flexibility is trouble waiting to happenNoSQL hard truth No.6: No extrasNoSQL hard trut

稀土类股票最近领涨:-）稀土金属，或称稀土，是元素周期表中钪、钇和镧系元素等化学元素的共同的俗称，是很多科技产品的材料。多数呈银灰色，晶体结构多为HCP或FCC ; 主要有氟碳铈、独居石、铈铌钙钛矿等。[@more@]根据稀土元素原子电子层结构和物理化学性质，以及它们在矿物中共生情况和不同的离子半径可产生不同性质的特征，十七种稀土元素通常分为二组：轻稀土包括：镧、铈、镨、钕、钷、钐、铕、钆。重稀土包括：铽、镝、钬、铒、铥、镱、镥、钪、钇。http://zh.wikipedia.org/zh-cn/%E7%A8%80%E5%9C%9F%E9%87%91%E5%B1%9E

Clone the oracle software between two server, need to confirm the OS compatibility are same between source & destination server.[@more@]Source Server:****************steps 1:ORACLE_HOME: /JASUATDB01//oracle/product/10.2.0.1Tar the oracle home 10.2.0.1$cd /JASUATDB01//oracle/product$tar -cvf 10.2.0.1.tar 10.2.0.1Destination server:******************Steps 2:Copy the oracle binary tar file from source server to Destination server.$mkdir -p /JASUATDB01//oracle/product$cd /JASUATDB01//oracle/prod

Wide Area File Services (WAFS) refer to technologies that enable the consolidation of file servers from remote sites to the data center without compromising end user performance. [@more@]W

To get error details: sudo errpt -aj BFE4C025Need to upgrade FW of P570. Refer to: http://www.aixchina.net/club/archiver/tid-17419.html[@more@]

恢复“快速启动”栏中的“显示桌面”按钮方法:打开“记事本”程序，在其中输入如下内容:　　[Shell]　　Command=2　　IconFile=explorer.exe,3　　[Taskbar]　　Command=ToggleDesktop[@more@]然后把这个文件保存为：“Show Desktop.scf”，必须确认文件名和双引号中的一样。然后把保持的Show Desktop.scf文件复制到：“C:Documents and Settings用户名Application Data MicrosoftInternet ExplorerQuick Launch”目录下。其中你需要把“用户名”替换成你需要恢复“显示桌面”按钮的用户名。

A solid-state drive (SSD) is a data storage device that uses solid-state memory to store persistent data.An SSD emulates a hard disk drive interface, thus easily replacing it in most applications. An SSD using SRAM or DRAM (instead of flash memory) is often called a RAM-drive, not to be confused with a RAM disk. Recently, NAND based flash memory has become the standard for most SSD's.[@more@]The original usage of the term "solid-state" (from solid-state physics) refers to the use of se

如何在Excel2007中工作都时候锁定单元格不被编辑和删除，是算一个简单都使用方法和过程。具体的步骤：第一步：全选表格，格式－单元格－保护，去掉锁定那个勾。[@more@]第二步：选中要保护的单元格，格式－单元格－保护，勾上锁定哪个勾。最后一步：工具－保护－保护工作表（可设置密码），OK了。

1 PB = 1024 TB ; 1 EB = 1,024 PB = 1,048,576 TB = 260 bytes真真算不过来了。。。。[@more@]The maximum amount of data M that can be stored in the Oracle database can be calculated using the formula: M = D * F * B, where D is the maximum number of data files in the database, F is the maximum number of blocks per data file, and B is the maximum block size.With the older limits (D = 64 KB, F = 4 M, and B = 32 KB), the value of M is 8 PB, or 2 PB for the most typical 8 KB block size.

A heap-organized table is a table with rows stored in no particular order. This is a standard Oracle table; the term "heap" is used to differentiate it from an index-organized table or external table. If a row is moved within a heap-organized table, the row's ROWID will also change. [@more@]An index-organized table (IOT) is a type of table where the data is stored in a B*Tree index structure.

不懂，抄的：DIMM（Dual Inline Memory Module，双列直插内存模块）与SIMM相当类似，不同的只是DIMM的金手指两端不像SIMM那样是互通的，它们各自独立传输信号，因此可以满足更多数据信号的传送需要。[@more@]同样采用DIMM，SDRAM 的接口与DDR内存的接口也略有不同，SDRAM DIMM为168Pin DIMM结构，金手指每面为84Pin，金手指上有两个卡口，用来避免插入插槽时，错误将内存反向插入而导致烧毁；DDR DIMM则采用184Pin DIMM结构，金手指每面有92Pin，金手指上只有一个卡口。卡口数量的不同，是二者最为明显的区别。DDR2 DIMM为240pin DIMM结构

Manually drop user sysman:i. Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and mangement objects:drop user sysman cascade;drop role MGMT_USER;drop user MGMT_VIEW cascade;drop public synonym MGMT_TARGET_BLACKOUTS;drop public synonym SETEMVIEWUSERCONTEXT;[@more@]ii. Delete the dbconsole configuration files :$ORACLE_HOME/<hostname_SID> directory$ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<hostname_SID> directoryMake sure the <hostname>_<sid> folder is ALL gone o

Use mail in 1 script and notice mail subject is always missing.[@more@]Quote from Berkeley :mail vs. mailx: Berkeley mail users may note that when they type "mail" on a Solaris system, the Subject: prompt does not show up. On all Solaris systems, you should not use "mail", you should use "mailx". The vendor did it this way to be compatible with other System V-based UNIX systems. On System V, "mail" has a certain set of parameters and a certain operating mo

endianformats (byte ordering)Byte ordering can affect the results when data is written and read. For example, the 2- byte integer value 1 is written as 0x0001 on a big-endian system (like Sun SPARC Solaris) and as 0x0100 on a little-endian system (such as an Intel-compatible PC). [@more@]laughed at Jasmine:-(SELECT tp.endian_formatFROM v$transportable_platform tp,v$database dWHERE tp.platform_name = d.platform_name;

不懂得怎么写SQL在BO端直接写了个明显有问题的语句，在数据库里跑了2个多小时没出来，晕。[@more@]真是路漫漫啊。

Fixing steps:1. Stop the dbconsole2. Relink the agent component manually using this procedure : 2.1 Make a copy of $ORACLE_HOME/sysman/lib/env_sysman.mk (as backup) 2.2 Edit the script $ORACLE_HOME/sysman/lib/env_sysman.mk adding $(LIBNMO) as follows: - search the link line looking for string "MK_EMDW_LIBNMEMSO_SHLIB" - replace the line $(LIBNMEM) $(LIBNMER) with $(LIBNMEM) $(LIBNMER) $(LIBNMO) 2.3 Perform the following relink: % cd $ORACLE_HOME/sysman/lib % make -f ins_sysman.mk age

网络传输量的分析: Data Guard只传输一份日志文件 磁盘镜像技术将传输交易所在的所有数据块以及归档日志、控制文件等数据 磁盘镜像技术无法区分出无效的IO，如大量临时表操作、排序操作等产生的IO[@more@]投资回报率投资回报率（ROI）分析分析 Data Guard Data Guard不需要单独的license 备份数据库可以建立在低档系统和廉价的磁盘阵列中 网络只要求标准的TCP/IP、带宽要求不高 Active Data Guard可以提高灾备系统的投资利用 磁盘镜像技术 单独的软件license（如SRDF、VeritasVVR等） 生产系统和备份系统必须存储设备同构 网络

emca -config dbcontrol db -repos recreateCONFIG: ORA-28003: password verification for the specified password failedORA-20003: Password should contain at least one [@more@]Fixed by the following steps:---------update default profile begin ------alter profile default limitpassword_verify_function null;select resource_name, resource_type, limit from dba_profiles where resource_name='PASSWORD_VERIFY_FUNCTION';RESOURCE_NAME RESOURCE LIMIT-------------------------------- -------- ---------------------

It's _inside_ the bos.adt fileset, which is on the first CD. Execute smit installp, input the correct directory,and manually select the fileset to install be pressing F4. Scroll down until you find the bos.adt stuff. Select libm with F7.[@more@]Oracle 10g pre-required checking can use:lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstat bos.perf.proctools rsct.basic.rte xlC.rte xlC.aix50.rte