How to cleanup ASM installation (RAC and Non-RAC) [ID 311350.1] Modified 03-DEC-2010     Type HOWTO     Status PUBLISHED <br />In this Document<br />  Goal<br />  Solution<br />  References<br /><br /> <br /> Applies to: <br />Oracle Server - Enterprise Ed

<br />环境说明：<br />操作系统：CentOS 5 x86<br />数据库：Oracle 10.2.0.1 非RAC环境<br />ASM实例名：+ASM<br /><br />参考：metalink node:311350.1<br /><br />检查ASM实例进程<br />ora_test@oracle[/home/oracle]> ps -ef|grep asm|grep -v grep<br />oracle 4263 1 0 Jan20 ? 00:00:02 asm_pmon_+A

<br />After upgrade the ASM instance from release 11.1 to release 11.2 existing database is unable to start/open due to the next error:<br /> <br />/u01/app/oracle/product/11.1.0/dbs>sqlplus<br />SQL*Plus: Release 11.1.0.6.0 - Production on Wed Apr 7 15:49

The present document explains how to upgrade an ASM instance from 10.2 to 11.1 release (on RAC). Solution1) Shutdown all the database instances that are using ASM as storage option. 2) Shutdown the ASM instances. 3) Install / upgrade the new 11g CRS as des

<br />关于ASMCMD<br />用来查看和维护ASM磁盘组上的文件和目录。它可以列出磁盘组内容，执行搜索，创建、删除目录和别名，显示空间利用等等。<br />注意：你不能使用ASMCMD去创建和删除磁盘组或对一个磁盘组增加或删除磁盘。你必须使用SQL命令进行这些操作。<br />关于ASM文件，文件名，目录和别名<br />系统产生的文件名或完全合格的文件名<br />(System-generated filename or ‘fully qualified filename’)<br />ASM

XML Database （XDB）使我们能够使用FTP和HTML协议访问和管理ASM磁盘组中的文件，可以方便的浏览和移入和移出。1. 查看当前的监听端口信息：$ lsnrctl statusLSNRCTL for Linux: Version 10.2.0.4.0 - Production on 04-NOV-2010 10:42:52Copyright (c) 1991, 2007, Oracle.  All rights reserved.Connecting to (ADDRESS=(PROTOCO

<br />一 。磁盘添加于删除<br /><br />当磁盘空间不够用时（我做迁移的时候发现不够用） 可以使用如下方式添加磁盘<br />SQL> --添加磁盘<br />SQL> alter diskgroup sys_data add disk 'f:/oracl/asm/asmdisk11' name asmdisk11;<br />Diskgroup altered.<br />SQL> alter diskgroup sys_data add disk 'f:/oracl/asm/asmdisk

How to Convert a Single-Instance ASM to Cluster ASM [ID 452758.1] Modified 03-DEC-2009     Type HOWTO     Status PUBLISHED <br />In this Document<br />  Goal<br />  Solution<br /><br /> <br /> Applies to: <br />Oracle Server - Enterprise Edition - Version:

Can I Store Datapump dumpfiles in ASM diskgroup?<br />One of my friend asked me , Can I store Datapump dumpfile in asm diskgroup?. Yes you can. Now we can see How do we create directory and store dumpfile.<br />Step 1: Go To ASM Instance and Create New Dir