Monday, June 11, 2012

CONTENT
OEM GRID CONTROL 11GR1 INSTALLATION ON REDHAT LINUX 5.5 (64-BIT) 3
FILE PARTITIONS 3
MIDDLEWARE ORACLE WEBLOGIC SERVER 11GR1 (10.3.2) INSTALLATION 3
ORACLE DATABASE 11G R2 FOR LINUX 64-BIT INSTALLATION 12
DROP THE OEM REPOSITORY 26
DATABASE PARAMETER CHANGE 27
APPLY LATEST VERSION OPATCH - 27
JAVA SE DEVELOPMENT KIT 6U18 29
ENTERPRISE MANAGER GRID CONTROL 11G INSTALLATION 29

OEM GRID CONTROL 11GR1 INSTALLATION ON REDHAT LINUX 5.5 (64-BIT)
During this installation I will use a HP with 2G RAM and 114G disk space. The swap size was set at 5G and the firewall and SELinux were disabled.

File partitions

• /u01 34G Oracle executables
• /u02 39G Oracle datafiles
• /u03 41G Archives logs


Start the X windows server in my case here Xming server

applprod@gvaoragrid:~ $ export DISPLAY=10.41.10.18:0.0
Middleware Oracle WebLogic Server 11gR1 (10.3.2) Installation
Grid Control 11g Release 1 no longer bundles the middleware components, so we must install the WebLogic Server before we can proceed with the Grid Control installation. The installation is started with the following command, run as the "applprod" user.
gvaoragrid(gshelton):/u03/GRID/Software/GRID2011/Weblogic
$ java -jar wls1032_generic.jar
Click the "Next" button on the welcome screen.

Enter "/u01/GRID/apps/product/Middleware" as the "Middleware Home Directory" and click the "Next" button.

Enter your Oracle Support details, or uncheck the checkbox and click the "Next" button.

If a warning dialog appears, click the "Yes" button, followed by the "Next" button from the previous screen.

Accept the "Typical" installation by clicking the "Next" button.

Accept the default JDK by clicking the "Next" button.

Accept the default "Product Installation Directories" by clicking the "Next" button.

Click the "Next" button on the summary "Installation Summary" screen.

Wait while the installation takes place.


Uncheck the "Run Quickstart" checkbox and click the "Done" button.



Next we must apply the "WDJ7" patch to the installation by running the Smart Update utility.
$applprod@gvaoragrid:/u01/GRID/apps/product/Middleware/utils/bsu $ ./bsu.sh
/u01/app/oracle/Middleware/utils/bsu/bsu.sh
Update the patch client by clicking the "OK" button on the message dialog.



Enter your support crednetials, then click the "Login" button.



These are the Metalink credentilas for downloading the updates



If you have chosen not to be updated with security information you may have to cycle through the warning message several times, but it will eventually continue. On Smart Update screen, click the "Get Patches" tab, select the "WDJ7" patch and click the "Download Selected" button and the "OK" button on the subsequent dialog.



Accept the default options and click okay


Click on the "Manage Patches" tab and click on the "Apply" button next to the "WDJ7" patch. Click "OK" on the subsequent validation dialog.






The patches are now listed under the "Default" tab.



Exit the Smart Update dialog, and the subsequent available maintenance screen if it appears.


Oracle Database 11g R2 for Linux 64-bit Installation
Unlike previous Grid Control installations, the database is no longer bundled, so we must install the database software separately. To accomplish this I followed the Oracle Database 11g Release 2 installation instructions here.

In addition to the packages listed in the DB installation, the following packages must be installed as the "root" user for WebLogic and the Grid Control to install correctly.
# From Enterprise Linux 5 DVD
cd /media/cdrom/Server
rpm -Uvh compat-db-4*
rpm -Uvh compat-libstdc++-296*
rpm -Uvh rng-utils-2*
rpm -Uvh setarch-2*
cd /
eject
applprod@gvaoragrid:/u03/GRID/Software/GRID2011/Oracle_Database_11gR2_for_Linux_x86-64/database $ ./runInstaller

Confiture the Metalink credentials



Choose the option for fresh install of the database



Choose server class


Single instance installation



I choose the advanced install to have all options













Choose the oracle Inventory directory here I put it in the Oracle Owner’s home
/home/applprod/


















If you choose a simple password you might encounter

[ins-30011] The password entered does not conform to the Oracle recommended standards.
Are you sure you want to continue choose Yes as you can harden the passwords later



All the operating systems Oracle recommended rpm’s were validated except the userid so I checked ignore


The install summary looks fine, you can create a response file for later silent install by clicking the save response file button







Creating the datafile and the creating the objects







root@gvaoragrid:/home/applprod/oraInventory # ls
root@gvaoragrid:/home/applprod/oraInventory # ./orainstRoot.sh
Changing permissions of /home/applprod/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /home/applprod/oraInventory to dba.
The execution of the script is complete.
root@gvaoragrid:/home/applprod/oraInventory #


root@gvaoragrid:/u01/GRID/apps/product/11.2.0 # ./root.sh
Running Oracle 11g root.sh script...

The following environment variables are set as:
ORACLE_OWNER= applprod
ORACLE_HOME= /u01/GRID/apps/product/11.2.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.



Drop the OEM repository
I performed the default installation you will notice the EM was created so I need to deconfigure Enterprise Manager Database Control. Run the following command as the "applprod" user.
$ applprod@gvaoragrid:/u01/GRID/apps/product/11.2.0/bin
$emca -deconfig dbcontrol db -repos drop -SYS_PWD -SYSMAN_PWD
$ emca -deconfig dbcontrol db -repos drop -SYS_PWD grid2011 -SYSMAN_PWD grid2011
applprod@gvaoragrid:/u01/GRID/apps/product/11.2.0/bin $ ./emca -deconfig dbcontrol db -repos drop -SYS_PWD grid2011 -SYSMAN_PWD grid2011

