Daily Archives: April 1, 2015

Monitoring Index Usage


SQL> create table anar1 (id number); Table created. SQL> insert into anar1 values (1); 1 row created. SQL> insert into anar1 values (2); 1 row created. SQL> insert into anar1 values (3); 1 row created. SQL> commit; Commit complete. SQL> create index idx_anar1_id on anar1(id); Index created. SQL> select table_name, index_name, monitoring, used from v$object_usage; […]

ORA-15001: diskgroup “DATA” does not exist or is not mounted , ORA-15077: could not locate ASM instance serving a required diskgroup


Problem: ORA-00210: cannot open the specified control file ORA-00202: control file: ‘+DATA/kbazerdr/controlfile/current.256.825098041’ ORA-17503: ksfdopn:2 Failed to open file +DATA/kbazerdr/controlfile/current.256.825098041 ORA-15001: diskgroup “DATA” does not exist or is not mounted ORA-15077: could not locate ASM instance serving a required diskgroup ORA-205 signalled during: ALTER DATABASE MOUNT STANDBY DATABASE… Analyze: 1) check if CRS is running on […]