Differences

This shows you the differences between two versions of the page.

--- e-business_suite_ebs [2018/12/10 18:38] – external edit 127.0.0.1
+++ e-business_suite_ebs [2026/01/09 15:29] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-  *  [[http://mtalmasri.blogspot.com|EBS blog - mtalmasri]]
+====== E-Business Suite ======
-  *  [[http://360oracleappsdba.blogspot.com|EBS blog -  360oracleappsdba]]
+  * [[https://sites.google.com/view/oracle-apps-dba/ebs/apps-concepts/autoconfig/details|Oracle EBS Autoconfig concepts]]
-===== Cloning =====
+  * [[https://techgoeasy.com/oracle-tutorials/e-business-suite-11ir12r12-1r12-2/|Oracle EBS 11i/R12/R12.1/R12.2 - techgoeasy.com]]
+  * [[https://www.oracle.com/support/contact.html#emea|SR not getting updated quick enough, contact Oracle Support by phone. Oracle Support phone numbers]]
+  * [[https://balajiabhi.blogspot.com/2008/12/fndcpass-tricks-and-methods.html?m=1|FNDCPASS Tricks and Methods]]
+Tried most methods. The only one that seems to work correctly is dump the 2 tables from another system and import them into the current one. Then run FNDCPASS.
+  * [[http://krishnaoracle.blogspot.com/2014/09/fndcpass.html|FNDCPASS to change APPS and APPLSYS passwords]]
+  * [[http://mtalmasri.blogspot.com|EBS blog - mtalmasri]]
+  * [[http://360oracleappsdba.blogspot.com|EBS blog -  360oracleappsdba]]
+  * [[http://oracleajidba.blogspot.com/2010/07/what-happening-when-executing.html|What happening when executing adpreclone.pl in DB and Apps Tier?]]
+  * [[https://gerardnico.com/ebs/installation#autoconfig|Install E-Business suite 12.1.1 Standard Installation on Linux OEL 5.3]]
+  * [[https://docs.oracle.com/cd/E26401_01/doc.122/e22953/T174296T575591.htm#8159578|Concurrent Processing Command-Line Utility (cpadmin)]]
+  * [[Clone E-Business Suite EBS database]]
+Some useful documents from Oracle
+  * [[https://docs.oracle.com/cd/E18727-01/doc.121/e12841/T120505T120514.htm|AutoConfig - Oracle E-Business Suite Concepts]]
+  * SRDC - Data Collection for E-Business Suite Cloning / Rapid Cloning Issues ( Doc ID 2108567.1 )
+  * Troubleshooting RapidClone issues with Oracle Applications R12.0 & R12.1 ( Doc ID 603104.1 )
+  * EBS R12.0.x / R12.1.x : How To Find Location Of Install, Autoconfig, Patching , Clone And Other Logs ( Doc ID 804603.1 )
+  * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=406982.1|Cloning Oracle Applications Release 12 with Rapid Clone ( Doc ID 406982.1 )]]
+  * [[https://docs.oracle.com/cd/E18727_01/doc.121/e12841/T120505T120514.htm|Oracle E-Business Suite Concepts Manual]]
+  * [[https://docs.oracle.com/cd/E18727_01/doc.121/e13675/T530130T530133.htm|Oracle® E-Business Suite Maintenance Procedures]]
+  * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=387859.1|Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 (Doc ID 387859.1)]]
+  * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=558478.1|Cloning A Database Home And Changing The User/Group That Owns It (Doc ID 558478.1)]]
+  * [[https://support.oracle.com/epmos/faces/DocumentDisplay?&id=2108567.1|SRDC - Data Collection for E-Business Suite Cloning / Rapid Cloning Issues (Doc ID 2108567.1) - Find those logs! ]]
+==== How to customise the Oracle Applications logo ====
+One of the things customers want to do is replace the logo. [[http://kumarsatheesh.blogspot.com/2010/05/personalize-oracle-apps-11i-e-business.html|Personalize Oracle Apps 11i (E-business Suite)]]
+==== Find out what the apps password is if it has been forgotten ====
+<code>
+Below steps to get the forgotten apps user password in oracle apps R12.
+Step 1:  Connect to sys user
+SQL> show user
+USER is "SYS"
+Step 2:  Create function to know the encrypted password
+SQL> create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
+/
+Function created.
+Step 3:  Query for password
+SQL> set linesize 200 long 300
+SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';
+ENCRYPTED_FOUNDATION_PASSWORD
+----------------------------------------------------------------------------------------------------
+ZGC679A64D8394F23E12CA4EB288F264FC09EBC9144C06181E921F88A972E231E9B530E7810DE42AC6103FC3CCD317CA3391
+Step 4:  Apps password using encrypted guest password
+SQL> SELECT apps.decrypt_pin_func('GUEST/ORACLE','ZGC679A64D8394F23E12CA4EB288F264FC09EBC9144C06181E921F88A972E231E9B530E7810DE42AC6103FC3CCD317CA3391') from dual;
+APPS.DECRYPT_PIN_FUNC('GUEST/ORACLE','ZGC679A64D8394F23E12CA4EB288F264FC09EBC9144C06181E921F88A972E231E9B530E7810DE42AC6103FC3CCD317CA3391')
+---------------------------------------------------------------------------------------------------------------------------------------------
+PASSWORD
+Step 5:  Test the password is working fine or not
+SQL> conn apps/PASSWORD;
+Connected
+</code>
+==== Restoring apps and applsys passwords after being changed at database level ====
+  * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=1306938.1|FNDCPASS Troubleshooting Guide For Login and Changing Applications Passwords (Doc ID 1306938.1)]]
+These user passwords must be changed using FNDCPASS otherwise they (and the Application) will become unusabe.
+If FNDCPASS does not work but you think it should (ie: you're pretty sure the password is correct), check the sec_case_sensitive parameter! It should be false for EBS.
+Trying to change the password without using FNDCPASS will fail
+<code>
+cat L5217782.log
++---------------------------------------------------------------------------+
+Application Object Library: Version : 12.1
+Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
+FNDCPASS:
++---------------------------------------------------------------------------+
+Current system time is 26-SEP-2023 16:06:36
++---------------------------------------------------------------------------+
+Arguments
+   FNDCPASS system/***** SYSTEM APPLSYS *****
++----------------------------------------------------------------------------+
+Working...
+Error in password verification for APPS.
++---------------------------------------------------------------------------+
+Concurrent request completed
+Current system time is 26-SEP-2023 16:06:37
++---------------------------------------------------------------------------+
+</code>
+It used to be possible to recover the situation by updating the fnd_oracle_userid table with a known encrypted password
+<code>
+alter user apps identified by apps account unlock;
+update apps.fnd_oracle_userid
+set    encrypted_oracle_password ='ZGA34EA20B5C4C9726CC95AA9D49EA4DBA8EDB705CB7673E645EED570D5447161491D78D444554655B87486EF537ED9843C8'
+where  oracle_username in ('APPS','APPLSYS');
+</code>
+ but this doesn't seem to work any more.
+A way that still works (if there is no table-level backup), is to export the tables from a good database and import them into the problem database.
+The passwords will obviously then be the same as those on the source database.
+  * Export tables from a good database
+<code>
+expdp \'system/password@EBSP\' directory=data_pump_dir tables="applsys.fnd_user, applsys.fnd_oracle_userid" dumpfile=fnd_passwords.dmp logfile=expdp_fnd_passwords.log exclude=statistics
+</code>
+  * scp the dumpfile over to the bad database
+  * Import the dumpfile into the bad database
+<code>
+impdp \'system/password@EBSA\' directory=data_pump_dir dumpfile=fnd_passwords.dmp logfile=impdp_fnd_passwords.log table_exists_action=replace
+</code>
+  * Change the password for apps and applsys in the database to match those of the good database
+<code>
+alter user apps identified by "password" account unlock;
+alter user applsys identified by "password" account unlock;
+</code>
+  * Change the password using FNDCPASS and check the logfile
+<code>
+FNDCPASS apps/"password" 0 Y system/manager SYSTEM APPLSYS "someotherpassword"
+cat L5218783.log
++---------------------------------------------------------------------------+
+Application Object Library: Version : 12.1
+Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
+FNDCPASS:
++---------------------------------------------------------------------------+
+Current system time is 26-SEP-2023 16:30:43
++---------------------------------------------------------------------------+
+Arguments
+   FNDCPASS system/***** SYSTEM APPLSYS *****
++----------------------------------------------------------------------------+
+Working...
+FNDCPASS completed successfully.
++---------------------------------------------------------------------------+
+Concurrent request completed successfully
+Current system time is 26-SEP-2023 16:30:44
++---------------------------------------------------------------------------+
+</code>
+==== Stuff requested by Oracle ====
+Include this info when creating a technical SR
+includes the version / release of Oracle Applications (fnd_product_groups)
+<code>
+conn apps/apps
+set lines 1000
+col release_name for a20
+col codelevel    for a10
+select release_name from fnd_product_groups;
+select version from v$instance;
+select abbreviation, codelevel from ad_trackable_entities where abbreviation in ('txk','ad');
+</code>
+As detailed in SRDC - Data Collection for E-Business Suite Cloning / Rapid Cloning Issues ( Doc ID 2108567.1 ) above, these things do not necessarily work properly. For example, TWO_TASK is not defined on the DB Tier so:
+<code>
+TWO_TASK=$ORACLE_SID
+</code>
+before running the zip command here. But then it still won't work if you used adcfgclone.pl with soemthing other than DBTier as a parameter (like me as I used Section 4, Option 6 in the Cloning document).
+<code>
+. On the target database tier, issue the following zip command:
+$ zip -r /tmp/$TWO_TASK'_'`uname -n`_`date +%m%d%y.%H%M`_DB_Clone_logs.zip \
+/tmp/adcfgclone_*.res \
+/tmp/adcfgclone_*.err \
+$ORACLE_HOME/appsutil/temp/portpool.lst \
+$ORACLE_HOME/clone/bin/CloneContext_*.log \
+$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log \
+$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/make_*.log \
+$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_*.log \
+$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/NetServiceHandler.log \
+$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/adcrdb_*.txt
+</code>
+The following command works unmodified.
+<code>
+. On the target application tier, issue the following zip command:
+$ zip -r /tmp/$TWO_TASK'_'`uname -n`_`date +%m%d%y.%H%M`_APP_Clone_logs.zip \
+/tmp/adcfgclone_*.res \
+/tmp/adcfgclone_*.err \
+$COMMON_TOP/clone/bin/CloneContext_*.log \
+$INST_TOP/admin/out/portpool.lst \
+$INST_TOP/admin/log/ohclone.log \
+$INST_TOP/admin/log/NetServiceHandler.log \
+$INST_TOP/admin/log/ApplyAppsTier_*.log \
+$LOG_HOME/ora/10.1.3/install/make_*.log \
+$LOG_HOME/ora/10.1.2/install/make_*.log \
+$LOG_HOME/ora/10.1.2/network/apps_*.log
+</code>
+Then they request you do this...
+<code>
+. Download and run the Clone Log Parser.
+This is a tool used to consolidate error information from various Rapidclone related log files into an HTML report.
+A single cloning session may generate up to a dozen separate log files, the Log Parser allows you to view relevant snippets of each log at one time.
+Additionally the Log Parser will do some basic configuration and health checks of the environment and also may provide leads to solving problems.
+Review note EBS Clone Log Parser Utility (Rapid Clone 11i,12.0, 12.1)[VIDEO] ( Doc ID 1447553.1 ).
+</code>
+Following the instructions in that document, it asks you to unset PERL5LIB but then perl cannot find strict.pm!
+=== RDA ===
+  * Download latest RDA engine - [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=314422.1|Remote Diagnostic Agent (RDA) - Getting Started (Doc ID 314422.1)]]
+Don't forget Database tier can be a different platform from the Apps tier so 2 versions may be needed (one AIX and one Linux?)!
+===== RDA - Health Check / Validation Engine Guide (Doc ID 250262.1) =====
+<code>
+In order to check your OS prerequisites in automatic way please use Note 250262.1 RDA 4 - Health Check / Validation Engine Guide .
+After following “Installation Instructions” please follow “Instructions for UNIX type operating systems”.
+I’ll attach an example :
+download the patch
+unzip
+cd rda
+[applmgr@soatest rda]$ ./rda.sh -T hcve
+Processing HCVE tests ...
+Available Pre-Installation Rule Sets:
+From the menu select the number corresponding to Oracle E-Business Suite Release 12.x Preinstall
+. Upload the generated html file
+</code>
+==== What version of Oracle Applications are we running? ====
+<code>
+select release_name from fnd_product_groups;
+</code>
+==== What maintenance packs have been applied? ====
+<code>
+select
+BUG_NUMBER,
+LAST_UPDATE_DATE,
+decode(bug_number,2728236, 'OWF.G INCLUDED IN 11.5.9',
+3031977, 'POST OWF.G ROLLUP 1 - 11.5.9.1',
+3061871, 'POST OWF.G ROLLUP 2 - 11.5.9.2',
+3124460, 'POST OWF.G ROLLUP 3 - 11.5.9.3',
+3126422, '11.5.9 Oracle E-Business Suite Consolidated Update 1',
+3171663, '11.5.9 Oracle E-Business Suite Consolidated Update 2',
+3316333, 'POST OWF.G ROLLUP 4 - 11.5.9.4.1',
+3314376, 'POST OWF.G ROLLUP 5 - 11.5.9.5',
+3409889, 'POST OWF.G ROLLUP 5 Consolidated Fixes For OWF.G RUP 5', 3492743, 'POST OWF.G ROLLUP 6 - 11.5.9.6',
+3868138, 'POST OWF.G ROLLUP 7 - 11.5.9.7',
+3262919, 'FMWK.H',
+3262159, 'FND.H INCLUDE OWF.H',
+3258819, 'OWF.H INCLUDED IN 11.5.10',
+3438354, '11i.ATG_PF.H INCLUDE OWF.H',
+3140000, 'ORACLE APPLICATIONS RELEASE 11.5.10 MAINTENANCE PACK',
+3240000, '11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 1',
+3460000, '11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 2',
+3480000, 'ORACLE APPLICATIONS RELEASE 11.5.10.2 MAINTENANCE PACK',
+4017300 , 'ATG_PF:11.5.10 Consolidated Update (CU1) for ATG Product Family',
+4125550 , 'ATG_PF:11.5.10 Consolidated Update (CU2) for ATG Product Family',
+5121512, 'AOL USER RESPONSIBILITY SECURITY FIXES VERSION 1',
+6008417, 'AOL USER RESPONSIBILITY SECURITY FIXES 2b',
+6047864, 'REHOST JOC FIXES (BASED ON JOC 10.1.2.2) FOR APPS 11i',
+4334965, '11i.ATG_PF.H RUP3',
+4676589, '11i.ATG_PF.H.RUP4',
+5473858, '11i.ATG_PF.H.RUP5',
+5903765, '11i.ATG_PF.H.RUP6',
+6241631, '11i.ATG_PF.H.RUP7',
+4440000, 'Oracle Applications Release 12 Maintenance Pack',
+5082400, '12.0.1 Release Update Pack (RUP1)',
+5484000, '12.0.2 Release Update Pack (RUP2)',
+6141000, '12.0.3 Release Update Pack (RUP3)',
+6435000, '12.0.4 RELEASE UPDATE PACK (RUP4)',
+5907545, 'R12.ATG_PF.A.DELTA.1',
+5917344, 'R12.ATG_PF.A.DELTA.2',
+6077669, 'R12.ATG_PF.A.DELTA.3',
+6272680, 'R12.ATG_PF.A.DELTA.4',
+7237006, 'R12.ATG_PF.A.DELTA.6',
+6728000, '12.0.6 RELEASE UPDATE PACK (RUP6)',
+7303030, '12.1.1 Maintenance Pack',
+7651091, 'Oracle Applications Technology Release Update Pack 2 for 12.1 (R12.ATG_PF.B.DELTA.2)',
+7303033, 'Oracle E-Business Suite 12.1.2 Release Update Pack (RUP2)',
+9239089, 'Oracle Applications DBA 12.1.3 Product Release Update Pack',
+8919491, 'Oracle Applications Technology 12.1.3 Product Family Release Update Pack',
+9239090, 'ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK',
+bug_number),
+ARU_RELEASE_NAME
+from AD_BUGS b
+where b.BUG_NUMBER in ('2728236', '3031977','3061871','3124460','3126422','3171663','3316333','3314376','3409889', '3492743', '3262159', '3262919', '3868138', '3258819','3438354','32400
+', '3460000', '3140000','3480000','4017300', '4125550', '6047864', '6008417','5121512', '4334965', '4676589', '5473858', '5903765', '6241631', '4440000','5082400','5484000','6141000',
+'6435000',
+'5907545','5917344','6077669','6272680','7237006','6728000','7303030', '7651091', '7303033', '9239089', '8919491', '9239090')
+order by BUG_NUMBER,LAST_UPDATE_DATE,ARU_RELEASE_NAME
+/
+</code>
+<code>
+BUG_NUMBER                     LAST_UPDATE_DATE         DECODE(BUG_NUMBER,2728236,'OWF.GINCLUDEDIN11.5.9',3031977,'POSTOWF.GROLLUP1-11.5.9.1 ARU_RELEASE_NAME
+------------------------------ ------------------------ ------------------------------------------------------------------------------------ ------------------------------
+2728236                        26-JUN-03 01:53:29       OWF.G INCLUDED IN 11.5.9                                                             11i
+3031977                        01-NOV-04 04:09:18       POST OWF.G ROLLUP 1 - 11.5.9.1                                                       11i
+3061871                        01-NOV-04 04:10:06       POST OWF.G ROLLUP 2 - 11.5.9.2                                                       11i
+3124460                        01-NOV-04 04:10:05       POST OWF.G ROLLUP 3 - 11.5.9.3                                                       11i
+3140000                        01-NOV-04 04:01:22       ORACLE APPLICATIONS RELEASE 11.5.10 MAINTENANCE PACK                                 11i
+3258819                        01-NOV-04 04:09:18       OWF.H INCLUDED IN 11.5.10                                                            11i
+3262159                        01-NOV-04 04:10:06       FND.H INCLUDE OWF.H                                                                  11i
+3262919                        01-NOV-04 04:10:27       FMWK.H                                                                               11i
+3314376                        01-NOV-04 04:10:27       POST OWF.G ROLLUP 5 - 11.5.9.5                                                       11i
+3316333                        01-NOV-04 04:10:27       POST OWF.G ROLLUP 4 - 11.5.9.4.1                                                     11i
+3409889                        01-NOV-04 04:10:10       POST OWF.G ROLLUP 5 Consolidated Fixes For OWF.G RUP 5                               11i
+3492743                        01-NOV-04 04:09:37       POST OWF.G ROLLUP 6 - 11.5.9.6                                                       11i
+4440000                        13-JAN-07 12:34:21       Oracle Applications Release 12 Maintenance Pack                                      R12
+4440000                        24-JAN-08 05:50:13       Oracle Applications Release 12 Maintenance Pack                                      R12
+5907545                        23-OCT-07 13:43:59       R12.ATG_PF.A.DELTA.1                                                                 R12
+5907545                        23-JAN-08 21:58:30       R12.ATG_PF.A.DELTA.1                                                                 R12
+5917344                        23-OCT-07 13:43:58       R12.ATG_PF.A.DELTA.2                                                                 R12
+5917344                        23-JAN-08 21:58:31       R12.ATG_PF.A.DELTA.2                                                                 R12
+6077669                        23-OCT-07 13:43:58       R12.ATG_PF.A.DELTA.3                                                                 R12
+6077669                        23-JAN-08 21:58:30       R12.ATG_PF.A.DELTA.3                                                                 R12
+6141000                        23-OCT-07 13:42:12       12.0.3 Release Update Pack (RUP3)                                                    R12
+6272680                        23-JAN-08 21:58:31       R12.ATG_PF.A.DELTA.4                                                                 R12
+6435000                        23-JAN-08 21:58:32       12.0.4 RELEASE UPDATE PACK (RUP4)                                                    R12
+7303030                        03-APR-09 16:28:06       12.1.1 Maintenance Pack                                                              R12
+7303033                        30-MAR-12 19:49:55       Oracle E-Business Suite 12.1.2 Release Update Pack (RUP2)                            R12
+7651091                        30-MAR-12 19:50:02       Oracle Applications Technology Release Update Pack 2 for 12.1 (R12.ATG_PF.B.DELTA.2) R12
+8919491                        30-MAR-12 19:49:56       Oracle Applications Technology 12.1.3 Product Family Release Update Pack             R12
+9239089                        30-MAR-12 11:10:16       Oracle Applications DBA 12.1.3 Product Release Update Pack                           R12
+9239090                        30-MAR-12 19:47:48       ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK                                   R12
+rows selected.
+</code>
+==== What patches have been installed? ====
+<code>
+set lines 1000 pages 100
+col patch_name       for a15
+col patch_type       for a20
+col maint_pack_level for a10
+select applied_patch_id
+,      patch_name
+,      patch_type
+,      maint_pack_level
+,      source_code
+,      creation_date
+from   apps.ad_applied_patches
+order  by creation_date
+/
+</code>
+<code>
+APPLIED_PATCH_ID PATCH_NAME      PATCH_TYPE           MAINT_PACK SOU CREATION_DATE
+---------------- --------------- -------------------- ---------- --- ------------------------
+10096077        ONE-OFF                         DRV 04-APR-12 13:50:45
+10096077        ONE-OFF                         DRV 04-APR-12 13:50:03
+10163753        ONE-OFF                         DRV 02-APR-12 10:55:29
+10163753        ONE-OFF                         DRV 02-APR-12 11:03:01
+10229047        ONE-OFF                         DRV 04-APR-12 13:38:25
+10229047        ONE-OFF                         DRV 04-APR-12 13:34:13
+10318122        ONE-OFF                         DRV 12-JUL-12 18:15:38
+10318122        ONE-OFF                         DRV 12-JUL-12 18:16:05
+10328890        ONE-OFF                         DRV 30-JUL-12 21:58:00
+10328890        ONE-OFF                         DRV 30-JUL-12 21:58:14
+10358055        ONE-OFF                         DRV 04-APR-12 14:54:58
+10358055        ONE-OFF                         DRV 04-APR-12 14:54:13
+10380225        ONE-OFF                         DRV 04-APR-12 15:38:08
+10380225        ONE-OFF                         DRV 04-APR-12 15:38:44
+10408339        ONE-OFF                         DRV 21-SEP-14 03:50:53
+10408339        ONE-OFF                         DRV 21-SEP-14 03:49:45
+11071569        ONE-OFF                         DRV 02-APR-12 11:06:47
+11768127        ONE-OFF                         DRV 30-JUL-12 21:50:22
+11768127        ONE-OFF                         DRV 30-JUL-12 21:39:43
+11792958        ONE-OFF                         DRV 04-APR-12 15:29:46
+11792958        ONE-OFF                         DRV 04-APR-12 15:30:11
+...
+9239089         PATCH-SET                       DRV 30-MAR-12 11:10:14
+9239090         MAINTENANCE-PACK     12.1.3     DRV 30-MAR-12 13:21:38
+9239090         MAINTENANCE-PACK     12.1.3     DRV 30-MAR-12 19:47:38
+9239095         ONE-OFF                         DRV 30-MAR-12 21:17:10
+9239095         ONE-OFF                         DRV 30-MAR-12 21:34:34
+9524997         ONE-OFF                         DRV 04-APR-12 13:46:03
+9524997         ONE-OFF                         DRV 04-APR-12 13:46:32
+9590326         ONE-OFF                         DRV 04-APR-12 14:10:46
+9590326         ONE-OFF                         DRV 04-APR-12 14:11:32
+9679595         ONE-OFF                         DRV 04-APR-12 13:44:15
+9679595         ONE-OFF                         DRV 04-APR-12 13:44:40
+9701260         ONE-OFF                         DRV 04-APR-12 13:41:44
+9701260         ONE-OFF                         DRV 04-APR-12 13:42:46
+9738085         ONE-OFF                         DRV 02-APR-12 11:09:49
+9742747         ONE-OFF                         DRV 04-APR-12 14:13:39
+9742747         ONE-OFF                         DRV 04-APR-12 14:14:29
+9817770         ONE-OFF                         DRV 30-MAR-12 22:12:51
+9852070         ONE-OFF                         DRV 02-APR-12 11:12:45
+9868229         ONE-OFF                         DRV 02-APR-12 10:45:39
+9868229         ONE-OFF                         DRV 02-APR-12 10:53:14
+9926320         ONE-OFF                         DRV 04-APR-12 13:47:41
+9926320         ONE-OFF                         DRV 04-APR-12 13:48:25
+9930308         ONE-OFF                         DRV 30-JUL-12 21:52:53
+9930308         ONE-OFF                         DRV 30-JUL-12 21:53:02
+9966055         ONE-OFF                         DRV 31-MAR-12 11:09:06
+preRH_dest1     ONE-OFF                         DRV 05-MAY-16 10:32:02
+preRH_dest1     ONE-OFF                         DRV 05-MAY-16 10:34:34
+rows selected.
+</code>
+==== Connection issues accessing the Applications login screen? ====
+http server error 500 or another issue? Perform some connection tests with this
+<code>
+http://host.domain:port/OA_HTML/jsp/fnd/aoljtest.jsp
+</code>
+==== Some useful directories / files ====
+CONTEXT_NAME is ${ORACLE_SID}_$(hostname|awk -F'.' {print $1}')
+  * Apps Context file
+<code>
+$INST_TOP/appl/admin/${CONTEXT_NAME}.xml
+</code>
+  * Database Context File
+<code>
+$ORACLE_HOME/appsutil/${CONTEXT_NAME}.xml
+</code>
+  * adautocfg.sh
+On Apps tier is found in $INST_TOP/admin/scripts (= $ADMIN_SCRIPTS_HOME)\\
+This file is a wrapper script that passes the name of the context file to adconfig.sh, which in turn calls $AD_TOP/bin/adconfig.pl (which calls java) to carry out the actual configuration tasks.
+On the Database Tier, it is found in $ORACLE_HOME/appsutil/scripts/${CONTEXT_NAME}/
+  * Backup Autoconfig files
+Backups of the files created by adautocfg.sh can be found in:\\
+    Apps Tier: $INST_TOP/admin/out/MMDDhhmm\\
+    Database Tier: $ORACLE_HOME/appsutil/out/$CONTEXT_NAME/MMDDhhmm
 There are many different ways of cloning an E-Business suite database. This is a long-winded version. Trying to trim it down...
   *  [[Clone E-Business Suite (EBS) database]]
@@ Line 8: / Line 446: @@
   *  [[https://docs.oracle.com/cd/E18727_01/index.htm|Oracle E-Business Suite Main library]]
   *  [[https://docs.oracle.com/cd/E18727_01/doc.121/e12841/T120505T120517.htm|Oracle E-Business Suite Concepts - Cloning]]
+  *  [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=406982.1|Cloning Oracle Applications Release 12 with Rapid Clone (Doc ID 406982.1)]]
+This is the Claremont way of doing it
+  *  [[https://www.claremont.co.uk/tips-for-cloning-oracle-ebusiness-suite/|Tips for Cloning Oracle E-Business Suite]]
+This is the Perficient way of doing it
+  *  [[https://blogs.perficient.com/2016/07/21/cloning-in-oracle-ebs-r12/]]
+==== Troubleshooting ====
+  * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=1447553.1|EBS Clone Log Parser Utility (Rapid Clone 11i,12.0, 12.1) (Doc ID 1447553.1)]]
 ===== General =====
+==== How to rebuild the Central Inventory for EBS databases ====
+  * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=834894.1|How to Create a Clean oraInventory in Release 12 (Doc ID 834894.1)]] - a bit log-winded and manual.
+  * Can also probably script something with runInstaller or deinstall or attach_home.  May be useful [[https://docs.oracle.com/cd/E14075_01/doc/em.112/e12255/oui2_manage_oracle_homes.htm|Managing Oracle Homes]]
 ==== How to find the Internal Concurrent Manager (ICM) log on Oracle Apps 11i and R12 ====
   *  [[http://mtalmasri.blogspot.com/2012/08/how-to-find-icm-log-on-oracle-apps-11i.html|mtalmasri.blogspot.com]]
@@ Line 17: / Line 467: @@
 ls -altr *$TWO_TASK*
 </code>
+==== How to clear/rebuild the java cache in R12 / 11i ====
+  * [[https://oraclegurukul.blogspot.com/2015/01/how-to-clear-cache-in-r12-11i_12.html|How to clear cache in R12 / 11i]]
 ===== Errors =====
 ==== internal concurrent manager has terminated with status 1 - giving up. ====
 === Problem ===
-Starting up with adstrtall.sh seems to end successfully but all the FND processes soon all crash.<br />
+Starting up with adstrtal.sh seems to end successfully but all the FND processes soon all crash.\\
 === Solution ===
   *  [[http://360oracleappsdba.blogspot.com/2010/12/internal-concurrent-manager-has.html|Rerun autoconfig on db server then apps server - 360oracleappsdba.blogspot.com]]
-Essentially, on the application server setup the environment, then<br />
+Essentially, on the application server setup the environment, then\\
 Stop what's left of the apps processes
 <code>
@@ Line 29: / Line 482: @@
 ./adstpall.sh apps/apps
 </code>
-on the database server setup the environment, then<br />
+on the database server setup the environment, then\\
 Run autoconfig appspass=apps
 <code>
@@ Line 35: / Line 488: @@
 ./adautocfg.sh
 </code>
-then back on the application server<br />
+then back on the application server\\
 Run autoconfig and restart apps
 <code>
@@ Line 43: / Line 496: @@
 </code>
 As a final check, have a look at the contents of FND_NODES
+==== EBS Sanity / Health check script ====
+  *  [[http://appsdbastuff.blogspot.com/2018/09/ebs-sanity-script.html]]
+<code>
+set pages 1000
+set linesize 135
+col PROPERTY_NAME for a25
+col PROPERTY_VALUE for a15
+col DESCRIPTION for a35
+col DIRECTORY_PATH for a70
+col directory_name for a25
+col OWNER for a10
+col DB_LINK for a40
+col HOST for a20
+col "User_Concurrent_Queue_Name" format a50 heading 'Manager'
+col "Running_Processes" for 9999 heading 'Running'
+set head off
+set feedback off
+set echo off
+break on utl_file_dir
+select '--------------------------------------------------------------------------------' from dual;
+select '-----------------------     Database Checks    ---------------------------------' from dual;
+select '--------------------------------------------------------------------------------' from dual;
+Prompt
+select '************************ Getting Database Information  *************' from dual ;
+select 'Database Name..................... : '||name from v$database;
+select 'Database Status................... : '||open_mode from v$database;
+select 'Archiving Status.................. : '||log_mode  from v$database;
+select 'Global Name....................... : '||global_name from global_name;
+select 'Creation Date..................... : '||to_char(created,'DD-MON-YYYY HH24:MI:SS') from v$database;
+select 'Checking For Missing File......... : '||count(*) from v$recover_file;
+select 'Checking Missing File Name ....... : '||count(*) from v$datafile where name like '%MISS%';
+select 'Total SGA ........................ : '||round(sum(value)/(1024*1024))||' MB' from v$sga ;
+select 'Database Version.................. : '||version from v$instance;
+select 'Temporary Tablespace.............. : '||property_value from database_properties
+                                                where property_name like 'default_temp_tablespace';
+select 'Apps Temp Tablespace.............. : '||temporary_tablespace from dba_users where username like '%APPS%';
+select 'Temp Tablespace size.............. : '||sum(maxbytes/1024/1024/1024)||' GB' from dba_temp_files group by tablespace_name;
+select 'No of Invalid Object ............. : '||count(*) from dba_objects where status = 'INVALID' ;
+select 'service Name...................... : '||value from v$parameter2 where name='service_names';
+select 'plsql code type................... : '||value from v$parameter2 where name='plsql_code_type';
+select 'plsql subdir count................ : '||value from v$parameter2 where name='plsql_native_library_subdir_count';
+select 'plsql native library dir.......... : '||value from v$parameter2 where name='plsql_native_library_dir';
+select 'Shared Pool Size.........,........ : '||(value/1024/1024) ||' MB' from v$parameter where name='shared_pool_size';
+select 'Log Buffer........................ : '||(value/1024/1024) ||' MB' from v$parameter where name='log_buffer';
+select 'Buffer Cache...................... : '||(value/1024/1024) ||' MB' from v$parameter where name='db_cache_size';
+select 'Large Pool Size................... : '||(value/1024/1024) ||' MB' from v$parameter where name='large_pool_size';
+select 'Java Pool Size.................... : '||(value/1024/1024) ||' MB' from v$parameter where name='java_pool_size';
+select 'utl_file_dir...................... : '||value from v$parameter2 where name='utl_file_dir';
+select directory_name||'.................... : '||directory_path from all_directories where rownum  < 15 ;
+select '************************ Getting Apps Information *****************' from dual ;
+select 'Home URL.......................... : '||home_url from apps.icx_parameters ;
+select 'Session Cookie.................... : '||session_cookie from apps.icx_parameters ;
+select 'Applicaiton Database ID........... : '||fnd_profile.value('apps_database_id') from dual;
+select 'GSM Enabled....................... : '||fnd_profile.value('conc_gsm_enabled') from dual;
+select 'Maintainance Mode................. : '||fnd_profile.value('apps_maintenance_mode') from dual;
+select 'Site Name......................... : '||fnd_profile.value('Sitename')from dual;
+select 'Bug Number........................ : '||bug_number from ad_bugs where bug_number='2728236';
+select '************************ Doing Workflow Checks ********************' from dual ;
+select 'No Open Notifications............. : '||count(*) from wf_notifications where mail_status in('MAIL','INVALID','OPEN');
+select 'Name(wf_systems).................. : '||name from wf_systems;
+select 'Display Name(wf_systems).......... : '||display_name from wf_systems;
+select 'Address........................... : '||address from wf_agents;
+select 'Workflow Mailer Status............ : '||component_status from applsys.fnd_svc_components
+                                                where component_name like 'Workflow Notification Mailer';
+select 'Test Address...................... : '||b.parameter_value
+                                                from fnd_svc_comp_param_vals_v a, fnd_svc_comp_param_vals b
+                                                where a.parameter_id=b.parameter_id
+                                                and a.parameter_name in ('TEST_ADDRESS');
+select 'From Address...................... : '||b.parameter_value
+                                                from fnd_svc_comp_param_vals_v a, fnd_svc_comp_param_vals b
+                                                where a.parameter_id=b.parameter_id
+                                                and a.parameter_name in ('FROM');
+select 'WF Admin Role..................... : '||text from wf_resources where name = 'WF_ADMIN_ROLE' and  rownum =1;
+Prompt
+Prompt Getting Apps Node Info
+Prompt ************************
+select Node_Name,'........................ : '||server_id from fnd_nodes;
+select server_type||'......................: '||name from fnd_app_servers, fnd_nodes
+                                                where fnd_app_servers.node_id =fnd_nodes.node_id;
+select '************************ Doing Conc Mgr Checks  ********************' from dual ;
+Column Target_Node   Format A12
+select User_Concurrent_Queue_Name,'....... : '||Target_Node||' ...... : '||Running_Processes
+                                                from fnd_concurrent_queues_vl
+                                                where Running_Processes = Max_Processes
+                                                and Running_Processes > 0;
+Prompt
+Prompt Getting Pending Request
+Prompt ***********************
+--select user_concurrent_program_name||'........ : '||request_id
+--                                                  from fnd_concurrent_requests r, fnd_concurrent_programs_vl p, fnd_lookups s, fnd_lookups ph
+--                                                  where r.concurrent_program_id = p.concurrent_program_id
+--                                                 and r.phase_code = ph.lookup_code
+--                                                and ph.lookup_type = 'CP_PHASE_CODE'
+--                                               and r.status_code = s.lookup_code
+--                                                  and s.lookup_type = 'CP_STATUS_CODE'
+--                                                  and ph.meaning ='Pending'
+--                                                  and rownum < 10
+--                                                  order by to_date(actual_start_date, 'dd-MON-yy hh24:mi');
+--
+Prompt
+Prompt Getting Workflow Components Status
+Prompt **********************************
+set pagesize 1000
+select fsc.COMPONENT_NAME,
+fsc.STARTUP_MODE,
+fsc.COMPONENT_STATUS,
+fcq.MAX_PROCESSES TARGET,
+fcq.RUNNING_PROCESSES ACTUAL
+from APPS.FND_CONCURRENT_QUEUES_VL fcq, APPS.FND_CP_SERVICES fcs,
+APPS.FND_CONCURRENT_PROCESSES fcp, fnd_svc_components fsc
+where fcq.MANAGER_TYPE = fcs.SERVICE_ID
+and fcs.SERVICE_HANDLE = 'FNDCPGSC'
+and fsc.concurrent_queue_id = fcq.concurrent_queue_id(+)
+and fcq.concurrent_queue_id = fcp.concurrent_queue_id(+)
+and fcq.application_id = fcp.queue_application_id(+)
+and fcp.process_status_code(+) = 'A'
+order by fcp.OS_PROCESS_ID, fsc.STARTUP_MODE;
+select '--------------------------------------------------------------------------------' from dual;
+select '-----------------------     End Of Database Checks  ----------------------------' from dual;
+select '--------------------------------------------------------------------------------' from dual;
+</code>