skip to main | skip to sidebar

Apun's Weblog

AWS

  • Building a sub $300/month Oracle RAC on AWS - Part I
  • Building a sub $300/month Oracle RAC on AWS - Part II
  • Building a sub $300/month Oracle RAC on AWS - Part III

Non Oracle

  • Steps to install Mysql Master-Slave Replication using Tungsten
  • Install/Configure Perl DBD for Oracle 11.2 on Redhat Linux
  • How to display Oracle PL/SQL 'OUT' variable in perl
  • MongoDB install and Quick Setup
  • Setup Data Replication from Oracle to MongoDB
  • Quick Hadoop 2 node Cluster Setup for Oracle DBAs

RAC & DG Related

  • How to Move OCR and Voting Disk to ASM Diskgroup in 11gR2
  • Oracle 11gr2 Grid: root.sh fails on node2, asmlib issue
  • Oracle 11gR2 Grid Infrastructure Installation Steps
  • Oracle: Failed to initialize GPnP
  • How To: Configure Data Guard Fast-Start Failover Step By Step
  • How To: Configure Data Guard Broker
  • Step by Step Data Guard Setup for Oracle 10g
  • What is Voting Disk & Split Brain Syndrome in RAC
  • RAC Installation on NetApps Raw Devices with ASM: Part 1
  • RAC Installation on NetApps Raw Devices with ASM: Part 2
  • RAC Installation on NetApps Raw Devices with ASM: Part 3
  • 10.2.0.1 CRS Installation and upgrade to 10.2.0.3 for RAC
  • Step by Step 11gR1 RAC CRS Installation
  • Move/Replace/Change Location of OCR & Voting Disk

DBA Related

  • Oracle Compression: To Compress Or Not To Compress
  • dbms_metadata.get_ddl & ORA-31603
  • Oracle: Rename single/RAC Database
  • IMPDP Stuck
  • Drop Materialized View takes a long time
  • Oracle Resource Manager Setup
  • How to refresh MVIEW in parallel
  • Import Error: IMP-00032: SQL statement exceeded buffer length
  • ORA-12060: During Mview Creation
  • Configuring and starting ons daemon in non RAC DB
  • Country ISO Code with Calling Code Data
  • Insert/Update XML data stored in CLOB Column
  • How To: Setup up of Oracle Streams Replication
  • How TO: Check for Charater Set Conversion Problems & Fix Them
  • Oracle Partitioning VIII - Partition Indexes
  • Oracle Partitioning - Exchange Partition
  • Oracle Partitioning - Merge Partition
  • Oracle Partitioning - Add Partition
  • Oracle Partitioning - Split Partition
  • Oracle Partitioning Types - VII (Virtual Column Based Partitioning)
  • Oracle Partitioning Types - VI (Multiple Column Partition)
  • Oracle Partitioning Types - V (Reference Partition)
  • Oracle Partitioning Types - IV (Interval Partition)
  • Oracle Partitioning Types - III (Composite Partitions)
  • Oracle Partitioning Types - II (Single Level Partitions)
  • Oracle Partitioning Types - I (Index)
  • How TO: Setup Multi-Master\Advanced Replication with Oracle 10g, 11g
  • How To: Enable Password Security/Complexity Check
  • How to: Move/Convert Database from Linux to Windows
  • Deduplication Using SecureFile for LOBS in 11g
  • Move from BasicFiles to Securefiles 11g
  • How To: Creation fo Cache Group Using Cache Administrator
  • How To Create Cache Group in TimesTen
  • Start/Stop TimesTen
  • Installation of TimesTen 7.0.5
  • How To: Install 11g DB on Windows
  • How to enable archivelog mode in Oracle 11g database
  • dbms_sqltune usage
  • In function `lcdprm':: warning
  • ORA-14074: partition bound must collate higher than that of the last partition
  • How to use Exclude in EXPDP
  • PRKP-1029, CRS-0211 on srvctl modify/add service

Popular Posts

  • PRKP-1029, CRS-0211 on srvctl modify/add service
    What I was trying to do: My requirement was to change the preferred node and available node for a service. Issues: srvctl modify service -...
  • IMPDP Stuck with wait event - "wait for unread message on broadcast channel"
    I was trying to run data import using impdp and the job was stuck with wait event "wait for unread message on broadcast channel". ...
  • Drop Materialized View takes a long time
    Recently I had to drop a couple of large Materialized View. And dropping them was taking a long time, as it tries to drop the data in both s...
  • Insert/Update XML data stored in CLOB Column
    Recently I had a requirement to insert/update XML data stored directly in CLOB column of a table by the application. There was a requirement...
  • What is Voting Disk & Split Brain Syndrome in RAC
    Voting Disk Oracle Clusterware uses the voting disk to determine which instances are members of a cluster. The voting disk must reside on ...
  • Building a sub $300/month Oracle RAC on AWS - Part I
    NOTE: The idea and inspiration of building a cheap Oracle RAC come from Amazon’s documentation ( https://aws.amazon.com/articles/74559083...
  • How To: Configure Data Guard Broker
    Configuring Data Guard Broker: NOTE: You should have your physical standby already setup. How to Setup Data Guard 1.) Check parameter DG_B...
  • How to display Oracle PL/SQL "OUT" variable in perl
    Step 1: Create a procedure in oracle with OUT variable create procedure testing (timendate out varchar2) as begin select systimestamp...
  • Step by Step Data Guard Setup for Oracle 10g
    Steps: 1.) Make sure archive log mode is enabled on your database: SQL> archive log list Database log mode Archive Mode Au...
  • Country ISO Code with Calling Code Data
    Recently was required to populate Country Name, Country ISO Code and Country Calling Code data in a table in the database. Compiled data fro...

Blog Archive

  • ► 2016 (3)
    • ► June (3)
  • ► 2014 (1)
    • ► February (1)
  • ► 2012 (6)
    • ► August (1)
    • ► May (5)
  • ► 2011 (6)
    • ► December (1)
    • ► September (1)
    • ► July (1)
    • ► May (1)
    • ► January (2)
  • ► 2010 (6)
    • ► November (2)
    • ► September (1)
    • ► August (3)
  • ► 2009 (33)
    • ► September (4)
    • ► August (2)
    • ► July (2)
    • ► May (12)
    • ► April (2)
    • ► March (11)
  • ► 2008 (11)
    • ► September (1)
    • ► August (1)
    • ► June (1)
    • ► May (1)
    • ► April (7)
  • ► 2007 (11)
    • ► September (1)
    • ► June (1)
    • ► May (1)
    • ► March (3)
    • ► February (5)
  • ▼ 2006 (2)
    • ▼ May (2)
      • Blog Logs
      • sitemap

Saturday, May 13, 2006

Blog Logs









Interview Helper

Posted by Apun Hiran at 2:18 PM    

Newer Post Older Post Home

About Me

My Photo
Apun Hiran
View my complete profile

Followers