Thursday, April 25, 2013

Oracle Database 10g: Analyze Index Vs. Gather_Index_Stats

›
  One of the difference I noticed about analyze index command and gather_index_stats procedure is that when we use analyze index command...

Reclaiming Segment Space

›
alter table ae1t3.ID_TICKET_STOCK_MASTER enable row movement; alter table ae1t3.ID_TICKET_STOCK_MASTER shrink space compact cascade; alt...
Monday, April 22, 2013

Drop 10g Database using RMAN

›
SQL> startup mount; SQL> alter system enable restricted session; $ rman target sys/dupdb@dupdb catalog rman/rman@catdb ...

Clone / Duplicate a database with RMAN

›
1.  create parameter file. SQL> create pfile from spfile; $ cp initdrprod.ora initadil.ora 2. edit parameter file and replac...
Thursday, April 18, 2013

Encrypting Data in Oracle 10g: Transparent Data Encryption (TDE)

›
SOURCE:   http://oracleinsider.wordpress.com/2009/05/09/encrypting-data-in-oracle-10g-transparent-data-encryption-ted/ Encrypting D...
Thursday, March 14, 2013

dbconsole can’t be started with ssl error

›
got error  in emdctl.trc : http: 257: Unable to initialize ssl connection with server, aborting connection attempt bash-3.2$ em...
Saturday, December 15, 2012

LGWR Generates Trace file "Warning: Log Write Time xxxms, Size xxxxkb"

›
Found tracefile omr_lgwr_841.tr, and below error after patched database to 10.2.0.4 /u00/app/oracle/admin/omr/bdump/omr_lgwr_841.trc Or...
2 comments:
Monday, December 3, 2012

Enabling Flashback Database in Oracle:

›
Enabling Flashback Database in Oracle: SQL> select flashback_on from v$database; FLASHBACK_ON ------------------ NO SQL> S...
Wednesday, November 28, 2012

RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

›
RMAN attempted to backup an archive log file, but couldn't find it. This can happen for a variety of reasons; the file has been ma...
Saturday, November 24, 2012

Unable to start DB Control oracle 10.2.0.4 & 10.2.0.5

›
After 31-Dec-2010, all 10.2.0.4 and 10.2.0.5 dbconsoles will face problems during secure/unsecure operations and during dbconsole configu...
2 comments: