how to relink all fnd executables using adadmin (R12.2.4)

Preliminary Tasks before running Adadmin:
1.      Logging in as applmgr.

2.      Running the environment file.

3.      Verifying if ORACLE_HOME is set properly.

4.      Verifying if ORACLE_SID or TWO_TASK identifies the correct database.

5.      Ensuring that ORACLE_HOME/bin and AD_TOP/bin are in PATH.

6.      Shutting down concurrent managers when relinking certain files or performing certain database tasks.

7.      Ensuring sufficient temporary disk space.


[applmgr@sujeet ~]$ adadmin
 
                     Copyright (c) 2002, 2012 Oracle Corporation
                        Redwood Shores, California, USA
 
                   Oracle E-Business Suite AD Administration
 
                                 Version 12.2.0
 
NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.
 
Your default directory is '/u02/apps/fs1/EBSapps/appl'.
Is this the correct APPL_TOP [Yes] ?
 
AD Administration records your AD Administration session in a text file
you specify.  Enter your AD Administration log file name or press [Return]
to accept the default file name shown in brackets.
 
Filename [adadmin.log] : relink.log
 
************* Start of AD Administration session *************
AD Administration version: 12.2.0
AD Administration started at: Mon Jan 04 2016 09:37:06
 
APPL_TOP is set to /u02/apps/fs1/EBSapps/appl
 
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?
 
Please enter the batchsize [1000] :
 
 
Please enter the name of the Oracle E-Business Suite System that this
APPL_TOP belongs to.
 
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
 
Sample Applications System names are: "prod", "test", "demo" and
"Development_2".
 
Applications System Name [PREPROD] : PREPROD *
 
 
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
 
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
 
Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.
 
Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
 
 
Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *
 
 
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *
 
 
Do you currently have Oracle E-Business Suite forms files installed
in this APPL_TOP [YES] ? YES *
 
 
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
 
 
Please enter the name Oracle E-Business Suite will use to identify this APPL_TOP.
 
The APPL_TOP name you select must be unique within an Oracle E-Business Suite
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
 
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
 
APPL_TOP Name [Oracle] : Oracle *
 
 
 
You are about to use or modify Oracle E-Business Suite product tables
in your ORACLE database 'PREPROD'
using ORACLE executables in '/u02/apps/fs1/EBSapps/10.1.2'.
 
Is this the correct database [Yes] ?
 
AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
 
Enter the password for your 'SYSTEM' ORACLE schema: ********
 
 
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
 
Enter the ORACLE password of Application Object Library [APPS] : *****
 
AD Administration is verifying your username/password.
 
The status of various features in this run of AD Administration is:
 
                                           <-Feature version in->
Feature                          Active?   APPLTOP    Data model    Flags
------------------------------   -------   --------   -----------   -----------
CHECKFILE                        Yes       1          1             Y N N Y N Y
PREREQ                           Yes       6          6             Y N N Y N Y
CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
PATCH_TIMING                     Yes       2          2             Y N N Y N Y
PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
JAVA_WORKER                      Yes       1          1             Y N N Y N Y
CODELEVEL                        Yes       1          1             Y N N Y N Y
 
 
 
Identifier for the current session is 43817
 
Reading product information from file...
 
Reading language and territory information from file...
 
Reading language information from applUS.txt ...
 
Reading database to see what industry is currently installed.
 
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:
 
Code   Language                                Status
----   --------------------------------------- ---------
US     American English                        Base        
 
Your base language will be AMERICAN.
 
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...
 
Saving product information.
 
AD code level : [C.6]
 
*** Maintaining the Run File System (in Hotpatch mode) ***
 
*** Edition Enabled User ***
 
            AD Administration Main Menu
   --------------------------------------------------
 
   1.    Generate Applications Files menu
 
   2.    Maintain Applications Files menu
 
   3.    Compile/Reload Applications Database Entities menu
 
   4.    Maintain Applications Database Entities menu
 
   5.    Exit AD Administration
 
 
 
 
 
 
 
 
 
 
 
Enter your choice [5] : 2
 
         Maintain Applications Files
   ----------------------------------------
 
   1.    Relink Applications programs
 
   2.    Copy files to destinations
 
   3.    Convert character set   
 
   4.    Maintain snapshot information
 
   5.    Check for missing files
 
   6.    Return to Main Menu
 
 Enter your choice [6] : 1
 
AD Administration uses your Oracle E-Business Suite environment file
to set up the environment for relinking Applications.
 
Before proceeding with the relink, you may optionally want to:
 - Go back to the menu by answering No below.
 - Use an option on the Maintain Files menu
   to generate your Applications environment file.
 - Edit the file to add any customizations.
 - Verify the list of executables in adlinkbk.txt which are saved
   before relinking and add any additional executables as desired.
 - Choose this option again, and proceed with the relink.
 
