ITPub博客

RMAN Backup Error ORA-19588: Archived Log Recid Stamp Is No Longer Valid [ID 1189883.1] 修改时间 28-AUG-2010 类型 PROBLEM 状态 MODERATED In this Document Symptoms Changes 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 technic

# pwd /u01/app/oracle# du -sm *0.31 admin1.16 oraInventory1193.83 oradata3612.43 product[@more@]

OERR: ORA 1652 unable to extend temp segment by %s in tablespace %s [ID 19047.1] 修改时间 02-APR-2002 类型 REFERENCE 状态 PUBLISHED Error: ORA-1652Text: unable to extend temp segment by %s in tablespace %s------- -----------------------------------------------------------------------Cause: Failed to allocate an extent for temp segment in tablespace.Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more

ORA-1652 Error Troubleshooting [ID 793380.1] 修改时间 12-JUL-2010 类型 TROUBLESHOOTING 状态 PUBLISHED In this Document Purpose Last Review Date Instructions for the Reader Troubleshooting Details References Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.8 to 11.2.0.1.0 - Release: 9.2 to 11.2Information in this document applies to any platform. Purpose This document can be used to

hpux oracle10.2.0.4 rac 下报ORA-1652 unable to extend temp segment by 128 in tablespace CARDTShpux 11.31 oracle10.2.0.4 rac ,2 nodes值得注意的是，报的是不能在CARDTS表空间中扩展temp段。。。后来查询metalink 文章， Troubleshooting ORA-1652 Errors in RAC [ID 280578.1]Troubleshooting ORA-1652 Errors in RAC [ID 280578.1] 修改时间 20-OCT-2010 类型 BULLETIN 状态 PUBLISHED PURPOSE-------To provide information on how t

select b.file_name "物理文件名", b.tablespace_name "表空间", b.bytes/1024/1024 "大小M", (b.bytes-sum(nvl(a.bytes,0)))/1024/1024 "已使用M", substr((b.bytes-sum(nvl(a.bytes,0)))/(b.bytes)*100,1,5) "利用率" from dba_free_space a,dba_data_files b where a.file_id=b.file_id group by b.tablespace_name,b.file_name,b.bytes order by b.tablespace_name[@more@]

值得注意的是，从sqlplus中执行命令检查数据库的状态，数据库是open 的。如下：Microsoft Windows [版本 5.2.3790](C) 版权所有 1985-2003 Microsoft Corp.C:Documents and SettingsAdministrator>hostnamevm2003C:Documents and SettingsAdministrator>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期日 7月 31 17:57:17 2011Copyright (c) 1982, 2010, Oracle. All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionWith the Partitioning, OLAP, Data Minin

oracle 11.2.0.1 rac 修改asm磁盘组的冗余模式(redundancy mode)为normal 背景介绍： oracle 11.2.0.1 linux rac , ocr和vote file存放于名为CRS的asm磁盘组中，名为CRS的asm磁盘组是external冗余模式 现在的需求： 将ocr和vote file 存放于 normal 冗余模式的磁盘组。 进行的步骤： fdisk -l 可以看到新加的硬盘（新加的硬盘位于存储上） /dev/sddlmaa /dev/sddlmab /dev/sddlmad 这3块硬盘都是10.7g 使用 fdisk /dev/sddlmaa fdisk /dev/sddlmab fdisk /dev/sddlmad 对磁盘进行分区：第一个区5

显示procedures, packages, functions, package bodies, and triggers 和 基于非dblink的视图 的 依赖性。 DBA_DEPENDENCIES describes all dependencies in the database between procedures, packages, functions, package bodies, and triggers, including dependencies on views created without any database links. Its columns are the same as those in "ALL_DEPENDENCIES". 举例： create view GDBMZD as SELECT KCBMZD_BMBH AS GDBMZD_BMBH , KCBMZD_BMMC AS GDBMZD_BMMC, KCBMZD_JS AS GDBMZD_JS, KCB

此视图存储的应该是Type of object: FUNCTION, JAVA SOURCE, PACKAGE, PACKAGE BODY, PROCEDURE, TRIGGER, TYPE, TYPE BODY 的定义，值得注意的是，以FUNCTION为例子，SQL> create or replace function substring 2 (vsS IN char , viS IN integer , viL IN integer ) 3 RETURN char 4 IS 5 BEGIN 6 RETURN(substr(vsS,viS,viL)) ; 7 END; 8 /这是一个有8行的FUNCTION，执行此FUNCTION后，在DBA_SOURCE中去查询此FUNCTION，结果有9行。呵呵。不知道为啥会多一行。[@more@]

http://blogold.chinaunix.net/u/31219/showart_1895925.html我们来看一下两种分区表MBR分区表：（MBR含义：主引导记录）所支持的最大卷：2T （T; terabytes,1TB=1024GB）对分区的设限：最多4个主分区或3个主分区加一个扩展分区（扩展分区中支持无限制的逻辑驱动器）GPT分区表：（GPT含义：GUID分区表）支持最大卷：18EB，（E：exabytes,1EB=1024TB）每个磁盘最多支持128个分区假设要用parted对/dev/sdb（大小为6000G）进行分区操作：1、进入系统执行：#parted /dev/sdb2、建立磁盘label：mklabel GPT3、按p键，查看磁盘可用空间，显示单位

How to configure USE_SHARED_SOCKET on Windows NT/2000 [ID 124140.1] 修改时间 13-APR-2011 类型 BULLETIN 状态 PUBLISHED Applies to: Oracle Net Services - Version: 8.0.6.3.0 to 11.2.0.2 - Release: 8.0.6 to 11.2Generic Windows Purpose The Oracle Net or Net8 connection to an Oracle Database running on Windows NT, Windows 2000, or later operating system may redirect the Client to connect to a port number selected fro

Port 1521 Open on Firewall But Unable to Connect Due to Errors: ORA-12535,TNS-12203 [ID 361284.1] 修改时间 08-OCT-2008 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Oracle dedicated databases on Windows platforms Oracle shared-mode databases Oracle 10g direct handoff feature on Windows platforms Oracle RAC clusters Solution References Applies to:

Solving Firewall Problems on Windows [ID 68652.1] 修改时间 13-APR-2011 类型 BULLETIN 状态 PUBLISHED Applies to: Oracle Net Services - Version: 2.3.4.0.0 to 11.2.0.2 - Release: to 11.2Generic Windows ORA-12535 TNS-12535 USE_SHARED_SOCKET Purpose This article describes how to get around firewall problems with SQL*Net or Net*8 on Windows servers. Scope and Application SCOPE & APPLICATIONA firewall is a s

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