AWS
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
-
What I was trying to do: My requirement was to change the preferred node and available node for a service. Issues: srvctl modify service -...
-
I was trying to run data import using impdp and the job was stuck with wait event "wait for unread message on broadcast channel". ...
-
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...
-
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...
-
Voting Disk Oracle Clusterware uses the voting disk to determine which instances are members of a cluster. The voting disk must reside on ...
-
NOTE: The idea and inspiration of building a cheap Oracle RAC come from Amazon’s documentation ( https://aws.amazon.com/articles/74559083... -
Configuring Data Guard Broker: NOTE: You should have your physical standby already setup. How to Setup Data Guard 1.) Check parameter DG_B...
-
Step 1: Create a procedure in oracle with OUT variable create procedure testing (timendate out varchar2) as begin select systimestamp...
-
Steps: 1.) Make sure archive log mode is enabled on your database: SQL> archive log list Database log mode Archive Mode Au...
-
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