Do you wish to proceed with the relink [Yes] ?
 
Enter the name of your Oracle E-Business Suite environment file below.
File name [PREPROD_chintels.env] :
 
Reading product executable information...
 
Enter list of products to link ('all' for all products) [all] : all
 
Generate specific executables for each selected product [No] ? yes
 
AD Administration can relink your Oracle E-Business Suite programs with debug
information.  Oracle recommends that you do not relink your programs
with debug information unless asked to do so by Oracle Support Services.
 
Relink with debug information [No] ?
 
Relinking selected modules in Application Object Library.
 
List of executables in Application Object Library :
 
         ADCONV       AFPASSWD       AFTBLGEN     CMDCART.so        CONCSUB
        FDULONG        FNDAQCT       FNDATUPD       FNDCPASS       FNDCPGLC
       FNDCPPUR       FNDCPRRF       FNDCPSPN       FNDCPTST       FNDCPUCF
         FNDCRM       FNDDWPUR        FNDEMON       FNDFBPLS       FNDFBUPG
       FNDFFCHY       FNDFFRXR       FNDFFUPG       FNDFFVGN          FNDFS
         FNDGFH         FNDGFU        FNDIMON        FNDLIBR        FNDLOAD
      FNDLOADSO       FNDMDCVT       FNDMDGEN       FNDPRESC       FNDPSTAX
       FNDRTR45         FNDSCH       FNDSLOAD          FNDSM       FNDSVCRG
       FNDTMTST     FNDWRR.exe         WFLOAD       WFMLRXFR       WFRESGEN
         WFTEST         fdfcmp       fndcpesr    fndfmxit.so    fndrwxit.so
 
Enter executables to relink, or enter 'all' [all] : all
Line-wrapping log file for readability ...
Done line-wrapping log file.
 
Original copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.lsv
New copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.log
 
 
Relinking selected modules in Alert.
 
List of executables in Alert :
 
         ALDTCA         ALDTOA         ALDVSS         ALECDC         ALECTC
         ALEPPE         ALPPNR         ALPPWF         ALUPMM         ALUTAD
 
Enter executables to relink, or enter 'all' [all] : all
Line-wrapping log file for readability ...
Done line-wrapping log file.
 
Original copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.lsv
New copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.log
 
 
Relinking selected modules in General Ledger.
 
List of executables in General Ledger :
 
         GLAMAS         GLAVAL         GLBAAC         GLBAAR         GLBBSU
         GLBCMP         GLBCRE         GLBDBO         GLBMBO         GLBOYR
         GLCCON         GLCPCA         GLCRVL         GLELIM         GLEOYR
         GLFYCF         GLGCPP         GLHRRT         GLLDEL         GLLEZL
         GLMMMP         GLMRCU         GLNSVI         GLOOAP         GLPARV
       GLPAUTOP         GLPPOS         GLPRBE         GLPREV         GLPRJE
        GLPURGE       GLPURGEC         GLSBRP         GLSIMS         GLSMST
         GLSTPM         GLSWPR         GLTATR         GLTTRC         GLTTRN
         GLUENC         GLYCCJ
 
Enter executables to relink, or enter 'all' [all] : all
 
End of adrelink session
Date/time is  Mon Jan 4 09:46:38 IST 2016
**********************************************************
 
Line-wrapping log file for readability ...
Done line-wrapping log file.
 
Original copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.lsv
New copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.log
 
 
Relinking selected modules in Application Report Generator.
 
List of executables in Application Report Generator :
 
         RGAUCP         RGDDAT         RGDEIB         RGDSEG         RGOPTM
         RGRARG         RGSSRQ
 
Enter executables to relink, or enter 'all' [all] : all
Line-wrapping log file for readability ...
Done line-wrapping log file.
 
Original copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.lsv
New copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.log
 
 
Relinking selected modules in Payables.
 
List of executables in Payables :
 
         APPBCF         APTZGF
 
Enter executables to relink, or enter 'all' [all] : all
Line-wrapping log file for readability ...
Done line-wrapping log file.
 
Original copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.lsv
New copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.log
 
 
Relinking selected modules in Assets.
 
List of executables in Assets :
 
         FAACCR         FAACUP         FACCBA         FADEPR          FAGDA
         FAMACH        FAMADEL         FAMAPT          FAMCP        FAMPRET
      FAMPSLTFR        FAMPTFR         FAMRCL         FAMRST         FAMTFR
         FAPADJ         FAPROJ         FAPURG          FARET       FARXPBSH
          FASCB        FATAXUP         FATMTA         FAUPPR         FAVRVL
         FAWDPR         FAXADJ
 
