2015年09月_loryliu

12月 11月 10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

转载 How to collect the full path name of the files in ASM diskgroups (文档 ID 888943.1)

In this Document Goal FixAPPLIES TO:Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]Information in this document a

2015-09-30 16:41:34 460

转载 Oracle: Network Waits

Contents1 Introduction2 SQL*Net Wait Events2.1 SQL*Net message from client2.2 SQL*Net message to client 2.3 SQL*Net more data to client 2.4 SQL*Net more data from client2.5 SQL*N

2015-09-29 16:36:45 592

转载 Execute to Parse及Soft Pars

The ratios quoted can be derived from the above as follows:Execute to Parse %: 100 * (Executes - Parses) / ExecutesSoft Parse %: 100 * (Parses - Hard Parses) / ParsesSo why not look at P

2015-09-28 11:20:27 487

转载观察UDP buffer size 情况

UDP is a perfectly viable protocol. It is the same old case of the right tool for the right job!If you have a program that waits for UDP datagrams, and then goes off to process them before returning

2015-09-26 10:58:00 3077

转载 Know more about RAC statistics and wait event

以下列出了RAC中的主要统计信息和等待事件： 1. Statistics:1.1 V$SYSSTAT, V$SESSTAT (join to V$STATNAME)gc cr blocks servedgc cr block build timegc cr block flush timegc cr block send timegc current blocks servedgc

2015-09-22 22:18:22 1356

原创使用onsctl ping显示ons is not running

显示如下[oracle@sdb1 ~]$ onsctl pingNumber of configuration nodes retrieved: 30: {node = sdb2.liteon.com, port = 6200}Adding remote host sdb2.liteon.com:62001: {node = sdb1.liteon.com, port = 62

2015-09-20 09:54:33 1107

原创手工添加RAC Instance

手工添加RAC Instance1 环境准备 10.2.0.5 on Oracle Linux 5.8 ；SDB2,SDB3上已经正常配置了Instance，现在要添加SDB1到RAC；SDB1上Cluster已经正常安装，Oracle Home及ASM Home已经是RAC Enabled；ASM instance已经在SDB1上正确配置并启用以下步骤是如何手工添加SDB

2015-09-18 08:50:29 723

转载设置 oracle sqlplus DBMS_OUTPUT.put_line

1 设置DBMS_OUTPUT.put_line输出显示 SET SERVEROUTPUT ON 2 关闭DBMS_OUTPUT.put_line输出显示 SET SERVEROUTPUT OFF 3 设置DBMS_OUTPUT缓冲区大小 SET SERVEROUTPUT ON SIZE number（1000） 4 设置只显示DBMS_OUTPUT默认的长度

2015-09-16 10:14:38 2454

转载 semi joins

2) semi joins are joins that stop when the first hit is encountered. They are used many times for "existence" checks.select * from dept where deptno in (select deptno from emp);that could use

2015-09-14 22:30:48 329

转载 Understanding Explain Plan

Benjamin Disraeli, circa 1870 wrote:Never complain and never explain.Disraeli was a lot of things, but Oracle Programmer was not amongst them. To be fair, perhaps he wasn't talking about

2015-09-11 08:58:46 376

原创如何修改thread 为public或private

10.2.0.5 on oracle linux 5.8 oracle clusterware3 nodes: sb1, sdb2, sdb3，其中两个thread 是private的OPEN PRIVATE1 RACTEST2 SDB2OPEN PUBLIC 2 RACTEST1 SDB1OPEN PRIVATE 3 RACTEST3

2015-09-10 11:31:54 1751

转载 Convert Single Instance to RAC – Part 2: Manually Convert to RAC

In part 1 I explained how to duplicate a single instance database using RMAN. This article will focus on converting the single instance to RAC.2. Convert Single instance to RACWe have migrat

2015-09-09 20:44:24 667

转载 Initialization Parameter files: PFILEs vs. SPFILEs

Initialization Parameter files: PFILEs vs. SPFILEsSubmitted by admin on Sun, 2003-08-03 19:29RDBMS ServerWhen an Oracle Instance is started, the characteristics of the Instance are estab

2015-09-09 19:43:57 438

转载 ASMCMD fails to start on module libnnz10.so, permission denied

10.2.0.5 on oracle linux 5.8使用asmcmd出现以下错误：[oracle@sdb2 ~]$ export ORACLE_SID=+ASM1[oracle@sdb2 ~]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1[oracle@sdb2 ~]$ export ORACLE_HOME=/u01

2015-09-08 15:02:03 694

原创如何查看RAC中spfile在何位置

10.2.0.5 on oracle linux 5.8使用如下命令查看：[oracle@sdb2 tmp]$ ocrdump -stdout -keyname DATABASE.DATABASES.ractest.SPFILE09/07/2015 14:24:00ocrdump -stdout -keyname DATABASE.DATABASES.ractest.SPFILE

2015-09-07 14:27:04 1779

转载 Connected to an idle instance-RAC 10.2.0.4.1

从以下文章可以得出在设定ORACLE_HOME环境变量的时候注意后面不要跟"/"，如下设定是正确：ORACLE_BASE=/u01/app/oracleORA_CRS_HOME=/u01/crs/oracle/product/10.2.0/crsORA_ASM_HOME=/u01/app/oracle/product/10.2.0/asmORACLE_HOME=/u01/app

2015-09-07 10:03:17 737

原创使用dbca添加new instance时报

10.2.0.5 on oracle linux 5.8已经有两个节点SDB1,SDB2 ，现在要使用DBCA添加第三个节点，在进行到以下步骤时出现错误。SID given in the connect descriptor could not be resolved.Connection to the database cannot be established be

2015-09-06 17:06:36 1656

原创 TNS-04612 error

10.2.0.5 on oracle linux 5.8使用dbca,在RAC添加第三个节点时报错 TNS-04612: Null RHS for "an tnsnames entry"。网上查到应该是tnsnames.ora里面对应的entry格式有问题造成的。之前该entry的格式如下：RACDB_LISTENER = (DESCRIPTION= (ADDRE

2015-09-06 10:00:29 1326

转载 How to Delete From or Add Resource to OCR in Oracle Clusterware (文档 ID 1069369.1)

How to Delete From or Add Resource to OCR in Oracle Clusterware (文档 ID 1069369.1)转到底部转到底部 In this DocumentGoalFix A. Terms/Variables used in this note B. Resource must be managed by

2015-09-06 09:54:04 1169

转载 Adding Users to Passwordfile / Using Passwordfile Authentication (Doc ID 184696.1)

Adding Users to Passwordfile / Using Passwordfile Authentication (Doc ID 184696.1)To BottomAPPLIES TO:Oracle Database - Enterprise Edition - Version

2015-09-05 22:17:38 503

转载 Correlation between MAXLOGHISTORY & CONTROL_FILE_RECORD_KEEP_TIME

Saibabu -- Thanks for the question regarding "Correlation between MAXLOGHISTORY & CONTROL_FILE_RECORD_KEEP_TIME", version 8.1.7Submitted on 5-Oct-2001 20:26 UTCTom's latest followup | Bookmark |

2015-09-01 21:38:50 778