As we know all that in the world of technology we have to fill ups user and password name multiple times . We must know what is actually happens while we enter incorrect password. First few lines give some basic idea about the Authentication. Authentication is a process in which the credentials provided are compared to those […]
All posts by Anuradha Mudgal
Anuradha Mudgal
Database Design(Software Selection)
Today we are going to talk about most important part of the Database. As a fresher, we all have a dream to do something different and we choose DBA as a profession. As my personal experience as a fresher I wanted to be Oracle DBA and today I feel proud to work as DBA. Let’s have look at […]
Oracle Internals – Fixed Objects – Part 1
Dynamic Performance Views Oracle contains a set of underlying views that are maintained by the database server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuously updated while a database is open and in use, and their contents relate primarily to performance. Although these views […]
ORA-30032: The Suspended (Resumable) Statement Has Timed Out
PROBLEM: While doing a transaction, it was hung for few seconds and got the below error. SQL> create TABLE TEST_3 as select * from dba_objects; create TABLE TEST_3 as select * from dba_objects * ERROR at line 1: ORA-30032: the suspended (resumable) statement has timed out CAUSE & SOLUTION: Let’s check the alert log: […]
How to recover database without knowing DBID or DB Name
This article is a bit different from other recovery and backup case studies. The solution to this scenario has given by my fellow DBA Sham. Being a DBA we all are must aware of some different conditions that can occur in different conditions. In this post, we are going to learn about the steps which […]
Recover a datafile from copy
Let’s recover if some datafile is unavailable. Let’s delete users01.dbf datafile which is in USERS tablespace. [oracle@node214 DB11G]$ pwd /u01/app/oracle/oradata/DB11G [oracle@node214 DB11G]$ [oracle@node214 DB11G]$ mv users01.dbf users01.dbf.bak #as backup file. [oracle@node214 DB11G]$ Let’s try to create a table name A in tablespace Users. SQL> create table a(id number) tablespace USERS * ERROR at line 1: […]
Recover controlfile
Controlfiles saved at least in 2 locations. If one of them is corrupted then you can copy from other one after shutdown database. In this case I will show you how to recover from autobackup via RMAN. So you need CONFIGURE CONTROLFILE AUTOBACKUP ON; in RMAN and you should have full backup database. It can […]
Oracle Engineered System MiniCluster S7-2 installation, step by step, short info
Here , I will write about how to initial software setup MiniCluster S7-2. (short guide) Pre-Installation Checklist DNS server NTP server at least 12 ip addresses for initial setup. Additional 7 ip addresses for 2 nodes RAC setup. (3 scan , 2 vm, 2 vip) More IP addresses for additional virtual machines or more grid […]
Changing password securely in Oracle
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – We are living in the world of username and password life. We all have countless password due to technology’s development. Password plays an important role in our life. Oracle Database leads the industry in security. To maximize the security […]
ORA-08104: This Index Object Is Being Online Built Or Rebuilt
This post is about “ORA-08104”. We are going t learn how to solve this issue. Steps are mention below:- While dropping an index, if you are facing ORA-08104 error, then you need to clean it using dbms_repair Problem: SQL> drop index eric_icmsprod.SOTRAN00_IDX1; drop index eric_icmsprod.SOTRAN00_IDX1 * ERROR at line 1: ORA-08104: this index object 94771 […]