How to install & configure Oracle Internet Directory on Linux 86-64 bit system

How to install & configure Oracle Internet Directory on Linux 86-64 bit system.

Oracle Wallet for Passwordless Connection to Database with Scripts

Exposing passwords to Oracle database accounts poses security risks. Here in this article, let us see how we can hide password using Oracle Wallet.

Transparent Data Encryption Using Oracle Wallet

Transparent Data Encryption (TDE) provided by Oracle database enables us to encrypt data that are stored in tables. Oracle database decrypts such data for applications and users who have access to the data. In this article, let us see how we can configure the database to implement TDE.

Create 12c Container Database Without Pluggable Database

Here in this article, a 12c R1 container database is created without creating a pluggable database.

Install Oracle Database 12c R1

Let us see the procedures to install Oracle's latest database verion, 12c R1 on a x86_64 Linux machine in this article.

RMAN Report Commands

RMAN provides some commands that help us get information about backupsets, those that have passed the retention policy, etc. Here we look at some of them.

How to Find Deprecated Parameters

While starting up a database, we sometimes see messages saying obsolete or depricated parameter(s).

Let us see how to identify the depricated parameter that is present in database.

Grant Privilege to Other Schema at once

How to grant select on all tables in a schema to another user

Oracle does not provide a single statement to grant privileges on all tables. Instead, we make use of PL/SQL block to acheive this.

Bewildering EXCLUDE of IMPDP / EXPDP

impdp and expdp has EXCLUDE options which perplexes some of us some point in time, that too, when you are boiling...

SQL Loader : ORA-01722: invalid number

Sometimes, we get a SQL Loader datafile were the data does not match the data type of the column. Here, we look at resolving how "invaid number" error from SQL Loader can be fixed.

Setting up backup job using shell script & expdp to backup database

How to set backup job using shell script and expdp to backp database fully or a specific schema

Disable Database Auto Segment Space Job

How to disable Auto Segment Space job from executing.

Oracle National Character Set and Character Set

Character Sets are the notations how systems stores data. Oracle uses two character sets : Character Set and National Character Set.

Myriad utilities of RMAN

RMAN is not just a backup, restore & recover utility anymore. It has a plethora of usefulness. Let us see some of them.

How to block & Unblock OEM Agent

I came across a situation where "emctl upload agent" was erroring out with AGENT_BLOCKED message

INCLUDE and EXCLUDE are mutually exclusive in Impdp

How to resolve Include and Exclude incompatiblities

How to use Oracle's ADRCI

ARDCI is used to create Incident Package using Incident Package Service, the new Diagnostic utility from 11g database. The incident package thus created is uploaded to Oracle Support for diagnosis to support Service Request (SR).

Bewildering EXCLUDE of IMPDP & EXPDP

impdp and expdp has EXCLUDE options which perplexes some of us some point in time, that too, when you are boiling...

Understanding various values that ACCOUNT_STATUS column of DBA_USERS table can take

ACCOUNT_STATUS can take 9 different values and these values are in USER_ASTATUS_MAP table.

Resolving Inconsistent Properties in Data Guard Broker

This article tries to resolve InconsistentProperties arising out of mismatch of parameter values between spfile, Data Guard Broker configuration and the database.

Soon after configuring Data Guard Broker, we may find various issues that makes broker not to run properly. The most common issue being the mismatch between the parameter values present in spfile, broker configuration and the database.

Overcoming ORA-01156: recovery or flashback in progress may need access to files

How to over come ORA-01156: recovery or flashback in progress may need access to files

Controlfile Multiplexing in ASM

Steps on multiplexing controfile when the controlfile resides in ASM.

Renaming datafiles using RMAN

RMAN eases up renaming datafiles, no matter how big the datafile is. Take a look.

Archivelogs writting to wrong directory. How to resolve

Check various possibilities of how archive logs can setting to wrong directory and thus filling up filesystem.

How to handle shared libraries loading

How to handle shared libraries loading

How to resolve No protocol specified error

No protocol specified error comes up when we run graphical user interface installers and exits the installer giving Exception in thread "main" java.lang.NoClassDefFoundError. We see how we can resolve this error.

How to find all privileges granted to users and roles

How to find all privileges granted to users and roles

How to change the password from SQL*PLUS

How can user change his password with an assistance

Oracle Profiles

Profiles helps DBA to control usage of database resources by user sessions and a policy to manage passwords.

How to delete duplicate rows when table does not have primary key

Deleting duplicate rows is trickey when there are no rows that uniquely identifies the rows. Let us see how we can achive this...

DBA_USERS.ACCOUNT_STATUS shows OPEN status when EXPIRY_DATE is alreay passed

We see that the status of an account is OPEN when the expiry date is aleady older than current date. What causes this?

How to configure Data Guard Broker

How can we configure Data Guard Broker...

How to drop a 10g database using DROP DATABASE command

How to reduce the burden of finding all files belonging to the database and removing each of them one by one by a single command. DROP DATABASE command does most of the work, but, we still need to make our mitts grubby...

Data Guard : Parameters

All data guard parameters we need to know

Data Guard : A Practical Approach to Quickly Building Physical Standby Database

Creating physical standby database on the same machine where primary database is running does not serve any reasonable purpose. But, we cannot rule out any possible usage of this layout. Here, we see how we can configure primary and standby databases running on same machine.

Parameter GLOBAL_NAMES

What is GLOBAL_NAMES and how does it effect database operations...

Configuring archiving to Flash Recovery Area

Sometimes, we require that the archive logs be configured on FRA so we can back them up with RMAN...

Enabling archive logging

Configuring archiving on a databases have various benefits. Production databases can't be without it. Let us look ways to configure...