Category Archives for Database

How to check Corruption in Database Using DBVERIFY

The primary tool for checking for corruption in an Oracle database is DBVERIFY. It can be used to perform a physical data structure integrity check on data files whether the database is online or offline. The big benefit of this is that DBVERIFY can be used to check backup data files without adding load to […]

Read More

Datapump-2

 This post is in continuation of my previous post on  Oracle Datapump Part I here   Directory: In Datapump syntax we found Directory, What does this directory means ? Does it talk about the OS level directory ??? well you can say that here directory means object. we need to create database level directory as well […]

Read More

Database Listener Hangs Intermittently

      I would like to share one thing here, which i resolved recently. Problem was Database Listener hangs intermittently in 10.2.0.1 instance. It might happen in the 10g versions(10.1.0.3, 10.1.0.4, 10.1.0.4.2, 10.1.0.5, 10.2.0.1 and 10.2.0.2). This is mostly specific to Unix/Linux platforms. The issue was  —> Users were not able to connect to database  —> There […]

Read More

Datapump in Oracle

Datapump is 10g new features useful to do export/import which is called as unload/load data too. There is one drawback with compare to normal export/import is… The DataPump export/import jobs need more startup time then the old export and import utility, so for small jobs better to use normal export/import utility. 2) DataPump export data only to […]

Read More

Configure Oracle Data Guard Part II

This is in continuation of Oracle Dataguard configuration part I  which I posted long back and forgot to update next one.    One of my friend was looking for steps so I thought of finishing this (If you think I missed any post just leave comment and I’ll try to post on that topic) Ensure that […]

Read More

Change Data Capture – Oracle CDC

CDC : is database functionality that helps in capturing incremental changes to Oracle Database. Terminology in CDC Publisher: is database user that publishes captured changed data Subscriber: is database user that consumes changed data Change Tables: Changes in database are written to change tables Subscriber Views: are database views against change tables for subscribers. Note* […]

Read More

Errors in Alert Log File of 10.2.0.1 Instances

These are the following Errors/Warning messages which we will get in 10.2.0.1 release Instances alert log files.  Find the following work arounds/solutions, what I have successfully applied.  Problem 1:  Memory Notification: Library Cache Object loaded into SGA Heap size 6237K exceeds notification threshold (2048K)  These are warning messages only which should not cause any problems. […]

Read More

Kill Oracle Sessions

                        One day My manager fired one sql statement, it got stuck and not moving further. He called up me and asked to kill Oracle Session. I immediately killed his oracle session using SQL*PLUS approach. I would like to share what I did . Here I am giving the procedurehow to kill Oracle Sessions using […]

Read More

Oracle RAC Part IV : Install Oracle Clusterware and Cluster Database

This is fourth and last post for installing Oracle RAC Database on single machine using VMWare virtual machines. In this part we will install oracle clusterware and rac database Copy Oracle RAC and Oracle Database Software to RAC1 Create a directory software in $HOME and copy clusterware and database zip files downloaded unzip 10201_clusterware_linux32.zip unzip […]

Read More

Orcale RAC Part III – Clone RAC1 to RAC2 and User Equivalency

This is fourth post on step by step building Oracle RAC Database on your desktop / laptop using VMWare (Virtual Machine) For previous three posts visit Try installing Orcale RAC on your laptop RAC Part I – Install Virtual Machine and Linux RAC Part II – Install Virtual Disk and Network Card In this post […]

Read More