冰释镜湖-CSDN博客

原创 What Happens When A Tablespace/Database Is Kept In Begin Backup Mode (Doc ID 469950.1)

GoalThis document explains in detail about what happens when a tablespace/datafile is kept in hot backup/begin backup mode.SolutionTo perform online/hot backup we have to put the tablespace in begin b

2015-05-11 13:03:36 1703 1

原创 Colored SQL--How to force the AWR to capture a specified SQL even if it is not the top one

This new feature doesn't paint the SQL statement in color; rather, it sort of marks it as "important."Suppose you are troubleshooting a performance issue and you suspect a specific SQL statement contr

2014-11-24 11:11:24 1907

转载 STARTUP Database failed ORA-38760 to turn on Flashback Database (Doc ID 1554596.1)

Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterInformation in this document applies to any platform.SymptomsThis is not RAC specific and could happen in Single Instances

2014-09-25 15:45:06 5211

转载 Start Of ONS Resource Fails With CRS-2672, CRS-5016, CRS-2674 and CRS-4000

(Doc ID 1633123.1)Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterInformation in this document applies to any platform.SymptomsThe ONS resource shows state OFFLINE for on

2014-08-22 12:18:38 5159

原创 OUI-67076 : OracleHomeInventory was not able to create a lock file" in Unix

Symptoms The command "opatch lsinventory" reports the error: OUI-67076:OracleHomeInventory was not able to create a lock file, probably due to a failed OPatch Session. The loaded inventory might not

2014-08-14 12:33:13 3243

转载 How To Check Whether Physical Standby is in Sync with the Primary or Not?

The following tips will help you in monitoring sync between primary and standby databases.How To Check Whether Physical Standby is in Sync with the Primary or Not?1. Check for GAP on standby2. C

2014-04-08 16:36:32 1879

原创 Data Guard Gap Detection and Resolution (Doc ID 232649.1)

Overview:===============An archive gap is a range of missing archived redo logs created whenever the standby system is unable to receive the next archived redo log generated by the primary databa

2014-04-08 16:32:22 3184

原创 How to move a datafile from a file system to ASM (Doc ID 390274.1)

This note will guide a DBA in moving a datafile currently located on file system to an ASM diskgroup.SolutionHow to move a datafile from a file system to ASMMoving a datafile from the file

2014-03-13 15:50:28 1453

原创关于 Dead Connection Detection, Resource Limits, V$SESSION, V$PROCESS and OS processes ( 601605.1)

Applies to: Oracle Database - Enterprise Edition - Version 8.0.3.0 and laterOracle Net Services - Version 9.2.0.1 and laterInformation in this document applies to any platform.GoalDiscuss wh

2014-01-09 10:43:55 2413

原创 How To Install 11.2 / 12.1 Database/Client Software In Silent Mode Without Using Response File

Applies to: Oracle Universal Installer - Version 11.2.0.1 and laterOracle Database - Enterprise Edition - Version 11.2.0.1 and laterOracle Database - Standard Edition - Version 11.2.0.1 and late

2014-01-04 21:53:26 6726

原创 How to install Oracle Database Server software silently with customized listener configuration

Applies to: Oracle Universal Installer - Version: 10.2.0.1 and later [Release: 10.2 and later ]Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later [Release: 10.2 and later]Orac

2014-01-04 21:41:16 2308

转载 How to Check and Enable/Disable Oracle Binary Options (Doc ID 948061.1)

Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.1 [Release 10.2 to 12.1]Other UNIXGoalTo show how to install/deinstall and/or disable/enable the following databas

2014-01-03 10:35:30 5482

原创《Excel 2013 Power Programming with VBA》试译样文

source：What Makes a Good Utility?An Excel utility, of course, should ultimately make your job easier or more efficient. But if you’redeveloping utilities for other users, what makes an Excel uti

2013-12-24 18:32:24 2397

转载 RMAN RESTORE FAILS WITH RMAN-06023 BUT THERE ARE BACKUPS AVAILABLE (Doc ID 965122.1)

Applies to: Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]Information in this document applies to any platform.***Checked for relevance on 29-Mar-2012

2013-12-23 17:57:59 1906

原创 How to create a Oracle 11g RAC Database manually without DBCA ?

From now on, Write everything in English.To create a Oracle 11g RAC database manually, there should be a ready RAC env, and you should following the steps below.1.Create a Single instance Databa

