S3fox provides a handy utility for creating import manifest and signature files; however, it doesn't seem to properly create export manifests. In fact, it seems like it only creates import manifest files. The version I used was 0.4.8. … [Read more...]
Metalink wget download script
Looking for a simpler way to download from the new Metalink? Oracle has replaced the ftp site with http downloads using wget. If you’re looking for a simple way to use wget without all of that cutting-and-pasting from the web site, you can use a simple script like this: #!/bin/bash # Program: download.sh # Description: Download Oracle … [Read more...]
Blue Gecko named Amazon Web Services partner
Blue Gecko has been officially recognized as an Amazon Web Services partner! Blue Gecko was an early adopter of the AWS platform for databases and database-backed applications. By deploying Oracle, Oracle E-Business Suite and MySQL infrastructures in the cloud, Blue Gecko leverages AWS to substantially improve customer IT flexibility and reduce … [Read more...]
Don’t be that way
Question for all IT support professionals: Ever hear, “The system is down!” when what they mean is, “I got an error,” or “I can’t log in.” How about, “This report doesn’t work!” when what they mean is, “I’m not getting the data I expected.” Working with servers and … [Read more...]
6 things to do after an Oracle Apps R12 install
OK, so there are a ton of things to do right after a fresh R12 install. And before anyone says anything, I know each of my steps has multiple steps; I though 6 things made a simpler blog title, that's all. Nevertheless, below are the major tasks I think every Apps DBA should do right away before letting anyone log in. I call these out for two … [Read more...]
Specificity + Inaccuracy = Yikes!
Every once in a while I run into a customer with a very specific request: Please do “this” down to the very last detail. I might take a look at the request and think, “Hmmm… I don’t know what they’re trying to do, but this doesn’t look like a good idea on the surface. I wonder what’s up.” For … [Read more...]
Use Autoconfig for common system administrator tasks
Use Autoconfig for common system administrator tasks Autoconfig is a wonderful tool that may be extended and customized to meet a variety of needs. One mundane task I don’t deal with anymore is scripting certain basic operating system scripts. For example: Rotating logs Cleaning out old trace files Init scripts … are all examples of cron … [Read more...]
Disable Flash for Oracle Metalink
If you want to improve certain aspects of Oracle's new Flash-based Metalink, you can do so by disabling Flash. In Firefox or IE you can disable Flash discretely; in Safari, you need to disable all plugins. Once Flash is disabled, log out of and back in to your browser and go to http://metalink.oracle.com. On the right, near the bottom, there … [Read more...]
9 reasons why the new Metalink sucks
I know I’m not alone, and I know I’m not the first to express displeasure, but let me just say: AAAARRRRRRRGHHHH!!!!! I’m going to call the new Metalink “Metaflash.” Seems like a good name for it. It combines “meta” and “flash” which sounds really hip and technical, yet communicates nothing. Kind of like shoving “i” or “e” in front of a … [Read more...]
How to hire a really good Oracle DBA
Many of our customers have internal database administrators. FACT: Any remote DBA organization, and I mean ANY one of them, should be excited to work with a talented on-site person; in fact, part of good remote DBA support should be to help clients hire good DBAs when appropriate. Without fail, collaboration between solid, focused technical … [Read more...]
If it’s really important… get 2
When our daughter was about 2, my wife and I noticed she had become almost disturbingly attached to a particular blanket. She carried it everywhere and slept with it every night; they were inseparable. There was nothing remarkable about the blanket, except that if Daniella (our daughter) couldn’t find it she would melt down like a popsicle on the … [Read more...]
Converting Hexadecimal Oracle SCNs to Decimal
Oracle serializes transactions and manages concurrency and recovery using an ever-increasing number called a system change number, or SCN. Usually, we see these numbers expressed in decimal, in places like the v$ views and the alert log. Occasionally, however, Oracle's code expresses SCNs in hexadecimal. Unfortunately, you can't just perform a … [Read more...]
Linux is the only choice for the E-Business Suite application tier
Some single points of failure are often unnecessary with Oracle E-Business Suite. By design, application code may easily run on multiple, inexpensive x86 (or x86_64) nodes running Linux. I often see organizations spending lots of money on commercial, internally redundant application computing nodes when they could be spending far less while … [Read more...]
ORA-00054: resource busy and acquire with NOWAIT specified
When trying to perform DDL such as truncate, drop or alter on Oracle objects that are in use by other users, you may encounter the error ORA-00054: resource busy and acquire with NOWAIT specified. This occurs even if you acquire an exclusive DML lock on the table using lock table. Locking a table does not guarantee the success of any subsequent DDL … [Read more...]
New presentation: Deriving Optimal Configurations Using 11g Database Replay
Jeremiah Wilton’s presentation shows how to use Oracle 11g Real Application Testing to quantify effect of system and database configuration changes. As an example, he uses Real Application Testing to validate the Automatic Advisor recommendations, and uncovers some interesting results. Check out the presentation on our whitepaper page. … [Read more...]
- « Previous Page
- 1
- …
- 7
- 8
- 9
- 10
- 11
- …
- 13
- Next Page »