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
How to: Move/Convert Database from Linux to Windows
There are two basic methods to achieve this. Method 1 ======== Steps 1: Check the ENDIAN format of the platforms. Both Windows and linux sho...
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 -d ...
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...
Building a sub $300/month Oracle RAC on AWS - Part II
In the previous post ( Building a sub $300/month Oracle RAC on AWS - Part I ) we discussed the network setup required for Oracle RAC. In t...
Oracle 10g RAC Installation on NetApps Raw Devices with ASM: Part 2
Start the iSCSI service on the hosts: If you are using dm-multipath, be sure you have configured multipathing before starting iSCSI. Use...
Oracle Partitioning Types - IV (Interval Partition)
1.) Interval-Partitioned Tables (11g) Extract from Oracle Documentation --------------------------------------------------------------------...
Oracle 10g RAC Installation on NetApps Raw Devices with ASM: Part 3
Installing and Configuring Oracle ASMlib Oracle ASMlib is software provided to ease the configuration of Disk Devices. Please download t...
Oracle 11gr2 Grid: root.sh fails on node2, asmlib issue
A very interesting problem which took me quite a while to resolve. Issue while running root.sh on node 2 during 11gr2 grid software installa...
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
)
Job List from Google Group
►
June
(
1
)
►
May
(
1
)
►
March
(
3
)
►
February
(
5
)
►
2006
(
2
)
►
May
(
2
)
Saturday, September 22, 2007
Job List from Google Group
View RSS feed
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
About Me
Apun Hiran
View my complete profile
Followers