Tuesday, November 6, 2012

11g File Watcher

›
http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse005.htm http://www.oracle-base.com/articles/11g/scheduler-enhancements-11gr2...
Monday, November 5, 2012

11g Migration using RMAN

›
The steps for 10g database: 1- Run the utlu112i.sql Pre-upgrade script. You can find this script under @$ORACLE_HOME/rdbms/admin/. It mus...

Listener ORA-00119 ORA-00132

›
Issues with setting Local Listener ORA-00119 ORA-00132 Today I was caught up in a issue with TNS while trying to setup SOA setup with OE...

ora 12560 tns protocol adapter error database DBCA fails

›
ora 12560 tns protocol adapter error database DBCA fails -------------------Most common reasons for ORA-12560 in Windows are-------------...

Create Database Structure using Datapump

›
You can use the INSERT statement to insert data into a table, partition, or view in two ways: conventional INSERT and direct-path INSERT. W...
Saturday, November 3, 2012

Create Schema Objects

›
Note: This will not work from 10g to 11g version......................procedure will be corrupted set pagesize 0 set linesize 30000 se...
Thursday, October 18, 2012

Temporary Tablespace Related Scripts

›
To check instance-wise total allocated, total used TEMP for both rac and non-rac set lines 152 col FreeSpaceGB format 999.999 col U...

Blocking Session Lockwait Best

›
SELECT TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' User ' ||s1.username || '@' || s1.machine || ' ( SID= ...
Tuesday, September 25, 2012

expdp procedure in 11g

›
 1) create directory export_auto as 'd:\expdp1213';  create user dba_export_user identified by test123; grant connect, create d...
Friday, September 21, 2012

RMAN Block Media Recovery

›
From Oracle 9i onwards you can use RMAN to recover only blocks while database is up and running. This could possibly save hours and hours ...
Thursday, September 20, 2012

Table level Recovery using Flashback Table

›
---------------------------------------------------Recover Dropped Table from Recyclebin using Flashback Table------------------------- ...
Friday, September 14, 2012

11g Active Data Guard - enabling Real-Time Query

›
Active Data Guard is a good new feature in 11g (although requires a license) which enables us to query the Standby database while redo log...