-
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
ASM resilvering – or – how to recover your crashed cluster – Test no 1
In the first test we will just disable one node under normal load. Lets see what the different components (clusterware, asm instance, advm/acfs) report:
Posted in Oracle in general
2 Comments
ASM resilvering – or – how to recover your crashed cluster – the Environment
We use the same environment we installed here which consists of two virtual machines running Oracle Enterprise Linux 5 Update 3 64-bit with Oracle 11g Release 2 (Grid Infrastructure and Oracle binaries) installed. All data is placed in ASM with … Continue reading
Posted in Oracle in general
1 Comment
Is it allowed to quote Metalink Notes completely or partially?
Writing posts for this blog i wondered: Am i allowed to post Metalink Notes entirely or partially in my blog posts? Looking at the web i did not find any information. I might have read the Oracle Support License but … Continue reading
Posted in Oracle in general
Leave a comment
ext3 – beware of periodic file system checks
Users running Oracle on Red Hat or Oracle Enterprise Linux will most probaly use ext3 as default file system. It is robust, well maintained, a journaling file system and supports file system sizes up to 32 TB. Database servers must … Continue reading
Posted in Oracle in general
5 Comments
Storing Oracle database connection strings in OpenLDAP instead of OID
Storing Oracle database connection strings in OpenLDAP – or – “Oracle Names for the masses” Typically Oracle stores it´s database connection strings in a file called TNSNAMES.ORA. Among storing every database connection string in this file there are other different … Continue reading
Posted in Oracle in general
21 Comments
Oracle 11g Release 2 – SSH equivalence gone after reboot
Today i came across a strange phenomenon: I set up ssh equivalence during database installation but after rebooting the system some tool complained about misconfigured ssh equivalence. So i digged a little bit. I found out SSH is complaining about … Continue reading
Posted in Oracle 11g Release 2, Oracle in general
5 Comments
Partition layout on Linux – Recommendations
Partition recommendations for Oracle on Linux Every system engineer or even every DBA comes along the following question from time to time: “How do i arrange my partitions for using oracle on linux?” In the following i am blogging my … Continue reading
Posted in Oracle in general
4 Comments
Increasing data checks performed by RMAN with "check logical" switch
By default RMAN checks for physical corruptions in data files when performing backups. For a logical check you can add “check logical” to your rman backup command. With this clause rman also checks the block integrity logically. A few examples … Continue reading
Posted in Oracle in general
Leave a comment
RMAN in Data Guard configurations – Problems of restoring rman disk backups and standby site and vice versa
… or: the problem of backup association From time to time i come across the same problems in data guard configurations using rman-to-disk: Backups taken on the standby database are not taken into account when trying to perform an rman … Continue reading
Posted in Oracle in general
3 Comments
Managing the AWR (automatic workload repository)
Overview on the AWR The automatic workload repository “AWR” was introduced with Oracle 10g. It collects performance data in intervals (default: 60 minutes) and keeps them by default for one week. The data is stored in the SYSAUX tablespace. The … Continue reading
Posted in Oracle in general
1 Comment