ADSPLICE (adsplice) is a utility that installs a product definition in the database to make it look as if it was installed by AutoInstall. The purpose of this is to make the product 'patchable' by AutoPatch. Products installed by ADSPLICE are only recognizable by AutoPatch and ADADMIN (adadmin). before applying this patch copy the following text files dna/admin/dnaprod.txt dna/admin/dnaterr.txt dna/admin/newprods.txt(adsplice control file) into your $APPL_TOP/admin directory. 2. Edit newprods.txt to refer to the correct default, data and index tablespaces for DNA: # first product main_tspace=DNAD index_tspace=DNAX temp_tspace=TEMP default_tspace=DNAD Replace DNAD,DNAX and TEMP with the correct tablespace names. Make sure that the tablespaces exist in your database. 3. Run adsplice command to splice DNA into your instance. You must run adsplice from the admin directory under your APPL_TOP. When you are asked to enter the name of your AD Splicer control file, enter newprods.txt. AD Splicer will regenerate the environment file or registry Verify that the environment variable MSR_TOP is set for your newly spliced products. To check that MSR(product) has been spliced successfully, try logging to the database using SQL*Plus as MSR/<password for MSR schema>. You should able to connect successfully. The patch requires all users be disconnected from the application before the patch is applied. To ensure that none of the users are blocking the resource ('MSC_FORM_QUERY') required by this patch, you can run the following SQL command by connecting to your database using SQL*Plus as system/<password for system schema>: select s.osuser, p.terminal, s.sid, s.serial#, p.program, p.spid, s.status
from v$session s, v$process p, v$access a where a.object = 'MSC_FORM_QUERY' and a.sid = s.sid and p.addr = s.paddr; HOW TO REGISTER CUSTOM PATH