Oracle ASMLib

This blog post is more of a note for myself on configuring ASMLib. ASMLib is an optional utility that can be used on Linux systems to manage Oracle ASM devices. ASMLib consists of the following components: An open source (GPL) kernel module package: kmod-oracleasm An open source (GPL) utilities package: oracleasm-support A closed source (proprietary) … Continue reading Oracle ASMLib

PRCA-1057 : Failed to retrieve the password file location used by ASM

After the Oracle Restart (Grid Infrastructure) upgrade from 11.2. to 12.1.0.2 , you might encounter the below lines in the ASM alert log file Tue Jun 23 01:16:01 2015 WARNING: unknown state for ASM password file location resource, Return Value: 3 WARNING: unknown state for ASM password file location resource, Return Value: 3 After the … Continue reading PRCA-1057 : Failed to retrieve the password file location used by ASM

Primary on FileSystem and Standby on ASM

For one of the client, standby server went down. We had another standby server which was kept down for more than a month. Decision was taken to start the server and apply incremental SCN based backup on the standby database. The standby was on ASM and the Primary on filesystem.Incremental backup was started from the … Continue reading Primary on FileSystem and Standby on ASM

ASM Diskgroup shows USABLE_FILE_MB value in Negative

Today while working on ASM diskgroup i noticed Negative value for USABLE_FILE_MB. I was little surprised as it has been pretty long that i worked on ASM. So i started looking around for blogs and mos docs and found few really nice one around. A negative value for USABLE_FILE_MB means that you do not have … Continue reading ASM Diskgroup shows USABLE_FILE_MB value in Negative

DBCA failing with “Diskgroup XXX is not compatible for database usage”

Today a friend of mine pinged me an error while he was trying to create database using DBCA from 11.2.0.3 RDBMS home on an exadata box.Screenshot of the error is below The error was easy to understand as compatible parameter set in the database initialization parameter was lower than the compatible.rdbms set for the diskgroup … Continue reading DBCA failing with “Diskgroup XXX is not compatible for database usage”

ERROR: No checkpoint table specified for ADD REPLICAT – Oracle GoldenGate

This is just a quick note for myself to remember and reference for in case someone comes across this error while setting up Oracle GoldenGate. While configuring the online synchronization replication, a default checkpoint table is created.The table's name is mentioned in file named GLOBALS. GGSCI (anand-lab) 29> EDIT PARAMS ./GLOBALS GGSCHEMA GG_OWNER CHECKPOINTTABLE GG_OWNER.CKPTAB … Continue reading ERROR: No checkpoint table specified for ADD REPLICAT – Oracle GoldenGate

Rename Database Having Datafiles on ASM – 11gR2

This blog post is about renaming the database when using ASM. Here i will be renaming the database name from "ORCL" to "MATRIX".This method can be used for the database on lower versions (than 11gR2) also. [oracle@anand-lab ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Sun Jun 19 10:33:31 2011 Copyright (c) 1982, … Continue reading Rename Database Having Datafiles on ASM – 11gR2

Duplicating a controlfile into ASM when original controlfile is stored on ASM – 11gR2

Here i will be duplicating the controlfile into ASM when the original controlfile is stored in ASM itself on 11.2.0.1.0 version and the database is up with spfile. Two diskgroups are mounted +DATA and +DATA02.The original controlfile exists in +DATA which we will be duplicating in +DATA02. [oracle@anand-lab ~]$ sqlplus / as sysdba SQL*Plus: Release … Continue reading Duplicating a controlfile into ASM when original controlfile is stored on ASM – 11gR2

Moving Datafile using ASMCMD “cp” command – 11gR2

Few months back i wrote "Moving datafile from one diskgroup to another in ASM – 10.2.0.4" where i used RMAN and DBMS_FILE_TRANSFER methods to move the datafile between the diskgroups. From 11gR1, Oracle introduced "cp" command in asmcmd utility. cp Command Purpose Enables you to copy files between ASM disk groups on local instances to … Continue reading Moving Datafile using ASMCMD “cp” command – 11gR2