-
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
Author Archives: Ronny Egner
Less known helpers: Linux sg3_utils
The linux sg3_utils are small tools intended for working with FC / SCSI / SATA / SAS hard driv.es. They can be used to send SCSI commands (for instance INQUIRY, LOG SENSE, …) to these devices. sg3_utils can be found … Continue reading
Posted in Oracle in general
Leave a comment
ASM witth Oracle 11g Release 2 – Best Practises revisited
Starting with 11g Release 2 it is possible to store voting disks and OCR in ASM. But how does this affect ASM best practises? Martin Decker found the updated Oracle document about this issue. .
Posted in Oracle in general
2 Comments
Using Large Pages for Oracle on Windows 64-bit (ORA_LPENABLE)
For using Large Pages on Windows some settings are needed: 1. Start > Settings > Control Panel 2. click Administrative Tools. 3. click Local Security Policy. 4. Expand Local Policies and select User Rights Assignment. 5. Select Lock pages in … Continue reading
Posted in Oracle in general
Leave a comment
How to determine FC HBA WWN on Oracle Enterprise Linux 5
To determine the FC HBA WWN on Oracle Enterprise Linux (OEL) use: cat /sys/class/fc_host/host<number>/port_name For example: [root@host sys]# cat /sys/class/fc_host/host6/port_name 0x2100001b329308df [root@host sys]# cat /sys/class/fc_host/host5/port_name 0x2100001b329388d9
Posted in Oracle in general
Leave a comment
EMC Networker: NDMP backups are failing after upgrading to 7.6.1
After upgrade to EMC Networker 7.6.1 NDMP are failing with: filer:/vol/vol0/etc 6899:nsrdsa_save: Warning: Could not determine job id. Continuing … filer:/vol/vol0/etc 39078:nsrdsa_save: SYSTEM error: Could not establish jobid with server. filer:/vol/vol0/etc 39078:nsrdsa_save: DSA save time could not be retrieved, exiting … Continue reading
Posted in Networker
Leave a comment
Less know features: Alternate Archive Log Destination
Oracle offers the ability to specify so called ‘alternative’ archive log destinations in case the primary archive log destination gets full. You can enable this feature by setting: log_archive_dest_1=’location=+FRA REOPEN=0 MANDATORY alternate=log_archive_dest_2′ log_archive_dest_2=’location=/some_path MANDATORY’ log_archive_dest_state_1=ENABLE log_archive_dest_state_2=ALTERNATE A configuration often used … Continue reading
Posted in Oracle in general
Leave a comment
Oracle 11.2.0.2.0 released
Few weeks ago Oracle released the first patchset for 11g Release 2 database. This is a summaization of other blog posts regarding upgrading or installating 11.2.0.2.0. At the moment (4th November 2011) 11.2.0.2.0 is available for the following platforms: Linux … Continue reading
Posted in Oracle in general
Leave a comment
Busy
I am pretty busy the last weeks so i had no time for updates. I will have more time next week.
Posted in Oracle in general
Leave a comment
Using variables in RMAN scripts
Ever wanted to use variables in your RMAN scripts? Until and including 10g R2 this was impossible. Starting with 11g R1 it is possible. Lets me show you a short example how to do it: First we create a simple … Continue reading
Posted in Oracle in general
Leave a comment
Tuning Linux for Oracle
This is a short post on how to tune Linux for running Oracle. It wont cover the background directly but i am trying to give some links with further informations. I am planning to improve it over the time. Currently … Continue reading
Posted in Oracle in general
5 Comments