-
Archives
- April 2019
- March 2019
- September 2018
- August 2016
- July 2016
- May 2015
- April 2015
- December 2014
- November 2014
- August 2014
- February 2014
- January 2014
- November 2013
- July 2013
- June 2013
- March 2013
- December 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- March 2012
- October 2011
- August 2011
- June 2011
- May 2011
- April 2011
- March 2011
- December 2010
- November 2010
- October 2010
- August 2010
- July 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
-
Meta
Category Archives: Oracle in general
ACFS Snapshots
This is a short article about ACFS and the acfs snapshots feature – a new 11g Release 2 feature: How to create, work with and drop a snapshot. ACFS is the ASM Cluster File System and ships with Oracle 11g … Continue reading
Posted in Oracle in general
2 Comments
Oracle database and operating support matrix
The following matrix shows a matrix of operating systems, database version and certification status. All information is taken from the database documentation and information freely available on the internet (e.g. oracle forums, blogs). The information is structured first into operating … Continue reading
Posted in Oracle in general
8 Comments
Using data pump to export and import data using the network mode feature
Data Pump is a great improvement of the old fashioned export and import utility. Data Pump is available since 10g Release 2 and offers some nice new features, for instance a API to be used to start exports and imports … Continue reading
Posted in Oracle in general
2 Comments
How to copy schema stats from one schema to another schema
The following post is a short description how to copy schema statistics from one schema to another. Basically there are two methods for doing this: using DBMS_STATS or using Data Pump This is especially useful when doing large data transfers … Continue reading
Posted in Oracle in general
8 Comments
Calculate required kernel parameters for running Oracle 11g Release 2 on Linux
The following is a short guide on how to calculate the required kernel parameters for running Oracle 11g Release 2 database on Linux. In addition to that i add some parameters recommended by myself. Note that for running Oracle Grid … Continue reading
Posted in Oracle 11g Release 2, Oracle in general
4 Comments
ASM resilvering – or – how to recover your crashed cluster
In this and the following posts i will perform some crash and recover scenarios and show how to recover the cluster successfully. At the moment the following tests are planned and will be published during the next days: suddenly turning … Continue reading
Posted in Oracle 11g Release 2, Oracle ASM, Oracle in general
2 Comments
ASM resilvering – or – how to recover your crashed cluster – Test no 5
In this post we will reproduce a more common scenario: We will forcefully remove the asm disk device from the operating system. This simulates common errors like a crashed storage system or some kind of interrupted connectivity (cable plugged, power … Continue reading
Posted in Oracle in general
3 Comments
Backing up your system configuration
When backing up servers with any kind of backup software you will most certainly backup your data. But how about the system configuration? When restoring a system from scratch do you know how big the disks were, what partition sizes, … Continue reading
Posted in Oracle in general
Leave a comment
Oracle on linux – yes of course – but what linux?
There is a discussion from December 2008 what Linux (SLES vs. Red vHat vs. Oracle Enterprise Linux) to use for running oracle on Linux by Yann Neuhaus. You can read his post here. After nearly one year i wanted to … Continue reading
Posted in Oracle in general
2 Comments
ORA-01555 (snapshot too old) error although undo_retention set to a high value
The past week i had a argumentation with a colleague of mine on the behavior of the parameter undo_retention in 10g. He stated in 10g undo_retention determines the lower number of seconds oracle keeps the undo records. If there is … Continue reading
Posted in Oracle in general
Leave a comment