2013-12-20 12:50:43 3410

原创 Script to Collect Data Guard Physical and Active Standby Diagnostic Info for 10g and above(+RAC)

2013-12-19 16:27:38 3125

原创 Script to Collect Data Guard Primary Site Diagnostic Information for Version 10g and above(+RAC)

2013-12-19 15:56:28 2693

转载 init: Id "co" respawning too fast: disabled for 5 minutes

init: Id "co" respawning too fast: disabled for 5 minutesFrom Linux syslog (i.e., /var/log/messages), we have found the following repeated messages:Dec 17 04:21:41 myserver init: Id "co" res

2013-12-19 14:14:49 3262

转载 Step By Step Guide To Create Physical Standby Database Using RMAN Backup and Restore (Doc ID 469493.

In this Document Goal Solution ReferencesApplies to: Oracle Database - Enterprise Edition - Version 9.0.1.0 to 11.2.0.3 [Release 9.0.1 to 11.2

2013-12-19 10:07:28 2226

转载 Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE (Doc ID

In this Document Goal Solution ReferencesCreated from SR 3-1430829871[This section is not visible to customers.]Applies to:

2013-12-19 10:05:30 3373

原创 How to create Oracle 11g R2 database manually in ASM?

Step 1: Specify an Instance Identifier (SID)export ORACLE_SID=maomiStep 2: Ensure That the Required Environment Variables Are Setexport ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1

2013-12-18 22:40:49 2123

转载 How to Setup Active DataGuard on Exadata (Doc ID 1580796.1)

APPLIES TO:Oracle Exadata Storage Server Software - Version 11.2.2.3.5 to 11.2.3.2.1 [Release 11.2]Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]Information i

2013-12-13 22:18:10 2475

原创 Free Linux Memory by Dropping Caches

Linux Kernels 2.6.16 and up provide a way to instruct the kernel to drop the page cache, inode and dentry caches on command. This tip can help free Linux memory without a reboot.Note: This is a

2013-12-13 14:14:07 1540

原创 All about control file in Oracle Database

--数据库实例启动的三个阶段：NOMOUNT(START):打开初始化参数文件MOUNT:打开控制文件OPEN:打开数据文件和日志文件 --控制文件控制文件的作用：管理数据库的状态和描述数据库的物理结构信息。控制文件主要包含如下信息：数据库名数据库标识符DBID数据库创建时间戳数据库字符集数据文件信息临时文件信息在线重做日志信息近期的归档

2013-10-31 15:51:01 1552

原创 ORA-27033:additional information:maxsems = 4004,verify_semcnt = 0 解决办法

今天在一个 RAC 上创建 RAC one node 数据库时遇到如下错误：费尽一般周折在网上和MOS上找来找去，发现这个错误代码的原因很多，从 ORA-27302 的输出可以区别，本例是由于内核参数中kernel.sem 值太小，导致无法操作系统无法分配更多的空间来启动建库时要启动的进程。改大即解决。[root@slcah434 ~]# sysctl -p |

2013-10-31 12:37:34 3310

原创 How to dump redo log entry？

1.转储针对特定数据块（4号文件的第10-20号数据块）修改的 redo entryselect file#,name,blocks from v$datafile; FILE# NAME BLOCKS---------- ----------------------------

2013-10-29 10:08:32 1816

原创 All about rowid in Oracle Database 11g

SQL> select t.rowid,t.* from scott.test t;ROWID DEPTNO DNAME LOC------------------ ---------- -------------- -------------AAAPtpAAEAAAADbAAA 10 ACCOUNTING

2013-10-28 13:14:14 1764

原创 How to open and close wallet for Oracle Databse 11g?

1.Add the following entries in the $ORACLE_HOME/network/admin/sqlnet.ora (Note it is the DB's ORACLE_HOME not the GRID'S ORACLE_HOME)Make sure that the DIR you specified in the sqlnet.ora exist on t

2013-10-28 09:36:30 2465

原创 Oracle Database 11g Release 2 DBCA Error At Adding Oracle JVM When Creating A Database With A Datab

Applies to: Oracle Multimedia - Version: 11.2.0.1 and later [Release: 11.2 and later ]Information in this document applies to any platform.SymptomsCreating a database with template in Oracle

2013-10-25 13:51:03 3615

转载 Linux 中与 Oracle Database 相关的内核参数详解

在安装Oracle的时候需要调整linux的内核参数，但是各参数代表什么含义呢，下面做详细解析。Oracle官方安装文档中给出的最小值：fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 4294967295kernel.shmmni = 4096kerne

2013-10-25 12:08:16 1843

原创 How to manage Oracle Database User profile

SQL> set linesize 200SQL> col TEMPORARY_TABLESPACE for a25SQL> col DEFAULT_TABLESPACE for a25 SQL> col USERNAME for a25SQL> col ACCOUNT_STATUS for a25SQL> select USERNAME,ACCOUNT_STATUS,D

2013-10-22 16:16:34 1609

转载 How to Add the JVM Component to an Existing Oracle Database (Doc ID 1461562.1)

Applies to: Oracle Server - Enterprise Edition - Version 11.2.0.1.0 and laterInformation in this document applies to any platform.This article details how to install the JVM in an existing Oracl

2013-10-21 10:27:01 1474

原创 Oracle GoldenGate 常见问题：长事务处理

长事务的影响 OGG是基于事务级的实时复制工具，也就是说OGG只复制已提交的事务，在遇到事务的commit或rollback之前，它会将每个事务的操作存储在称为cache的托管虚拟内存池中。内存再大也有不够用的时候，当事务数据超过一定的阈值或者当前空闲内存无法满足分配请求时，OGG进程会将最少使用的old buffer swap 到磁盘上的dirtmp中。当OGG遇到长事务时

2013-09-18 16:46:57 5210

原创 Oracle GoldenGate 数据同步初始化最佳实战（Data Pump）

全链路初始化标准化流程：1）验证同步链路连通性使用infoextract/pump/replicat,detail命令核实同步链路各进程 trail 文件及检查点是否一致，如不一致，需要使用如下语句接通，如有必要还可在初始化开始前进行DML测试 alter extract/pump/repilcatextseqno,e

2013-09-16 14:20:41 3738 2

原创 Oracle GoldenGate 系列：使用 Oracle ASM API DBLOGREADER 时遇 ora-01031 错误

今天在自己新搭建的 Oracle ACFS 文件系统上测试 GoldenGate ，启动 extract 进程报如下错误：2013-08-27 14:58:39 ERROR OGG-00446 Opening ASM file +FRA/rac/archivelog/2013_08_27/thread_1_seq_84.357.824568733 in DBLOGREADER

2013-08-27 15:20:46 4387

原创 Oracle 11g R2 ASM:了解 Oracle ASM 基本概念

About Oracle ASM InstancesAbout Oracle ASM Disk GroupsAbout Mirroring and Failure GroupsAbout Oracle ASM DisksAbout Oracle ASM FilesAbout Oracle ASM InstancesOracle ASM 实例基

2013-08-24 09:16:08 5337

原创 Oracle 11g ASM：如何在 ASMCMD 命令行工具中创建 Oracle ACFS 文件系统

实验环境：Oracle 11g R2 RAC （11.2.0.3.5） Oracle Enterprise Linux 5.6 x861、创建 ASM 磁盘组在两节点挂好磁盘后，在第一节点上对磁盘进行分区[root@rac1 ~]# fdisk -lDisk /dev/sde: 2147 MB, 2147483648 bytes2

2013-08-18 20:29:48 4060

原创 Why Does GoldenGate Report The Lag Is Unknown or a Timestamp Mismatch? (Doc ID 968614.1)

Issue: Why does GoldenGate report the Lag is unknown? The "Lag" command fails with "Timestamp Mismatch". Sometimes the "Info All" will also show the Lag is unknown.How to troubleshoot the pr

2013-08-10 19:53:55 5155

原创 OGG Extract displays Discarding bad record (discard recs = 1) when using filter or where clause [ID

Applies to:Oracle GoldenGate - Version 10.0.0.1 and laterInformation in this document applies to any platform.Symptoms 1. I am using filter or where clause in extract parameter file and

2013-07-27 22:52:53 1651

原创 Expdp For Metadata Is Slow In 11.2.0.3 With Partitioned Objects [ID 1466040.1]

Applies to:Oracle Server - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]Information in this document applies to any platform.Symptoms- 11.2 Database with partitioned objec

2013-07-07 23:33:03 6428