Category Archives: Oracle in general

Altough not oracle related i successfully completed my certification as an MS SQL Server DBA. In most companies MS SQL is used for smaller databases in addition to oracle. So from my point of view it is a plus. I … Continue reading →

This week a came across the following very interesting scenario: The customer made an RMAN online backup and saved it to an NFS location. Controlfile autobackup was on. During backup the backupset was written to that NFS location. The control … Continue reading →

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 →

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. .

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 →

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

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 →

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 →

I am pretty busy the last weeks so i had no time for updates. I will have more time next week.