ITPub博客

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@]

数据库配置文件已经安装到 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

http://technet.microsoft.com/zh-cn/library/ms189852%28SQL.90%29.aspxhttp://technet.microsoft.com/zh-cn/library/ms366349%28SQL.90%29.aspxhttp://technet.microsoft.com/zh-cn/library/ms190030%28SQL.90%29.aspxhttp://technet.microsoft.com/zh-cn/library/ms189977%28SQL.90%29.aspxhttp://technet.microsoft.com/zh-cn/library/ms189270%28SQL.90%29.aspxhttp://technet.microsoft.com/zh-cn/library/ms186348%28SQL.90%29.aspxhttp://technet.microsoft.com/zh-cn/library/ms179481%28SQL.90%29.aspxhttp://technet.microsoft

环境如下：主体数据库(ip: 192.168.0.11) winxp sp3 sqlserver2005 sp3 32bit , 数据库名字为cwbase2镜像数据库(ip: 192.168.0.12)win2003 sp2 sqlserver2005 sp3 32bit , 数据库名字为cwbase2不使用见证服务器，采用异步数据库镜像（高性能模式）准备工作：将主体数据库cwbase2 改为full恢复模式将镜像数据库cwbase2 改为full恢复模式将主体机器上的sqlserver 服务，sqlserver agent服务，sqlserver browser服务，改为由administrator启动，并设置为自动启动将镜像机器上的sqlserver 服务，sqlserver agent服务，sqlserver browser服务

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