Generic failure interacting with CRS while using asmca utility to mount diskgroup

While i was mounting diskgroup using asmca utility. I got the below error

ASM configuration utility error while mounting diskgroup

I just logged in  sqlplus / as sysasm and issued the below command

the issue was resolved and i was able to create database.

Hope that helps

2014 in review

sunilthetechfreak 2014 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 9,800 times in 2014. If it were a concert at Sydney Opera House, it would take about 4 sold-out performances for that many people to see it.

Click here to see the complete report.

Oracle DBA 11g, 12c Training – Oracle Genesis

Hi friends,

Oracle DBA 11g, 12c training is being conducted by OracleGenesis. Anyone interested can join demo tomorrow.

Register now: https://attendee.gotowebinar.com/rt/4101773566875783937

Advanced DBA Training – Crash Course

Hi Friends,

This is golden chance for people who are looking for Advanced oracle dba training. It is one week crash course and covers all the advanced topics required for oracle dba. Register soon as they have limited seats!!!!

Register: https://attendee.gotowebinar.com/rt/4039442252251558658

Advanced Training

 

Training Details

How to setup environment variables in oracle to sucessfuly connect to a particular database/instance

Oracle environment variable is set to inform your operating system about the Oracle software installation directory and which oracle software/binaries should interact with which database/instance.

The most important environment variable are listed below
ORACLE_HOME : setting oracle home means which oracle product/software or installation you will be using to associate with your databasehaving oracle home environment variable makes easier for maintenance and management of oracle software.As per Oracle optimal flexible architecture (OFA)
/u01/app/oracle/product/10.2.0.1/dbhome_1

ORACLE_SID : The oracle system identifier is a unique identifier which is set to interact with a particular instance. You may have multiple oracle database on a single machine by setting this variable we are information oracle software to connect to that particular instance.

we will learn various way to set this variable

firstly we will check oracle home and how many databases are installed on the machine

[oracle@db10g /]$ cat /etc/oratab
#
# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.

# A colon, ‘:’, is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, ‘#’, are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third filed indicates
# to the dbstart utility that the database should , “Y”, or should not,
# “N”, be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
ora10gdb01:/u01/app/oracle/product/10.2.0.1/db01:N
10gdb02:/u01/app/oracle/product/10.2.0.1/db01:N

In the above out put we can see we have two databases ora10gdb01 & 10gdb02

now let see if our environment variable is not set correctly what will happen

Login: oracle
Last login: Sat May 31 18:12:45 2014 from 192.168.1.1
[oracle@db10g ~]$ sqlplus
-bash: sqlplus: command not found
[oracle@db10g ~]$

the operating system doesn’t know what is sqlplus command

setting oracle home and sid for ora10gdb01 manually

set oracle_sid by giving below command
[oracle@db10g /]$ export ORACLE_SID=ora10gdb01

check if the environment variable is set correctly
[oracle@db10g /]$ echo $ORACLE_SID

set oracle_home by giving below command
[oracle@db10g /]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0.1/db01

check if the environment variable is set correctly
[oracle@db10g /]$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0.1/db01

now you can connect to the database issuing below
[oracle@db10g /]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 – Production on Sat May 31 20:07:18 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>

using .oraenv script provided by oracle, installed during software installation

[oracle@db10g ~]$ . oraenv
ORACLE_SID = [ora10gdb01] ? ora10gdb01
[oracle@db10g ~]$ echo $ORACLE_SID
ora10gdb01
[oracle@db10g ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0.1/db01

let us again login as oracle user and check the environment variables

Login: oracle
Last login: Sat May 31 20:10:07 2014 from 192.168.1.1
[oracle@db10g ~]$ echo $ORACLE_HOME

[oracle@db10g ~]$ echo $ORACLE_SID

[oracle@db10g ~]$

as you can see not output our environment variables are not set

now we will again use .oraenv to set environment variable for our second database

[oracle@db10g ~]$ . oraenv
ORACLE_SID = [oracle] ? 10gdb02
[oracle@db10g ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0.1/db01
[oracle@db10g ~]$ echo $ORACLE_SID
10gdb02
[oracle@db10g ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 – Production on Sat May 31 20:27:10 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1207959552 bytes
Fixed Size                  2020352 bytes
Variable Size             318770176 bytes
Database Buffers          872415232 bytes
Redo Buffers               14753792 bytes
Database mounted.
Database opened.
SQL> select name from v$database;

NAME
———
10GDB02

SQL>

third way  to set the environment variable in user’s .bash_profile

our user is oracle so we will set the variable as shown below

[oracle@db10g ~]$ vi .bash_profile

[oracle@db10g ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export ORACLE_HOME=/u01/app/oracle/product/10.2.0.1/db01    [this line is added]
export ORACLE_SID=ora10gdb01                    [this line is added]    

export PATH
unset USERNAME

set the variable set running the .bash_profile file (. .bash_profile)
or by login back again with user oracle

it is not recommended to set the environment variable in bash_profile because we have more then one database on a single machine.

Wishing You and Your Family a Very Happy & Prosperous New Year. Have a Blessed year ahead.

SSPL, HSPL, Flashing rom and Custom rom

Everyone who has Flashed Android on their Windows phone, seem to talk about SSPL and HSPL. So what are these ??????????????

SPL (Secondary Program Loader), is the same as your bios on the pc (it sets where your system boots from, intialises sub system process etc).

sspl (Soft Secondary Program Loader), allows you to flash another spl or hardspl.

HSPL or HardSPL (Hard Secondary Program Loader), allows flashing of any rom. It protects you from bricking your device. If you have a bad flash, it just forces the phone to load into bootloader from where you can flash another rom using

pc or storage card to get your phone working again. Using a hardspl you can flash any carrier or manufacturer rom without cid unlocking your device first.

Radio rom is a part of software which manges GSM/3G antenna.

Now if you are flashing your carriers official rom then you don’t need any of these but different carriers set their CID (Country Identification) in their roms so only phones that have their cid can flash those roms … now if you like

htc rom and want to flash on to it, you will first need to hardspl your device otherwise you won’t be able to flash the rom . It will time out with an error telling you invalid vendor id.

Flashing Custom Rom, basically means to load a different version of the operating System.

Custom ROM is the full verion of mobile operating system customized by the ROM developer’s with different set of features (Example: make it faster, provide better battery-life, customized application, utilites etc)