Translate this Page

 

This posting contains the issue that I got during the migration Oracle DB and Apps EBS  as we post in trilogy of migration part I, II and III. And how to solve the problem, hope this can help you.

Ø      FRM-92150 WEB Client Version too New

SOLUTION (NOTE: 788151.1) :

Cross check the version of forms server used from the forms server installed .  Use the cmd

f60gen|grep Forms|grep Version

The output is  Forms 6.0 (Form Compiler) Version 6.0.8.xx, if not same, re-apply patch for developer6i_patch19. And assure the user already have permission. After that relink the “fnd” module.

In the java console ( or JInitiator console ) check the version. You should have the same version. Continue reading »

 

Continue from previous posting.

Step-by-Step Migrate Database and Applications

1. Migrate Database of Oracle EBS

After upgrade the database of Oracle EBS to 10g Release 2, migration process will be more easier than if the database version still in 9i. The supported way to accomplish this prior to Oracle Database 10g Release 2 was to export the data from the database on the old platform, create a new database on the new platform, and import the data into the new database. This process could take a number of days for a large database. Oracle Database 10g provides two additional methods of migration a database to a new platform. Oracle Database 10g Release 2 introduced Transportable Database (TDB), which is used to reduce the amount of time and effort required to migrate a database between platforms that share the same endian format (byte ordering). Oracle Database 10g Release 1 introduced cross platform transportable tablespaces (XTTS), which allows data files to be moved between platforms of different endian format. XTTS is an enhancement to the transportable tablespace (TTS) feature introduced in Oracle8i. TTS was originally released as a method to move a subset of one database into another, such as plugging parts of an OLTP database into a data warehouse on the same platform. With the cross-platform enhancement, XTTS can plug data files into a database on a different platform, including those that are using a different endian format. XTTS may reduce platform migration time by moving all user tablespaces from a source database to an empty target database running on a platform that uses a different endian format. With the XTTS feature, Tablespaces plugged into the empty target database by copying the data files to the target database, converting them to the target system endian format, then importing the object metadata into the target database. Continue reading »

 

After we assigning some responsibilities to a user in Oracle E-Business Suite. Unfortunately when user login to the system, he can’t found the responsibilities that he want in the web navigator. This problem usually happen after upgrading or patching.

To solve this problem :

1. Set the role_end_date to null in the wf_local_user_roles.
The sql used will depend on the responsibility missing. For example for the System Administrator responsibility, type in the following:

UPDATE wf_local_user_roles
 SET role_end_date = NULL
 WHERE user_name LIKE 'SYSADMIN%'
 AND role_name = 'FND_RESP|SYSADMIN|SYSTEM_ADMINISTRATOR|STANDARD';

or
Continue reading »

 

Continue from previous posting.

B. Upgrade the Database of Oracle EBS

1. Check Prerequisites

  • Compatibility

If the database still using original DB (EBS 11.5.9 using Oracle DB 9i) then we need to upgrade it first. Check the compatibility matrix on NOTE: 316889.1, which path that we must take. Minimum Version of the database that can be directly upgraded to Oracle 10g Release 2

      8.1.7.4 -> 10.2.X.X.X
      9.0.1.4 or 9.0.1.5 -> 10.2.X.X.X
      9.2.0.4 or higher -> 10.2.X.X.X
      10.1.0.2 or higher -> 10.2.X.X.X

The following database version will require an indirect upgrade path.

      7.3.3 (or lower) -> 7.3.4 -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
      7.3.4 -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
      8.0.n -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
      8.1.n -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X Continue reading »
 

APPLICATION PARTIONING on Oracle E-Business Suite 11i

Not only the database needs to be partitioning to separate the data, we can also partitioning the applications. Why we need partitioning the applications? There are some reason if we talking about this topic, i.e.: Continue reading »

 

First concern when we need to migrate our EBS is because the End Of Support of our HP Servers, the cost for extension maintenance support is very high if we still use the old servers. It will be as same as we buy new server with 3 years warranty include.
There are many ways to do the migration :

  • If we don’t want to upgrade the original DB (EBS 11.5.9 using Oracle DB 9i)
    • Export-Import
    • Using CDC (Change Data Capture) tools
  • If we plan to upgrade to 10gR2 (10.2.0.2.0)
    • Export-Import
    • Convert Database (if migrate to the platform with same Endian)
    • Convert Tablespace (if migrate to the platform with different Endian)

In this document, I just discuss how to Migrate Application and Database using Convert Database options.
I will separate the process migration EBS 11.5.9 from HP-UX 11.11 to SUN Solaris 10 into 2 phase. The first phase, we can call the preparation phase. At this phase we upgrade the applications and database. This phase could be reference if we want Oracle E-Business Suite 11.5.9 with Oracle Database 10g. You can review NOTE 369693.1.

The second phase we will discuss the process migration from current platform (HP-UX) into new platform (SUN Solaris). Let’s get rock…. ;)

Continue reading »

 

Our company runs Oracle E Business Suite 11.5.9 and 11.5.10, mostly application and database server running 24×7 to support production. We have own development team to enhance our applications regarding the user needs. And sometime our development team needs to refresh development server with current data and applications from production server. But we don’t have enough time to cloning applications and database if we have to shut it down first. To solve this problem, we have a solution to “On-line” cloning application and database from production into development. Some of these steps can be found on Note: 230672.1. Continue reading »

© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha