Monday, June 11, 2012

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

No comments:

Post a Comment