ITPub博客

RAC Assurance Support Team: RAC and Oracle Clusterware Starter Kit and Best Practices (Generic) RAC Platform Specific Starter Kits and Best Practices While this note focuses on platform generic RAC Best Practices, the following notes contain detailed platform specific best practices including Step-By-Step installation cookbooks. Document 811306.1 RAC Assurance Support Team: RAC Starter Kit and Best Practices (Linux) Document 811280.1 RAC Assurance Support Team: RAC Starter Ki

RAC Assurance Support Team: RAC and Oracle Clusterware Starter Kit and Best Practices (Generic) [ID 810394.1] Modified 21-JUL-2011 Type BULLETIN Status PUBLISHED In this Document Purpose Scope and Application RAC Assurance Support Team: RAC and Oracle Clusterware Starter Kit and Best Practices (Generic) RAC Platform Specific Starter Kits and Best Practices RAC Platform Generic Load Testing and System

DBCA Does Not Display ASM Disk Groups In 11.2 [ID 1177483.1] 修改时间 30-JUN-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution References Applies to: Oracle Database Configuration Assistant - Version: 11.2.0.1 and later [Release: 11.2 and later ]Information in this document applies to any platform. Symptoms When DBCA is launched by the oracle user OS account, the process get

在11.2.0.2 grid安装之前，"pre-downloaded software updates" 选项有点让人理解歧义"pre-downloaded software updates" 含义是可以先通过runInstaller 这个oui工具（windows下是setup.exe）先下载好software updates ，然后当运行runInstaller（windows下是setup.exe）时就可以直接调用下载后的文件。注意：必须通过runInstaller 这个oui工具（windows下是setup.exe）这个工具下载（命令为./runInstaller -downloadUpdates），不能自己跑到metalink上下载patch，然后放在指定目录下，这样弄的话安装此补丁时会报错：

How To Download The Latest Updates And Patches Using 11.2.0.2 OUI [ID 1295074.1]有贴图不好发出来。只好放这里了。http://blog.csdn.net/msdnchina/article/details/6621260[@more@]

Error: INS-20704 While Installing 11.2.0.2 with "Use pre-downloaded software updates" Option [ID 1265270.1] 修改时间 10-MAY-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later [Release: 11.2 and later ]Information in this document applies to any platform. Symptoms You may receive

windows 2008R2 x64bit 完全安装需要38G左右的空间，请预留好。[@more@]

dell r910开机，按F11，进入boot manager，选择sata optical driver ，回车，从光盘启动安装windows2008[@more@]

How to move Oracle Spatial objects from SYSAUX tablespace to a user defined tablespace [ID 1119758.1][@more@]

Does "Alter Table Move Tablespace" Fire DML Triggers? [ID 460489.1] 修改时间 24-AUG-2010 类型 HOWTO 状态 MODERATED In this Document Goal Solution References Platforms: 1-914CU; 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 rev

ORA-12545 or ORA-12537 While Connecting to RAC through SCAN name [ID 970619.1] 修改时间 22-JUN-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution References Symptoms Error ORA-12545 or ORA-12537 reported while trying to connect to 11gR2 Real Application Cluster (RAC) database through SCAN name Cause Client is able to resolve all Fully Qualified Domain Name (FQDN) SCAN and VIP n

sybase的具体信息如下：C:Documents and SettingsAdministrator>sqlsrvr -vAdaptive Server Enterprise/15.0.1/EBF 13823/P/NT (IX86)/Windows 2000/ase1501/2379/32-bit/OPT/Mon Aug 14 22:12:39 2006Confidential property of Sybase, Inc.Copyright 1987, 2006Sybase, Inc. All rights reserved.Unpublished rights reserved under U.S. copyright laws.This software contains confidential and trade secret information of Sybase,Inc. Use, duplication or disclosure of the software and documentation bythe U.S. Government

对于sybase公司，其实是由于pb的缘故，我才知道sybase的，后来在工作中，接触到了sybase ase 数据库软件，再后来又知道了pd：powerdisigner。只不过现在的sybase已经被sap收购了。据说sybase是美国国防部最为倚重的数据库服务提供商，美国佬竟然也能同意德国企业收购sybase？有点意思。。。可能我在工作中接触到的sybase 都是windows下11.5 和11.9.2的关系，而windows下这两个版本的数据库性能很差（20-30万行的数据量就慢的要死），让我对ase 有了不太好的印象，也许慢的原因不仅仅是数据库，还有应用程序的写法，不知道unix环境下的syba

1.目的端的listener已经启动2.目的端已经执行过 alter database recover managed standby database disconnect from session;以上这两个条件都必须满足，源端才传输日志到目的端。[@more@]

以下转自：http://www.eygle.com/digest/2008/12/rhel45oracle10g_dataguard.html5、常用维护SQL 查询当前库的角色和保护模式： SQL> select database_role,db_unique_name,open_mode,protection_mode,protection_level,switchover_status,supplemental_log_data_pk,supplemental_log_data_ui from v$database; 主库归档： SQL> ALTER SYSTEM SWITCH LOGFILE; --对单实例数据库或RAC中的当前实例执行日志切换 SQL> ALTER SYSTEM ARCHIVE LOG CURRENT; --对数据库中的所有实例执行日志切换 在备库上，验

主库做了几次alter system switch logfile;看主库的alert日志：[oracle@rhel42 bdump]$ tail -f alert_orac.log ARCH: Tue Jul 12 22:27:14 2011 ORA-16038: log 2 sequence# 23 cannot be archived ORA-12541: TNS:no listener ORA-00312: online log 2 thread 1: '/u01/app/oradata/orac/redo02.log' Tue Jul 12 22:27:14 2011 Errors in file /u01/app/admin/orac/bdump/orac_arc0_5024.trc: ORA-16038: log 2 sequence# 23 cannot be archived ORA-12541: TNS:no listener ORA-00312: online log 2 thread 1: '/u01/app/o

Windows: Can not Install Clusterware on x64 with More Than 32 Processors/Cores/Threads [ID 1177387.1] 修改时间 05-JUL-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2Microsoft Windows x64 (64-bit) Symptoms Oracle Clusterware installation(10.2 - 11.1 CRS or 11.2 Gr

RMAN> connect auxiliary sys/aaaaaa@STANDBYconnected to auxiliary database: orac (not mounted)RMAN> duplicate target database for standby nofilenamecheck;Starting Duplicate Db at 12-JUL-11using target database controlfile instead of recovery catalogallocated channel: ORA_AUX_DISK_1channel ORA_AUX_DISK_1: sid=12 devtype=DISKprinting stored script: Memory Script{ restore clone standby controlfile to clone_cf; replicate clone controlfile from clone_cf; sql clone 'alter database mount sta

在primary端连接standby时，有如下的报错：RMAN> connect auxiliary sys/aaaaaa@STANDBYRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-04006: error from auxiliary database: ORA-12523: TNS:listener could not find instance appropriate for the client connection 后来搜了一下，http://www.oracleblog.org/working-case/service-status-is-b

SWITCHOVER_STATUS VARCHAR2(18) Indicates whether switchover is allowed: NOT ALLOWED - Either this is a standby database and the primary database has not been switched first or this is a primary database and there are no standby databases.SESSIONS ACTIVE - Indicates that there are active SQL sessions attached to the primary or standby database that need to be disconnected before the switchover operation is permitted. Query the V$SESSION view to identify the specific