Monthly Archives: September 2008

How to change default tablespace for LogMiner tables in Oracle Streams

— Create a new tablespace CREATE TABLESPACE LOGMNR_TBS DATAFILE ‘+CDATA2’ SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED / –Then move the objects from SYSAUX (default tablespace) to new tablespace. BEGIN DBMS_LOGMNR_D.SET_TABLESPACE(‘LOGMNR_TBS’); END; / — If there are active log miner session, … Continue reading

Posted in Oracle LogMiner | Tagged | 1 Comment

Applying Oracle Interim Patches using opatch

When we need to apply a Oracle Interim Patchs for a specific bug fix, we can use opatch command line interface. When we are applying the patch to a standalone database, we can use following command $ /u01/app/oracle/product/10.2.0/OPatch/6145177> opatch apply … Continue reading

Posted in Oracle One-Off Patch | Tagged | Leave a comment

Streams Replication Heartbeat

Heartbeat table in a Streams replication is very useful, to track the status of the replication. Instead of going to all monitoring tables, it can give us a status at a glance. We can use following example to implement Streams … Continue reading

Posted in Oracle Replication | Tagged | 4 Comments

How to resolve ORA-1119 in ASM environment?

Scenario: I was running out of space in one of the ASM diskgroup. I added new disks, same size of existing disks in diskgroup. Disks were added successfully. But when I tried creating the datafile using the the diskgroup (where … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | 2 Comments

How to change the SHARED_POOL_SIZE in ASM instance?

Recently, when I was trying to select some information from the ASM view, I stared getting ORA-04031 errors in ASM alert.log, which was quite unusual. SYS@+ASM> select * from v$asm_diskgroup * ERROR at line 1: ORA-00604: error occurred at recursive … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | Leave a comment