ITPub博客

Diskgroup resource shows status offline after restart even it is mounted in ASM instance [ID 1065158.1] 修改时间 28-FEB-2010 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 - Release: 11.2Information in this document applies to any platform. Symptoms After restart the 11.2 HAS stack, the di

ALERT.LOG for ASM Shows "WARNING: failed to online diskgroup resource ora.GI.dg (unable to communicate with CRSD/OHASD)" [ID 1060920.1] 修改时间 12-AUG-2011 类型 PROBLEM 状态 MODERATED In this Document Symptoms Cause Solution This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject

select owner,constraint_name, constraint_type, table_name, delete_rule from DBA_constraints WHERE table_name='ZWKMZD'列delete_rule的返回结果若是为CASCADE ，就表示是级联删除[@more@]

What is the Maximum Datafile Size Limit In an Oracle Database? [ID 804733.1] 修改时间 16-MAY-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution From the Database Perspective From the Operating System Perspective References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2Information in this document applies to any pl

Bigfile Tablespaces A bigfile tablespace is a tablespace with a single, but very large (up to 4G blocks) datafile. Traditional smallfile tablespaces, in contrast, can contain multiple datafiles, but the files cannot be as large. The benefits of bigfile tablespaces are the following: A bigfile tablespace with 8K blocks can contain a 32 terabyte datafile. A bigfile tablespace with 32K blocks can contain a 128 terabyte datafile. The maximum number of datafiles in an Oracle Database is