STARTED EMCA at Mar 24, 2011 2:29:20 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: GRID
Listener port number: 1521

Do you wish to continue? [yes(Y)/no(N)]: Y
Mar 24, 2011 2:41:36 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/GRID/apps/product/cfgtoollogs/emca/GRID/emca_2011_03_24_14_29_20.log.
Mar 24, 2011 2:41:36 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Mar 24, 2011 2:41:59 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Mar 24, 2011 2:45:11 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 24, 2011 2:45:14 PM
You have new mail in /var/spool/mail/applprod
Database parameter change

Make the following initialization parameter changes.
sqlplus / AS SYSDBA

ALTER SYSTEM SET log_buffer=10485760 SCOPE=SPFILE;
ALTER SYSTEM SET processes=500 SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
If you have done a default installation as described here, the UNDO tablespace will be autoextensible. If you have done a custom installation make sure the UNDO tablespace is at least 200M in size.
Alter some table space sizes log on as sysdba

SQL> ALTER DATABASE DATAFILE '/u02/GRID/dbf/GRID/undotbs01.dbf' RESIZE 400M;
SQL> ALTER DATABASE DATAFILE '/u02/GRID/dbf/GRID/system01.dbf' RESIZE 2048M;
SQL> ALTER DATABASE DATAFILE '/u02/GRID/dbf/GRID/sysaux01.dbf' RESIZE 1024M;

Apply Latest version opatch -
Next we must install the latest version of the "opatch" utility.
$ applprod@gvaoragrid: cd /u03/GRID/Software/GRID2011/
$ cp unzip -o p6880880_112000_Linux-x86-64.zip /u01/GRID/apps/product/11.2.0
$ applprod@gvaoragrid: unzip -o p6880880_112000_Linux-x86-64.zip
Sanity Check for the latest Opatch
applprod@gvaoragrid:/u03/GRID/Software/GRID2011 $ opatch lsinventory
Invoking OPatch 11.2.0.1.4
Oracle Interim Patch Installer version 11.2.0.1.4
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /u01/GRID/apps/product/11.2.0
Central Inventory : /home/applprod/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.4
OUI version : 11.2.0.1.0
OUI location : /u01/GRID/apps/product/11.2.0/oui
Log file location : /u01/GRID/apps/product/11.2.0/cfgtoollogs/opatch/opatch2011-03-24_16-37-49PM.log

Patch history file: /u01/GRID/apps/product/11.2.0/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /u01/GRID/apps/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2011-03-24_16-37-49PM.txt

Installed Top-level Products (1):
Oracle Database 11g 11.2.0.1.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.

OPatch succeeded.

The documentation states that patches for database bugs 9002336 and 9067282 must be applied. Patch 9002336 has a prerequisite of patch 9352237 (a PSU), which includes patch 9067282, so I have only applied patches 9352237 and 9002336, which can be downloaded from My Oracle Support. The database patches include installation instructions, but to summarize, these commands should be run as the "applprod" user.
$ dbshut $ORACLE_HOME
$ export PATH=$PATH:$ORACLE_HOME/OPatch
$ cd /u03/GRID/Software/GRID2011/

$ unzip p9352237_112010_Linux-x86-64.zip
$ cd 9352237
$ opatch apply
$ Verifying the update...
Inventory check OK: Patch ID 9352237 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9352237 are present in Oracle Home.
********************************************************************************
********************************************************************************
** ATTENTION **
** **
** Please note that the Patch Set Update Installation (PSU Deinstallation) **
** is not complete until all the Post Installation (Post Deinstallation) **
** instructions noted in the Readme accompanying this PSU, have been **
** successfully completed. **
** **
********************************************************************************
********************************************************************************
Execution of 'sh /u03/GRID/Software/GRID2011/9352237/custom/scripts/post -apply 9352237 ':
Return Code = 0
The local system has been patched and can be restarted.
OPatch succeeded.

$ unzip p9002336_112011_Linux-x86-64.zip
$ cd 9002336
$ opatch apply
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/u01/GRID/apps/product/11.2.0/lib/libserver11.a" with "lib/libserver11.a/kkqtutl.o"
Running make for target ioracle
ApplySession adding interim patch '9002336' to inventory
Verifying the update...
Inventory check OK: Patch ID 9002336 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9002336 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.


$ dbstart $ORACLE_HOME
The database installation is now complete.


Java SE Development Kit 6u18

Java Installation
Install Java JDK 6u18 using the following commands as the "root" user. Later version of the JDK cause errors when patching WebLogic (unless you are using a proxy), so the version of the JDK is very important.
# chmod u+x jdk-6u18-linux-x64-rpm.bin
# ./jdk-6u18-linux-x64-rpm.bin

Enterprise Manager Grid Control 11g Installation

Unzip the Grid control software into an empty directory.
$ /u03/GRID/Software/GRID2011
$ unzip GridControl_11.1.0.1.0_Linux_x86-64_1of3.zip
$ unzip GridControl_11.1.0.1.0_Linux_x86-64_2of3.zip
$ unzip GridControl_11.1.0.1.0_Linux_x86-64_3of3.zip
Start the installer as the "applprod" user.
applprod@gvaoragrid:/u03/GRID/Software/GRID2011/Oracle_Enterprise_Manager_11g_Grid_ControlRelease1_11.1.0.1.0_64Bits
$ ./runInstaller
Enter your support details, or uncheck the notification checkbox, then click the "Next" button. Click the "Yes" button on any subsequent warning dialogs.



Select the "Download and install updates from My Oracle Support" option and enter your support details, then click the "Next" button.



Wait while the check is performed, then click the "Download Updates" button on the subsequent dialog and wait for the updates to be downloaded.



Accept the default "Apply Software Updates" option by clicking the "Next" button.



Accept the default "Install a new Enterprise Manager system" option by clicking the "Next" button.



Wait while the prerequisite checks are performed. If any fail, correct them before proceeding by clicking the "Next" button.

I check the ignore all so that the highlighted memory check does not stop the installation



Enter "/u01/GRID/apps/product/Middleware/oms11g" as the OMS instance base location, then click the "Next" button.




Enter password for the WebLogic domain and node manager users, then click the "Next" button.





Enter the database connection details and click the "Next" button.



Enter password details for the "SYSMAN" database user and click the "Next" button.



Enter the password for secure agent connections, then click the "Next" button.



Amend the ports as you see fit, then click the "Next" button.



If you are happy with the information on the "Review" screen, click the "Next" button.



Wait while the installation takes place.



Run the specified script, then click the "OK" button.


root@gvaoragrid:/u01/GRID/apps/product/Middleware/oms11g # ./allroot.sh

Starting to execute allroot.sh .........

Starting to execute /u01/GRID/apps/product/Middleware/oms11g/root.sh ......
Running Oracle 11g root.sh script...

The following environment variables are set as:
ORACLE_OWNER= applprod
ORACLE_HOME= /u01/GRID/apps/product/Middleware/oms11g

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]: y
Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Adding entry to /etc/oratab file...
Finished execution of /u01/GRID/apps/product/Middleware/oms11g/root.sh ......


Starting to execute /u01/GRID/apps/product/Middleware/agent11g/root.sh ......
Running Oracle 11g root.sh script...

The following environment variables are set as:
ORACLE_OWNER= applprod
ORACLE_HOME= /u01/GRID/apps/product/Middleware/agent11g

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]: y
Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
Adding entry to /etc/oratab file...
Finished execution of /u01/GRID/apps/product/Middleware/agent11g/root.sh ......
Wait while the configuration steps take place.





Make a note of the URLs on the "Finish" screen, then click the "Close" button.



