Fix Oracle 10g 11g Data Pump IMPDP Failed withORA-39002 ORA-06512 ORA-39070 ORA-29283: invalid file operation

Error Description:
Oracle datapump impdp fails with following error.
impdp dumpfile=exp_TAB_28122011.dmp directory=DATA_PUMP_DIR logfile=exp_TAB_28122011_imp.log job_name=EXP ignore=y
Import: Release - Production on Wed Dec 28 06:19:40 2011

What are the Considerations for EXADATA Smart Scan Cell Offloading?

In below mentioned situations the exadata predicate evaluation will not offloaded.
  • If you use more that 255 columns in the query
  • The object which belongs to the tablespace is not stored on the Exadata
  • If a virtual column is present on the query

One More Interactive Music Doodle from Google: Happy Holidays 2011

Once again goole released interactive music doodle during the 2011 holyday season. It has good graphics which represents the X-mas and holidays. Each letters of google transforms to beautiful graphics images and once you finish click on buttons of all characters, the letters starts dancing with the Jingle Bells music. Enjoy the doodle in this link. 

EXADATA Smart Scan - cell_offload_plan_display = NEVER / AUTO /ALWAYS Parameter

CELL_OFFLOAD_PLAN_DISPLAY parameter desides whether the SQL execution plan to show or not to show the offload predicates. This parameter can be dynamically modified by using ALTER SESSION or ALTER SYSTEM command. This parameter will not make any difference to the SQL execution speed.

The parameter values can be

Fix Duplicate Database failing RMAN-06136: ORA-01618: redo thread is not enabled - cannot mount

Error description: RMAN duplicate command is failing with following error.

RMAN-00571: =================================================
RMAN-00571: ===============================================
RMAN-03002: failure of Duplicate Db command at 12/21/2011 04:43:44
RMAN-05501: aborting duplication of target database

opt_param ( 'cell_offload_processing' , ’TRUE/FALSE’ ) Hint to Enable EXADATA Smart Scan Feature: Speed Comparison with Smart Scan

opt_param( ‘cell_offload_processing’ ’TRUE’) hint is used to enable the exadata smart scan feature in sql execution process. Please see some speed comparison below with and without smart scan.

You can disable the smart scan feature in session level by using following commands
To Disable: alter session set CELL_OFFLOAD_PROCESSING = FALSE;
To Enable: alter session set CELL_OFFLOAD_PROCESSING = TRUE;

Floating Facebook Like, Share, Google Plus One +1 Button Gadget HTML Code For Blogger

Steps to Implement the code.

  1. Go to Blogger Dashboard > Design > Page Elements.
  2. Click Add A Gadget.
  3. In Add A Gadget window, select HTML / Javascript.
  4. Copy below mentioned code and paste it inside the window.
  5. Click Save.

Google Language Translator Gadget HTML Code: With Small Beautiful Flags for Blogger

Steps to Implement the code.

  1. Go to Blogger Dashboard > Design > Page Elements.
  2. Click Add A Gadget.
  3. In Add A Gadget window, select HTML / Javascript.
  4. Copy below mentioned code and paste it inside the window.
  5. Click Save.

Main Reasons for Delay or Not Receiving the Adsense PIN after a Period of Time

All publishers are required to enter a Personal Identification Number (PIN) to get the eligibity to get the payments from Adsense. PIN detail comes to your mailing address. PINs are necessary to verify and validate the accuracy of your contact information, mailing address. After entering the PIN, Adsense team ensure that you can receive your payments.