Enter executables to relink, or enter 'all' [all] : all
Line-wrapping log file for readability ...
Done line-wrapping log file.
 
Original copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.lsv
New copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.log
 
 
Relinking selected modules in Receivables.
 
List of executables in Receivables :
 
         ARBCPC         ARCABP         ARDLGP         ARDSLG         ARGCGP
         ARGLTP         ARGUPC         ARLIBR         ARLPLB         ARRGTA
         ARTXMT         ARXAAP         ARXCER         ARXREC         ARXSGP
         ARZCAR         RACUST         RAXDEL         RAXMTR         RAXTRX
 
Enter executables to relink, or enter 'all' [all] : all
Relinking selected modules in Projects.
 
List of executables in Projects :
 
         PACCBL       PACODTBC        PAICGEN         PAIGEN         PALDLC
         PALIBR         PAPBER         PARCFR         PARGDR         PARTAR
         PASDUC         PASGLT         PATTAR         PATTGL         PAVDVC
 
Enter executables to relink, or enter 'all' [all] : all
 
Relinking selected modules in Payroll.
 
List of executables in Payroll :
 
        PYATUPD         PYCBTC         PYLOAD         PYUADV         PYUCSU
         PYUGEN         PYUMAG         PYUMWT         PYUPIP         PYUPRT
         PYUSRP         PYUVEN
 
Enter executables to relink, or enter 'all' [all] : all
Relinking selected modules in FastFormula.
 
List of executables in FastFormula :
 
           FFTM         FFXBCP         FFXMLC
 
Enter executables to relink, or enter 'all' [all] : all
Relinking selected modules in Inventory.
 
List of executables in Inventory :
 
         INCAAA         INCAAC         INCAAP         INCACG         INCACI
         INCACP         INCACS         INCAPA         INCAPD         INCAPF
         INCAPP         INCAPT         INCDSS         INCFDH         INCFIF
         INCIAP         INCIAR         INCIPS         INCOIN         INCRPG
         INCRPR         INCRVL         INCTCC          INCTM         INCTPG
         INCTSN        INVLIBR
 
Enter executables to relink, or enter 'all' [all] : all
Relinking selected modules in Purchasing.
 
List of executables in Purchasing :
 
         POCDMC          POCFH         POCIRM         POCISO         POCRMC
         POXCON         POXRAF         POXRSR        RCVOLTM          RVCTP
 
Enter executables to relink, or enter 'all' [all] : all
Relinking selected modules in Bills of Material.
 
List of executables in Bills of Material :
 
         BMCCCI         BMCCLT         BMCMUD         BMCPCL         BMCRLT
         CMCACW         CMCCCI         CMCCCM         CMCCCW         CMCCOC
         CMCCTW         CMCICU         CMCLCW         CMCMCW         CMCMEC
         CMCPAM         CMCPAW         CMCPIM         CMCPIW         CMCTCM
         CMRICU         CTOCLT
 
Enter executables to relink, or enter 'all' [all] : all
Relinking selected modules in Engineering.
 
List of executables in Engineering :
 
         ENCACN         ENCECP
 
Enter executables to relink, or enter 'all' [all] : all
Relinking selected modules in Material Requirements Planning.
 
List of executables in Material Requirements Planning :
 
         MRCAUD         MRCBLC         MRCCPP         MRCEAP         MRCFCC
         MRCIDX         MRCLIB         MRCMON         MRCNEW         MRCNSP
         MRCPDW         MRCPRG         MRCSAL         MRCSCW         MRCSDW
         MRCSLD         MRRDPR         MRRFCS         MRRGRF         MRRPCR
         MRRSCD
 
Enter executables to relink, or enter 'all' [all] : all
Relinking selected modules in Capacity.
 
List of executables in Capacity :
 
         CYCCRP         CYCPLN         CYCROL         CYQLIB         CYRRCP
 
Enter executables to relink, or enter 'all' [all] : all
 
Relinking selected modules in Work in Process.
 
List of executables in Work in Process :
 
         WICMEX         WICMLX
 
Enter executables to relink, or enter 'all' [all] : all
 
Relinking selected modules in Configurator.
 
List of executables in Configurator :
 
    libczlce.so
 
Enter executables to relink, or enter 'all' [all] : all
 
Relinking selected modules in Advanced Supply Chain Planning.
 
List of executables in Advanced Supply Chain Planning :
 
         MSCCPP         MSCMON         MSCNEW         MSCNSP       MSCNSPNM
         MSCPCL         MSCPCP         MSCPDW         MSCPRG         MSCSDW
         MSCSLD       MSCXGCAL
 
