Category Archives: Oracle in general

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.

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 →

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 →

With end of July 2010 support for Oracle 10g Release 2 ends. You can order (at additional costs of course) so called extended support to get support until July 2011. After this date there is so called “Sustaining Support” which … Continue reading →

I just found Oracle released 10.2.0.5.0 patchset for the following platforms: Linux x86_64 Linux x86 See Doc ID 1088172.1 for a list of fixed problems.

This is a short posting about an error i found today. This errors prevents the import of tables with lob columns when using traditional import, deferred segment creation and an altered tablespace name. For this i created a test case … Continue reading →

Some time ago i´ve seen a discussion on OTN about ASM and thin provisioned volumes. Hi there, sorry for the x-post from database-general but it was suggested that I do so. Anyhow, we’ve got 11g (11.1.0.7 with the 6851110 ASM … Continue reading →