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
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...
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 Auto...
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 ...
Import Error: IMP-00032: SQL statement exceeded buffer length
While trying to import a big table with 1000s of partitions I got error: IMP-00032: SQL statement exceeded buffer length IMP-00008: unrecogn...
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...
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...
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". ...
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...
How To: Configure Data Guard Fast-Start Failover Step By Step
Note: Physcial Standby should be working fine and Data Guard Broker has already been configured and working fine. How to Setup Data Guard Ho...
How to refresh MVIEW in parallel
Refresh TYPES are COMPLETE/FAST/ON COMMIT/ON DEMAND Couple of things you should do to make a mview to refresh in parallel: 1.) Alter the mas...
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