Different Methods to Print Single Quote (') in AWK programming

This is my input file

cat dat
NO         TAG20111217T004155
YES        TAG20111217T004157
YES        TAG20111217T004157

Fix RMAN-03009 ORA-00245 RMAN-08132 control file backup operation failed

Error Description: RMAN backup is getting failed with following error.

RMAN-00571: ===================================================
RMAN-00571: ===================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 12/15/2011 05:24:57
ORA-00245: control file backup operation failed

Tested Tips to Increase or Improve Adsesnse CTR

General Facts on Adsense CTR
  • Adsense CTR is closely related the traffic on your website. The more traffic you achieve on your website the CTR gradually increases.
  • Eventhogh the revenue is related to the CTR, it more related on where the traffic or click is coming from. I.e. The clicks from certain countries like US, UK, Australia, etc pays more for each click.

Oracle 11g 10g Database SQL Script to Find Out Active Sessions Waits

This script outputs the current wait states for all active database sessions.
COLUMN dbusername FORMAT A12
COLUMN sid FORMAT 999999
COLUMN serial# FORMAT 99999999

Fix DB Link Error ORA-02085: database link connects to

Problem Description:

Select from database link failing with following error
SQL> select 1 from dual@PRODDB1;
select 1 from dual@PRODDB1
ERROR at line 1:
ORA-02085: database link PRODDB1 connects to TEST3E

Oracle 10g 11g RAC ASM RMAN Database Cloning to Different Server with Different File System

Here is the Scenario:
We have 3 RMAN backup pieces from the source database (SOURCE)
Backup pieces which is already trasfered from ASM to file system :
mfmtiqi3_1_1, mhmtiqk5_1_1, SOURCE_cf_c-3981864101-20111207-00

How to Rename Oracle Database Using NID command Line Utility

Requirement is rename the database name from SOURCE to TARGET

  1. Create the initTARGET.ora file with necessary parameters. Db_name parameter value must be TARGET.
  2. Shutdown the SOURCE database

Oracle 10g 11G RAC Database Control File Creation Failed with ORA-01503, ORA-12720: operation requires database is in EXCLUSIVE mode

Error Description
Oracle RAC database control file creation failed with following error.

ORA-12720: operation requires database is in EXCLUSIVE mode

How to Change Oracle 11g 10g RAC database to Noarchivelog mode?

  1. Veryfy the current log mode using below mentioned query
SELECT log_mode FROM gv$database;


How to See the Oracle 10g 11g Bind Variable Values Using v$sql_bind_capture

Here is the simple query to see the bind variables from Oracle database.

SELECT     s.sql_id,   s.sql_text SQLTEXT, BIND_VAR_NAME, 
bc.value_string BIND_VAR_STRING
FROM       v$sql s  , v$sql_bind_capture bc
WHERE      s.sql_id = bc.sql_id

Benefits of Registering Own Custom Domains for Your Blog on Blogger or WordPress

  • The blog without a domain will show as the subdomain of their (blogger/wordpress) domains. Some of the benefited services will be limited for the subdomains. The subdomain address will block your website from displaying some featured ads.  Example:

Reset the Password for an Oracle Expired Login or Username to Old or Previous Value

Sometimes we don’t remember the passwords for some application user/logins which we hard coded in the application. These users/logins password get expired by the aging. Even though the account password is expired the encrypted password values will be stored in the database. There are two ways to find out the encrypted values and reset it to the old value.

RMAN Reset Incarnation Failed: ORA-19910: can not change recovery target incarnation in control file

You cannot the reset of the database if it is in open or nomount state. If you try to perform the reset database to incarnation Command you will get ORA-19910 error message. You have to reset the incarnation in mount state. Now you can perform the recovery from the previous incarnation.

How to Restore Oracle RMAN Backup from Previous or Old Incarnation

Some fact about this Restoration:

  • It will be a point-in-time recovery
  • You must set the incarnation to the previous or required one accorind to your restoration time using RESET DATABASE command

How to Force Oracle RMAN to Delete All Archive log files

As a DBA, in many situations you get archive destination going to be filled or filled with archivelogs. Immedidately you are force to remove some or all archives. Here are the commands to remove the archivelogs.
Note: If you remove archivelogs with out backing up it is better to take a fresh level 0 backup of the database to avoid the data lose.

Oracle RAC Startup failed ORA-01102: cannot mount database in EXCLUSIVE mode

Problem Description
Oracle RAC database startup command failed with ORA-01102: cannot mount database in EXCLUSIVE mode.
Error Description:
The error is because the database is running or opened in EXCLUSIVE mode in one node. So you can not start the database in another node with normal startup command.

Database startup failing ORA-19815: WARNING: db_recovery_file_dest_size of bytes is 100.00% used,

Your database db_recovery_file_dest is full and it does not have any room for any more files. So you have to clean up your db_recovery_file_dest location

1. Find out your db_recovery_file_dest location from the init file and clean up some unwanted files from the location

RMAN-06059 ORA-19625 backup archivelog all delete input

Problem Description
RMAN archivelog all delete input is failing with following error.
Starting backup at 01-DEC-11
using channel ORA_DISK_1
using channel ORA_DISK_2

FIX RMAN-11001 ORA-01547 "warning: RECOVER succeeded but OPEN RESETLOGS would get error below"

Error Description:
Open resetlogs fails with 01152, 00000, "file %s was not restored from a sufficiently old backup "

Solution Description:
It looks like the datafiles are not consistent state. The datafiles must be in consistent state after the recovery to open the database in open resetlogs.

Fix RMAN-08138: WARNING: archived log not deleted - must create more backups

Error description: RMAN delete archivelog all command is failing with RMAN-08138 warning.

Solution Description:
The archive log files which you are trying to delete is still needed for recovery.


Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2) Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer