How To Create Self Certificate In EBS R12 and Import Certificate in Wallet

How To Create Self Certificate In EBS R12 and Import Certificate in Wallet

================================

First -

1. Creating a Wallet

    Verify the location of the Web SSL Directory:
        grep s_web_ssl_directory $CONTEXT_FILE
    Navigate to this directory which will have Apache and opmn sub-directories.
    Change to the Apache sub-directory.
    Backup any existing wallets (demo certificates are included in Release 12).
    Create your new wallet:
    orapki wallet create -wallet . -auto_login -pwd <password>

    "-wallet ." tells orapki that you want to create the wallet in the current directory.
                        You can also specify the full path to any directory where you wish to
                         create a wallet.
      " -auto_login" tells orapki that you want to create cwallet.sso which is an obfuscated copy
                             of ewallet.p12
                             With auto login enabled - processes submitted by the OS user who created
                             the wallet will not need to supply the password to access the wallet.

You should now see two wallet files in your directory:
     cwallet.sso
     ewallet.p12

This is for test server only. if you dont want to secure you link

Section 8: Self-Signed Testing Certificates

    SELF-SIGNED CERTIFICATES ARE NOT SECURE!!!
THEY SHOULD NOT BE USED IN A PRODUCTION ENVIRONMENT!!!

If you wish to self-sign your certificates for use in a TESTING Environment enter the following command all on 1 line substituting the appropriate parameters (in bold) for your instance:

orapki wallet add -wallet . -dn "CN=server.us.oracle.com,OU=Unit,O=Org,L=Orlando,ST=Florida,C=US" -keysize 2048 -self_signed -validity 3650 -pwd welcome1

Your wallet is now ready for use in your testing environment - do not use this wallet in a production environment.
Section 9: Converting Existing Certificates

If you have existing un-expired certificates from a previous implementation of SSL they can be converted and imported into a Release 12 wallet using the tools:
     SSL2OSSL (Unix)
     SSLCONVERT (Windows NT/2000)

Copy your server.key, server.crt, and ca.crt to the wallet directory and issue the command:

    $ORACLE_HOME/Apache/Apache/bin/ssl2ossl -cert ./server.crt -key ./server.key -cafile ./ca.crt -wallet . -ssowallet yes

Section 10: Adding and Removing the Auto_Login Feature

To enable auto_login:

    navigate to the wallet directory and use the same command used in Section 1 to create the wallet:
         orapki wallet create -wallet . -auto_login -pwd <password>

To disable auto_login you must use the Oracle Wallet Manger GUI interface:

    Navigate to the wallet directory.
    Start the Oracle Wallet Manager as a background process:
         owm &
    Open your existing wallet.
    Select Wallet from the menu bar.
    Deselect Auto Login.
      A message at the bottom of the window indicates that auto login is disabled.

DMZ setup on Oracle EBS R12

Creating an External Web Tier for E-Business Suite

Oracle E-Business Suite R12 Configuration in a DMZ (Doc ID 380490.1)
Clone the internal web tier to create a new external web tier
Pre-Clone Steps on Internal Server

- Run adpreclone.pl

As Database node :


cd $ORACLE_HOME/appsutil/scripts/DEV_Hostname

perl adpreclone.pl dbTier


As Application Node :


cd $ADMIN_SCRIPTS_HOME

perl adpreclone.pl appsTier


Take a backup of application mount point.

Restore the Backup into external server node.

Setup Host File:


Put the following entries in the Hosts File (/etc/hosts)

IP Addressh            yourhostname

IP Addressh           yourhostname


Change the owner Ship of /finerp/FINDEV folder and the file under it to apps


cd /dev


chown –R appdev:dba findev



Creating External Web Tier

Note:          Your steps should be more

Create XML file for External Server:

su – appdev

cd –--/apps/apps_st/comn/clone/bin

perl adclonectx.pl contextfile=---------------/inst/apps/dev_hostname/appl/admin/dev_hostname.xml


Enter the APPS password:

Target System Hostname (virtual or normal) [hostname]:

Do you want the inputs to be validated (y/n) [n]? :

Target System Database SID: dev

Target System Database Server Node [hostname]: extrenalhostname

Target System Base Directory: /dev/oradev/dev

Target System Forms ORACLE_HOME Directory [/dev/oradev/dev/apps/tech_st/10.1.2]:

Target System Web ORACLE_HOME Directory [/dev/oradev/dev/apps/tech_st/10.1.3]:

Target System APPL_TOP Mountpoint [/dev/oradev/dev/apps/apps_st/appl]:

Target System COMMON_TOP Directory [/dev/oradev/dev/apps/apps_st/comn]:

Target System Instance Home Directory [/dev/oradev/dev/inst]:

Username for the Applications File System Owner [appldev]:

Group for the Applications File System Owner [dba]:

Target System Root Service [enabled]:

Target System Web Entry Point Services [enabled]:

Target System Web Application Services [enabled]:

Target System Batch Processing Services [disabled]:

Target System Other Services [disabled]:

Do you want to preserve the Display [hostname:0.0] (y/n)? : n

Target System Display [extrenalhostname:0.0]:

Do you want the the target system to have the same port values as the source system (y/n) [y]? : n

Target System Port Pool [0-99]: 1

Choose a value which will be set as APPLPTMP value on the target node [1]: 2

New context path and file name [/dev/oradev/dev/inst/apps/dev_extrnalhost/appl/admin/dev_extrnalhost.xml]:


Cross Check if the Context File generated is correct or not, check with following command if the respective components are enabled on extrenal hostname :


grep –i status $CONTEXT_FILE



Run adpreclone.pl to add the extrnal server as a node to dev:

su - appldev

cd /dev/appldev/dev/apps/apps_st/comn/clone/bin

perl adcfgclone.pl appsTier /dev/appldev/dev/inst/apps/dev_extrnalhost/appl/admin/dev_extrnalhost.xml

Enter the APPS password:

Check the logfile for any error.

CONTEXT_FILE configuration:


Modify the following CONTEXT_FILE parameters:


Context File Variable
   

Existing Value
   

New Value

s_applcsf
   

/dev/appldev/dev/inst/apps/dev_extrnalhost/logs/appl/conc
   

/dev/appldev/dev/conc

s_appltmp
   

/dev/appldev/dev/inst/apps/dev_extrnalhost/temp
   

/dev_appltmp

s_applptmp
   

/dev/appldev/dev/inst/apps/dev_extrnalhost/ptemp
   

/dev_applptmp

s_formshost
   

extrnalhost
   

dev

s_chronosURL
   

http://extrnalhost.externalhost.com:8001/oracle_smp_chronos/oracle_smp_chronos_sdk.gif
   

http://dev.externalhost.com:8001/oracle_smp_chronos/oracle_smp_chronos_sdk.gif

s_external_url
   

http://extrnalhost.externalhost.com:8001
   

http://dev.externalhost.com:8001

s_webentryhost
   

extrnalhost
   

dev

s_login_page
   

http://extrnalhost.externalhost.com:8001/OA_HTML/AppsLogin
   

http://dev.externalhost.com:8001/OA_HTML/AppsLogin


Run AutoConfig on all the Nodes.




Configuring extrnalhost for DMZ


Run the script txkChangeProfH.sql for the Profile option setup:


# Internal Node..

$ su – appldev


$ sqlplus apps/password


Update Hierarchy Type


@$FND_TOP/patch/115/sql/txkChangeProfH.sql SERVRESP


Run AutoConfig on all nodes.

Update Node Trust Level

To change the value of the Node Trust Level profile option value to External for a particular node, perform the following steps:

1. Login to Oracle E-Bsonapness Suite as sysadmin user sonapng the internal URL

2. Select the System Administrator Responsibility

3. Select Profile / System

4. From the 'Find system profile option Values' window, select the server and get the valie extrnalhost into it.

5. Query for %NODE%TRUST%. You will see a profile option named 'Node Trust Level'. The value for this profile option at the site level will be Normal. Leave this setting unchanged.

6. Set the value of this profile option to External at the server level. The site level value should remain set to Normal


Update List of Responsibility


To change the value of the Responsibility Trust Level profile option at the responsibility level for a particular responsibility, perform the following steps:

7. Login to Oracle E-Bsonapness Suite as sysadmin user sonapng the internal URL

8. Select System Administrator Responsibility

9. Select Profile / System

10. From the 'Find system profile option Values' window, select the responsibility that you want to make available to users logging in via the external web tier

11. Query for %RESP%TRUST%. You will see a profile option named 'Responsibility trust level'. The value for this profile option at site level will be Normal.  Leave this setting unchanged.

12. Set the value of this profile option for the chosen responsibility to External at the responsibility level. The site-level value should remain Normal.

13. Repeat for all responsibilities that you want to make available from the external web tier.


List of Responsibilities which can be enabled on External Server is as followed:


Product Name
   

Externally Accessible Responsibilites
   

Additional Profile Options

iSupplier
   


Do this as per your requirment
   

POS: External URL

POS: Internal URL

Oracle Sourcing
   

Sourcing Supplier
   

PON: External Applications Framework Agent

PON: External login URL

Oracle iProcurement
   

Self Registered Employee Default Responsibility

Self Registered New User Default Responsibility
   



q Enable Oracle E-Business Suite Application Server Security

1. Set the value of Application Server Security Authentication (s_appserverid_authentication) to SECURE, in the CONTEXT_FILE on all the nodes.

2. Run AutoConfig on each Applications middle tier to complete the configuration.

3. After AutoConfig completes successfully, restart Oracle HTTP Server and OC4J processe


Run Autoconfig

Run AutoConfig from ADMIN_SCRIPTS_HOME.


Internal Node and Extrenal node.


After start the service and check..

EBS 12.2.3 Cloning Steps

EBS 12.2.3 Cloning Steps

================================================

Adcgfclone path:- [appltest@crp bin]$ pwd
/application/appltest/systest/fs1/EBSapps/comn/clone/bin

NOTE:- SAME PORT DENA HAI DATABASE AUR APPLICATION KO. Aur fs2 me adcfg

clone run karte samay port number 1 jyada dena hai

Copy database backup from source to target node on db and apps.
1. first shutdown the application, database, listener  on target node.
2. then remove the all the directory of fs1,fs2,fs_ne and in database also.
For apps:- /application/appltest/systest/  remove all the directory
fordb:- /oracle/oratest         remove all the directory
    3.       then unzip the  backup directory.
    4.    then remove the the fs2 files full,  and also remove files from fs_ne ,and remove inst,fmw from fs1 of backup unzipped backup directory.
    5.    then move backup directory to database and application to application
        For db:-
      Database  [oratest@crporatest]$ mv db /oracle/oratest/
      Application [appltest@crp appltest]$ mv * /application/appltest/systest/

   6.    and then run adfgclone command.


Perl adcfgclone command on 12.2.3 on Database Tier

