Learning, relearning or unforgetting…
What value is there in a DISABLEd constraint?
This was a question on the OTN forums this week and a) my first reply was wrong and b) I couldn’t find a clear demonstration elsewhere.
The documentation is clear.
The ETL process commonly verifies that certain constraints are true. For example, it can validate all of the foreign keys in the data coming into the fact table. This means that (more...)
I was recently contacted by a customer who runs a busy ERP system on their Oracle database. Their users have been screaming for some time about unpredictable performance, where application screens which would usually open in under a second suddenly take an age. ERP systems are legendary for this, of course, because as each screen loads the application tends to fire off a glut of queries to populate all the various fields, graphs and so (more...)
Recently, I’ve been engaged in a conversation on the OTN community pages about upgrading Oracle GoldenGate 12c from 188.8.131.52.0 to the 184.108.40.206.0. During the discussion I mentioned that you can upgrade using the Oracle Universal Installer (OUI) that is now available with Oracle GoldenGate 12c. The upgrade process I’m going to show you here is an in-place upgrade of Oracle GoldenGate 12c for Oracle Database 12c.
This week one of our developers highlighted the fact that the DBMS_SCHEDULER on one of our 220.127.116.11 databases was running jobs an hour later than scheduled until just recently, when the clocks went back (26/10/2014) for British Summer Time (BST) …and now they’re running on-time again! I’d not seen this before, and at first I thought we
A couple of weeks ago I wrote a post about my trip to Oracle OpenWorld 2014 and the surprise announcement of the Oracle FS1 Flash Array. I posted it on the Violin Memory corporate website here:
Follow the link to find out whether I thought it was the most amazing product in the history of storage, or simply a rehashed Pillar Axiom hybrid array with some SSDs and a ton of marketing. (more...)
Just a quick note to point out that the October PSU was just released. The database has a few more vulnerabilities than usual (31), but they are mostly related to Java and the high CVSS score of 9 only applies to people running Oracle on windows. (On other operating systems, the highest score is 6.5.)
I did happen to glance at the announcement on the security blog, and I thought this short (more...)
The following steps are what I did for installing 18.104.22.168 on Windows.
1. Download the Oracle installation ZIP files from the Oracle Downloads page.
2. Unzip the two 12c downloads files into the same directory.
3. Go to the newly created directory (it is probably called 'database') and you will find a file called setup.exe. Double click on this file.
After a couple of seconds you will see the Oracle Database (more...)
OTech Magazine – Summer 2014
The fourth issue of OTech Magazine, the independent magazine for Oracle professionals, is available. For the summer 2014 issue there are some more personal articles included. Titles vary from The Spiritual Programmer to The Next Generation: Oracle SOA Suite 12c and back via How to protect your sensitive data using Oracle Data Vault.
Download OTech Magazine – Summer 2014 here.
Moving datafiles has always been a pain. There are several steps, it’s fairly easy to make a mistake and it requires the datafile to be offline. There are also different steps depending on whether the database is in ARCHIVELOG mode or not. In ARCHIVELOG mode, the steps are…
1) Take the tablespace containing the datafile offline
2) Copy/rename the datafile at the OS layer
Use ALTER TABLESPACE…RENAME DATAFILE (more...)
In this post, I’m installing the Oracle Database 11g Release 2 (22.214.171.124) software on Oracle Linux 6.4, along with optional instructions on how to apply the latest Patch Set Update (PSU) to your new Oracle home. First and foremost, before you start, make sure your Linux server meets the minimum hardware requirements: 1GB of RAM (plus
I hit the following problem with a 126.96.36.199 database running on Windows 2003 this morning (info pulled from the alert log). The database had failed to restart after a client’s cold backup process ALTER DATABASE MOUNT Wed Jan 15 22:32:08 2014 ORA-09341: scumnt: unable to mount database OSD-04400: unable to acquire internal semaphore for process
Oracle has released the much-anticipated version of cellsrv compatible with Oracle Database 188.8.131.52 (patch #16980054). Before thinking about upgrading, read MOS note #1571789.1 carefully. Unless you are planning to run database 12c on your Exadata, it would be advisable to continue down the 11.2 branch (more...)