Category Archives for Database

How can i see, Critical Patch Update is installed on the database,

Note that the methods in this note will allow you to check upon an Oracle installation, it is still recommended for a DBA to properly document all applied patches to the software installation. The output of ‘opatch lsinventory’ will give you a list of bug numbers, but it can be awkward to cross reference them […]

Read More

Embedding SQL in Shell

Embedding a SQL inside Shell Script:- Here is a tip on how to run sqlplus scripts within a shell script. This is an example of how to pass database values into shell variables, and to make shell scripts more dynamic. This will help DBA to automate certain DBA tasks, also to setup some automation using […]

Read More

Validating and rebuilding large and fragmented indexes in 11i

You can have various methods to identify the large or fragmented indexes in 11i or you can just configure the Oracle Alert to receive a mail. This alert is scheduled to check the situation periodically say daily at mid night. The alert ‘Indexes too large or fragmented‘ is pre-defined alert. There are three possible ways […]

Read More

Upgrade overview for Oracle Database to 11g Release 1 (11.1)

Steps mentioned in this post is overview of Oracle database upgrade from 8i, 9i or 10g to 11g Rel 1 i.e. 11.1.X.X.X (Step by step Oracle 10g upgrade to 11g including pointer to documentation coming soon…) Things good to know for 11g Database Upgrade 1. Oracle 11g Database software must be installed in new ORACLE_HOME 2. If you […]

Read More

Oracle Database – RMAN overview

Solution available for backup and recovery of Oracle Database i) RMAN (Recovery Manager) ii) User Managed backup (using o.s. commands like cp, copy..) . RMAN (Recovery Manager) – is Oracle Database client that perform backup & restore task of oracle database. . Components in RMAN 1. Target Database – is Oracle database which you want […]

Read More

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