APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 36,440 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    August 2009
    M T W T F S S
    « Jul   Sep »
     12
    3456789
    10111213141516
    17181920212223
    24252627282930
    31  
  • Archives

  • Authors

Splicing IZU TOP for Support Diagnostics

Posted by appsinfo on August 25, 2009

Splicing IZU TOP

For diagnostic patch you need to apply certain other patches and Splice IZU_TOP. Below are the steps that you need to follow while splicing the TOP.

1. Verify that the product is in the database or not

select APPLICATION_ID
       from fnd_application
       where APPLICATION_SHORT_NAME = ‘IZU’

2. 1. Copy the following text files from 3636980 to the admin directory under
   APPL_TOP.

        izuprod.txt
        izuterr.txt
        newprods.txt

Review newprods.txt and verify that the tablespaces listed exist
and are the ones planned for use by this product.
If changes are required, edit the file as appropriate and save it

3. Create tablespace

user_data
user_idx
apps_ts_tool—–create this table becoz this will throw an error
using adsplice

4. Run env and then adsplice

5. check
SQL> select APPLICATION_ID
  2         from fnd_application
  3         where APPLICATION_SHORT_NAME = ‘IZU’;

APPLICATION_ID
————–
           278

From within SQL*Plus, logged in as APPS, run the following:
        select STATUS
        from fnd_product_installations
        where APPLICATION_ID = 278;

   This statement should return one row:
   S
   –
   I
6. Set the IZU top in the evniornment file, echo and check the patch
7. Apply 3636980
8. Check the log files

9. Remove standalone RDA if installed into $IZU_TOP/bin/rda
   If you have previously installed RDA into the $IZU_TOP/bin/rda directory
   by manually extracting it from a zip or tar file, you should remove the rda
   directory and its contents from under $IZU_TOP/bin before applying the patch
   unified driver.

   Failure to do so could result in an adpatch error similar to this:

   Error: Applying rda.cmd to the wrong release:
    Patch  : /PATCH/7530017/izu/bin/rda/rda.cmd, v115.6
   On-Site: /u01/appltop/izu/11.5.0/bin/rda/rda.cmd, v1.4

10. Apply the following unified driver file with AutoPatch:
     u7530017.drv

11. Perform menu and/or responsibility setup as per Note 358831.1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: