ORACLE ASM MOSTLY FACED ERRORS AND SOLUTIONS

1) SQL> startup;
ORACLE instance started.

Total System Global Area  629145600 bytes
Fixed Size                  1220964 bytes
Variable Size             171970204 bytes
Database Buffers          452984832 bytes
Redo Buffers                2969600 bytes
ORA-00205: error in identifying control file, check alert log for more info

solution:-

SQL> alter system set control_files='+DG1/kfc/controlfile/current.276.918365369' scope=spfile;

System altered.

SQL>
SQL> startup force;
ORACLE instance started.

---------------------------------------------------------------------------------------------
2) [oracle@teng dbs]$ export ORACLE_SID=+ASM
[oracle@teng dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 18 13:09:29 2016

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

ERROR:
ORA-01031: insufficient privileges


solution:-
[oracle@teng ~]$ export ORACLE_SID=+ASM
[oracle@teng ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 18 14:23:58 2016

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

ERROR:
ORA-01031: insufficient privileges


Enter user-name: sys as sysdba
Enter password: sys

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

---------------------------------------------------------------------------------------------
3)SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> startup force;
ASM instance started

Total System Global Area   83886080 bytes
Fixed Size                  1217836 bytes
Variable Size              57502420 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted


solution:-

create diskgroup DG1 normal redundancy
failgroup FG1 disk '/dev/raw/raw1','/dev/raw/raw2' size 5114m
failgroup FG2 disk '/dev/raw/raw3','/dev/raw/raw4' size 5114m;


---------------------------------------------------------------------------------------------

4)SQL> create tablespace tbs;
create tablespace tbs
                    *
ERROR at line 1:
ORA-02199: missing DATAFILE/TEMPFILE clause

solution:-
SQL> create tablespace tbs datafile '+DG1' size 100m;
Tablespace created.

IF U SET db_create_file_dest PARAMETER  CAN GIVE LIKE BELOW
alter system set db_create_file_dest='+DG1' scope=spfile;
SQL> create tablespace tbs1;
Tablespace created.


---------------------------------------------------------------------------------------------

5)SQL> startup
ORA-01261: Parameter db_create_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
Linux Error: 2: No such file or directory


solution:-
SQL>create pfile from spfile;
[oracle@teng dbs]$ vi initkfc.ora
change parameter like below.....
    db_create_file_dest='+DG1'

shut immediate;
startup;
alter system set control_files='+DG1/kfc/controlfile/current.276.918365369' scope=spfile; ........TAKE from ASMCMD
-------------------------------------------------------------------------------------------------
6)SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- ----------
KFC       READ WRITE

SQL> show parameter control_files;
control_files                        string      +DG1/kfc/controlfile/current.2
                                                 76.918365369


SQL> alter system set control_files='+DG1/kfc/controlfile/current.276.918365369' scope=spfile;
alter system set control_files='+DG1/kfc/controlfile/current.276.918365369' scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup



solution:-
create spfile from pfile='/home/oracle/kfc/admin/pfile/initkfc.ora';
create pfile from spfile;
create spfile from pfile;
shut immediate;
startup;
ORACLE instance started.
Total System Global Area  629145600 bytes
Fixed Size                  1220964 bytes
Variable Size             171970204 bytes
Database Buffers          452984832 bytes
Redo Buffers                2969600 bytes
ORA-00205: error in identifying control file, check alert log for more info

SQL>alter system set control_files='+DG1/kfc/controlfile/current.276.918365369' scope=spfile;

SQL> startup force;
ORACLE instance started.

Total System Global Area  629145600 bytes
Fixed Size                  1220964 bytes
Variable Size             171970204 bytes
Database Buffers          452984832 bytes
Redo Buffers                2969600 bytes
Database mounted.
Database opened.