Connect to the Grid Control console (https://gvaoragrid.temenosgroup.com:7799/em) using the username (SYSMAN) and password defined during the installation, accept the license agreement and you are presented with the console.


Startup/Shutdown
Use the following commands to turn on all components installed by this article.
#!/bin/bash
export OMS_HOME=/u01/GRID/apps/product/Middleware/oms11g
export AGENT_HOME=/u01/GRID/apps/product/Middleware/agent11g

# Start everything
dbstart $ORACLE_HOME

$OMS_HOME/bin/emctl start oms

$AGENT_HOME/bin/emctl start agent
Use the following commands to turn off all components installed by this article.
#!/bin/bash
export OMS_HOME=/u01/GRID/apps/product/Middleware/oms11g
export AGENT_HOME=/u01/GRID/apps/product/Middleware/agent11g

# Stop everything
$OMS_HOME/bin/emctl stop oms -all

$AGENT_HOME/bin/emctl stop agent

dbshut $ORACLE_HOME
Its all about FNDLOAD
What is Data Synchronization ?
Data Synchronization is a process in which some setup data would be synchronized, and this would be more important when you are working in oracle application development/implementation project? The equally important that AOL data Migration takes place necessary to synchronize the data across databases instance during
• Installations (New desc. flex field creations etc)
• Upgrades (Apps upgrade etc)
• Maintenance (Value set changes etc)
Then… What.. FNDLOAD
Yes, that is one and only oracle solution. It can be defined as a concurrent program that can move Oracle Applications data between database and text file representations. Or this can be defined as FNDLOAD can download data from an application entity into an editable text file, which can be uploaded to another database.
How it works
Conversion between database format and text file format is specified by a configuration file. Oracle does provide confirmation file and it is important to just pass the configuration file name and then just call the loader and leave everything .The schematic visual representation of the loader is like:

What can be done?
These are the extensive list which can be done through FNDLOAD
• Concurrent Programs, Executables
• Request Groups, Request Sets
• Profile Options
• Key and Descriptive Flexfields
• Menus and Responsibilities
• Forms and Form Functions
• Attachments
• Messages
• Value Sets and Values
• Lookup Types
• User Responsibilities
• Printer Definitions
• FND Dictionary
• Help Configuration
• Document Sequences
• Concurrent Manager Schedules
Then…what are advantages when using FNDLOAD are :
1. Because downloaded data is stored in a text file, version administration is possible
2. There is nothing to worry to go to purchase because..Investment = 0$
3. No learning curve. this is relief for developer/dba’s
4. Fully supported and recommended by Oracle
5. Capture the migrations in a file and use it during installations, clones etc. to migrate in batch
6. Pin-point when something happened and where (database) easily
7. Your AOL data migration process is now simplified and streamlined – goal attained!!
And these are some Disadvantages also :
1. Applications patching mechanisms use FNDLOAD heavily – possibility of negative impact is not zero
2. UPLOAD_MODE=REPLACE only for menus
3. No validation against migrating database/instance sensitive data
The Syntax
To use FNDLOAD, the following syntax is needed.
FNDLOAD apps/appspwd 0 Y mode configfile datafile entity [parameter1…..]
As you can see, some info is needed.- First you will need to know the Apps password.
• The mode is either DOWNLOAD or UPLOAD.
• The configfile is the file that Fndload needs to download on upload data.
• T he data file is the output file, in which the downloaded data is written
• The entity is the entity you want to download,
• Parameters van is passed to download a certain Alert
Modes of Operation
This is important because it would drive the whole flow, and it always be two mode .. Upload and Download…
Example of download:
FNDLOADapps/pwd 0 Y DOWNLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt \ PROGRAM CONCURRENT_PROGRAM_NAME= concurrent_program_short_name> APPLICATION_SHORT_NAME=
Example of Upload
FNDLOAD apps/pwd 0 Y UPLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt - CUSTOM_MODE=FORCE undocumented parameter
WHAT IS FNDLOADLoad Options:
• Application level OR single entity level download
o (Example) Download all the profile options of Inventory or just the INV: Default Primary UOM
• Entire OR Partial upload of a data file
o (Example) Upload the entire myfile.ldt or just a single enity indicated by - and mode UPLOAD or UPLOAD_PARTIAL
o Entity name required for UPLOAD_PARTIAL mode
• Custom mode force update
o To override Oracle's upload algorithm and update the custom AOL data regardless, use CUSTOM_MODE= FORCE
o UPLOAD_MODE= REPLACE (only for menus)
• Support for NLS uploads
o NLS data uploads for translated columns are supported, use UPLOAD_MODE= NLS
Then ..Where is Config File Located
By default Oracle delivers most of configuration files you can use to download certain entities.
• Configuration files with extension .lct
o On Unix - all the configuration files are in $FND_TOP/patch/115/import directory
o On Unix – Oracle also places the original configuration files in $FND_TOP/admin/import directory
• Data files with extension .ldt
and..FNDLOAD File Structures is
• The config files (.lct) are delivered and maintained by Oracle
• It has entity definitions, parent-child relationships and user input parameters identified by :NAME
o Downloading a parent automatically downloads all children - (Example) Concurrent Program download
Take a note FNDLOAD File Structures
• The data files (.ldt) have both entity definition and the data
• It also shows the version and the location of the config file (.lct) that was used
• Without the config file, data file is useless
• Without the data file, config file is meaningless
..Remember regarding FNDLOAD Files
• Key files: .lct and .ldt
• You must run the FNDLOADas apps user not as applsys or any other, otherwise you will receive Ora-6550
• Both are easily readable, editable and portable
• DO NOT MODIFY Oracle’s .lct files
• Use your favorite editor (I would suggest Textpad or Editplus) to manipulate only the .ldt files but be cautious about data type, length, delimiter placements etc.
• Use the log file outputs or .ldt file contents creatively for quick file comparisons and answer questions faster (Why can’t I access that? What is that profile option name, value and level? What is the value set used for that DFF segment attribute10 etc.)
• Partial string searches (which value set has Priority “something” in its where clause? etc)
Sample Script Code for these Objects :
1 - Printer Styles
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"
2 - Lookups
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="prod" LOOKUP_TYPE="lookup name"
3 - Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=?COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME="prod" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name"
4 - Key Flexfield Structures
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=?COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL? APPLICATION_SHORT_NAME="prod" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name"
5 - Concurrent Programs
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="prod" CONCURRENT_PROGRAM_NAME="concurrent name"
6 - Value Sets
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"
7 - Value Sets with values
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"
8 - Profile Options
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="prod"
9 - Requset Group
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="prod"
10 - Request Sets
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME="prod" REQUEST_SET_NAME="request set"
11 - Responsibilities
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility
12 - Menus
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name"
13 – Forms/Functions
FNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES The Upload syntax for all styles: FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt
14. User/Responsibilities
FNDLOAD apps/apps@seed115 0 Y DOWNLOAD @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER Then UPLOAD FNDLOAD apps/apps@seed115 0 Y UPLOAD [UPLOAD_PARTIAL] @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER []

Hybrid clone with rman

Hybrid database cloning using RMAN and appsTier file copy This document demonstrates how to clone the dbTier using RMAN and refreshing the appsTier using the file copy. The RMAN APPSClone scripts found on the appsTier /home/applprod/APPSClone is not yet mature as it’s prone to some errors some refined tests needs to be carried out. Delete the datafiles from dbtier The following files should be deleted before launching the RMAN refresh applprod@gvaebsdb2:$ • /u02/DEV2/rdo/* • /u03/DEV2/rdo/* • /u04/DEV2/rdo/* • /u02/DEV2/dbf/DEV2/* Launch the RMAN refresh start time for the DB restore 1:36 pm The scripts for the RMAN backup and catalog management are in /home/applprod/DBclone. The DB refresh script will ask for 2 parameter the source PROD and destination DEVx In the example below I refreshing DEV2 using PROD backup. It will run for approximately 6 hours applprod@gvaebsdb2:~/DBClone/bin $ refresh_DB.ksh PROD DEV2 Checking options for restore... ********************************************************* ******** Running Database Restore Process For ******** ******** PROD to DEV2 ******** ********************************************************* Refresh Start Date/Time: 12032011_1339 Step 1: Preparing new init.ora file for restore... Step 2: Preparing Password file for restore... Step 3: Launching RMAN restore process... Step 3.1: Shutting down DB and Listener... Step 3.2: Starting up DB in nomount with RMAN init parameters ... Step 3.3: Launching RMAN command for the restore, For more detail pls tail the logs under /RMAN/logs Step 4: Restarting Database and Listener with old init values... Step 5: Adding Temp tablespace and changing SYSTEM password... Step 6: Launchng the autoconfig on the DB tier... The log file for this session is located at: /u01/DEV2/apps/proddb/11.2.0/appsutil/log/DEV2_gvaebsdb2/12032002/adconfig.log AutoConfig is configuring the Database environment... AutoConfig will consider the custom templates if present. Using ORACLE_HOME location: /u01/DEV2/apps/proddb/11.2.0 Classpath : /u01/DEV2/apps/proddb/11.2.0/jdk/jre/lib/rt.jar:/u01/DEV2/apps/proddb/11.2.0/jdk/lib/dt.jar:/u01/DEV2/apps/proddb/11.2.0/jdk/lib/tools.jar:/u01/DEV2/apps/proddb/11.2.0/jdbc/lib/ojdbc5.jar:/u01/DEV2/apps/proddb/11.2.0/appsutil/java/xmlparserv2.zip:/u01/DEV2/apps/proddb/11.2.0/appsutil/java:/u01/DEV2/apps/proddb/11.2.0/jlib/netcfg.jar:/u01/DEV2/apps/proddb/11.2.0/jlib/ldapjclnt11.jar Using Context file: /u01/DEV2/apps/proddb/11.2.0/appsutil/DEV2_gvaebsdb2.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...COMPLETED Updating rdbms version in Context file to db112 Updating rdbms type in Context file to 64 bits Configuring templates from ORACLE_HOME ... AutoConfig completed successfully. REFRESH FINISHED... Refresh Finish Date/Time: 12032011_2004 applprod@gvaebsdb2:~/DBClone/bin $ Restore_DEV2_13:39:42-12-03-2011.log Check the RMAN logs for errors The RMAN error logs can be found on the mounted partition RMAN/logs gvaebsdb2@applprod:$/RMAN/logs# Recovery Manager: Release 11.2.0.1.0 - Production on Sat Dec 3 13:39:43 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. RMAN-06549: connected to auxiliary database: DEV2 (not mounted) RMAN-08030: allocated channel: c1 RMAN-08500: channel c1: SID=1171 device type=DISK RMAN-08030: allocated channel: c2 RMAN-08500: channel c2: SID=5 device type=DISK ……………………. ………………………….. …………………………………… ……………………………………………… RMAN-08161: contents of Memory Script: { Alter clone database open resetlogs;} RMAN-08162: executing Memory Script RMAN-06400: database opened RMAN-03091: Finished Duplicate Db at 12/03/11 20:00:36 RMAN-08031: released channel: c1 RMAN-08031: released channel: c2 RMAN-08031: released channel: c3 RMAN-08031: released channel: c4 RMAN-08031: released channel: c5 RMAN-08031: released channel: c6 RMAN> Recovery Manager complete. Sat Dec 3 20:00:37 CET 2011 Remove the lock file RMAN DUPLICATE FINISH Total Refresh time 6:30 mins Put the database in noarchivelog After the successful database clone the RMAN script puts the newly cloned database in archivelog mode. De-activate the archiving by running the below process. Log on the system as sys applprod@gvaebsdb2:/u01/DEV2/apps/proddb/11.2.0/dbs $ sqlplus '/as sysdba'; SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 4 13:25:35 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining and Real Application Testing options SQL> create pfile from spfile; File created. Edit the initDEV2.ora located in $ORACLE_HOME/dbs add or remove the below incase you want to archiving or not * log_archive_dest_1='LOCATION=/u03/DEV2/arch/logs/' SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. Deactivate archiving SQL> startup mount; ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2220200 bytes Variable Size 444600152 bytes Database Buffers 608174080 bytes Redo Buffers 13942784 bytes Database mounted. SQL> alter database noarchivelog; Database altered. SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/DEV2/arch/logs Oldest online log sequence 39 Current log sequence 41 SQL> alter database open; Database altered. Run the postclone scripts Run as apps user with the source apps passowrd run on the newly cloned database the following postclone scripts found in /home/dba/dbaScripts • cmclean.sql input DUAL for this script to continue this will clean the fnd type commit at the end as this script as it does not auto commit. • create_fnd_trig.sql SQL> @create_fnd_trig.sql; Trigger created. PL/SQL procedure successfully completed. Commit complete. • tem_postclone_script.sql Either run the tem_postclone_script.sql or create a script all.sql in /home/applprod with the following contents see below ################################## script start here############################# -- Update salary entries with random values between 500'000 and 800'000 UPDATE pay_element_entry_values_f pev SET pev.screen_entry_value = TRUNC(dbms_random.VALUE(500000,800000)) WHERE pev.element_entry_id IN (SELECT pee.element_entry_id FROM pay_element_entries_f pee, pay_element_types_f pet WHERE pev.effective_start_date <= pee.effective_end_date AND pee.effective_start_date <= pev.effective_end_date AND pee.element_type_id = pet.element_type_id AND pet.reporting_name = 'Salary'); COMMIT; -- Update salary proposals with salary entries UPDATE per_pay_proposals ppp SET proposed_salary_n=NVL( (SELECT MAX(pev.screen_entry_value) FROM pay_element_entries_f pee,pay_element_types_f pet,pay_input_values_f piv,pay_element_entry_values_f pev WHERE pee.element_entry_id = pev.element_entry_id AND pev.effective_start_date BETWEEN pee.effective_start_date AND pee.effective_end_date AND pev.input_value_id = piv.input_value_id AND pet.element_type_id = piv.element_type_id AND EXISTS (SELECT 1 FROM per_pay_bases ppb, pay_input_values_f piv2 WHERE ppb.input_value_id=piv2.input_value_id AND piv2.element_type_id=pet.element_type_id) AND ppp.assignment_id=pee.assignment_id AND ppp.change_date=pee.effective_start_date AND ppp.date_to=pee.effective_end_date ), 0); COMMIT; --- To disable messaging system in alerts UPDATE ALR_MESSAGE_SYSTEMS SET enabled_flag='N'; COMMIT; ---- To disable scheduled requests UPDATE fnd_concurrent_requests REQ SET phase_code = 'C',status_code = 'D',completion_text = 'Cancelled by clone'WHERE phase_code IN ('P','I'); commit; -- To disable active alerts UPDATE alr_alerts SET enabled_flag = 'N' WHERE enabled_flag = 'Y'; COMMIT; UPDATE fnd_profile_option_values SET profile_option_value='Temenos E-Business [ DEVx ] Environment clone of ('||to_char(sysdate-1,'dd-Mon-yyyy')||')' WHERE profile_option_id=125; TRUNCATE TABLE applsys.FND_CONCURRENT_REQUESTS; TRUNCATE TABLE applsys.FND_RUN_REQUESTS; TRUNCATE TABLE applsys.FND_CONC_REQUEST_ARGUMENTS; TRUNCATE TABLE applsys.FND_CONCURRENT_PROCESSES; TRUNCATE TABLE applsys.FND_CONC_STAT_LIST; TRUNCATE TABLE applsys.FND_CONC_STAT_SUMMARY; TRUNCATE TABLE applsys.FND_RUN_REQ_PP_ACTIONS; TRUNCATE TABLE applsys.WF_NOTIFICATIONS; UPDATE fnd_profile_option_values f SET f.profile_option_value = 'BLUE' WHERE f.profile_option_id = 5785; ################################script ends here ################################## Run dbTier autoconfig To ensure that the new parameter are taken into consideration re-run the dbTier autoconfig applprod@gvaebsdb2: cd /u01/DEV2/apps/proddb/11.2.0/appsutil/scripts/DEV2_gvaebsdb2 input the source database apps password to continue applprod@gvaebsdb2:/u01/DEV2/apps/proddb/11.2.0/appsutil/scripts/DEV2_gvaebsdb2 $ ./adautocfg.sh Enter the APPS user password: The log file for this session is located at: /u01/DEV2/apps/proddb/11.2.0/appsutil/log/DEV2_gvaebsdb2/12042301/adconfig.log AutoConfig is configuring the Database environment... AutoConfig will consider the custom templates if present. Using ORACLE_HOME location : /u01/DEV2/apps/proddb/11.2.0 Classpath : /u01/DEV2/apps/proddb/11.2.0/jdk/jre/lib/rt.jar:/u01/DEV2/apps/proddb/11.2.0/jdk/lib/dt.jar:/u01/DEV2/apps/proddb/11.2.0/jdk/lib/tools.jar:/u01/DEV2/apps/proddb/11.2.0/jdbc/lib/ojdbc5.jar:/u01/DEV2/apps/proddb/11.2.0/appsutil/java/xmlparserv2.zip:/u01/DEV2/apps/proddb/11.2.0/appsutil/java:/u01/DEV2/apps/proddb/11.2.0/jlib/netcfg.jar:/u01/DEV2/apps/proddb/11.2.0/jlib/ldapjclnt11.jar Using Context file : /u01/DEV2/apps/proddb/11.2.0/appsutil/DEV2_gvaebsdb2.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...COMPLETED Updating rdbms version in Context file to db112 Updating rdbms type in Context file to 64 bits Configuring templates from ORACLE_HOME ... AutoConfig completed successfully. applprod@gvaebsdb2:/u01/DEV2/apps/proddb/11.2.0/appsutil/scripts/DEV2_gvaebsdb2 $ Stop and restart the dbTier Set the dbTier environment applprod@gvaebsdb2:~ $ . db.env applprod@gvaebsdb2:~ $ dbctrl stop applprod@gvaebsdb2:~ $ dbctrl start Change the sys and system password applprod@gvaebsdb2:~ $ sqlplus '/as sysdba'; SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 5 11:35:51 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining and Real Application Testing options SQL> alter user sys identified by sysdev2; User altered. SQL> alter user system identified by sysdev2; User altered. Recreate the passwordfile Creating the password enables remote connections applprod@gvaebsdb2:/u01/DEV2/apps/proddb/11.2.0/dbs $ orapwd file=orapwDEV2 password=sysdev2 entries=5 force=y Method 1 Configuring the appsTier Copy the appsTier of the source environment in this case the production gva2ebsapps2@applprod:$ cd /u01/PROD/apps/ gva2ebsapps2@applprod:$ cp –R * /tmp FTP the above directories to the same location on the new server from the tmp directory using winscp Gunzip the files applprod@gvaebsapps2:~ $/u01/DEV2/apps/prodcomn $ gunzip *.tgz applprod@gvaebsapps2:~ $/u01/DEV2/apps/prodora $ gunzip *.tgz applprod@gvaebsapps2:~ $/u01/DEV2/apps/prodappl $ gunzip *.tgz Then execute the below command in all the applprod@gvaebsapps2:/u01/DEV2/apps/prodora $ find . -name "*.tar" -exec tar xf {} \; applprod@gvaebsapps2:/u01/DEV2/apps/prodcomn $ find . -name "*.tar" -exec tar xf {} \; applprod@gvaebsapps2:/u01/DEV2/apps/prodappl $ find . -name "*.tar" -exec tar xf {} \; gvaebsapps2@applprod:$ cd /u01/DEV2/apps/ After the application tier software unzipping are complete, the file system configurations need to be updated to reflect the new environment. To do this on the application tiers, log on to the NEW application tier system as the APPLPROD user and execute the following commands. Since your environment scripts are not yet set up, you will need to manually resolve the reference to and : $ cd /clone/bin $ perl adclonectx.pl /admin/.xml Answer the questions appropriately. • The new host name is the server you are on. • Note the database name will stay the same as the production DB, but the database server name will be different. • Do not validate the context, as the process will not be able to connect to the database. • When it asks for the new context path and file name, give it /admin/.xml applprod@gvaebsapps2: cd /u01/DEV2/apps/prodappl/ad/11.5.0/bin applprod@gvaebsapps2: $ perl adclonectx.pl /u01/DEV2/apps/prodappl/admin/PROD_gva2ebsapps2.xml /usr/java/jdk1.6.0_21/bin/java -classpath ../../../fnd/11.5.0/java/3rdparty/stdalone/jdbc12.zip:../../../fnd/11.5.0/java/3rdparty/stdalone/xmlparserv2.zip:/usr/java/jdk1.6.0_21/lib/rt.jar:../java: oracle.apps.ad.context.CloneContext -e /u01/DEV2/apps/prodappl/admin/PROD_gva2ebsapps2.xml -perl "/usr/bin/perl" -perl5lib "/usr/lib/perl5/5.8.5/i386-linux-thread-multi:/usr/lib/perl5/5.8.5:/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi:/usr/lib/perl5/site_perl/5.8.5:/usr/lib/perl5/site_perl:/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi:/usr/lib/perl5/vendor_perl/5.8.5:/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread- multi:/usr/lib/perl5/vendor_perl/5.8.3:/usr/lib/perl5/vendor_perl:." -tmpl ../admin/template/adxmlctx.tmp Provide the values required for creation of the new APPL_TOP Context file. Do you want to use a virtual hostname for the target node (y/n) [n] ?:n Target hostname [gva2ebsapps2]:gvaebsapps2 It is recommended that your inputs are validated by the program. However you might choose not to validate your inputs under following circumstances: -If cloning a context on source system for a remote system. -If cloning a context on a machine where the ports are taken and you do not want to shutdown the services at this point. -If cloning a context but the database it needs to connect is not available. Do you want the inputs to be validated (y/n) [n] ?:n Target system database SID [PROD]:DEV2 Username for the applications file system owner [applprod]: Group for the applications file system owner [dba]: Target system database server node [gva2ebsdbprod]:gvaebsdb2 Target system database domain name [temenosgroup.com]: Does the target system have more than one application tier server node (y/n) [y] ?:n Is the target system APPL_TOP divided into multiple mount points (y/n) [n] ?: Target system APPL_TOP mount point [/u01/PROD/apps/prodappl]:/u01/DEV2/apps/prodappl Target system COMMON_TOP directory [/u01/PROD/apps/prodcomn]:/u01/DEV2/apps/prodcomn Target system 8.0.6 ORACLE_HOME directory [/u01/PROD/apps/prodora/8.0.6]:/u01/DEV2/apps/prodora/8.0.6 Target system iAS ORACLE_HOME directory [/u01/PROD/apps/prodora/iAS]:/u01/DEV2/apps/prodora/iAS Do you want to preserve the Display set to gva2ebsapps2:0.0 (y/n) [y] ?:n Target system Display [gvaebsapps2:0.0]: Location of the JDK on the target system [/usr/java/jdk1.6.0_21]: Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:y Complete port information available at /u01/DEV2/apps/prodappl/admin/out/DEV2_gvaebsapps2/portpool.lst New context path and file name [/u01/DEV2/apps/prodappl/admin/DEV2_gvaebsapps2.xml]: Creating the new APPL_TOP Context file from : /u01/DEV2/apps/prodappl/ad/11.5.0/admin/template/adxmlctx.tmp The new APPL_TOP context file has been created : /u01/DEV2/apps/prodappl/admin/DEV2_gvaebsapps2.xml Log file located at /tmp/CloneContext_1205100437.log applprod@gvaebsapps2:/u01/DEV2/apps/prodappl/ad/11.5.0/bin $ When the script is finished and the context file is created, execute the following, again resolving the reference to manually: Using the perl script adclonectx.pl clone the production xml to new context file Edit the newly created XML above and change the following to the appropriate values and ports • 1522temenosgroup.comgvaexchangeebizadmindev2@temenos.comebizadmindev2vezfe1europe.temenosgroup.comhermes.temenosgroup.com7779http://bidev1.temenosgroup.com:9705gvaebsapps2_dev2 applprod@gvaebsapps2:$ perl adconfig.pl contextfile=/u01/DEV2/apps/prodappl/admin/DEV2_gvaebsapp2.xml run=INSTE8 Type the perl command all on one line. Answer the questions when prompted. This creates your environment files on the application tier. It tries to connect to the database, so some portions fail, but the environment scripts should be successfully created. applprod@gvaebsapps2:/u01/DEV2/apps/prodappl/ad/11.5.0/bin $ perl adconfig.pl contextfile=/u01/DEV2/apps/prodappl/admin/DEV2_gvaebsapps2.xml run=INSTE8 Enter the APPS user password: Script execution phase specified: INSTE8 The log file for this session is located at: /u01/DEV2/apps/prodappl/admin/DEV2_gvaebsapps2/log/12051048/adconfig.log AutoConfig is configuring the Applications environment... AutoConfig will consider the custom templates if present. Using APPL_TOP location : /u01/DEV2/apps/prodappl Classpath : /usr/java/jdk1.6.0_21/jre/lib/rt.jar:/usr/java/jdk1.6.0_21/lib/dt.jar:/usr/java/jdk1.6.0_21/lib/tools.jar:/u01/DEV2/apps/prodcomn/java/appsborg2.zip:/u01/DEV2/apps/prodcomn/java Using Context file : /u01/DEV2/apps/prodappl/admin/DEV2_gvaebsapps2.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Execution phase specified at run time: INSTE8 No uploading of Context File and its templates to database. Configuring templates from all of the product tops... Configuring AD_TOP........COMPLETED Configuring FND_TOP.......COMPLETED Configuring ICX_TOP.......COMPLETED Configuring IEO_TOP.......COMPLETED Configuring ABM_TOP.......COMPLETED Configuring ECX_TOP.......COMPLETED Configuring BIS_TOP.......COMPLETED Configuring GL_TOP........COMPLETED Configuring AMS_TOP.......COMPLETED Configuring CCT_TOP.......COMPLETED Configuring WSH_TOP.......COMPLETED Configuring CLN_TOP.......COMPLETED Configuring OKE_TOP.......COMPLETED Configuring OKL_TOP.......COMPLETED Configuring OKS_TOP.......COMPLETED Configuring CSF_TOP.......COMPLETED Configuring XNC_TOP.......COMPLETED Configuring IGS_TOP.......COMPLETED Configuring IBY_TOP.......COMPLETED Configuring PA_TOP........COMPLETED Configuring JTF_TOP.......COMPLETED Configuring MWA_TOP.......COMPLETED Configuring CN_TOP........COMPLETED Configuring CSI_TOP.......COMPLETED Configuring WIP_TOP.......COMPLETED Configuring CSE_TOP.......COMPLETED Configuring EAM_TOP.......COMPLETED Configuring IMT_TOP.......COMPLETED Configuring FTE_TOP.......COMPLETED Configuring ONT_TOP.......COMPLETED Configuring AR_TOP........COMPLETED Configuring AHL_TOP.......COMPLETED Configuring OZF_TOP.......COMPLETED Configuring IES_TOP.......COMPLETED Configuring CSD_TOP.......COMPLETED Configuring IGC_TOP.......COMPLETED AutoConfig completed successfully. Run FNDCPASS Change the apps ,sysadmin password using FNDCPASS applprod@gvaebsapps2:~ $ FNDCPASS apps/appspassword 0 Y system/sysdev2 SYSTEM APPLSYS appsdev2 applprod@gvaebsapps2:~ $ FNDCPASS apps/appspassword 0 Y system/sysdev2 USER SYSADMIN sysadmindev2 Rerun adautocfg.sh applprod@gvaebsapps2:/u01/DEV2/apps/prodcomn/admin/scripts/DEV2_gvaebsapps2 $ ./adautocfg.sh Enter the APPS user password : The log file for this session is located at: /u01/DEV2/apps/prodappl/admin/DEV2_gvaebsapps2/log/12051112/adconfig.log AutoConfig is configuring the Applications environment... AutoConfig will consider the custom templates if present. Using APPL_TOP location : /u01/DEV2/apps/prodappl Classpath : /usr/java/jdk1.6.0_21/jre/lib/rt.jar:/usr/java/jdk1.6.0_21/lib/dt.jar:/usr/java/jdk1.6.0_21/lib/tools.jar:/u01/DEV2/apps/prodcomn/java/appsborg2.zip:/u01/DEV2/apps/prodcomn/java Using Context file : /u01/DEV2/apps/prodappl/admin/DEV2_gvaebsapps2.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database... Configuring templates from all of the product tops... Configuring AD_TOP........COMPLETED Configuring FND_TOP.......COMPLETED Configuring ICX_TOP.......COMPLETED Configuring IEO_TOP.......COMPLETED Configuring ABM_TOP.......COMPLETED Configuring ECX_TOP.......COMPLETED Configuring BIS_TOP.......COMPLETED Configuring GL_TOP........COMPLETED Configuring AMS_TOP.......COMPLETED Configuring CCT_TOP.......COMPLETED Configuring WSH_TOP.......COMPLETED Configuring CLN_TOP.......COMPLETED Configuring OKE_TOP.......COMPLETED Configuring OKL_TOP.......COMPLETED Configuring OKS_TOP.......COMPLETED Configuring CSF_TOP.......COMPLETED Configuring XNC_TOP.......COMPLETED Configuring IGS_TOP.......COMPLETED Configuring IBY_TOP.......COMPLETED Configuring PA_TOP........COMPLETED Configuring JTF_TOP.......COMPLETED Configuring MWA_TOP.......COMPLETED Configuring CN_TOP........COMPLETED Configuring CSI_TOP.......COMPLETED Configuring WIP_TOP.......COMPLETED Configuring CSE_TOP.......COMPLETED Configuring EAM_TOP.......COMPLETED Configuring IMT_TOP.......COMPLETED Configuring FTE_TOP.......COMPLETED Configuring ONT_TOP.......COMPLETED Configuring AR_TOP........COMPLETED Configuring AHL_TOP.......COMPLETED Configuring OZF_TOP.......COMPLETED Configuring IES_TOP.......COMPLETED Configuring CSD_TOP.......COMPLETED Configuring IGC_TOP.......COMPLETED AutoConfig completed successfully. Start the application Set the application environment applprod@gvaebsapps2:~ $ . apps.env applprod@gvaebsapps2:~ $ appsctrl start You should Change the application profile Color UPDATE fnd_profile_option_values f SET f.profile_option_value = '%' WHERE f.profile_option_id = 5785; Where % is in 1. Teal 2. Titanium (DON’T USE exclusively for production) 3. Red 4. Khaki 5. Blue 6. Olive 7. Purple Use the different colors for the diffrernet DEV server from DEV1 to DEV5 Sitename UPDATE fnd_profile_option_values SET profile_option_value= 'Temenos Development DEVx a clone of ('||to_char(sysdate-1,'dd-Mon-yyyy')||')' WHERE profile_option_id=125; Please see section Run the postclone scripts above