Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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.







Comments

Popular posts from this blog

PostgreSQL Pgbadger Installation On Linux

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?

7 Steps to configure BDR replication in postgresql

PostgreSQL Sequence