If like me, and a couple of others I’ve spoken to recently, you were not previously aware of “sudo -s” then you might be interested to know that you can save yourself two keystokes by switching from:
sudo su -
From the man page:
The -s (shell) (more...)
Have you ever found yourself being asked to provide a scan of a document that you’ve printed and signed? Have you ever found yourself in that position without a printer and/or scanner?
That happened to me recently. I’d been asked to provide a signed copy of document and so I (more...)
When working with Oracle Database Resource Manager recently I ran into what seemed like unexpected behaviour and turned out to be bug 13101791 as documented in MOS ID 13101791.8. The note states workaround as “none”, but that depends on what you view as an acceptable workaround.
The bug description (more...)
Relax and Recover (ReaR) is a great tool for facilitating Linux bare-metal recovery. In works really well, however, there is a bug in the 1.14 release (it seems the same issue is present in 1.15, but I didn’t test yet) that effects restores for many bonded Ethernet interface (more...)
I’ve just installed 12c (I’m a little slow off the mark) and during the installation process I hit the screen below and thought, “That’s a good idea.”
However, near the end of the installation I noticed that the ASM instance numbers did not match up with the numeric identifiers (more...)
Just a brief note to remind myself next time that this is very easy and just 3 commands…
All my VMs run on Logical Volumes (LV) created on the VM host. Every once in a while I want to move the storage for a VM from a particular Volume Group (more...)
I just stumbled upon this bug reference on My Oracle Support:
Bug 13262857 Enh: provide some control over DBMS_STATS index clustering factor computation
This enhancement was long due. Previously, when computing the clustering factor during gathering statistics, the value was incremented, whenever the row was not found in the same block as the previous row. Now, it is finally possible to determine how many blocks should be considered when computing clustering factor. The patch delivers an improved DBMS_STATS package body that can be used to set preferences with value TABLE_CACHED_BLOCKS.
The flaw in the over-simplistic and pessimistic original computation was (more...)
Recently, i was troubleshooting a datapump export duration problem. Over the period of 18 months, the duration of a multi-table export increased dramatically. A quick analysis showed that the export duration was mainly dependent on one big table. This 50 GB table with no BLOB/CLOB/LONG datatypes took more than 4 hours on a modern system wheras it should not take more than 10 – 15 minutes. The system was performing ONLY single-block I/O requests (db file sequential read). I found this strange and started investigating.
Beginning with 11g, you can enable sql_trace (10046) for datapump with the new syntax:
I would like to point your attention to a bug in RAC 220.127.116.11. The bug leads to instance crashes during Dynamic Remastering. As of June 1st, there is no patch publicly available. The workaround seems to be to set:
So, if you are thinking about upgrading your RAC to 18.104.22.168, maybe you should wait just a little bit longer…
More details are in MOS: Bug 13397104: INSTANCE CRASH WITH ORA-600 [KJBLPKEYDRMQSCCHK:PKEY]
Update 12.06.2012: Patch 13397104 is now available in MOS for 22.214.171.124.
Oracle yesterday announced certification of RHEL6 / OEL6 with Oracle Database 11gR2 and Oracle Fusion Middleware 11.1.
Moreover, Oracle will from now on provide errata packages for free. Until now, they could only be obtained with a valid ULN support contract. I think this will be a big plus for Oracle Linux in competition with Red Hat Enterprise Linux.
I wonder how long it will take before they ship Exadata and Oracle Database Appliance (ODA) with Unbreakable Kernel.
Gone are the day when cleartext passwords had to be stored in scripts for Oracle database access. The solution to this requirement is “Oracle Secure External Password Store (SEPS)”. This article will give a short introduction and a practical example of the solution.
no Advanced Security Option (License) necessary
every unix-account, who has access to the wallet can use it to log on to the contained databases without a password! Therefore prevent other unix-accounts from accessing your wallet! (chmod, chown)
Oracle Client: Unix-Account, who wishes to connect to the database without providing a password needs to (more...)
I just saw MOS Note
ORA-4031 After Upgrade From 126.96.36.199 To 188.8.131.52 With Leak in ‘KTC latch subh’ Subheaps [ID 1398984.1]
giving very little information about this bug. At the time of this writing, there is no patch available but I expect it to be in a few days. I have checked some 184.108.40.206 instances and found only one with > 60 MB for this subheap.
In case you have not heard all the buzz about the Oracle SCN flaw, which was published by Infoworld after the release of January CPU, I summarize the essentials.
- There is a risk that the SCN reaches it´s maximum value and this could lead to an outage of the database.
- There is a bug in “ALTER DATABASE BEGIN BACKUP”, which increases the SCN dramatically. (Bug 12371955 – fixed in 220.127.116.11.4 and others)
- When you query a remote database via database link from a database with elevated SCN, the remote SCN gets increased to the higher value (more...)
At one of my customers, we wondered about some entries in v$datafile.unrecoverable_change# for the most critical tablespace of the application. Certainly no application components were allowed to perform nologging operations for segments inside this tablespace and yet there was evidence that “something” was done with nologging.
- The unrecoverable_time was shortly after 10 pm
- The ASH data covering this time period showed activity by DBMS_SCHEDULER and Autotask Jobs.
- An internal DDL log table showed the following operations:
CREATE TABLE "MYOWNER".DBMS_TABCOMP_TEMP_UNCMP tablespace "DAT_MYOWNER" nologging AS SELECT /*+ FULL("MYOWNER"."MYTAB") */ * FROM "MYOWNER"."MYTAB" sample block( 3.55) (more...)
From time to time we hit Errors like ORA-600 or ORA-7445, which are triggered by specific SQL statements. For these cases, Oracle developed the SQL Repair Advisor. This is a short demonstration of utilizing the SQL Repair Advisor to avoid ORA-7445 caused by a SQL statement.
SQL and Error:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
SELECT EXTRACT(YEAR FROM date_new) jahr, EXTRACT(MONTH FROM date_new) monat, COUNT(DISTINCT TRUNC (more...)