Monthly Archives: November 2010

Oracleasm configuration issues in RAC environment

I was configuring ASM on Linux with ASMLIB in RAC environment. Identified the disks (sdcm, sdcn, sdco, sdcq, sdcr, sdcs, sdct, sdcu, sdcv, sdcw, sdcx, sdcy) and created required partitions on it. # fdisk  /dev/sdcq Command (m for help): d … Continue reading

Posted in Oracle Automatic Storage Management | Tagged , , | 3 Comments

CRS-4013: This command is not supported in a single-node configuration.

In 11gR2 RAC configuration, after planned shutdown I wanted to start the Grid infrastructure.  So I issued crsctl start crs command, which resulted in following error # crsctl start crs CRS-4013: This command is not supported in a single-node configuration. … Continue reading

Posted in Oracle Cluster Ready Services | Tagged | 3 Comments

ORA-29780: unable to connect GPnP daemon [CLSGPNP_ERR]

On 11gr2 Grid installation, I wanted to changed few ASM parameters. So I created a pfile, and then was trying to create a spfile out of it. Started getting following error SQL> create spfile from pfile=’test.ora’; create spfile from pfile=’test.ora’ … Continue reading

Posted in Oracle Cluster Ready Services | Tagged | Leave a comment

ORA-600: arguments:[krf_enable_flashback_db_5]

 I had some issue with a ASM disks. This disk was used for my FRA.  Diskgroup was not in recoverable state, so I created a new DG & changed the DB_RECOVERY_FILE_DEST parameter SQL> startup mount SQL> alter database flashback … Continue reading

Posted in Oracle ORA-600 errors | Tagged | Leave a comment

ORA-29786: SIHA attribute GET failed with error [Attribute ‘SPFILE’ sts[200] lsts[0]]

At the time of creating ASM spfile in 11gR2 standalone infrastructure, I faced following error $ export ORACLE_SID=+ASM $ sqlplus / as sysasm SQL> create spfile=’$ORACLE_HOME/spfile+ASM.ora’ from pfile= ‘$ORACLE_HOME/dbs/init+ASM.ora’ / create spfile=’$ORACLE_HOME/spfile+ASM.ora’ from pfile=’$ORACLE_HOME/dbs/init+ASM.ora’ * ERROR at line 1: ORA-29786: … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | Leave a comment

Oracle 11.2.0.2 In-Place & Out-of-Place Upgrade

We can perform database upgrade from 11.2.0.1 to 11.2.0.2 in 2 ways 1. In-Place 2. Out-of-Place (Oracle’s recommended approach) In prior releases, how it worked DB Upgrade 8i to 10g (Out-Of-Place) We install Oracle binaries for 10g at new location, then … Continue reading

Posted in Oracle 11.2.0.x, Oracle 11g Enhancements, Oracle Database Upgrade | Tagged | 5 Comments

Oracle RAC One Node – HA Solution for Oracle Database

Oracle provides many solution for database HA. To name few Oracle RAC, Oracle Data Guard, Oracle Streams etc. These solutions provide protection at different levels. For example, RAC protects from instance failure, node failure. Data guard & streams protect from … Continue reading

Posted in Oracle Real Application Cluster, RAC One Node | Tagged | 4 Comments