Dbtieradcfgclone command
[oratest@crp bin]$ ls -ltr
total 172
-rwxr-xr-x 1 oratestdba 76411 Mar  5 12:59 adclone.pl
-rwxr-xr-x 1 oratestdba  5101 Mar  5 12:59 adchkutl.sh
-rwxr-xr-x 1 oratestdba 37265 Mar  5 12:59 adclonectx.pl
-rwx--x--x 1 oratestdba 48371 Mar  5 12:59 adcfgclone.pl
/dbt1/oracle/11.2.0/appsutil/clone/bin
[oratest@crp bin]$ perl adcfgclone.pl dbTier

                     Copyright (c) 2011 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

adcfgclone Version 120.63.12020000.7.1202010.2

Enter the APPS password :

Running:
/oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /oracle/or                     atest/db/systest/11.2.0/appsutil/clone/jlib/java:/oracle/oratest/db/systest/11.2.0/appsutil/                     clone/jlib/xmlparserv2.jar:/oracle/oratest/db/systest/11.2.0/appsutil/clone/jlib/ojdbc5.ja  oracle.apps.ad.context.CloneContext -e /oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/                     ../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_43952.lst -stage /oracle/ora                     test/db/systest/11.2.0/appsutil/clone  2> /tmp/adcfgclone_43952.err; echo $? > /tmp/adcfgclo                     ne_43952.res

Log file located at /oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/CloneContext_062000                     3742.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [crp] :

Target Instance is RAC (y/n) [n] : n

Target System Database SID : GORAK

Target System Base Directory : /oracle/oratest/db/systest

Target System utl_file_dir Directory List : /usr/tmp

Number of DATA_TOP's on the Target System [1] :

Target System DATA_TOP Directory 1 [/u01/oratest/db/systest/data] :
RC-00002: Warning: Directory /u01/oratest/db/systest/data not found.

Target System DATA_TOP Directory 1 [/u01/oratest/db/systest/data] : /oracle/oratest/db/systest/data

Target System RDBMS ORACLE_HOME Directory [/oracle/oratest/db/systest/11.2.0] :

Do you want to preserve the Display [null] (y/n)  : n

Target System Display [crp:0.0] :

Do you want the target system to have the same port values as the source system (y/n) [y] ?                      : n

Target System Port Pool [0-99] : 8

Checking the port pool 8
done: Port Pool 8 is free
Report file located at /oracle/oratest/db/systest/11.2.0/appsutil/temp/portpool.lst
Complete port information available at /oracle/oratest/db/systest/11.2.0/appsutil/temp/portpool.lst

Creating the new Database Context file from :
  /oracle/oratest/db/systest/11.2.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :
 /oracle/oratest/db/systest/11.2.0/appsutil/GORAK_crp.xml

Log file located at /oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/CloneContext_062000                     3742.log
Check Clone Context logfile /oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/CloneContex                     t_0620003742.log for details.

Running Rapid Clone with command:
Running:
perl /oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/adclone.pl java=/oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/oracle/oratest/db/systest/11.2.0                     /appsutil/clone component=dbTier method=CUSTOM dbctxtg=/oracle/oratest/db/systest/11.2.0/app                     sutil/GORAK_crp.xml showProgresscontextValidated=true


Beginning database tier Apply - Fri Jun 20 00:40:24 2014

/oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALI                     DATED=true  -Doracle.installer.oui_loc=/oracle/oratest/db/systest/11.2.0/oui -classpath /ora                     cle/oratest/db/systest/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/oracle/oratest/db/systest                     /11.2.0/appsutil/clone/jlib/ojdbc6.jar:/oracle/oratest/db/systest/11.2.0/appsutil/clone/jlib                     /java:/oracle/oratest/db/systest/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/oracle/ora                     test/db/systest/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/oracle/oratest/db/systest/11.2.0/ap                     psutil/clone/jlib/oui/share.jar:/oracle/oratest/db/systest/11.2.0/appsutil/clone/jlib/oui/sr                     vm.jar:/oracle/oratest/db/systest/11.2.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /oracle/oratest/db/systest/11.2.0/appsutil/GORAK_crp.xml -stage /oracle/o                     ratest/db/systest/11.2.0/appsutil/clone   -showProgress
APPS Password : Log file located at /oracle/oratest/db/systest/11.2.0/appsutil/log/GORAK_cr                     p/ApplyDBTier_06200040.log
  |     15% completed

Completed Apply...
Fri Jun 20 00:43:54 2014

Starting database listener for GORAK:
Running:
/oracle/oratest/db/systest/11.2.0/appsutil/scripts/GORAK_crp/addlnctl.sh start GORAK


(move EBSapps from fs1 to fs2) cp -pr EBSapps /appt1/applmgr/fs2
Perl adcfgprecloneappsTier on 12.2.3

/appt1/devapps/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/prereq/linux64


