Oraone

  Recently I had to refresh a test-database from a production-database. However, no downtime was allowed for the production-database, and because the RDBMS-version in use was release 11.2.0, this was a perfect situation to give the RMAN 'duplicate' function a try.  I found out that the RMAN 'duplicate'-command by itself is pretty straight-forward, there are some requirements...
Read More »

  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 »