-
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
Monthly Archives: September 2009
Oracle Dataguard – automatic archive log file management on primary site
System Environment Suppose you have an oracle data guard environment with one primary database and one physical standby database running. You perform online backups with RMAN from the PRIMARY database. Your users complain about slowness during the night. You notice … Continue reading
Posted in Oracle in general
Leave a comment
Oracle 11 Release 2 Install Guide – ACFS and ADVM
ACFS and ADVM System configuration We will use the system configured and installed in part 2 General information ADVM = ASM dynamic volume manager ACFS = ASM cluster file system Basic layout (Source: Oracle Database Storage Administrator’s Guide 11g Release … Continue reading
Posted in Oracle 11g Release 2, Oracle ASM
9 Comments
Calculate IOPS (or IO/s) for hard disks
From time to time i spend time looking for information how to calculate IOPS (or IO operations per second) for hard drives. In the following table i outlined how to calculate the IOPS a disk can handle. For this calculation … Continue reading
Posted in Uncategorized
Leave a comment
Changing ADR Destination for 11g Listener
With 11g Release 1 Oracle introduced the Automatic Diagnostic Repository – “ADR”. The ADR is designed as central repository for storing all oracle-related log files such as alert.log, listener.log and so on. The log files are stored in XML format … Continue reading
Posted in Oracle in general
Leave a comment
Building and using the kfed utility
When using ASM sometimes it it extremely helpful to get more information on the asm disk header. The “kfed” utility from oracle enables to dump the asm disk header and many more. With this tool corruptions to the asm can … Continue reading
Posted in Oracle ASM, Oracle in general
Leave a comment
Using ASM with files (either locally or via NFS)
From time to time i need to configure additional and temporary storage for data migration or just testing purposes. Raw Devices are not recommended to use from 11g onwards. So why not use the loopback device for that? With this scenario … Continue reading
Posted in Oracle ASM, Oracle in general
3 Comments
Oracle 11g Release 2 Install Guide – Grid Infrastructure installation
System configuration: Hardware configuration two virtual machines (VMWARE) 1 vCPU 2 GB RAM –> bare minimum possible 40 GB Disk Storage exported via ISCSI 4 LUNs with 2 GB each 2 LUNs with 30 GB each Operating system configuration Oracle Enterprise … Continue reading
Posted in Oracle 11g Release 2
88 Comments
Oracle 11 Release 2 Install Guide – Update 14th September 2009
The install guide was updated. The presentation is already up-to-date. I will also post the topics from the presentation as separated posts in this blog. For a better overview i created a separate page to collect and sort all … Continue reading
Posted in Oracle 11g Release 2
Leave a comment
Oracle 11g Release 2 Install Guide – Single database creation guide
Oracle 11g Release 2 – Single database creation guide The first part (binary installation of the database) is available here. Start default listener Create single database instance
Posted in Oracle 11g Release 2
1 Comment
Oracle 11g Release 2 Install Guide – Single database binary installation
Oracle 11g Release 2 – Single database binary installation guide Local System configuration Installation took place on laptop with CentOS 5 x86_64 (Kernel 2.6.18-128.2.1.el5) 4 GB Memory 500 GB local disk Steps required to install Oracle 11g Release … Continue reading
Posted in Oracle 11g Release 2
3 Comments