Oracle How to determine raw disks configured for OCR/voting disk, ASM spfile

I have a two-node Oracle 10gR2 RAC configuration using raw disks. Basically, raw disks are used for CRS's OCR/voting disks, ASM's ASM spfile and disk groups.Is there a better way to figure out what raw disks are configured in Oracle using methods other than those shown below:- To find out votedisk:# ...

Oracle ASM Spfile Location in RAC

I am installing oracle RAC on 2nodes 11g R1 clusters, I am not quite sure about the spfile location when creating the asm instances, I know that it has to be on the shared location accessible for both the nodes to load the ASM, but how to set the shared storage, my shared storage is raw devices for ...

Oracle change ASM-spfile Location (Cluster Installation)

I upgraded ASM and RDBMS from 10.2 to 11.2. The ASM-spfile is still in the 10.2-Oracle-Home. How can I change the location? I found in the manual "Oracle® Database Upgrade Guide11g Release 2 (11.2) Part Number E10819-02" the syntax: srvctl modify asm -n node [-p spfile] -o asm_home -i instanceThat ...

Oracle 11gR2 ASM disk rename failing - renamedg

We are in 11gR2 ASM and trying to rename the disk group with the oracle tool renamedg.$ renamedg phase=one dgname=TEST_RENAME newdgname=TEST_RENAME2 config=/tmp/TEST_RENAME.conf verbose=trueNOTE: No asm libraries found in the systemParsing parameters..Parameters in effect:Old DG name : TEST_RENAMENe ...

+ASM spfile default location of Oracle 11g RAC Linux

Is anybody now the default location of +ASM spfile at Oracle 11g RAC Linux. ...

Oracle Backup of ASM spfile

Using RMAN, you can backup of spfile & controlfile using CONFIGURE CONTROLFILE AUTOBACKUP ON. How do you backup the +ASM spfile using 'RMAN' ?We need to backup of 'spfile', its in +ORADATA1 ASM configuration disks.We don't want to take the backup using sqlplus prompt like...+ASM sql> create p ...

Oracle create a pfile via rman command (for ASM spfile) ?

Is there a way via RMAN to copy the spfile (which is stored in ASM) to a normal filesystemeg : in SQL> create pfile='init.ora' from spfile; (where the spfile is on a ASM diskgroup) So is this possible via some rman command ? ...

Oracle ASM 11gR2 ASM functionality

Does all of the new ASM functionality for 11gR2 work with the Exadata database machine (ex. ASM Cluster & Single Node File System (ACFS)l)? ...

Oracle 11gR2/ASM on Windows Server 2008

Ok, hopefully this isn't too dumb of a situation.I have installed Oracle 9, 10 and 11 using NTSF plenty of times. However, now I need to install Oracle 11gR2 using ASM (as a single database instance). And to do that I need to install the Grid Infrastructure.This is the environment:- Windows Server 2 ...

Oracle What's the advantage of putting ASM spfile on raw disk?

Over putting the spfile on disk group (which itself is on raw disk)? ...

Oracle Unable to PIN nodes in 11gR2 ASM to run 10gDatabase

In order to run 10g Database with 11g Clusterware and ASM, we need to PIN the nodes as per Oracle Documentation. But, I get an error when i try to pin th e nodes:-bash-3.00$ /crs/product/bin/crsctl pin css -n node1CRS-4563: Insufficient user privileges.CRS-4000: Command Pin failed, or completed with ...

Oracle 11gR2 ASM and SCAN questions

I need to install 2 node cluster (2x HP ProLiant DL380G7) based on Win2008 R2 and HP storage (HP P2000).I have next questions:1) Number of partiotions in ASM diskgroupHow much LUNs I need to prepare for ASM (for DB and Flashrecovery separetely)?Storage array has RAID 5, so in my opinion I need to cr ...

Oracle ASM and CRS in 11gR2, chicken egg dilemma solved ?

it seems, that the chicken egg dilemma in terms of ASM and CRS was solved in 11gR2. To start ASM in RAC, CRS needs to be running first. However in 11gR2 the OCR is stored in ASM. So to start CRS, ASM needs to be available beforehand. The same is with ASM. The ASM spfile is stored in ASM. Thus to sta ...

Oracle starting database with spfile which is stored on ASM (11.2.0.2)

