Script to check for scheduled concurrent requests in Oracle Apps 11i
Just a quick script that I wrote to report on concurrent requests that are scheduled to run in the future: select fcr.request_id, fcr.parent_request_id, fu.user_name requestor, to_char(fcr.requested_start_date, ‘MON-DD-YYYY HH24:MM:SS’) START_DATE, fr.responsibility_key responsibility, fcp.concurrent_program_name, fcpt.user_concurrent_program_name, decode(fcr.status_code, ‘A’, ‘Waiting’, ‘B’, ‘Resuming’, ‘C’, ‘Normal’, ‘D’, ‘Cancelled’, ‘E’, ‘Error’, ‘F’, ‘Scheduled’, ‘G’, ‘Warning’, ‘H’, ‘On Hold’, ‘I’, ‘Normal’, ‘M’, ‘No ...
Oracle and TSM for Databases: Part 2
In the first installment of this series, I discussed some of the basic concepts in using Tivoli Storage Manager for Databases to backup and recover Oracle databases. In this installment, we’ll look at how to keep TSM and Oracle in sync. When backing up a typical filespace, the TSM backup-archive (BA) client compares what files ...
Check for failed concurrent requests in Oracle EBS 11i
Just a quick SQL script that I wrote to check for concurrent requests that failed in the past 24 hours. The script is for E-Business Suite 11.5.10.2; it may or may not work on other versions of Oracle Apps.
Finding licensing changes in EBS 11i
Here’s a quick script to see when modules were licensed, and by whom, in Oracle E-Business Suite 11i: select fa.application_short_name, fpi.last_update_date, fu.user_name, fpi.status from fnd_application fa, fnd_product_installations fpi, fnd_user fu where fpi.last_updated_by = fu.user_id and fpi.application_id = fa.application_id and fpi.status = ‘I’ order by last_update_date
Oracle and TSM for Databases: Part 1
One of the most confusing areas for TSM admins is backing up Oracle databases using TSM for Databases (frequently referred to by its old name, Tivoli Data Protection or TDP). In this series, I’ll provide an overview of how to use TSM to backup Oracle databases, with a special emphasis on problems you may face ...
RMAN Compatibility Matrix for 11gR2
I needed to check and verify that I was in the clear moving our RMAN catalog from 10.2.0.4 to 11.2.0.1, and had to dig a little to find the current documentation. I decided to post it here in hopes of saving someone a bit of time. Oracle’s RMAN Compatibility Matrix for 11gR2.
So many databases…
Just realized that we have more database platforms that we support than we have people in the infrastructure team! DB2 9.7 MySQL 5.0 Oracle 10g SAP DB SQL Server 2007 How many different platforms is your team supporting? I’m guessing the most accurate answer is probably, ‘too many!’
Cloning Oracle databases with RMAN
Some of the hats I currently wear include being the backup administrator and sometime DBA. The two overlap, since I use IBM’s Tivoli Storage Manager (TSM) to handle all of our Oracle-related backups and restores. By restoring backups of a production environment to a nonproduction one (eg, a development or testing instance), you can make ...
Zabbix 1.8.4 released
I just noticed that Zabbix 1.8.4 has been released. Along with changes to the web interface, DB2 has been added as a supported backend. The documentation doesn’t have any information on what the requirements are for DB2 support (9.5? 9.7?), but it’s nice to see Zabbix support another big-time database.
When your senior DBA is on vacation…
…you realize just how valuable he is. I’m just hoping that we don’t have any further reminders for the rest of the week.
Recent Comments