Weblog for the AMIS Technology corner
Bas Klaassen
This user hasn't shared any biographical information
Posts by Bas Klaassen
Custom sql scripts in OAM
23/10/2007 - 10:50 am
Posted in AMIS, DBA, General, Oracle E-Business Suite | No comments
I noticed Oracle Applications Manager has some very handy sql script you can use when monitoring your EBS environment.
When starting up OAM, navigate to Site Map —-> Monitoring —-> SQL Extensions
The following scripts are available…
invalid oraInventory in Oracle e-Business Suite
11/6/2007 - 3:03 pm
Posted in AMIS, DBA, General, Oracle E-Business Suite | No comments
When running the http (CPU April 2007) patch on the Oracle EBS 11.5.9, I received some errors…It seemed the oraInventory was not valid, at least the http entry was missing. The oraInventory that was incomplete was the global oraInventory. I noticed that the local oraInventory in the $IAS_HOME was complete, but running the patch with this [...]
Autoconfig templates ?
11/5/2007 - 11:55 am
Posted in DBA, General, Oracle E-Business Suite | 2 comments
The company I work right now uses autoconfig. No problem off course, but they also have a lot off custom templates. Autoconfig uses templates to generate the configuration files so the EBS can work properly. When you want to add customizations the a template, you place that template in the ‘custom’ directory in the $product_top/template, [...]
Oracle E-Business Suite R12 with OEM10G
20/3/2007 - 11:30 am
Posted in AMIS, DBA, General, Oracle, Oracle E-Business Suite | No comments
After configuring the Oracle EBS 11.5.10 environment in OEM10G, it was time to also configure the new Oracle EBS R12 environment in OEM10G.
Before I could configure R12 in OEM10G, I first had to upgrade the Oracle Applications plugin for EM10GR3. I downloaded the patches p5489352_R12_LINUX.zip and installed this patch on the OMS_HOME and in [...]
First patch for Oracle E-Business Suite R12
27/2/2007 - 5:05 pm
Posted in AMIS, DBA, General, Oracle E-Business Suite | No comments
This morning I downloaded my first patch for the new Oracle EBS R12. Already there are 2 high priority patches for the new EBS, and I downloaded one of them (patch p5856453_R12[1].AD.A_R12_LINUX.zip). I could not help feeling a little bit excited, because patching is changed in EBS R12.
The manual steps to be taken before [...]
Installing Oracle E-Business Suite R12
So, I finally installed the new EBS 12i release. I had to install with an empty database, because of disk space limits…But the important thing is that the installation was successful.
Some first impressions…- the look and feel changed (we had already seen some previews..)- some strange options when logging in the application ??- the database is [...]
Sizing Oracle EBS 12i
2/2/2007 - 8:22 pm
Posted in AMIS, DBA, General, Oracle Development Tools, Oracle E-Business Suite | No comments
I wanted to find out how ‘big’ the new Oracle EBS 12i release really is. So, I downloaded the software from Edelivery and created a stage area.
From the stage area I started the rapidwiz to check the required disk space. Here is the required disk space for Oracle EBS 12i :
Database ORACLE_HOME = /ebs/db/tech_st/10.2.0required = [...]
FNDCPASS ALLORACLE
16/1/2007 - 12:05 pm
Posted in DBA, General, Oracle, Oracle E-Business Suite | 1 comment
FNDCPASS is an EBS tool to change passwords of database schema’s within the Oracle EBS. For example, you can change the APPS password using FNDCPASS, but also any other schema in the EBS database. FNDCPASS can also be used to change the password of an application user (like sysadmin).
To change the APPS password use…FNDCPASS apps/*** [...]
Upgrading EBS 11i database (9.2.0.6) to 10GR2 database
8/1/2007 - 1:50 pm
Posted in AMIS, DBA, General, Oracle E-Business Suite | No comments
I have upgraded my EBS 11.5.10 database (9.2.6.0) to release 10gR2 (10.2.0.2.0). I have followed note 362203.1 from Metalink to perform the upgrade. Here are some tips or problems I ran into… 1. The first patch is 5478710 (TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH O) After applying the patch make a new appsutil.zip file… [...]
Changing background in Oracle EBS 11i
5/1/2007 - 4:05 pm
Posted in General, Oracle, Oracle Development Tools, Oracle E-Business Suite | 1 comment
It would be nice to have your own company logo as background in the Oracle E-business suite. Default the background is white, but the following steps will put your company logo (or any other logo…) in the background. 1. modify the appsweb.cfg in the $OA_HTML/bin directory. Find the ‘background’ parameter and let it point to [...]
