Adsplice

Copy These files at the $APPL_TOP/admin

izuprod.txt  izuterr.txt  newprods.txt


$ cp izuprod.txt /instance/applmgr/11510/admin
$ cp /instance/applmgr/11510/patches/3636980/izu/admin/izuprod.txt /instance/applmgr/11510/admin
$ cp /instance/applmgr/11510/patches/3636980/izu/admin/izuterr.txt /instance/applmgr/11510/admin
$ cp /instance/applmgr/11510/patches/3636980/izu/admin/newprods.txt /instance/applmgr/11510/admin
$ cd  $APPL_TOP/admin





+++++++++++++++++++++
Before running Adsplice create tablespace

create tablespace IZUD datafile '/instance/oradata/data01/izud01.dbf' size 1000M autoextend on next 25M maxsize 1800M ;

create tablespace IZUX datafile '/instance/oradata/data01/izux01.dbf' size 100M autoextend on;

create tablespace IZUX datafile '/instance/oradata/data01/izux01.dbf' size 1000M autoextend on next 25M maxsize 1800M ;

Sometime Tablespace can be default

SQL> select username , default_tablespace from dba_users where username='IZU';

USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
IZU                            APPS_TS_TX_DATA
+++++++++++++++++++++


SQL> create tablespace user_data datafile '/instance/oradata/data01/user_data01.dbf' size 200M;

Tablespace created.

SQL> create tablespace user_idx datafile '/instance/oradata/data01/user_idx01.dbf' size 200M;



SQL> create user izu identified by izu default tablespace izud;

User created.

SQL> grant connect,resource to izu;

Grant succeeded.

select tablespace_name,status from dba_tablespaces where tablespace_name like '%IZU%';

+++++++++
changing newprod.txt file replace the names by userdata to IZUD
product=izu
base_product_top=*APPL_TOP*
oracle_schema=izu
sizing_factor=100
main_tspace=IZUD
index_tspace=IZUX
temp_tspace=TEMP
default_tspace=IZUD





- run adsplice



use option no for regeneration for environment file : NO


Saving product actions...done.

Making product top directory for product "izu"...
Directory will be /instance/applmgr/11510/izu/11.5.0
...............................................
Creating stub file "admin/driver/izudfr.drv" for product "izu"...
Creating stub file "admin/driver/izuen.drv" for product "izu"...
Creating stub file "admin/driver/izudep.drv" for product "izu"...


Do you wish to regenerate your environment file [Yes] ? No

AD Splicer is complete.

Errors and warnings are listed in the log file
/instance/applmgr/11510/admin/INSTANCE/log/adsplice.log

and in other log files in the same directory.


Set this Path on all nodes.

/instance/applmgr/11510/ar/11.5.0

/instance/applmgr/11510//izu/11.5.0

/instance/applmgr/11510/izu/11.5.0
++++++++++come out from box and login again and check it


$ echo $IZU_TOP
/instance/applmgr/11510/izu/11.5.0


select APPLICATION_ID        from fnd_application        where APPLICATION_SHORT_NAME = 'EGO';


This statement should return one row:    APPLICATION_ID    --------------               278     From within SQL*Plus, logged in as APPS, run the following:        

select STATUS         from fnd_product_installations         where APPLICATION_ID = 431;

This statement should return one row:    S    -    I


SQL> select APPLICATION_ID from fnd_application where APPLICATION_SHORT_NAME = 'IZU';

APPLICATION_ID
--------------
278

SQL> select STATUS from fnd_product_installations where APPLICATION_ID = 278;

S
-
I


Then RUN Patch 3636980 after completion of all these activities.

If Issue Came
=============
- If product is not showing Installed in u can license it through OAM
- Login in sysadmin and check Oracle Diaganostic Tool responsibility is available.
- Oracle Diaganoitic is installed properly.