I am trying to startup database with spfile which is stored on ASM. when i tried to startup it says no file in $ORACLE_HOME/dbs.so created a symbolic link from $ORACLE_HOME/dbs pointing it to ASM spfile. I know we can have acopy in $ORACLE_HOME/dbs..which i dont want.Thanx guys ...

Oracle Space used by each DB in a ASM.

Is it possible to find out the space used by each database in the asm using ASM view?We got 30 dbs running in a server on a single 11gR2 ASM instance. I need to get 2 liner for all the database space from ASM.Eg:- Diskgroup total_mb free_mb --------------data 200g 50gflash 200g 100gThe above informa ...

Oracle Best Practice for monitoring RAC 11gR2

I have RAC 11gR2+ASM on two nodes.I would like to get your advice what are the most critical things i should monitor - Regarding RAC COMPONENCTS ...

Creating Oracle 11g Database Manually on ASM on 11g R2 Grid

Earlier added this issue alongwith Grid installation. Only Jorg replied to me but could not find a complete solution. So thought of starting a new thread.Wanted to know if any one of you have successfully created Oracle Database Manually on ASM on Oracle 11g R2 Grid.I have installed Oracle 11g R2 gr ...

Oracle 11gR2 - External redundany. RAID1 or 5

Leaving IOP's out of fray for now, is it frowned upon if I was to use external redundancy on 11gr2 ASM diskgroups with my disks backed by SAN and RAID5. In other words, is ASM striping combined with RAID5 striping deemed unnecessary particularly if RAID1(mirroring) is possible on the SAN? ...

Oracle ASM snapshots and ACFS

I've been playing with 11gr2, asm and ACFS.. I saw the new snapshot technology and I thought wahooo.... I've worked with netapp in my previous job, and I loved the snapshot technology. I was thinking this would be the same..You would put your files on a "cooked" file system, put your database in bac ...

Steps to install and setup Oracle GoldenGate 11g Release 1 (11.1.1)

Environment is as below:Primary site (source): This is production DB and up and running.RAC 2 nodesOracle RAC 11gr2ASMEnterprise Linux Server release 5.5 (Carthage) target Site (destination): Software installed and instance has been created.Standalone single server - Non RACOracle 11gr2ASMEnterprise ...

Oracle Performance Strategies

Oracle 11gR2 (ASM Single Instance) RHEL5 64bitHi All,I wanted everyone's input on what performance strategies should we implement or think about implementing if our database is going to grow to 100TB. We don't have a large amount of users (100 max) and majority of the data that will be stored and ac ...

Oracle installation on SLES 11 SP1

Good Morning,I have followed the tutorial of Arun Singh [ftp.novell.com/partners/oracle/docs/11gR2_sles11_sp1_install.pdf] in order to install Oracle Database 11g R2 on SLES 11 SP1.When I run the Oracle Installer, after the install type selection, this message is displayedINS-32008: The Oracle Base ...

Cloning Oracle Clusterware to Create a Cluster

I'm trying to clone my clusterware on anonther cluster (on red hat 5.6)I've followed all the instructions, but the cloning failed when it's trying to configure asm : Here's my log : *****************************************************************************************[root@lora503l install]# /app ...

Oracle How To Create a Pfile From an Spfile Stored in ASM?

I've got an 11gR2 DB instance. The spfile for that instance is stored in ASM at +DATA/test/spfiletest.ora and my database will not start:SQL> startup;ORA-01078: failure in processing system parametersORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGETbecause I inadvertently ...

Oracle spfile locatin under ASM after recreation

i run 10g RAC on to SUN nodes with asm. after installation the location of the spfile was correct (+data/pkrac/spfile_pkrac.ora -> linking to +data/pkrac/parameterfile/spfilexxxx) i had to change an parameter, so i created an pfile, changed it and recreated the spfile. after that the alias is on ...

Oracle migration of spfile from non-asm instance to asm instance.

I try to sum-up first what all i did I am using 10g R2 on Windows 2003, configured ASM having 3 disk groups on this machine. I migrated my existing test database to ASM instance through RMAN. Now if i check location of all my datafile and redo log file then they all are in asm disk groups but my spf ...

Oracle moving spfile from non-asm to asm file system

