ITPub博客

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

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

SQL> col name format a34SQL> set pagesize 15SQL> col name format a34SQL> set pagesize 15SQL> select name ,sequence#,creator,REGISTRAR,STANDBY_DEST,ARCHIVED,applied from v$archived_log;NAME SEQUENCE# CREATOR REGISTR STA ARC APP---------------------------------- ---------- ------- ------- --- --- ---/home/oracle/archive/1_12.dbf 12 ARCH RFS NO YES YES/home/oracle/archive/1_13.dbf 13 ARCH RFS NO YES YES/home/o

1.在主库上，alter system switch logfile; 在备库上:tail -f alert_orac.log 查看：Tue Jul 12 15:25:01 2011Media Recovery Log /home/oracle/archive/1_20.dbfMedia Recovery Waiting for thread 1 seq# 212。在主库上：SQL> select open_mode from v$database;OPEN_MODE----------READ WRITESQL> select database_role from v$database;DATABASE_ROLE----------------PRIMARY在备库上：^X[oracle@rhel43 bdump]$ sqlplus " / as sysdba"SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 12 15:26:38 2011Copyr

The number of nodes supported is not limited by Oracle, but more generally by the clustering software/hardware in question. When using solely Oracle Clusterware: 63 nodes (Oracle 9i or Oracle RAC 10g Release 1) With 10g Release 2, the maximum nodes is 100 When using a third party clusterware: Sun: 8 HP UX: 16 HP Tru64: 8 IBM AIX: * 8 nodes for Physical Shared (CLVM) SSA disk * 16 nodes for Physical Shared (CLVM) non-SSA disk * 128 nodes for Virtual Shared Disk (VSD) *

RAC: Frequently Asked Questions [ID 220970.1] 修改时间 06-JUL-2011 类型 FAQ 状态 PUBLISHED Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.1 - Release: 9.2 to 11.2Information in this document applies to any platform. Purpose Frequently Asked Questions for Real Application Clusters and Grid Infrastructure. Questions and Answers p.MsoNormal, li.MsoNormal, div.MsoNormal

RAC Assurance Support Team: RAC Starter Kit and Best Practices (Windows) [ID 811271.1] 修改时间 14-JUN-2011 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Application RAC Assurance Support Team: RAC Starter Kit and Best Practices (Windows) RAC Assurance Support Team: RAC and Oracle Clusterware Starter Kit and Best Practices (Generic) RAC Platform Specific Starter Kits and Best Practic

在windows x64bit上安装oracle 11.2.0.2 rac 要求必须使用域用户安装（必须使用域用户安装的报错是在grid软件安装到“先决条件检查”部分弹出的提示）而在相同的os平台上，安装oracle 11.2.0.1 rac，可以用本地administrator用户来安装。[@more@]za

Oracle RAC Technologies Certification Matrix for Microsoft Windows Platforms Oracle will support the Oracle software on clusters comprised of RAC compatible technologies and supported software combinationsNOTE: Please consult your hardware and software vendors as not all vendors may choose to support their hardware or software in every possible cluster combinationFor RAC database and server virtualization (Oracle VM, LPAR, vPAR, LDOM, etc.) support see here.For RAC dat

最近在客户处执行sqlplus / as sysdba 进入sqlplus,提示权限不足，于是很自然的就想到sqlnet.ora文件中的设置：看这个一行是否是这么写的：SQLNET.AUTHENTICATION_SERVICES= (NTS)此时处于生产时段，我当时没有修改sqlnet.ora。而是到了晚上，才修改sqlnet.ora文件的内容，将SQLNET.AUTHENTICATION_SERVICES= (NONE)改为SQLNET.AUTHENTICATION_SERVICES= (NTS)此次修改主要是为了sqlplus / as sysdba 能进入sqlplus进行操作。当操作完毕后，sqlnet.ora的内容没有改会原来的。之后，前台应用报错，连不上数据库，报错为ORA-12637:包接收失败

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/process.htm#sthref1626Other Background Processes There are several other background processes that might be running. These can include the following: MMON performs various manageability-related background tasks, for example: Issuing alerts whenever a given metrics violates its threshold value Taking snapshots by spawning additional process (MMON slaves) Capturing statistics value for SQL objects which have been recently mo

Job Queue Processes Job queue processes are used for batch processing. They run user jobs. They can be viewed as a scheduler service that can be used to schedule jobs as PL/SQL statements or procedures on an Oracle instance. Given a start date and an interval, the job queue processes try to run the job at the next occurrence of the interval. Job queue processes are managed dynamically. This allows job queue clients to use more job queue processes when required. The resources used b