Run this scripts  /tmp/orainstRoot.sh
. ./orainstRoot.sh   (after execute this command bydefault jump to application

Run Time

[appltest@crp bin]$pwd
/application/appltest/systest/fs1/EBSapps/comn/clone/bin

[appltest@crp bin] perl adcfgclone.pl appsTier

                     Copyright (c) 2011 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.26

Enter the APPS password :
Running:
/application/appltest/systest/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /application/appltest/systest/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /application/appltest/systest/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt

Enter the WeblogicAdminServer password :
Running:
/application/appltest/systest/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /application/appltest/systest/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /application/appltest/systest/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/application/appltest/systest/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /application/appltest/systest/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /application/appltest/systest/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource


Do you want to add a node (yes/no) [no] : no


Running:
/application/appltest/systest/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojdbc5.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /application/appltest/systest/fs1/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_18183.lst -stage /application/appltest/systest/fs1/EBSapps/comn/clone  2> /tmp/adcfgclone_18183.err; echo $? > /tmp/adcfgclone_18183.res

Log file located at /application/appltest/systest/fs1/EBSapps/comn/clone/bin/CloneContext_0619130725.log

Target System File Edition type [run] : run

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [crp] :

Target System Database SID : TEST

Target System Database Server Node [crp] :

Target System Database Domain Name [phfi.org] :

Target System Base Directory :  /application/appltest/systest

Target System Base Directory set to /application/appltest/systest

Target System Current File System Base set to /application/appltest/systest/fs1

Target System Other File System Base set to /application/appltest/systest/fs2

Target System Fusion Middleware Home set to /application/appltest/systest/fs1/FMW_Home

Target System Web Oracle Home set to /application/appltest/systest/fs1/FMW_Home/webtier

Target System Appl TOP set to /application/appltest/systest/fs1/EBSapps/appl

Target System COMMON TOP set to /application/appltest/systest/fs1/EBSapps/comn

Target System Instance Home Directory [/application/appltest/systest] :

Target System Instance Top set to /application/appltest/systest/fs1/inst/apps/TEST_crp

Do you want to preserve the Display [sristitest:0.0] (y/n)  : n

Target System Display [crp:0.0] :

Target System Root Service [enabled] :

Target System Web Administration [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 6

Checking the port pool 6
done: Port Pool 6 is free
Report file located at /application/appltest/systest/fs1/inst/apps/TEST_crp/admin/out/portpool.lst
Complete port information available at /application/appltest/systest/fs1/inst/apps/TEST_crp/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2./usr/tmp
3./oracle/oratest/db/systest/11.2.0/appsutil/outbound/TEST_crp
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 1

Creating the new APPL_TOP Context file from :
  /application/appltest/systest/fs1/EBSapps/comn/clone/context/apps/adxmlctx.tmp

The new APPL_TOP context file has been created :
  /application/appltest/systest/fs1/inst/apps/TEST_crp/appl/admin/TEST_crp.xml

Log file located at /application/appltest/systest/fs1/EBSapps/comn/clone/bin/CloneContext_0619130725.log
Check Clone Context logfile /application/appltest/systest/fs1/EBSapps/comn/clone/bin/CloneContext_0619130725.log for details.

Running Rapid Clone with command:
Running:
perl /application/appltest/systest/fs1/EBSapps/comn/clone/bin/adclone.pl java=/application/appltest/systest/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/application/appltest/systest/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/application/appltest/systest/fs1/inst/apps/TEST_crp/appl/admin/TEST_crp.xml showProgresscontextValidated=true



FMW Pre-requisite check log file location : /application/appltest/systest/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /application/appltest/systest/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /application/appltest/systest/fs1/inst/apps/TEST_crp/appl/admin/TEST_crp.xml -stage /application/appltest/systest/fs1/EBSapps/comn/clone -log /application/appltest/systest/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply - Thu Jun 19 13:08:20 2014

/application/appltest/systest/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /application/appltest/systest/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/application/appltest/systest/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.ApplyAppsTier -e /application/appltest/systest/fs1/inst/apps/TEST_crp/appl/admin/TEST_crp.xml -stage /application/appltest/systest/fs1/EBSapps/comn/clone    -showProgress -nopromptmsg
Log file located at /application/appltest/systest/fs1/inst/apps/TEST_crp/admin/log/clone/ApplyAppsTier_06191308.log
  /    100% completed

Completed Apply...
Thu Jun 19 13:25:55 2014


 Executing command: /application/appltest/systest/fs1/EBSapps/10.1.2/bin/sqlplus @/application/appltest/systest/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/truncate_ad_nodes_config_status.sql


Do you want to startup the Application Services for TEST? (y/n) [n] : n

Services not started

[appltest@crp fs1]$
[appltest@crp fs1]$ pwd
/application/appltest/systest/fs1
[appltest@crp fs1]$
[appltest@crp fs1]$




Now copy the EBSapps from FS1 TO fs2 and give TOP Number 1 greater than top gave to DB and Fs1
[appltest@crp fs1]$ cp -pr  EBSapps/  /application/appltest/systest/fs2
[appltest@crp fs1]$
[appltest@crp fs1]$
[appltest@crp fs1]$
Patch Level Autoconfig


[appltest@crp bin]$ perl adcfgclone.pl appsTier

                     Copyright (c) 2011 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.26

Enter the APPS password :
Running:
/application/appltest/systest/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /application/appltest/systest/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /application/appltest/systest/fs2/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt

Enter the WeblogicAdminServer password :
Running:
/application/appltest/systest/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /application/appltest/systest/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /application/appltest/systest/fs2/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/application/appltest/systest/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /application/appltest/systest/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /application/appltest/systest/fs2/EBSapps/comn/clone/bin/../FMW/EBSDataSource


Do you want to add a node (yes/no) [no] : no


Running:
/application/appltest/systest/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojdbc5.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /application/appltest/systest/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_18972.lst -stage /application/appltest/systest/fs2/EBSapps/comn/clone  2> /tmp/adcfgclone_18972.err; echo $? > /tmp/adcfgclone_18972.res

Log file located at /application/appltest/systest/fs2/EBSapps/comn/clone/bin/CloneContext_0619141550.log

Target System File Edition type [run] : patch

Enter the full path of Run File System Context file : /application/appltest/systest/fs1/inst/apps/TEST_crp/appl/admin/TEST_crp.xml
or
/appt1/applmgr/fs1/inst/apps/DEVNEW_sristidev/appl/admin/DEVNEW_sristidev.xml
Provide the values required for creation of the new APPL_TOP Context file.

Target System Fusion Middleware Home set to /application/appltest/systest/fs2/FMW_Home

Target System Web Oracle Home set to /application/appltest/systest/fs2/FMW_Home/webtier

Target System Appl TOP set to /application/appltest/systest/fs2/EBSapps/appl

Target System COMMON TOP set to /application/appltest/systest/fs2/EBSapps/comn

Target System Instance Top set to /application/appltest/systest/fs2/inst/apps/TEST_crp

Target System Port Pool [0-99] : 7

Checking the port pool 7
done: Port Pool 7 is free
Report file located at /application/appltest/systest/fs2/inst/apps/TEST_crp/admin/out/portpool.lst
Complete port information available at /application/appltest/systest/fs2/inst/apps/TEST_crp/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2./usr/tmp
3./oracle/oratest/db/systest/11.2.0/appsutil/outbound/TEST_crp
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 1

Creating the new APPL_TOP Context file from :
  /application/appltest/systest/fs2/EBSapps/comn/clone/context/apps/adxmlctx.tmp

The new APPL_TOP context file has been created :
  /application/appltest/systest/fs2/inst/apps/TEST_crp/appl/admin/TEST_crp.xml

Log file located at /application/appltest/systest/fs2/EBSapps/comn/clone/bin/CloneContext_0619141550.log
Check Clone Context logfile /application/appltest/systest/fs2/EBSapps/comn/clone/bin/CloneContext_0619141550.log for details.

Running Rapid Clone with command:
Running:
perl /application/appltest/systest/fs2/EBSapps/comn/clone/bin/adclone.pl java=/application/appltest/systest/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/application/appltest/systest/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/application/appltest/systest/fs2/inst/apps/TEST_crp/appl/admin/TEST_crp.xml showProgresscontextValidated=true



FMW Pre-requisite check log file location : /application/appltest/systest/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /application/appltest/systest/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /application/appltest/systest/fs2/inst/apps/TEST_crp/appl/admin/TEST_crp.xml -stage /application/appltest/systest/fs2/EBSapps/comn/clone -log /application/appltest/systest/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply - Thu Jun 19 14:16:36 2014

/application/appltest/systest/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /application/appltest/systest/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/application/appltest/systest/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.ApplyAppsTier -e /application/appltest/systest/fs2/inst/apps/TEST_crp/appl/admin/TEST_crp.xml -stage /application/appltest/systest/fs2/EBSapps/comn/clone    -showProgress -nopromptmsg
Log file located at /application/appltest/systest/fs2/inst/apps/TEST_crp/admin/log/clone/ApplyAppsTier_06191416.log
  -    100% completed

Completed Apply...
Thu Jun 19 14:34:22 2014

Looking for incomplete CLONE record in ad_adop_session_patches table

The CLONE record status is no rows selected

Updating incomplete CLONE record to COMPLETED
[appltest@crp bin]$
[appltest@crp bin]$

Upgrade EBS Database 11.2.0.2 to 12.1.0.2 Steps by Steps..

Install the Oracle 12c Software : -

Using Silent Mode -
======================

./runInstaller -ignoreSysPrereqs -ignorePrereq -force -showProgress -silent -responseFile /oracle_home/PATCH2015/ORACLE_12C/database/install.rsp

Responce file :-
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=Hostname
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle_home/app/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/oracle_home/app1/orahome
ORACLE_BASE=/oracle_home/app1
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=oinstall
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.BACKUPDBA_GROUP=oinstall
oracle.install.db.DGDBA_GROUP=oinstall
oracle.install.db.KMDBA_GROUP=oinstall
oracle.install.db.isRACOneInstall=false
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
oracle.installer.autoupdates.option=SKIP_UPDATES


After Install Start CD  -  p21419221_121020_AIX64-5L_9of10.zip
============================

./runInstaller -ignoreSysPrereqs -ignorePrereq -force -showProgress -silent -responseFile Respons file location..

oracle.install.responseFileVersion=/oracle/install/rspfmt_demosinstall_response_schema_v12.1.0
ORACLE_HOSTNAME=youhostname
UNIX_GROUP_NAME=dba
INVENTORY_LOCATION=/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/home/db/orahome12c
ORACLE_BASE=/oracle/database/base


***************** Do the prerequisits of OLD Database **********************

################################## Check The INVALID objects ##################################
########################################################################################################

SELECT DISTINCT object_name, object_type, owner  FROM dba_objects  WHERE  status='INVALID';

–If any invalid objects
@?/rdbms/admin/utlrp.sql

OR

select count(*) from dba_objects where status='INVALID';
exec utl_recomp.recomp_parallel('8');
select count(*) from dba_objects where status='INVALID';

################################## Staus of DB Components ################################################
########################################################################################################

select substr(COMP_ID, 1,10) compid,substr(COMP_NAME,1,24) compname, STATUS,VERSION from DBA_REGISTRY;

################################## DUPLICATE objects Detail ################################################
########################################################################################################

–Always check for DUPLICATE objects in SYS/SYSTEM

select OBJECT_NAME, OBJECT_TYPE from DBA_OBJECTS where OBJECT_NAME||OBJECT_TYPE
in (select OBJECT_NAME||OBJECT_TYPE from DBA_OBJECTS where OWNER='SYS') and
OWNER='SYSTEM' and OBJECT_NAME not in ('AQ$_SCHEDULES_PRIMARY','AQ$_SCHEDULES','DBMS_REPCAT_AUTH');

 or

column object_name format a30
select object_name, object_type
from dba_objects
where object_name||object_type in
   (select object_name||object_type 
    from dba_objects
    where owner = 'SYS')
and owner = 'SYSTEM';

–Fix DUPLICATE objects in SYS/SYSTEM BEFORE upgrade
–• Note:1030426.6 How to Clean Up Duplicate Objects Owned by SYS
How to Clean Up Duplicate Objects Owned by SYS and SYSTEM Schema (Doc ID 1030426.6)
–and SYSTEM Schema


##################### VERY IMPORTANT TO RUN THIS SCRIPT!(preupgrd.sql) #################################
########################################################################################################

@$ORACLE_HOME/rdbms/admin/preupgrd.sql

   * Log into the system as the owner of the Oracle Database 12c Release 1 (12.1) Oracle Home directory.
    * Copy the Pre-Upgrade Information Tool script preupgrd.sql and utluppkg.sql from the Oracle Database 12c Release 1 (12.1) $ORACLE_HOME/rdbms/admin directory to  the $ORACLE_HOME/rdbms/admin directory of the source Oracle Home.

  Step 2:

     * Run the new Pre-Upgrade Information Tool. For example, if you copied preupgrd.sql to the /admin directory of the source Oracle Home:
SQL> @$ORACLE_HOME/rdbms/admin/preupgrd.sql

preupgrade.log, preupgrade_fixups.sql and postupgrade_fixups.sql files are created in $ORACLE_HOME/cfgtoollogs/$ORACLE_SID/preupgrade/, which is under the source database ORACLE_HOME to be upgraded.




Ensure that no files need media recovery and that no files are in backup mode.


SELECT * FROM v$recover_file;
SELECT * FROM v$backup WHERE status != 'NOT ACTIVE';

########################################################################################################
################################## Distributed Transactions  Check ################################################
########################################################################################################

Resolve outstanding distributed transactions prior to the upgrade.
SQL> select * from dba_2pc_pending;


If this returns rows you should do the following:
SQL> SELECT local_tran_id
     FROM dba_2pc_pending;

If exist the disable

SQL> EXECUTE dbms_transaction.purge_lost_db_entry('');
SQL> COMMIT;

or

SQL >rollback force 'local_tran_id' ;
SQL> COMMIT;

########################################################################################################
################################## Standby Database  Check ################################################
########################################################################################################

To check if a standby database exists, issue the following query:

SELECT SUBSTR(value,INSTR(value,'=',INSTR(UPPER(value),'SERVICE'))+1)
FROM v$parameter
WHERE name LIKE 'log_archive_dest%' AND UPPER(value) LIKE 'SERVICE%';


If this query returns a row, then sync the standby database with the primary database.
1. Make sure all the logs are transported to the standby server after a final log switch
in the primary.
2. Start the recovery of the standby database with the NODELAY option.

######################################################################################    ##################
################################## Disbale All Jobs ################################################
########################################################################################################

Disable all batch and cron jobs.

About jobs initiated with Oracle the packages DBMS_JOB, DBMS_SCHEDULER can be used

select * from DBA_SCHEDULER_JOBS;
select * from  DBA_JOBS;

[edit]Enable / Disable a job

BEGIN 
  DBMS_SCHEDULER.ENABLE('myjob');
END;
/
BEGIN 
  DBMS_SCHEDULER.DISABLE('myjob');
END;
/

########################################################################################################
################################## Sys n System Default Tablespace ################################################
########################################################################################################

Ensure the users SYS and SYSTEM have 'SYSTEM' as their default tablespace.
You must have sufficient space in the tablespace or be set to extents unlimited.

SQL> SELECT username, default_tablespace FROM dba_users  WHERE username in ('SYS','SYSTEM');


If DEFAULT_TABLESPACE is anything other than SYSTEM tablespace, modify the default tablespace to SYSTEM by using the below command.

SQL> ALTER user SYS default tablespace SYSTEM;
SQL> ALTER user SYSTEM default tablespace SYSTEM;


########################################################################################################
################################## Aud$ Tablespace Check ################################################
########################################################################################################

Ensure that if the aud$ table exists that it is in the SYS schema and in the SYSTEM tablespace.

SQL> SELECT owner,tablespace_name
     FROM dba_tables
     WHERE table_name='AUD$';

########################################################################################################
############################# Check whether database has any externally authenticated SSL users ##################################
########################################################################################################

SQL> SELECT name FROM sys.user$
     WHERE ext_username IS NOT NULL
     AND password = 'GLOBAL';


########################################################################################################
################################## Purging of Recyclebin n Aud$ ################################################
########################################################################################################

Purge the Recyclebin as well as Truncate the Aud$ table after backup( Note:- &&& Use the Doc Final Audit Purging Script)...

purge DBA_RECYCLEBIN;
Truncate table aud$;


########################################################################################################
################################## Remove Enterprise Manager  Database Control repository ################################################
########################################################################################################
%%%%%%%%%%%%%%% this is not needed %%%%%%%%%%%%%%%%%%%%%%%%%%%

Enterprise Manager Database Control is superseded in 12c by Oracle Enterprise Manager Express .

     Therefore no repository is needed anymore .

     Remove  Enterprise Manager  Database Control  repository MANUALLY using the following command

     Note : You will get the emremove.sql script in the Oracle 12c home .

    Copy the emremove.sql script from the 12c $ORACLE_HOME/rdbms/admin to the source $ORACLE_HOME/rdbms/admin and then execute on the source database prior to upgrade.

$emctl stop dbcontrol

SQL> @?/rdbms/admin/emremove.sql

  If the EM repository is not removed up front ,it will be automatically removed during the catuppst.sql post-upgrade phase.

########################################################################################################
################################## Run olspreupgrade.sql ################################################
########################################################################################################
%%%%%%%%%%%%%%% this is not needed %%%%%%%%%%%%%%%%%%%%%%%%%%%

If  OLS(Lable Security) and/or DV ( Database Vault) was already in the  database prior to the upgrade then execute the following steps on Source database prior to upgrade
Note : You will get the olspreupgrade.sql script in the Oracle 12c home .
Copy the olspreupgrde.sql script from the 12c $ORACLE_HOME/rdbms/admin to the source $ORACLE_HOME/rdbms/admin and then execute on the source database prior to upgrade.
SQL> @?/rdbms/admin/olspreupgrade.sql

   - It prepares the move of AUD$ table from SYSTEM to SYS.

   - It processes the audit records to minimize downtime.

   - It moves records to an Interim temporary table.

See  Requirements for Upgrading Databases That Use Oracle Label Security and Oracle Database Vault for complete information


########################################################################################################
############# Drop Oracle 12c  Release 1 supplied users and roles ,if exist in the source database #########
Note :- Its not required in our case as we are upgrading from 12.1.0.1
########################################################################################################
%%%%%%%%%%%%%%% this is not needed %%%%%%%%%%%%%%%%%%%%%%%%%%%

There are new Oracle users and roles in Oracle 12.1.  If there exist in the source database users or roles with the same names, then they must be dropped before upgrading the database.

Run the preupgrade tool to check for the existence of any users or roles in the source database that use the same names.

Note: If there is a pre-existing user in the database with same name as the 12.1 oracle-supplied users or roles, then move the data of that user to a different schema before dropping the pre-existing user.

Make sure to drop these pre-existing users and/or roles before doing the upgrade.  Else, the upgrade will terminate will with "ORA-01722: invalid number"  error.

########################################################################################################
################## Review and Remove any unnecessary hidden/underscore parameters ######################
########################################################################################################

Please review and remove any unnecessary hidden/underscore parameters prior to upgrading. It is strongly recommended that these be removed before upgrade

unless your application vendors and/or Oracle Support state differently.Changes will need to be made in the init.ora or spfile.
To view existing hidden parameters execute the following command while connected AS SYSDBA:


SQL> SELECT name, value from SYS.V$PARAMETER WHERE name LIKE '\_%' ESCAPE '\' order by name;


########################################################################################################
################## Check the XDB ACLs has start_date and end_date ACE attributes ######################
########################################################################################################

Before upgrading the database to 12c, please run the below query as SYS:

SQL> select aclid, start_date, end_date from xds_ace where start_date is not null; 

If the query returns any row, then please follow Note 1958876.1 Upgrade to 12.1 fails with ORA-01830 date format picture ends before converting entire input string ORA-06512: at "SYS.XS_OBJECT_MIGRATION"  to avoid failure in XDB's upgrade.

########################################################################################################
###### Check the Mitigation patch has been applied on the source Oracle home ######################
NOTE : This step is ONLY applicable if you have applied  Mitigation Patch  on the source database
########################################################################################################
%%%%%%%%%%%%%%% this is not needed %%%%%%%%%%%%%%%%%%%%%%%%%%%
Check the Mitigation patch has been applied on the source Oracle home ,it disables the Java development in the Database which cause error during upgrade

NOTE : This step is ONLY applicable if you have applied  Mitigation Patch  on the source database

Please "enable" the Java development in source database .
Connect to the database as a SYSDBA user
  SQL> exec dbms_java_dev.enable;

And then upgrade the database.

Please refer Note 1985725.1 Database Upgrade failed with Errors “ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated” & “ORA-04045: SYS.DBMS_ISCHED”

########################################################################################################
################################## Shutdown the DB,Listener n OEM ################################################
########################################################################################################

Stop Listener
shutdown immediate
stop oracle agent if running OEM
exit

################################## Unset Variables ################################################
########################################################################################################

-Undefine all the defined oracle parameters.
In my case i undefined the below parameters:
unset ORACLE_BASE
unset ORACLE_SID
unset ORA_NLS10
unset TNS_ADMIN
unset ORACLE_HOME
unset ORA_CRS_HOME
unset CRS_HOME

########################################################################################################
################################## Export New Oracle Home ################################################
########################################################################################################

— Make sure oracle_home is new home

echo $ORACLE_BASE
echo $ORACLE_SID
echo $ORA_NLS10
echo $TNS_ADMIN
echo $ORACLE_HOME
echo $ORA_CRS_HOME
echo $CRS_HOME


–START USING NEW ORACLE HOME
export ORACLE_HOME=/u01/app/oracle/11.2.0.4
in bash_profile set it to new oracle home. logout and log back in again

orapwd file=orapw$SID password=oracle entries=40

vi /etc/oratab
/u01/app/oracle/11.2.0.4

vi /u01/app/oracle/admin/${ORACLE_SID}/pfile/upgrade_11.2.0.4.pfile

sqlplus "sys/nopass as sysdba"
create spfile from pfile = ‘/u01/app/oracle/admin/${ORACLE_SID}/pfile/upgrade_11.2.0.4.pfile';

–Make sure there is enough archive log space


########################################################################################################
##################### Startup Upgrade n Cat Upgrade(Upgrading Database to 12cR1) ########################
########################################################################################################
instead $ORACLE_HOME user full path


$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus "/ as sysdba"
SQL> startup UPGRADE
SQL> exit

–THIS IS THE UPGRADE
–Takes about 30 minutes to run
show parameter cluster

$ORACLE_HOME/perl/bin/perl /oracle_home12c/db/orahome12c/rdbms/admin/catctl.pl -n  6 -l /oracle_home12c/db/orahome12c/rdbms/admin catupgrd.sql

$ORACLE_HOME/rdbms/admin/perl catctl.pl -n  6 -l $ORACLE_HOME/rdbms/admin catupgrd.sql
/oracle_home12c/db/orahome12c/rdbms/admin

–UPGRADE FOR THE MOST PART COMPLETE

————Wait for Script to Complete————

########################################################################################################
################################## Run the SQL's in Ordered ################################################
########################################################################################################

un the Post-Upgrade Status Tool $ORACLE_HOME/rdbms/admin/utlu121s.sql which provides a summary of the upgrade at the end of the spool log.
It displays the status of the database components in the upgraded database and the time required to complete each component upgrade.
Any errors that occur during the upgrade are listed with each component and must be addressed.


— This order
$ sqlplus "/as sysdba"
SQL> STARTUP
SQL> @utlu121s.sql

Important: The catuppst.sql script is run as part of the upgrade process unless the upgrade returns errors during the process. Check the log file for "BEGIN catuppst.sql" to verify that catuppst.sql ran during the upgrade process. If catuppst.sql has not run, then proceed to run catuppst.sql as shown in this step. Warning messages are also displayed when running catctl.pl indicating that catuppst.sql was not run during the upgrade.

Run catuppst.sql, located in the $ORACLE_HOME/rdbms/admin directory, to perform upgrade actions that do not require the database to be in UPGRADE mode.
SQL> @catuppst.sql

This script can be run concurrently with utlrp.sql.
Run utlrp.sql to recompile any remaining stored PL/SQL and Java code in another session.
SQL> @utlrp.sql

########################################################################################################
################### Identify Invalid Objects With the utluiobj Script #############################
########################################################################################################


Before the upgrade ,the list of invalid SYS/SYSTEM objects is written to registry$sys_inv_objs and non-SYS/SYSTEM objects was written to registry$nonsys_inv_objs by the Pre-Upgrade Information Tool

After the upgrade, run utluiobj.sql from $ORACLE_HOME/rdbms/admin/ to identify/compare any new invalid objects due to the upgrade.

@?/rdbms/admin/utluiobj.sql

########################################################################################################
################################## IN Case of PSU Patch ################################################
########################################################################################################


@?/rdbms/admin/catbundle.sql psu apply


########################################################################################################
################################## Startup All the Nodes ################################################
########################################################################################################

sqlplus "sys/nopass as sysdba"
create spfile from pfile = ‘/u01/app/oracle/admin/${ORACLE_SID}/pfile/upgrade_11.2.0.4.pfile';
startup




########################################################################################################
#### See the InValid Objects #########################################################################

select object_name from dba_objects where status != 'VALID';

## Gather the Stats #########################################################################################

EXEC DBMS_STATS.GATHER_SCHEMA_STATS (‘SYS’);
EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

##### Upgrade the Catalog (Optional)
rman catalog username/password@rman_db
upgrade catalog;

Updated Metalink Notes

Updated Metalink Notes

Updated Metalink Note:

NOTE.74660.1 : Resolving Invalid Objects in Oracle Applications
NOTE.338879.1 : Landscape1309 - Linux Landscape Quick Reference
NOTE.341782.1 : Linux Quick Reference
NOTE.312572.1 : About Oracle Applications Technology Updates for Release 11.
NOTE.316806.1 : Oracle Applications Installation Update Notes, Release 11i
NOTE.370274.1 : New Features in Oracle Application 11i
NOTE.275734.1 : India Localization
NOTE.47837.1 : Applications Utilities FAQ
NOTE.189487.1 : System Administration FAQ's
NOTE.289786.1 : Installing Oracle Applications: A Guide to Using Rapid
NOTE.245079.1 : Steps to clone a 11i RAC environment to a non-RAC
NOTE.243693.1 : Rapid Clone Coredumps when Running Adcfgclone.pl
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.331746.1 : Oracle Accelerator FAQ for Global Product Support (Internal
NOTE.144751.1 : Applications Patching - Time Saving Techniques
NOTE.232833.1 : Oracle Applications Release Notes, Release 11i (11.5.9)
NOTE.110372.1 : 11i: How to Clean up the UNIX Environment After Install
NOTE.156219.1 : Net8i/9i Basic configuration of LISTENER.ORA and TNSNAMES.
NOTE.69725.1 : Configuring TNSNAMES.ORA, SQLNET.ORA,and LISTENER.ORA in
NOTE.356878.1 : How to relink the whole Applications 11i Installation
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.130686.1 : How to Generate Form, Library and Menu for Oracle
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.139949.1 : NEED TO CLEAR APACHE, BROWSER OR JINITIATOR CACHE FOR
NOTE.133972.1 : How to Reset the APPS and APPLSYS Passwords in Release 11.5
NOTE.216980.1 : FNDLOAD Fails with PLS-306 in call to LOAD_ROW
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.222663.1 : Internationalization Update Notes for the Oracle E-Business Suite 11i
NOTE.372952.1 : Customer Translations
NOTE.168330.1 : Reload Applications Related Java Objects
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
NOTE.233436.1 : Installing Oracle Application Server 10g with Oracle E-
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.238276.1 : Migrating to Linux with Oracle Applications Release 11i
NOTE.242480.1 : Using a Staged Applications 11i System to Reduce Patching
NOTE.1076329.6 : SQL*Plus Errors - SP1.MSB Not Found
NOTE.248857.1 : Oracle Applications Tablespace Model Release 11i -
NOTE.269293.1 : Oracle Applications Tablespace Model FAQs
NOTE.258330.1 : About Oracle Applications Manager Minipack 11i.OAM.H
NOTE.268837.1 : Gathering Debug Weboam Log
NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i
NOTE.112577.1 : How to customize reports at runtime using XML - simple
NOTE.144689.1 : How to Generate a Report (.rdf) File from the UNIX Command
NOTE.211424.1 : How to Enable a Large SGA(over 1.7GB) on RedHat Advanced
NOTE.345145.1 : Is There A Way To Automate The Prompts For Adcfgclone.Pl?
NOTE.1812.1 : TECH : Getting a Stack Trace from a CORE file
NOTE.144599.1 : How to Generate a .pll Library File for Applications 11i
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g
NOTE.208375.1 : How To Convert A Single Instance Database To RAC In A
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC
NOTE.1067473.6 : Custom Forms do not Show up in FNDSCMON Form
NOTE.232834.1 : Oracle Applications Release 11.5.9 Maintenance Pack
NOTE.216550.1 : Oracle Applications Release 11i with Oracle9i Release 2 (9.
NOTE.362203.1 : Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
NOTE.233038.1 : AD Command Line Options
NOTE.186125.1 : Applications 11i and Standby Databases
NOTE.260887.1 : Steps to Clean Nonexistent Nodes or IP Addresses from
NOTE.342459.1 : Diagnostics Overview
NOTE.394615.1 : Adaddnode.Pl failed with : ORA-00001 : unique constraint
NOTE.338003.1 : How to change the hostname and/or port of the Database Tier
NOTE.341322.1 : How to change the hostname of an Applications Tier using AutoConfig
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.211708.1 : Detailed Explanations of How NLS/MLS is Being Handled in 11i
NOTE.73352.1 : NLS/MLS Frequently Asked Questions
NOTE.72324.1 : Guidelines on Resolving NLS/MLS issues
NOTE.316365.1 : Oracle Applications Release 11.5.10.2 Maintenance Pack
NOTE.230627.1 : 9i Export/Import Process for Oracle Applications Release 11i
NOTE.331221.1 : 10g Export/Import Process for Oracle Applications Release 11i
NOTE.362205.1 : 10g Release 2 Export/Import Process for Oracle Applications Release 11i
NOTE.259552.1 : 11.5.9 Category 3 Preupgrade Instructions for 9.2.0.4
NOTE.341281.1 : How to disable the language selection option available in AppsLocalLogin.jsp
NOTE.389472.1 : OATM Migration fails with ORA-22853 for LOB objects
NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.124721.1 : Migrating an Applications Installation to a New Character
NOTE.66320.1 : Changing the Database Character Set or the Database
NOTE.119164.1 : Changing Database Character Set - Valid Superset Definitions
NOTE.123670.1 : Use Scanner Utility before Altering the Database Character
NOTE.213015.1 : SYS.METASTYLESHEET marked as having convertible data (ORA-
NOTE.258895.1 : SYS.RULE$ marked as having convertible data (ORA-12716 when
NOTE.258902.1 : SYS.JOB$ marked as having convertible data
NOTE.43208.1 : Certified Compilers
NOTE.270806.1 : 11.5.9 : Invalid Objects - IES Java Classes
NOTE.165114.1 : Resolving Invalid Java Classes in Oracle Applications
NOTE.343253.1 : Tns-12555, Tns-12560, Tns-00525, Linux Error : 1 Starting
NOTE.150168.1 : Obtaining Forms Runtime Diagnostics (FRD) In Oracle
NOTE.210193.1 : Use of Multiple Organizations In Oracle Applications
NOTE.165035.1 : Current Issues - Multiple Organizations Architecture
NOTE.208267.1 : Improved Convert to Multi-Org Process In Oracle
NOTE.226456.1 : Multiple Organizations in Oracle Applications R11i, March
NOTE.259546.1 : Setting Up Multiple Organizations in Oracle HRMS
NOTE.131081.1 : How can I find which version of Portal I am running ?
NOTE.262125.1 : Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt,
NOTE.216205.1 : Database Initialization Parameters for Oracle Applications
NOTE.213015.1 : SYS.METASTYLESHEET marked as having convertible data (ORA-
NOTE.283225.1 : How to Recreate the Listener for Event and Listener for
NOTE.153960.1 : FAQ : X Server testing and troubleshooting
NOTE.146468.1 : Installing and Upgrading Oracle9i Application Server with
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.351283.1 : Interoperability Notes : Oracle Applications Release 11i
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.317226.1 : Concurrent Managers Do Not Start With GSM Profile Option
NOTE.311015.1 : Adgendbc.sh Errors Running AutoConfig
NOTE.337937.1 : Step By Step - 10gR2 RAC with ASM install on Linux(x86) -
NOTE.266043.1 : Support of Linux and Oracle Products on Linux
NOTE.224302.1 : Raw Devices on Linux
NOTE.134395.1 : Cannot Connect to Personal Home Page : Your Session is no
NOTE.351646.1 : Configuring Oracle E-Business Suite Release 11i with 10g
NOTE.230688.1 : Basic ApacheJServ Troubleshooting with IsItWorking.class
NOTE.70276.1 : HOW TO INTEGRATE APPLICATIONS RELEASE 11 WITH CUSTOM
NOTE.273449.1 : Diagnosing Login Problems with Apps 11.5.9 (FND.G)
NOTE.139863.1 : Configuring and Troubleshooting the Self Service Framework
NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.252422.1 : Requesting Translation Synchronization Patches
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
NOTE.68713.1 : Troubleshooting Self-Service Web Applications Login
NOTE.304489.1 : Using Oracle Applications with a Split Configuration
NOTE.225074.1 : 11i AOL : Cannot login to PHP after DB upgrade to 9.2.0.2
NOTE.358140.1 : Troubleshooting Unix coredumps and obtaining stack traces
NOTE.1007808.6 : HOW TO HANDLE CORE DUMPS ON UNIX
NOTE.1812.1 :
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.197031.1 : 32-bit/64-bit Certification/Conversion Issues on Oracle
NOTE.300172.1 : Obsolescence of KOREAN_LEXER Lexer Type
NOTE.225456.1 : Troubleshooting Guide for Cloning Issues
NOTE.161474.1 : Oracle Applications Remote Diagnostics Agent (APPS_RDA)
NOTE.111383.1 : The Basics About Report Review Agent (FNDFS) on 11i
NOTE.210062.1 : Generic Service Management (GSM) in Oracle Applications 11i
NOTE.316447.1 : About Oracle XML Publisher Release 5.5
NOTE.295036.1 : About XML Publisher Release 5.0
NOTE.130091.1 : Upgrading Oracle Applications 11i to use JDK 1.3
NOTE.292424.1 : Cleaning your Windows System After a Failed Oracle
NOTE.124606.1 : Upgrading JInitiator with Oracle Applications 11i
NOTE.316806.1 : Oracle Applications Installation Update Notes, Release 11i
NOTE.177183.1 : Succesfully Installing NLS/MLS in 11i
NOTE.134007.1 : CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables
NOTE.1010501.7 : FAQ : Licensing and de-licensing a product, country-specific
NOTE.217368.1 : Advanced Configurations and Topologies for Enterprise
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
NOTE.302738.1 : Using Virtual Hostnames with Oracle Applications Release 11i
NOTE.403311.1 : United States Time Zone Changes 2007 : E-Business Suite
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.232313.1 : Information on Previous Versions of Developer 6i Patchsets
NOTE.240862.1 : Install Oracle Unicode Fonts for Dynamic Image Generation
NOTE.60966.1 : Getting Rid Of Those Pesky Invalid Objects In Oracle
NOTE.400830.1 : How to Render Non ASCII Characters in Personalized
NOTE.285218.1 : Recommended Browsers for Oracle Applications 11i
NOTE.403311.1 : United States & Canada 2007 Daylight Saving Time (DST)
NOTE.289788.1 : Upgrading Oracle Applications
NOTE.316804.1 : Oracle Applications NLS Release Notes, Release 11i (11.5.10.
NOTE.189867.1 : Troubleshooting FRM-92050, FRM-92100, FRM-92101, FRM-92102
NOTE.253763.1 : After Cloning on Target instance FRM-92050 Failed to
NOTE.274783.1 :

Amol's Bookmark
*********************************************************************
NOTE.167000.1 : eBusiness Suite Support - Oracle Diagnostics Support Pack
NOTE.235307.1 : OSS Application Diagnostics Tools : FAQ and Troubleshooting
NOTE.231142.1 : About Oracle Diagnostics version 2.1
NOTE.262006.1 : About Oracle Diagnostics 2.2
NOTE.300976.1 : Support Diagnostics Newsletter for Applications Core
NOTE.357223.1 : "This test can be executed only after logging into
NOTE.363759.1 : How To Add Diagnostic Tools To Responsibility Menu

Installation
*********

NOTE.215868.1 : 11i Release Notes
NOTE.77219.1 : Applications Release 11.0.3 One-Hour Install for Unix
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.292424.1 : Cleaning your Windows System After a Failed Oracle
NOTE.110372.1 : 11i : How to Clean up the UNIX Environment After Install
NOTE.169402.1 : How To Cleanup After A Failed Applications Installation On
NOTE.48602.1 : How do I determine which products are fully installed, and
NOTE.124353.1 : WIN : Manually Removing all Oracle Components on Microsoft
NOTE.275493.1 : Removing 10g Database and Software from AIX, HP-UX, Linux,
NOTE.279519.1 : How to completely remove 8i / 9i Database and Software from
NOTE.232831.1. : Oracle Applications NLS Release Notes 11.5.9 - B10846-01
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.187240.1 : Applications AOL Scenarios : Is It Supported ?
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.316806.1 : Oracle Applications Installation Update Notes, Rel 11.5.10.2
NOTE.360079.1 : Global and Local Inventory explained
NOTE.295185.1 : How to Recreate the Global oraInventory
NOTE.197028.1 : Software Requirements and Tools for Oracle Applications
NOTE.201392.1 : Visual C++ Requirement for Release 11i on Windows
NOTE.268776.1 : GNU Make Requirement for Release 11i For Windows
NOTE.181244.1 : Configuring VNC Or XVFB As The X Server For Applications 11i
NOTE.153960.1 : FAQ : X Server testing and troubleshooting

Patching
*******

NOTE.174436.1 : Oracle Applications Patching FAQ
NOTE.175485.1 : How to Apply an 11i Patch When adpatch is Already Running
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.252422.1 : Requesting Translation Synchronization Patches in Release
NOTE.316366.1 : 11.5.10 Oracle E-Business Suite Consolidated Update 2 (CU2)
NOTE.259484.1 : Release 11.5.10 Maintenance Pack Installation Instructions
NOTE.316365.1 : Oracle Applications Release 11.5.10.2 Maintenance Pack
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.181665.1 : Release 11i Adpatch Basics
NOTE.358247.1 : ORA-00001 : unique constraint violated error while applying
NOTE.358417.1 : Unable to Start Concurrent Managers After Applying 11i.
NOTE.353414.1 : Application Technology Group (ATG) Patching Policy
NOTE.359198.1 : XDF files fail to load on HP-UX, Memory Fault(Coredump)
NOTE.232834.1 : Oracle Applications Release 11.5.9 Maintenance Pack
NOTE.337274.1 : About Oracle Applications Technology 11i.ATG_PF.H Rollup 3
NOTE.244040.1 : Oracle E-Business Suite Recommended Performance Patches
NOTE.367756.1 : Uploading Java Objects To Patch History Tables Fails While
NOTE.76708.1 : Using ADSPLICE To Add Products To The APPL_TOP In

Cloning
******

NOTE.230672.1 : Cloning Oracle Applications Release 11i with Rapid Clone
NOTE.216664.1 : FAQ : Cloning Oracle Applications Release 11i
NOTE.242123.1 : Create new middle tier node in existing Apps 11i
NOTE.238276.1 : Migrating to Linux with Oracle Applications Release 11i
NOTE.364565.1 : Troubleshoot RapidClone or OAM Clone issues

Upgrade
*******

NOTE.200963.1 : R11.5.3/R11.5.4/R11.5.5 Upgrade And Install Issues
NOTE.289765.1 : Oracle Applications Release 11i (11.5.10) Upgrade Assistant
NOTE.289788.1 : Upgrading Oracle Applications

Autoconfig
**********

NOTE.165195.1 : Using AutoConfig to Manage System Configurations with
NOTE.218089.1 : Autoconfig FAQ
NOTE.270519.1 : Customizing an AutoConfig Environment
NOTE.260887.1 : Steps to Clean Nonexistent Nodes or IP Addresses from
NOTE.341322.1 : How to change the hostname of an Applications Tier using
NOTE.338003.1 : How to change the hostname and/or port of the Database Tier
NOTE.108865.1 : How To Create a Database Connection(DBC) File and

AD Utilities
**********

NOTE.233038.1 : AD Command Line Options

Relinking
********

NOTE.69798.1 : Basics of Relinking an Executable or Binary in an Oracle
NOTE.1009722.6 : How to relink Oracle Concurrent Program Executables on Unix

OAM
****

NOTE.210062.1 : Generic Service Management (GSM) in Oracle Applications 11i
NOTE.117264.1 : FAQ (Oracle Applications Manager)
NOTE.177089.1 : OAM11i Standalone Mode Setup and Configuration
NOTE.214962.1 : How To Determine The Version Of OAM (Oracle Application
NOTE.258330.1 : About Oracle Applications Manager Minipack 11i.OAM.H
NOTE.166115.1 : Oracle Applications Manager 11i integrated with Oracle
NOTE.185431.1 : Troubleshooting Oracle Applications Manager OAM 2.0 for 11i
NOTE.73959.1 : Installation and Configuration of Oracle Application Manager
NOTE.225024.1 : Oracle Applications Manager 11i Documentation Roadmap
NOTE.338317.1 : Basic Information on Cloning An 11.5.10 System Using OAM

NLS/MLS
*******

NOTE.15389.1 : NLS DEBUGGING SUCCESS GUIDE ** INTERNAL ONLY **
NOTE.227332.1 : NLS considerations in Import/Export - Frequently Asked
NOTE.15095.1 : Export/Import and NLS Considerations
NOTE.175300.1 : A Guide to Debugging Globalization (NLS) Support Issues
NOTE.124721.1 : Migrating an Applications Installation to a New Character

Forms
*****

NOTE.130686.1 : How to Generate Form, Library and Menu for Oracle
NOTE.177610.1 : Oracle Forms in Applications FAQ
NOTE.141012.1 : How to Manually Generate an 11.5 Form on Unix

Apps Database
*************

NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.186125.1 : Applications 11i and Standby Databases
NOTE.248857.1 : Oracle Applications Tablespace Model Release 11i -
NOTE.216205.1 : Database Initialization Parameters for Oracle Applications
NOTE.285267.1 : Oracle E-Business Suite 11i and Database FAQ
NOTE.230627.1 : 9i Export/Import Process for Oracle Applications Release 11i
NOTE.183078.1 : Recreating Applications 11i JAVA objects in the database
NOTE.216212.1 : Business Continuity for Oracle Applications Release 11i,
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g
NOTE.340859.1 : Upgrading Oracle Applications 11i Database to 10g with
NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.216211.1. : Nologging in the E-Business Suite
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g

RAC / Apps RAC
**************

NOTE.220970.1 : RAC : Frequently Asked Questions
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.270901.1 : How to Dynamically Add a New Node to an Existing 9.2.0 RAC
NOTE.294652.1 : E-Business Suite 11i on RAC : Configuring Database Load balancing & Failover
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :
NOTE.277825.1 : How to setup Tnsnames.ora (806) for 11i and RAC

Database
********

NOTE.1012933.6 : General Information : Alert Logs and Trace Files
NOTE.209870.1 : How to Reload the JVM in 9.2.0.X
NOTE.175472.1 : How to Reload the JVM in 8.1.7.X
NOTE.159143.1 : Separating Multiple 8i or 9i Oracle Versions to Avoid
NOTE.307349.1 : OUI tips for Oracle RDBMS 10.1.X on OpenVMS
NOTE.130814.1 : How to move LOB Data to Another Tablespace

System Administration
*******************

NOTE.189457.1 : Oracle Applications Systems Administration Setup and Usage
NOTE.290525.1 : Oracle User Management FAQ
NOTE.316277.1 : Unable To Change Guest User Password In Oracle Applications
NOTE.311552.1 : How to optimize the purge process in a high transaction
NOTE.154850.1 : How to Run the Purge Concurrent Request and/or Manager Data

Jserver
******

NOTE.295484.1 : Clear Server Cache and Bounce Apache (Web Server)
NOTE.220188.1 : Oracle Applications Release 11i apps.zip Re-architect
NOTE.230688.1 : Basic ApacheJServ Troubleshooting with IsItWorking.class

Invalid Objects
*************

NOTE.60558.1 : Troubleshooting the Source of Invalid Objects
NOTE.266910.1 : How To Resolve IES Invalid Java Classes After Loading JAR
NOTE.113947.1 : Step by Step Troubleshooting Guide to Solve APPS Invalid
UNIX / LINUX / WINDOWS
=======================
NOTE.1007808.6 : HOW TO HANDLE CORE DUMPS ON UNIX
NOTE.1812.1 : TECH : Getting a Stack Trace from a CORE file
NOTE.28588.1 : TECH : Using Truss / Trace on Unix
Advanced Configuration:
======================
NOTE.217368.1 : Advanced Configurations and Topologies for Enterprise
NOTE.226880.1 : Configuration of Load Balancing and Transparent Application
NOTE.97926.1 : Failover Issues and Limitations [Connect-time failover and
NOTE.123718.1 : 11i : A Guide to Understanding and Implementing SSL for
Techstack:
=========

NOTE.162488.1 : Complete Guide to JInitiator 1.1.8 Setup & Troubleshooting
NOTE.312572.1 : About Oracle Applications Technology Updates for Release 11.
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.94091.1 : Example : Identifying Connection String Problems in JDBC

Workflow:
========

NOTE.298550.1 : Troubleshooting Workflow Data Growth Issues

General:
=======

NOTE.184977.1 : Certify FAQ, Product Navigation & User's Guide
NOTE.224882.1 : Common Commands asked by Oracle Support for Troubleshooting
NOTE.110415.1 : Payables MRC Frequently Asked Questions
NOTE.285218.1 : Recommended Browsers for Oracle Applications 11i
NOTE.257650.1 : Resolving Problems with Connection Idle Timeout
NOTE.270523.1 : How To Find the Oracle Applications Framework and Rollup
NOTE.301504.1 : "Cannot Complete Applications Logon" Error After Selecting
NOTE.315094.1 : JTF Login Page - an operational assessment for CRM
NOTE.242490.1 : How To Configure The "/etc/hosts" File On Linux
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g Release 1
NOTE.342861.1 : Java Version Conflict When Migrating Platforms
NOTE.209999.1 : Oracle Applications Manager in Oracle Applications 11.5.8
NOTE.198160.1 : Summary note to LOB's/BLOB's/CLOB's/NCLOB's and BFILES
NOTE.159244.1 : How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS and Application Module Passwords (INV, AR, AP, etc.) For Applications 11.5 in Unix
NOTE.186981.1 : Oracle Application Server with Oracle E-Business Suite
NOTE.333436.1 : Oracle E-Business Suite 11i on Windows Server 2003 Service
NOTE.356878.1 : How to relink the whole Applications 11i Installation
NOTE.197031.1 : 32-bit/64-bit Certification/Conversion Issues on Oracle
NOTE.158577.1 : NLS_LANG Explained (How does Client-Server Character
NOTE.227331.1 : Setting NLS Parameters - Frequently Asked Questions
NOTE.124721.1 : Migrating an Applications Installation to a New Character
NOTE.43208.1 : Certified Compilers
NOTE.66320.1 : Changing the Database Character Set or the Database
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :
NOTE.260393.1 : Java Mailer and Other 11.5.9/OWF G Current Issues in
NOTE.232313.1 : Information on Previous Versions of Developer 6i Patchsets
NOTE.125767.1 : Upgrading Developer 6i with Oracle Applications 11i
NOTE.371438.1 : adpreclone.pl dbTier fails with RC-50409 : Topology
NOTE.135949.1 : Troubleshooting the Personal Home Page Login Problems in 11.
NOTE.164317.1 : Upgrading JDBC drivers with Oracle Applications 11i
NOTE.302035.1 : How to Test a JDBC Thin Driver Connection From the SSO
NOTE.365735.1 : How to use Digital Certificates for 11i Applications
NOTE.357922.1 : Autoconfig Reverts to old Context File Values.
NOTE.206511.1 : How to Find a JAR File Which Contains a Particular JAVA
NOTE.68839.1 : 8i Using loadjava and dropjava to Load and Unload Java
NOTE.165123.1 : JAVA CLASS - ORA-29534 : referenced object
NOTE.165114.1 : Resolving Invalid Java Classes in Oracle Applications
NOTE.271218.1 : Yellow bar's and Java security error , The daddy of all
NOTE.294932.1 : Recommendations to Install Oracle Applications 11i
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.342442.1 : Cloning Multi-Node to Single-Node Oracle Applications
NOTE.233428.1 :
NOTE.302738.1 : Using Virtual Hostnames with Oracle Applications Release 11i
NOTE.356433.1 : Using Oracle Applications Release 11i with Virtual
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC
NOTE.159270.1 : How To Use FNDCPASS to Change The Oracle Users, APPS,
NOTE.303237.1 : Migrating Red Hat Linux 2.1 or 3.0 to Red Hat Linux 4.0
NOTE.91985.1 :
NOTE.200963.1 : R11.5.3/R11.5.4/R11.5.5 Upgrade And Install Issues
NOTE.272789.1 : Post Clone Problem : Login/Portal Server Installation May
NOTE.339664.1 : Analyst Crib Sheet for NLS/MLS issues in Oracle
NOTE.211708.1 : Detailed Explanations of How NLS/MLS is Being Handled in 11i
NOTE.245079.1 : Steps to clone a 11i RAC environment to a non-RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.131321.1 : How to Relink Oracle Database Software on UNIX
NOTE.231876.1 : Windows OS Upgrade for 11i E-Business Suite
NOTE.184977.1 : Certify FAQ, Product Navigation & User's Guide
NOTE.209810.1 : How to Relink Oracle Applications 11i Programs After
NOTE.361428.1 : Using Linux Desktop Clients with Oracle Applications 11i
NOTE.296559.1 :
NOTE.275734.1 : India Localization
NOTE.364439.1 : Tips and Queries for Troubleshooting Advanced Topologies
NOTE.372928.1 : Oracle Critical Patch Update July 2006 Documentation Map
NOTE.372931.1 : E-Business Suite Critical Patch Update Note
NOTE.268837.1 : Gathering Debug Weboam Log
NOTE.292996.1 : How to Re-Install Intermedia on an 11i Environment
NOTE.160121.1 : Introduction to Sun Cluster v3
NOTE.188135.1 : Documentation Index for Real Application Clusters
NOTE.251351.1 : How to Change the Characterset in a Standby Database in 9i
NOTE.362203.1 : Oracle Applications Release 11i with Oracle 10g Release 2
NOTE.362205.1 : 10g Release 2 Export/Import Process for Oracle Applications
NOTE.1009718.6 : HOW TO SOLVE UNDEFINED SYMBOL ERRORS ON UNIX AND VMS
NOTE.316889.1 : Complete checklist for manual upgrades to 10gR2
NOTE.223721.1 : How to Install XVFB on Linux for dynamic image generartion
NOTE.130091.1 : Upgrading Oracle Applications 11i to use JDK 1.3
NOTE : 163400.1 : Release Content Documents and Features Summary Matrices
NOTE.253918.1 : Autopatch Fails with "Unable to call adppdepRunFndLoad
NOTE.166650.1 : Working Effectively With Oracle Support Services
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.119164.1 : Changing Database Character Set - Valid Superset Definitions
NOTE.17210.1 : Supported NLS Character Sets
NOTE.179133.1 : The correct NLS_LANG in a Windows Environment
NOTE.226565.1 : 9iRAC Useful Views and Statistics (INTERNAL ONLY)
NOTE.387046.1 : RCONFIG : Frequently Asked Questions
NOTE.200340.1 : RAC : Cache Fusion
NOTE.265253.1 : 10g Recyclebin Features And How To Disable it( _recyclebin )
NOTE.312594.1 : Get Warning Messages Trying To Generate Jar Files From
NOTE.242480.1 : Using a Staged Applications 11i System to Reduce Patching
NOTE.134007.1 : CMCLEAN.SQL - Non Destructive Script to Clean Concurrent
NOTE.365228.1 : About Oracle Applications Technology 11i.ATG_PF.H Rollup 4
NOTE.371016.1 : How To License A New Product.
NOTE.151654.1 : How To Start the License Manager After Installing Oracle
NOTE.279430.1 : How To Change Project Installation From Shared To Full
NOTE.123891.1 : How to deactivate a language in e-Business Suite
NOTE.216550.1 : Oracle Applications Release 11i with Oracle9i Release 2 (9.
NOTE.341437.1 : Business Continuity for Oracle Applications Release 11i
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.304748.1 : Internal : E-Business Suite 11i with Database FAQ
NOTE.308320.1 : How to install the 10.1.0 Enterprise Manager Grid Control
NOTE.291901.1 : Maintenance Mode - A New Feature in 11.5.10
NOTE.134527.1 : TNS-00516 Starting TNS Listener
NOTE.300482.1 : Overview of Using Java with Oracle E-Business Suite Release
NOTE.208256.1 : WIN : How to Remove a Single ORACLE_HOME and Its Traces on
NOTE.363827.1 : Rebaselined Oracle Applications Technology Components for
NOTE.373611.1 : How to move Concurrent Processing Server from one node to
NOTE.240818.1. : Concurrent Processing: Transaction Manager Setup and Configuration Requirement in an 11i RAC Environment
NOTE.69660.1 : Understanding Data Auditing in Oracle Application Tables
NOTE.60828.1 : Overview of Oracle Applications AuditTrails
NOTE.134949.1 : Release 11.0.3 and Oracle 8i Release 8.1.6 Interoperability
NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i
NOTE.189256.1 : UNIX : Script to Verify Installation Requirements for Oracle
NOTE.296559.1 : FAQ : Common Tracing Techniques within the Oracle
NOTE.177183.1 : Succesfully Installing NLS/MLS in 11i
NOTE.73352.1 : NLS/MLS Frequently Asked Questions
NOTE.399789.1 : NLS Frequently Asked Questions
NOTE.339664.1 : Analyst Crib Sheet for NLS/MLS issues in Oracle
NOTE.227331.1 : Setting NLS Parameters - Frequently Asked Questions
NOTE.110849.1 : Installing and Relinking Oracle Developer on UNIX Platforms
NOTE.76535.1 : Troubleshooting Issues Which Arise During the Application of Release 11 Patches
NOTE.316804.1 : Oracle Applications NLS Release Notes, Release 11i (11.5.10.
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
NOTE.310840.1 : AFPCAL Received Failure Code While Parsing or Running
NOTE.371434.1 : Using Openfiler iSCSI with an Oracle database
NOTE.233040.1 : When Oracle Applications Automatic Patch Prerequisite
NOTE.236469.1 : Using Distributed AD in Applications Release 11.5.
NOTE.233043.1 : 11.5.9 Oracle E-Business Suite Consolidated Update 2
NOTE.108185.1 : Oracle Applications Object Library SQL scripts
NOTE.201662.1 : How To Manually Relink on Windows NT or Windows 2000
NOTE.306906.1 : How to create missing DB objects from xdf files
NOTE.396708.1 : Guidelines to Determine whether a Bug or SR is a LinuxOS
NOTE.166762.1 : Oracle Applications Manager 11i Availability
NOTE.60966.1 : Getting Rid Of Those Pesky Invalid Objects In Oracle
NOTE.216589.1 : Step By Step Guide to Creating a Custom Application in
NOTE.105127.1 : FAQ (Customization)
NOTE.243880.1 : Shared APPL_TOP FAQ
NOTE.409045.1 : How to clone from Rac to Non-rac in Oracle Applications 11i.
NOTE.373611.1 : How to move Concurrent Processing Server from one node to
NOTE.342442.1 : Cloning Multi-Node to Single-Node Oracle Applications
NOTE.261428.1 : Setting up 11i E-Business suite using a hardware load
NOTE.224875.1 : Installation, Patching & Upgrade Frequently Asked Questions
NOTE.278816.1 : How to Setup Parallel Concurrent Processing using Shared
NOTE.286506.1 : Sharing Middle-tier Oracle Home in E-Business Suite 11i
NOTE.105133.1 : Concurrent Manager Questions and Answers Relating to
NOTE.69336.1 : Basic information about Concurrent Managers
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.345145.1 : Is There A Way To Automate The Prompts For Adcfgclone.Pl?
*********************************************************************
NOTE.416338.1 : How To Upgrade JDK / J2SE 1.4 Sub-Versions
NOTE.225165.1 : Patching Best Practices and Reducing Downtime
NOTE.368628.1 : Is The 'Personal Home Page' Mode Supported In Oracle 11i Applications?
NOTE.387859.1 : Using AutoConfig to Manage System Configurations in Oracle
NOTE.402306.1 : Oracle Applications Installation and Upgrade Notes Release
NOTE.160214.1 : How to change the oracle users, APPS, APPLSYS and
NOTE.159244.1 : How To Use FNDCPASS to Change The Oracle Users, APPS,
NOTE.335515.1 : Relink fails for Oracle 9.2.0.7.0 on LINUX x86 server on
NOTE.372800.1 : How to Implement an SSL CA Root Certificate in JInitiator
NOTE.402312.1 : Oracle Applications Installation and Upgrade Notes Release
NOTE.394692.1 : Oracle Applications Documentation Resources, Release 12
NOTE.603104.1 : Troubleshooting RapidClone issues with Oracle Applications R12
NOTE.384248.1 : Sharing The Application Tier File System in Oracle E-Business Suite Release 12
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC
NOTE.559518.1 : Cloning Oracle Applications Release 12 with Rapid Clone on RAC Enabled Systems
NOTE.393861.1 : Globalization Guide for Oracle Applications Release 12
NOTE.372800.1 : How to Implement an SSL CA Root Certificate in JInitiator
NOTE.184876.1 : Oracle Application Object Library Middle (Web) Tier Setup
NOTE.403385.1 : Duplicate Responsibilities Created On Sysadmin Login And
NOTE.380483.1 : Oracle E-Business Suite Release 12 Additional Configuration
NOTE.148903.1 : Interoperability Notes Oracle Applications Release 11i with
NOTE.364704.1 : A Guide to Configure, Maintain & Troubleshoot JDBC Buffers
NOTE.148902.1 : Interoperability Notes Oracle Applications Release 11.0
NOTE.337762.1 : How to Remove an Oracle Applications 11i node
NOTE.399362.1 : Oracle Applications Release 12 Upgrade Sizing and Best
NOTE.104457.1 : Invalid Objects In Oracle Applications FAQs
NOTE.132604.1 : Upgrading OJSP with Oracle Applications 11i
NOTE.215268.1 : Implementing and Using the JSP Precompiler
NOTE.316900.1 : ALERT : Oracle 10g Release 2 (10.2) Support Status and Alerts
NOTE.189908.1 : ALERT : Oracle9i Release 2 (9.2) Support Status and Alerts
NOTE.380490.1 : Oracle E-Business Suite R12 Configuration in a DMZ
NOTE.269291.1 : Oracle Applications Tablespace Migration Utility User
NOTE.206511.1 : How to Find a JAR File Which Contains a Particular JAVA
NOTE.406982.1 : Cloning Oracle Applications Release 12 with Rapid Clone
NOTE.262125.1 : Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt,
NOTE.419839.1 : How to enable Apache, OC4J and OPMN logging in Oracle
NOTE.422419.1 : How To Enable and Collect Debug for HTTP, OC4J and OPMN in
NOTE.15390.1 : How to Determine and Change DB_NAME or ORACLE_SID
NOTE.375682.1 : About Oracle Applications Technology ATG_PF.H Rollup 5
NOTE.135715.1. : Diagnostic Steps for Intermittent FRM-99999 & FRM-92100
NOTE.185489.1 : Setting Up Parallel Concurrent Processing On Unix Server
NOTE.431496.1 : Java In The Database For Oracle Applications : Introduction
NOTE.183408.1 : Raw Devices and Cluster Filesystems With Real Application
NOTE.277366.1 : Technology Validation Utility for Oracle Applications
NOTE.394448.1 : Getting Started with the Application Management Pack for
NOTE.412044.1 : Application Management Pack for Oracle E-Business Suite
NOTE.375113.1 : Oracle Diagnostics 2.4
NOTE.405425.1 : Oracle Diagnostics 2.5
NOTE.201340.1 : Using Forms Listener Servlet with Oracle Applications 11i
NOTE.160337.1 : How To Manually Change The APPS, APPLSYS and APPLSYSPUB
NOTE.372322.1 : HP Tru64 UNIX Migration Strategy for Oracle E-Business
NOTE.303709.1 : Reclaiming unused space in APPLSYSD tablespace
NOTE.130183.1 : How to Get Log Files from Various Programs for Oracle
NOTE.269129.1 : How to Implement Printing for Oracle Applications : Getting
NOTE.297522.1 : How to investigate printing issues and work towards its resolution ?
NOTE.215527.1 : Maintenance Wizard Overview
NOTE.452120.1 : How to locate the log files and troubleshoot RapidWiz for
NOTE.312640.1 : Oracle Text : Re-installation of Applications 11i (11.5.10)
**************
*** iSetup ***
**************
NOTE.402785.1 : iSetup dependency with Deinstall and Reinstall of XMLDB
NOTE.368670.1 : About Oracle iSetup Minipack 11i.AZ.H
NOTE.243554.1 : How to Deinstall and Reinstall XML Database (XDB)
NOTE.244523.1 : Security Alert #57 : Buffer Overflows in EXTPROC of Oracle
NOTE.433435.1 : Japanese characters are displayed like square boxes in
NOTE.455366.1 : Investigating NoClassDefFoundError in eBusiness 11i when
NOTE.197409.1 : Error Opening Oracle*Terminal File fmrweb.res
NOTE.312553.1 : How To Use the Original Forms for Reprint Instead of the
NOTE.438086.1 : Platform Migration with Oracle Applications Release 12
NOTE.458452.1 : Complying with Daylight Saving Time (DST) and Time Zone
NOTE.189367.1 : Best Practices for Securing the E-Business Suite
NOTE.300969.1 : Troubleshooting SSL with Oracle Applications 11i
NOTE.444524.1 : About Oracle Applications Technology ATG_PF.H Rollup 6
NOTE.265253.1 : 10g Recyclebin Features And How To Disable it( _recyclebin )
NOTE.428262.1 : How to identify the form name attached to an f60webmx
NOTE.68839.1 : 8i Using loadjava and dropjava to Load and Unload Java
NOTE.405521.1 : Oracle Enterprise Manager Grid Control Release Notes for
NOTE.187905.1 : bde_imt_index_status.sql - List all interMedia Text indexes
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC
NOTE.345106.1 : Login Links On New Rapid Install Homepage Do Not Function
NOTE.443521.1 : Enterprise Manager Grid Control Plug-in for Oracle Applications, Version 1.0/1.2
NOTE.398412.1 : Workflow Queues Creation Scripts
NOTE.77483.1 : External Support FTP site : Information Sheet
NOTE.122452.1 : Global Customer Services Policy Regarding Customizations
NOTE.257911.1 : How To Use Rotatelogs In 9iAS Release 1 (1.0.2.x)
NOTE.276845.1 : Apache Web Server Hangs Every Other Time Running Adapcctl.
NOTE.218893.1 : How to Create The Service Manager 'FNDSM' on Oracle
NOTE.437878.1 : Upgrading Forms and Reports 10g in Oracle Applications
NOTE.290807.1 : Upgrading Sun JRE with Oracle Applications 11i
NOTE.280167.1 : AS10g with Apps 11i - Summary of Login process
NOTE.357218.1 : Troubleshooting JDeveloper setup for Oracle Applications
NOTE.403339.1 : Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12 Upgrade
NOTE.463249.1 : After Clone Forms Is Trying To Connect To Target Instance
NOTE.386374.1 : How to enable/disable/change password of the listeners for Oracle Applications 11i
NOTE.454750.1 : Oracle Apps Release 12 with Oracle Database 10.2.0 interoperability notes
NOTE.428503.1 : Integrating Oracle E-Business Suite Release 11i with Oracle Database Vault 10.2.0.3
NOTE.443761.1 : How to check if a certain Patch was applied to Oracle Applications instance using 'adpatch'?
NOTE.291783.1 : Getting Started with the Oracle Grid Control Plug-in for Oracle Applications in Release 11i (AMP v1)
NOTE.468980.1 : How to Remove the Language Icons in the AppsLocalLogin.jsp
NOTE.398619.1 : Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)
NOTE.295606.1 : Oracle Application Server 10g with Oracle E-Business Suite Release 11i Troubleshooting
NOTE.169706.1 : Oracle® Database on AIX®,HP-UX®,Linux®,Mac OS® X,
Solaris®,Tru64 Unix® Operating Systems Installation and
Configuration Requirements Quick Reference (8.0.5 to 11.1)
NOTE.109665.1 : Organization Setup Frequently Asked Questions - FAQ
NOTE.434395.1 : ATG Service Request Creation
NOTE.438086.1 : Platform Migration with Oracle Applications Release 12
NOTE.469213.1 : How To Encrypt The Apps Password In Wdbsvr.App
NOTE.293369.1 : OPatch documentation list
NOTE.275379.1 : Script To Check What Workflow Related Patches Are Installed
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC
NOTE.264157.1 : The correct NLS_LANG setting in Unix Environments
NOTE.91985.1 : Step by Step on Cloning the ORACLE_HOME (Including DB) and
NOTE.74838.1 : Migrating Apps Release 11.0 from UNIX Host To A Second
NOTE.396009.1 : Database Initialization Parameters for Oracle Applications Release 12
NOTE.391406.1 : How to get a clean Autoconfig Environment
NOTE.560719.1 : How to troubleshoot iSetup issues
NOTE.406376.1 : Oracle E-Business Tax Release 12 Known Issues
NOTE.577713.1 : On Windows, After 10g Upgrade, Running Autoconfig on Apps
NOTE.343917.1 : Frequently Asked Questions : Oracle E-Business Suite Support
NOTE.553831.1 : java.lang.ArrayIndexOutOfBoundsException Error when
NOTE.119319.1 : How to Replace Oracle Logo with Company Logo on Applications 11i Sign-On Screen
NOTE.554336.1 : How Do You Manually Generate A Form In Release 12 (frmcmp)
NOTE.444286.1 : How to manually generate a R12 report on Unix
NOTE.356433.1 : Using Oracle Applications Release 11i with Virtual Hostnames and Business Continuity
NOTE.555081.1 : Concurrent Manager Does Not Start if the Profile Option "Concurrent : GSM Enabled" is Set "Y" at Site Level
NOTE.149124.1 : Creating a StatsPack performance report
NOTE.471566.1 : Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit
NOTE.397757.1 : How to Speed Up Index Creation on FND_LOBS by indexing Only FND_HELP Data
NOTE.375127.1 : How to restart the adworker having status fixed,restart,wait
NOTE.353150.1 : OPatch Failing Validation Phase When Archiving Really Did Not Fail
NOTE.215527.1 : Maintenance Wizard Overview
NOTE.564465.1 : Sysadmin And User Responsibility Not Available
NOTE.219968.1 : SQL*Net, Net8, Oracle Net Services - Tracing and Logging at a Glance
NOTE.417122.1 : Resolving the Library Cache Locks
NOTE.419475.1 : Removing Credentials from a Cloned EBS Production Database

Metalink Important Note IDs

1. How to run OATM migration utility ---- Note:404954.1

2. 11.5.10 Oracle E-Business Suite Consolidated Update 2 (CU2)---- Note:316366.1

3. Upgrading Oracle Applications ---- Note:289788.1

4. E-Business Suite Diagnostics Patch Installation Guide ---- Note:167000.1

5. Step by Step Troubleshooting Guide to Solve APPS Invalid Objects ---- Note:113947.1

6. Compatibility Matrix for Export And Import Between Different Oracle Versions ----Note:132904.1

7. ORA-06550 Running Sys.Utl_recomp.Recomp_parallel(1) During ADPATCH or ADADMIN Session ---- Note:362727.1

8. Now Available: Oracle E-Business Suite Release 12.0.4 ---- Note:556312.1

9. Cloning Oracle Applications Release 11i with Rapid Clone ---- Note:230672.1

10.Upgrading Developer 6i with Oracle Applications 11i ---- Note:125767.1

11.The Basics About Report Review Agent (FNDFS) on 11i ---- Note:111383.1

12.How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS and Application Module Passwords (INV, AR, AP, etc.) For Applications 11.5 in Unix ---- Note:159244.1

13.USAGE OF INDIA LOCALIZATION PATCH TOOL (INDPATCH) ---- Note:376756.1

14.Sharing the Application Tier File System in Oracle Applications 11i ----Note:233428.1

15.Shared APPL_TOP FAQ ---- Note:243880.1

16.Using a Staged Applications 11i System to Reduce Patching Downtime ---- Note:242480.1

17.Summary of Possible Reasons and Solutions for the Problem Where All Concurrent Requests Stuck in Pending Phase ---- Note:182154.1

18.Release 11i Adpatch Basics ---- Note:181665.1

19.How to Apply an 11i Patch When adpatch is Already Running ---- Note:175485.1

20.How to Create a Custom Concurrent Manager ---- Note:170524.1

21.Concurrent Manager Questions and Answers Relating to Generic Platform ----Note:105133.1

22.E-Business Suite Diagnostics Patch Installation Guide ---- Note:167000.1