We are migrating non-asm file system to asm file system, we are held up in moving the spfile from non-asm file system to asm file system ...we tried the below methodRecreate SPFILE on ASM diskgroupSQL> create pfile='c:\initTEST.ora' from spfile;File created.SQL> create spfile='+DGRP2/spfileTES ...

Oracle Can't start ASM on one node (two node RAC) after 11gR2

This has been driving me batty.Upgraded RAC to 11gR2 from 11gR1. 11gR1 RAC was initially built using Jeffrey Hunter's 'Build a RAC on Linux using iSCSI' paper.ASM starts fine on node 2, but it won't start on node 1. Nothing in any of the alert logs. There are password file soft links in the GRID_HOM ...

Oracle DB Using ASM Storage (Spfile)

I have setup a db to use asm storage. i need to view the contents of the spfile for that db.when i go to the $ORACLE_HOME/dbs i get to see the init file which in turn points to an spfile like what is seen belowSPFILE='+DATA/asmdb/spfileasmdb.ora'How can i view the contents of this from a diskgroup. ...

Oracle How to view spfile in ASM diskgroup while the database can’t be started?

We are in 10.2.0.3 and server is window 2003. And the init.ora file has one line in it “SPFILE='+DG_DATA/MITCH/spfileMITCH.ora'”.One time I can’t start the database and got the error below. I googled it and it said if I can reduce large_pool_size or sga_target I should be able to start. But I ...

Oracle 11gR2 Database Installation with ASM - NOT RAC

Im littel bet confused about the "Grid Infrastructure" in 11gR2. In oracle 10gR2 i had to install oracle software twice. 1. one for the rdbms instance and the second software on for the ASM instance. 2. Then from the asm home i run dbca and choose "configure automatic storage management" and continu ...

Oracle OCR and voting disks on ASM storage with 11gR2

