Oraone

  When cloning an EBS-environment, from production to test for example, it can be necessary to disable the end-users to prevent them from logging in. You can do this as SYSADMIN using the Apps-interface, but for more then 10 users that can take quite some time. An alternative is to update the fnd_user table directly, something like this: update fnd_user set end_date = sysdate ...
Read More »

  When used in combination with the Oracle E-Business Suite, Oracle databases can become very large. Take the Vision-database for instance, this is a preconfigured EBS-environment with demo-data. The R12-version of the demo-database is very large, on our Linux-servers it is taking a whopping 135 GB of diskspace. Recently, Oracle certified its Advanced Compression technology in...
Read More »

  Upgrading the Oracle RDBMS of an EBS-environment is generally a bit more complicated than a stand-alone upgrade, but the process is documented in great detail by Oracle. This blog will discribe the upgrade from RDBMS 10.2.0.3 to 11.1.0.6, and because Oracle has done a pretty good job in documenting this process in Metalink Document: 735276.1 only the non-documented deviations are...
Read More »

  A tool that is often used to monitor servers and services is Nagios . With Nagios both out-of-the-box services and custom services can be monitored. When a server or service enters a fault-situation, Nagios can send an alert to an administrator. For critical services it is of great importance that alerts are delivered as soon as possible to administrators. Simply letting Nagios...
Read More »