EBS multi node configuration for Apps Tier with load balancer
A multi node architecture for Oracle EBS is normal for a large enterprise with houndreds of users. This kind of architecture is characterized with both load sharing and high availability. Although It is a three tier architecture with application server and database server, Its application tier is more complex in some way.Read more
Oracle Database migration across platform with Transportable Tablespace or Transportable Database
Recently I ' m working for a customer for a Oracle Database migration project from Sun Solaris to HP-UX platform. It is a 10.2.0.4 RAC with totally 3.5 terabyte datafiles which reside on a Symentec cluster file system. The migration requirement is simple: minimize the downtime of the database and keep it simple.
I consider all the possible solution for database migration across platform:
Oracle Database pro-active performance management with Metrics and Alert
As we mentioned in the last article that with Oracle 10g, Oracle introduce the concept of 'Metric' and 'Baseline' for pro-active database performance management. It is a big leap for effective performance managment.
What is Metric
For the versions before Oracle database 10g, The main performance diagnostic tools is statspack. The essence of stackpack is to compute the change for Oracle internal counters:Read more
Oracle database performance methodology evolution - from 9i to 10g and 11g
Recently I re-read the performance document of Oracle Database 9i,10g and 11g. It is interesting to notice that different performance tools available with different version of Oracle database. The newer version always introduce some new concept that lead to new performance tuning methodology.
This evolution of performance methodology could be best descrbied with the following:Read more
Error: Access Denied for Hyperion Interactive Reporting BQY embedded in HTML iframe
It is common requirement that we embed IR BQY report into our self-developed applications . Hyperion provide a few methods for integrating the BQY report into our own applications. Portlet is a common solution for embed the report into portal , and iframe is another solution for its simplicity and easy use.
When we publish the BQY report in Hyperion workspace, Hyperion provid a unique url for every BQY report as Smartcut, using this URL, we could easily embed the report into HTML iframe. Read more
How to install Oracle Enterprise Linux 6.1 from USB into the second harddisk
To setup the local sandbox into my Dell E6400 's second hardisk, I download the Oracle Enterprise Linux 6.1 and install it using a 4G usb flash. And here 's how it works.
First there 's some preparation work to do with the USB flash drive. and there 's a few tools that can make your life a little easier.
1. format the USB drive with the HP usb utility tools( It is quite strange that It does not work when formatted by the windows XP disk tools)