I've installed some RAC solutions using 10gR2 and 11gR1. I've now finished a 11gR2 installation and I've some questions:after I've prepared two ocfs2 disks based on different storage area, during Grid Installation (Step 1: Install and Configure Grid Infrastructure for a Cluster, Step 2: Advanced Ins ...

Oracle 11gR1 to 11gR2 Upgrade Single Instanece on ASM

HiCan someone outline steps to upgrade single instance ASM 11.1 database to single instance 11.2 ASM database. Do I need to install ASM as part of 11gR2 Grid infrastructure OR Just upgrade ASM home?? ...

Oracle 11gR2 Grid/ASM deinstallation tool

we are automating deinstallation process for 11gR2 grid. End of the execution deinstall create de-configuration directory (deinstall2010-02-03_06-43-00-AM) with date and time inside tmp folder. is it possible to specify name for this tmp directory to some static (/tmp/deinstall_app).at the end of in ...

Oracle how to use ASM+GFS with 11gR2 clusterware?

hihow to install 11gR2 clusterware with ASM+GFS?do i need external lock-server nodes?it was for 9i RAC.is it still supported or not in 11gR2?regards http://www.redhat.com/docs/manuals/csgfs/oracle-guide/s1-gfs-conffiles.htmlhttp://www.redhat.com/docs/manuals/csgfs/oracle-guide/ch-overview.html#S1-OV ...

Oracle how to get names of all the asm disk groups in 11gr2

i have a question regards getting the all the asm disk group names in 11gr2 on hp-ux. earlier in 11gr1 asmcmd lsdg used to display all the names along with the state irrespective whether it is mounted or not. but in 11gr2 it is displaying the information regardsthe disk group which are mounted only. ...

Oracle how to get t ASM SID in 11gR2 using srvctl commands

helloI am looking for a command which gives ASM SID.in 11gR1 i am using the following commandsrvctl config asm -n <node name>+ASM2 /var/opt/product/RACDBi use the first part of it and use it in scripts.srvctl status asm -n <node name>ASM instance +ASM2 is running on node <node name ...

Oracle 11gR2 installation with ASM

I want to install a 11gR2 server that would use ASM to manage disks. It seems that in 11gR2 I must install grid infrastructure to install ASM even though I would not create a RAC database. Is that correct? ...

11gR2 - ACMCA needs Oracle grid infrastructure to configure ASM

HiI am installing single instance oracle 11gR2 on linux redhat 5I have problem with 11gr2 ASMCA.I successfully installed 11gR2 oracle grid home.Than i wanted to create the ASM diskgroup using asmcaThe disks was succssefully discavered , but the creatation failed on the following error messages:Oracl ...

Oracle 11gr2 RaC with ASM question

Installating 11gR2 on OEL5.4 with ASM on VMWare for training/learning purpose.Im following a tutorial, to learn RAC and 11gR2 grid installation process. I never used RAC and ASM before.My setup:node1 for databasenode2 for databasenode3 for asm/grid/dnsSo far, I configured the dns, ssh passwordless s ...

how to create an asm instance manaually? oracle 11gr2.

env: oracle 11gr2 os: hpux or aix single machine , not rac.question:how to create an asm instance manaually?? diskgroup,listener,db ,they can be resigistered to crs??can anyone give me document about it? ...

Oracle 11gR2 RAC setup with ASM option running on two nodes . Seeking help

Recently we have migrated to 11gR2 extended RAC for one of our application using ASM . Its a two node RAC setup . We are using ASM Normal redundancy feature maintaining two failure group . I need few clarification regarding our new DR set up . We are planning to have EMC SRDF replication from any of ...

Oracle RAC 11gR2: How to configure ASM group for OCR?

I've just installed an 11gR2 RAC on two Linux boxes, connected to two (iSCSI-) Storages. Since it's a standard edititon, I'm bound to ASM for the OCR and votedisks, so, I've setup four ASM disks (two on each storage), and had the installer build my CRS volume out of these.The installer has created t ...

Oracle 11gR2 RAC Grid installation - Configuration of ASM failed,

Trying to install/configure Oracle 11gR2 Grid for 2 nodes RAC on Suse 10, root.sh failed with this error:2010-08-19 15:30:47: Querying for existing CSS voting disks2010-08-19 15:30:47: Performing initial configuration for cluster2010-08-19 15:30:48: Start of resource "ora.ctssd -init" Succeeded2010- ...

Oracle ASM, Clusterware 11gR2, What log files do multipath errors get logged into?

Folks, I am running Oracle 11gR2 Grid Infrastructure, (Clusterware and ASM), on a two node Suse Linux cluster. (The databases are release 10.2.0.4.3.) All datafiles, flash, OCR and VOTE are on ASM managed disk. We have multipath configured properly and this weekend one of the paths to disk was offli ...

Oracle create spfile in asm - ORA-17503 - failed to open spfile

I have an initnew.ora in the $ORACLE_HOME/dbs dir. I want to create the spfile to be stored in asm.- create spfile='+disk1' from pfile.somehow the pfile was not the one I intend, and I create the spfile serveral times creating multiple spfile in asm.so I go in the asmcmd and delete the spfile, +disk ...

Oracle spfile ASM

HelloI know that in oracle11gR2 spfile location and diskstring parameters are located in Oracle Local Registry.By looking at these values, oracle reads spfile and mounts the asm instance.I can query this by running "crsctl stat res ora.asm -p" How about in 10g or 11gR1? How does oracle reads spfile ...

Is Oracle 11gR2 RAC with ASM supported on AIX7.1?

Does Oracle support RAC (11gR2) on AIX7.1 ? We got a requirement for the same and i found in oracle certification that it supports single instance only on AIX7.1.? I tried to go ahead with the installation and found runcluvfy and then runinstaller throwing "not a supported platform" error messages. ...

Oracle want to move datafiles, controlfiles, redolog on new ASM Disks (11gR2 RAC)

Setup: Two Node 11gR2 (11.2.0.1) RAC on RHEL 5.4Existing disks are from Old SAN & New Disks are from New SAN.Can I move all datafiles (+DATA), controlfiles (+CTRL), redolog (+REDO) on new ASM Disks by adding disks in is same Diskgroup & dropping older disks from existing Diskgroup taking adv ...

Oracle startup command does not find spfile on ASM Disk Group

I have installed 11g Grid Infrastructure and created an 11g database called gc11g. I verified the spfile is stored on my ASM disk group with ASMCMD:ASMCMD> ls -lType Redund Striped Time Sys NameY 10GDB/Y ASM/Y GC11G/N spfilegc11g.ora => +DATA/GC11G/PARAMETERFILE/spfile.295.758980767But when I ...