Oracle Restart configuration after Renaming the Database – 11gR2

The Oracle Restart ensures that various Oracle components gets automatically restarted after hardware or software failures.In my last post as i had renamed the database, i had to update the OLR (Oracle Local Registry)for the database to come up automatically. [oracle@anand-lab bin]$ ./crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources … Continue reading Oracle Restart configuration after Renaming the Database – 11gR2

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

Histogram on VARCHAR2 column having first 32 character identicals

Recently i read the below link and came to know that,while creating histogram on a VARCHAR2 column, Oracle will only consider the first 32 characters in the column. In other words, if the first 32 bytes of the column values are identical all of the values end up in a single bucket of the histogram … Continue reading Histogram on VARCHAR2 column having first 32 character identicals