ORA errors

ORA-01031: Insufficient Privileges while creating mview in different schema.

Recently I faced very interesting issue, when user was complaining that he is getting (SCHEMA:TEST1) ORA-01031: insufficient privileges while creating materialized view under different schema (SCHEMA:TEST2) though TEST1 has DBA role assigned. For TEST1: SQL> select * from dba_sys_privs where grantee=’TEST1′; GRANTEE PRIVILEGE ADM —————————— —————————————- — TEST1 UNLIMITED TABLESPACE […]

UNNAMED datafile issue in standby database: ORA-01111, ORA-01110, ORA-01157

We have following two reasons for getting UNNAMED files created on standby database: 1. STANDBY_FILE_MANAGEMENT enables or disables automatic standby file management. When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database. Setting this parameter to MANUAL […]

ORA-29786: SIHA attribute GET failed with error [Attribute ‘SPFILE’ sts[200] lsts[0]]

Recently while performing fresh ASM installation, I was trying to create spfile from pfile , I encountered this issue: ORA-29786: SIHA attribute GET failed with error [Attribute ‘SPFILE’ sts[200] lsts[0]] [oraasm@rmb-put-mordor ~]$ sqlplus SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 6 07:55:51 2013 Copyright (c) 1982, 2011, Oracle. All rights […]

DBCA failing with ORA-01034

I faced this issue while creating database using DBCA in one of the UAT database server. Issue was with just DBCA , I was able to create database manually without any issues. Each attempt of creating database with DBCA utility was failing with ORA-01034: ORACLE not available. After putting lots of efforts, […]