以下转自张乐奕的ppt：1. 本机的tnsnames.ora设置为：INTERTOL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.3.201)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.3.202)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.3.203)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.3.204)(PORT = 1521)) (LOAD_BALANCE = yes) ) (CONNECT_DATA = (SERVICE_NAME = intertol) (FAILOVER_MODE= (TYPE=SELECT) (METHOD

Microsoft Windows [版本 5.2.3790](C) 版权所有 1985-2003 Microsoft Corp.C:Documents and SettingsAdministrator>set oracle_sid=ora11gC:Documents and SettingsAdministrator>sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:46:10 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> create user test1

以下参考oracle 官方文档：The COMPATIBLE database initialization parameter must be set to 11.0 or higher to usethe real-time query feature of the Active Data Guard option.A physical standby database instance cannot be opened if Redo Apply is active on amounted instance of that database. Use the following SQL statements to stop RedoApply, open a standby instance read-only, and restart Redo Apply:SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;SQL> ALTER DATABASE OPEN;SQL> ALTE

goldengate 在rhel5.5 oracle 10g/11g x64bit中的自动启动背景描述：goldengate安装于/u01/ggs目录下rhel5.5 oracle 10g/11g x64bitOracle GoldenGate Command Interpreter for OracleVersion 11.1.1.0.0 Build 078Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 13:13:42实现goldengate 自动启动的步骤：1.用oracle用户建立/u01/info.txt，文件内容如下：sh datestart mgr2.chmod +x info.txt3.用oracle用户建立/u01/startmgr.sh，文件内如下：/u01/ggs/ggsci paramfile /u01/info.txt >> /u01/ggstartoutput.txt4.chmo

1. 做dataguard升级<Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1]><Data Guard Support for Heterogeneous Primary and Logical Standbys in Same Data Guard Configuration [ID 1085687.1]>2.Changing between 32-bit and 64-bit Word Sizes [ID 62290.1]3.Can you / How to Upgrade RDBMS and Convert From 32-bit to 64-bit Binaries Directly on Linux or Windows based Intel Platforms Using the Database Upgrade Assistant (DBUA) [ID 75724

Complete checklist to upgrade the database to 11g R2 using DBUA [ID 870814.1] 修改时间 01-AUG-2011 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Application Complete checklist to upgrade the database to 11g R2 using DBUA REQUIRED POST UPGRADE STEPS References Applies to: Oracle Server - Standard Edition - Version: 9.2.0.8 to 11.2.0.2 - Release: 9.2 to 11.2Oracle Server - Enterpris

Oracle Database on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2) [ID 169706.1][@more@]

Linux索引节点(inode)用满导致的一次故障 一、发现问题　　 在一台配置较低的Linux服务器（内存、硬盘比较小）的/data分区内创建文件时，系统提示磁盘空间不足，用df -h命令查看了一下磁盘使用情况，发现/data分区只使用了66%，还有12G的剩余空间，按理说不会出现这种问题 二、分析问题 后来用df -i查看了一下/data分区的索引节点(inode)，发现已经用满(IUsed=100%)，导致系统无法创建新目录和文件 inode译成中文就是索引节点，每个存储设备（例如硬盘）或存储设备的分区被格式化为文件系统后，应该有两部份，一部份是i

Getting ORA-00604 ORA-01422 When Trying To Drop A Table [ID 453528.1] 修改时间 15-AUG-2007 类型 PROBLEM 状态 MODERATED In this Document Symptoms Cause Solution References This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review. Applies to: Oracle Server - Enterprise Ed

数据库配置文件已经安装到 D:appAdministrator,同时其他选定的安装组件也已经安装到 D:appAdministratorproduct11.2.0dbhome_1。 您需要在远程节点上执行 <Oracle Home>binselecthome.bat 以激活以下产品: Oracle Data Provider for .NET Oracle Provider for OLE DB Oracle Objects for OLE Oracle Counters for Windows Performance Monitor Oracle Administration Assistant Microsoft Windows [版本 6.1.7600] 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。 C:UsersAdministrator>sqlplus / as

goldengate 支持ddl的数据库类型：oracle 和teradata其他的数据库诸如sqlserver，sybase，db2，goldengate是不支持ddl复制的。metalink文章Does Oracle GoldenGate(OGG) support DDL Replication for DB2 [ID 1303729.1]说明了如下情况：OGG does not support DDL replication for DB2 database [@more@]

Is GoldenGate Compatible Between Different Releases? [ID 965423.1] 修改时间 19-MAY-2011 类型 HOWTO 状态 PUBLISHED In this Document Solution Applies to: Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]Information in this document applies to any platform. Solution Issue:Are my Oracle GoldenGate versions compatible?Solution Overview:Yes, Oracle GoldenGate has been designed to be bac

Goldengate Replicat Ignores "Alter Table Rename" DDL [ID 1216846.1] 修改时间 16-DEC-2010 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution References Applies to: Oracle GoldenGate - Version: 10.4.0.19 and later [Release: 10.4.0 and later ]Information in this document applies to any platform. Symptoms Source: as user PRICERC1 - ALTER TABLE test RENAME TO bkup_test; Ta

V$RMAN_STATUS 视图 V$RMAN_STATUSdisplays the finished and on-going RMAN jobs. For on-going jobs, this view displays progress and status. The jobs which are in progress are stored only in memory while the finished jobs are stored in the controlfile.V$RMAN_STATUS显示已完成和正在进行的RMAN任务。对于正在进行的任务，显示 progress 和 status，这些信息仅存在于内存中。当任务结束后，信息将存在控制文件中。ColumnDatatypeDescriptionSIDNUMBERSession ID of the session which is running this RMAN operati

V$RMAN_OUTPUT 视图 V$RMAN_OUTPUTdisplays messages reported by RMAN. This is an in-memory view and is not recorded in the controlfile. The view can hold 32768 rows.V$RMAN_OUTPUT 视图记录了RMAN生成的信息，这是在内存中额视图，不会记录到控制文件上。最多有37278条记录。ColumnDatatypeDescriptionSIDNUMBERSession ID of the session which is running this RMAN operationRECIDNUMBERRecord ID of the correspondingV$RMAN_STATUSrowSTAMPNUMBERTimestamp of the correspondingV$RMAN_STATUSrowSESSION_RECIDNUMBERRe