ITPub博客

RMAN> catalog start with '<directory_path>';

最近发现某一时段数据库入库比较慢，并且查到入库慢的sql是一个简单的insert语句，而不是insert...select。从等待事件看这个sql等待的主要事件是gc cr multi block request事件。这个等待事件比较奇怪，因为multi bl...

metalink note 283107.1介绍了如何设置VIP的IPMP，此处记录一下设置过程。 o Existing 10g RAC installation ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ For existing 10g RAC installations, use srvctl to mod...

To use DRM or not to use DRM 10g Real Application Clusters introduced a concept of resource remastering via Dynamic Resource Mastering (DRM). With DRM a resource can be re-mastered on anoth...

oracle documents:library cache lockThis event controls the concurrency between clients of the library cache. It acquires a lock on the object handle so that either:    *  &nbs...

Oracle Block change Tracking improves the incremental Backup performance and is used to record changed blocks in each datafile in a change tracking file. If change Tracking is enabled, RMAN uses blo...

http://www.oracle-home.ro/Oracle_Database/Architecture/Oracle-service-name.htmlLook at these cases and see how an Oracle service is named function of the pfile/ spfile parameters.Listener.ora...

http://www.orafaq.com/node/2033How to Identify OS or Oracle 64 bit or 32 bit on Unix---------------------------------------------------------------It is very common question which version of oracle ...

今天遇到一个奇怪问题，发现srvctl和crs_start命令无法启动Oracle RAC实例，但用sqlplus却可以正常启动。最终发现原因是在OCR中数据库的状态变成了disable，将此状态更改为enable后恢复正常。以下是一个模拟示例：or...

utlrp.sql用来编译数据库内无效的对象，但有时可能会遇到utlrp.sql执行时间很长的情况。utlrp.sql执行时间长的可能原因之一是数据库并行度过高。以下是在2节点的RAC环境下的测试情况。环境：主机:：2台 ...

http://arjudba.bot.clogspom/2010/07/troubleshoot-ora-12547-tns-lost-contact.htmlProblem DescriptionWhenever you connect to database as sysdba it fails with ORA-12517 like below.$ sqlplus / as sysdba...

Configuring IPMP for private cluster InterconnectsHi,It is advisable to first have a look at the post configuring IPMP on Solaris with oracle RAC before going through this post.With IPMP configured f...

Oracle 10 with RAC MPXIO and ASM installation on Solaris 10 By AkH, 2 years, 11 months ago, modified Nov. 23, 2006 oracle Oracle database is fairly simple t...

/var/tmp/.oracle目录下保存着一些socket文件，如果删除该目录可能会引起oracle故障。http://it.toolbox.com/wiki/index.php/Var/tmp/.oracle_hidden_directoryWhen Your Database is Unix RAC cluster ...

http://asktom.oracle.com/tkyte/Mutate/index.htmlAvoiding Mutating TablesOk, so you've just recieved the error:ORA-04091: table XXXXis mutating, trigger/function may not see itand you want to get ...

http://jonathanlewis.wordpress.com/2006/11/09/dbms_xplan-in-10g/dbms_xplan in 10gFiled under: Execution plans, Hints, Tuning — Jonathan Lewis @ 9:17 pm UTC Nov 9,2006 [More in dbms_xpla...

http://arjudba.blogspot.com/2008/05/use-select-any-dictionary-or.htmlUse SELECT ANY DICTIONARY or SELECT_CATALOG_ROLE or SELECT ANY TABLEIn this topic I will try to make you understand the differ...

在安装CRS时系统会要求输入cluster name, 缺省值是crs。安装后如果想查cluster name,可以从OCR中得到。执行ocrdump命令，然后从OCRDUMPFILE中找出clustername.......[SYSTEM.css.clustername]ORATEXT : crsS...

添加和删除VoteDisk:(版本10.2.0.1)[root@rac1pub ~]# crsctl query css votedisk 0.     0    /dev/raw/votedisk1 1.     0    ...

1. 备份　1.1 备份Oracle Inventory, CRS_HOME, ORACLE_HOME.　　　　使用tar命令备份。Inventory的位置记录在文件/etc/oraInst.loc  1.2 备份数据库2. 升级CRS  1.1 安装CRS升级软件  1.2 CRS rolli...