ITPub博客

SID_LIST_LISTENER_CMSUN17 =(SID_LIST =    (SID_DESC =        (SID_NAME = ICMLSExtProc)        (ORACLE_HOME = /oracl...

Root user to perform. the following scripton node1------------cd $ORA_CRS_HOME/install./rootdelete.shon node2------------cd $ORA_CRS_HOME/install./rootdelete.shon node1 only--------------cd $ORA_C...

Metalink 283684.1Purpose:----------------The purpose of this note is to describe how to change or update the cluster_interconnect and/or public interface IP information that is stored in the OCR.&nbsp...

Metalink 276434.1Purpose--------------The purpose of this note is to illustrate the changing of a Virtual IP Address (VIP) or VIP hostname or other VIP parameters in an Oracle10g RAC/Oracle Clusterwar...

问题描述： 3节点的Oracle 10.2.0.3版本RAC Oracle Patch  merge6平台上主机P570，操作系统AIX 5***没有压力状态下，拔掉节点node1的2根public网线，发现VIP重启累计用时如下：      ...

     When a node stops and restarts, Oracle Clusterware starts the instance as soon as the node starts. This may not be desirable because instance startup might fail if system ...

ACTIVE_INSTANCE_COUNT enables you to designate one instance in a two-instance cluster as the primary instance and the other instance as the secondary instance. This parameter has no functionality in a...

PURPOSE-------The purpose of this document is to help DBA's and support analysts understand howto clean up a failed CRS (Cluster Ready Services) install for 10g RAC. SCOPE & APPLICATION----------...

一、添加OCR1) 停止crs，分别在所有节点执行# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl stop crsStopping resources.Successfully stopped CRS resourcesStopping CSSD.Shutting down CSS daemon.Sh...

For optimal performance, you’ll want to keep the library cache reload ratio [sum(reloads) /sum(pins)] at zero and the library cache hit ratio above 95 percent. If the reload ratio is not zero, then t...

The data dictionary cache is a key area to tune because the dictionary is accessed so frequently, especially by the internals of Oracle. At startup, the data dictionary cache contains no data. But as ...

Here is a query that will show you the time between log switches. It can be handy in determining if you have a problem:select b.recid,to_char(b.first_time,'dd-mon-yy hh:mi:ss') start_time, a.recid,to_...

Use ASSM instead of FREELISTS, FREELIST GROUPS, and PCTUSED.In version 9i of the database, Oracle introduced Automatic Segment Space Management, as an alternative to using free lists, in locally manag...

It is recommended that you regularly monitor your database to find segments that are growing to extreme numbers of extents (over a thousand) and then manage those segments appropriately.select seg...

You can look at the chained and migrated rows of a table or cluster using the ANALYZE statement with the LIST CHAINED ROWS clause. The results of this statement are stored in a specified table cre...

 We can retrieve the information regarding partitions by accessing user_tables, dba_part_tables,and user_segments. Example queries to these three tables are displayed next with corresponding outp...

9.2.0.4 = 30952779.2.0.5 = 35019559.2.0.6 = 39484809.2.0.7 = 41634459.2.0.8 = 454780910.1.0.3 = 376184310.1.0.4 = 416336210.1.0.5 = 450513310.2.0.2 = 454781710.2.0.3 = 533701410.2.0.4 = 6810189...

For lob data we should pay attention for two options:store as (CHUNK NK disable storage in row/enable storage in row) that we specified during the table creation means whether allow the Lob data to be...

Get the snapshot with level=>6-------------------------------------------exec statspack.snap(i_snap_level => 6);exec statspack.snap(i_snap_level => 6);Generate the report -----------------------------...

How to enable the flashback database:--------------------------------------[root@plinuxt19 ~]# su - oracle[oracle@plinuxt19 ~]$ sqlplus /nologSQL*Plus: Release 10.2.0.3.0 - Production on Tue Feb 3 10:...