ITPub博客

修改时间 12-AUG-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 - Release: 10.1 to 11.1Information in this document applies to any platform. ***Checked for relevance on 27-Feb-2011*** Goal Is there any list of limits when configuring an ASM instance ? Solution ASM imposes the following limits:63 disk groups in a storage system10,0

ORA-15196 WITH ASM DISKS LARGER THAN 2TB [ID 736891.1]此问题是bug，此问题在The fix prevents using disks larger than 2TB and is included in the following patchsets: 10.2.0.4 11.1.0.7 被修复。准确的说，asm disk 大小超过2t并且在超过2t的空间中分配空间时报错ORA-15196[@more@]

Master Note for Automatic Storage Management (ASM) [ID 1187723.1] 修改时间 12-AUG-2011 类型 ANNOUNCEMENT 状态 PUBLISHED In this Document What is being announced? What do you need to do? Automatic Storage Management (ASM) Alerts: Automatic Storage Management (ASM) Concepts and Overview: Automatic Storage Management (ASM) Installation: Automatic Storage Management (ASM) Configuration: Auto

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

使用partprobe可以不用重启系统即可配合fdisk工具创建新的分区 partprobe使kernel重新读取分区表，避免重启os，当然，重启os也行。[@more@]

以下参考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@]

red hat linuxLast login: Fri Jul 1 17:08:24 2011 from 192.168.0.82[oracle@ODD ~]$ df -hFilesystem Size Used Avail Use% Mounted on/dev/hda3 15G 14G 863M 95% //dev/hda1 487M 17M 445M 4% /bootnone 506M 0 506M 0% /dev/shm[oracle@ODD ~]$ df -iFilesystem Inodes IUsed IFree IUse% Mounted on/dev/hda3 1974720 336966 1637754 18% //dev/hda1 128520 42 128478 1% /bootnone

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

开机grub提示的解决pc机装了双系统，windows2003和rhel5.3，开机启动直接到了grub>界面下从google上搜了搜，http://www.linuxsir.org/main/?q=node/129写的不错grub> root (hd0,6) --可以用tab键来辅助完成grub> kernel /boot/vmlinuz-2.6.11-1.1369_FC4 ro root=LABEL=/ --可以用tab键来辅助完成grub> initrd /boot/initrd-2.6.11-1.1369_FC4.img --可以用tab键来辅助完成grub>boot --可以用tab键来辅助完成就可以启动rhel了。注意：整个过程中，可以使用cat命令来间接确定/分区和boot分区所在[@more@]