Enter executables to relink, or enter 'all' [all] : all
 
Relinking selected modules in Process Manufacturing Financials.
 
List of executables in Process Manufacturing Financials :
 
       GMFACOST        GMFCUPD        GMFROLL        GMFXUPD
 
Enter executables to relink, or enter 'all' [all] : all
Relinking selected modules in SDP Provisioning.
 
List of executables in SDP Provisioning :
 
        XDPCTRL       XDPCTRLS          XDPDQ       XDPSCRPT
 
Enter executables to relink, or enter 'all' [all] : all
Relinking selected modules in Constraint Based Optimization.
 
List of executables in Constraint Based Optimization :
 
         MSONEW
 
Enter executables to relink, or enter 'all' [all] : all
 
Relinking selected modules in Shop Floor Management.
 
List of executables in Shop Floor Management :
 
         WSCMTI         WSCMTM
 
Enter executables to relink, or enter 'all' [all] : all
 
Relinking selected modules in Mobile Applications.
 
List of executables in Mobile Applications :
 
         MWADIS
 
Enter executables to relink, or enter 'all' [all] :
Relinking selected modules in Inventory Optimization.
 
List of executables in Inventory Optimization :
 
         MSRNEW
 
Enter executables to relink, or enter 'all' [all] : all
Relinking selected modules in Sourcing.
 
List of executables in Sourcing :
 
    libponao.so
 
Enter executables to relink, or enter 'all' [all] : all
Remove the temp directory
rm -rf temp
 
Done relinking module libponao.so in product pon
Done with link of product 'pon' on Mon Jan  4 09:58:06 IST 2016
 
 
adrelink is exiting with status 0
 
End of adrelink session
Date/time is  Mon Jan 4 09:58:06 IST 2016
**********************************************************
 
Line-wrapping log file for readability ...
Done line-wrapping log file.
 
Original copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.lsv
New copy is /u02/apps/fs_ne/EBSapps/log/adadmin/log/adrelink.log
 
 
Review the messages above, then press [Return] to continue.
Recording Adadmin action :ADADMIN_RELINK
 Tokens:ENV_FNAME=PREPROD_chintels.env,PRD_TO_LINK=all,SPECIFIC_BIN=yes,LNK_DEBUG=No,SELECTED_FILES_FND=all,SELECTED_FILES_ALR=all,SELECTED_FILES_GL=all,SELECTED_FILES_RG=all,SELECTED_FILES_AP=all,SELECTED_FILES_FA=all,SELECTED_FILES_AR=all,SELECTED_FILES_PA=all,SELECTED_FILES_PAY=all,SELECTED_FILES_FF=all,SELECTED_FILES_INV=all,SELECTED_FILES_PO=all,SELECTED_FILES_BOM=all,SELECTED_FILES_ENG=all,SELECTED_FILES_MRP=all,SELECTED_FILES_CRP=all,SELECTED_FILES_WIP=all,SELECTED_FILES_CZ=all,SELECTED_FILES_MSC=all,SELECTED_FILES_GMF=all,SELECTED_FILES_XDP=all,SELECTED_FILES_MSO=all,SELECTED_FILES_WSM=all,SELECTED_FILES_MWA=all,SELECTED_FILES_MSR=all,SELECTED_FILES_PON=all
 
 
Backing up restart files, if any......Done.
 
         Maintain Applications Files
   ----------------------------------------
 
   1.    Relink Applications programs
 
   2.    Copy files to destinations
 
   3.    Convert character set   
 
   4.    Maintain snapshot information
 
   5.    Check for missing files
 
   6.    Return to Main Menu
 
 Enter your choice [6] :
AD Administration is complete.
 
Errors and warnings are listed in the log file
/u02/apps/fs_ne/EBSapps/log/adadmin/log/relink.log
 
and in other log files in the same directory.

*********************************END******************************************
 
How to Relink using command line.

I would like to write something useful for patching and fine-tuning. When times, we have to relink a particular binary file (executable) in connection with patching or else corrupted file etc. I am providing the step-by-step procedure of relinking a particular executable.

Login as owner of Application Tier and source the environment file..

Go to cd $FND_TOP/bin
$ adrelink.sh force=y "fnd FNDLIBR"
$ adrelink.sh force=y "fnd FNDSM"
$ adrelink.sh force=y "fnd FNDFS"
$ adrelink.sh force=y "fnd FNDCRM"

$ adrelink.sh force=y “ad adadmin”
If you are using the command
$ adrelink.sh force=y “ad all”

you are relinking all binaries under the $AD_TOP/bin

Check the logfile for errors and warning



No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...