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 -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...
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...
Oracle: Rename single/RAC Database
Method 1: Recreate control file with the new DB name, the old tried and tested method. Method 2: Use new utility called NID Steps to renam...
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...
How To: Setup up of Oracle Streams Replication
Note: I have started using TOAD now, so you wont see the statement complication output. Step 1: Create stream administration user in both ...
Oracle 10g RAC Installation on NetApps Raw Devices with ASM: Part 1
Setting Up storage: For performance benefits while using ASM we would be using iSCSI devices instead of virtual devices on NFS filesystem....
Step by Step 11gR1 RAC CRS Installation
Oracle Global Support strongly recommends that you use Red Hat Enterprise Linux ES/AS 4 (update 3 or higher). This is kernel 2.6.9-34 or gre...
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