本文共 12683 字，大约阅读时间需要 42 分钟。
1. Apply the following patches on your test system: 9239089, 9171651,9833058, 12404574,12598630adstpall.sh apps/apps
adadmin menu_option=ENABLE_MAINT_MODE
create table apps.invalids_before_patch as select * from dba_objects where status='INVALID';
unzip p9239089_R12.AD.B_R12_LINUX.zip
cd 9239089
adpatch driver=u9239089.drv
unzip p9171651_R12.OAM.B_R12_GENERIC.zip -d src/
unzip p9833058_R12.OAM.B_R12_GENERIC.zip -d src/
unzip p12404574_R12.OAM.B_R12_GENERIC.zip -d src/
unzip p12598630_R12.OAM.B_R12_GENERIC.zip -d src/
admrgpch -s src/ -d dst/
cd dst/
adpatch driver=u_merged.drv
create table apps.invalids_after_patch as select * from dba_objects where status='INVALID';
select * from invalids_after_patch where object_id not in (select object_id from invalids_before_patch);
adadmin menu_option=DISABLE_MAINT_MODE
adstrtal.sh apps/appsRun Active User to do sanity test
--EOF--
2. List in SQL*PLUS that you have applied the patches stated in Assignment 1.SQL> select bug_number,last_update_date,TRACKABLE_ENTITY_ABBR from ad_bugs where bug_number in (9239089, 9171651,9833058, 12404574,12598630);
BUG_NUMBER LAST_UPDATE_DATE TRACKABL------------------------------ ------------------ --------9239089 02-APR-14 ad12404574 03-APR-14 oam12598630 03-APR-14 oam9171651 03-APR-14 oam9833058 03-APR-14 oamSQL>--EOF--
3. Try to use Rapid Clone to create a clone of your test system.Oracle EBS R12 - Clone EBS R12.1.1 on Oracle Linux 64 5.7 to Oracle Linux 64 5.7
基于 Oracle Linux 64 5.7 的 EBS R12.1.1 详细克隆步骤Section 0: VersionSource: R12.1.1 on Oracle Linux 64 5.7, SID=r12dev, host=r12dev.example.comTarget: Oracle Linux 64 5.7, host=r12uat.example.com (to be cloned: R12.1.1,SID=r12dev)Target should have all necessary rpm packages installed and have localhost & hostname with correct IP addresses mapped in /etc/hosts.Section 1: Prerequisite Tasks1.1 patch9239089 R12.AD.B.DELTA.39171651:R12.OAM.B 12.1 RAPIDCLONE CONSOLIDATED FIXES JUL/20109833058:R12.OAM.B HOT CLONE FAILS WITH ORA-00201 DURING RECOVERY MANAGER12404574:R12.OAM.B ORACLE_HOME REGISTRATION DOES NOT HAPPEN WITH CENTRAL INVENTORY ON LOZ12598630:R12.OAM.B R12.1 ONE-OFF FOR S_DB_LISTENER BUG 123620101.2 run autoconfig on app tier$ADMIN_SCRIPTS_HOME/adautocfg.sh1.3 synchronize appsutil to db tierrun perl $AD_TOP/bin/admkappsutil.pl by ap user, switch to db user and copy generated appsutil.zip from app tier to $ORACLE_HOME on db tier,unzip -o appsutil.zip by db user.1.4 run autoconfig on db tier$ORACLE_HOME/appsutil/scripts/SID_hostname/adautocfg.sh 1.5 maintain snapshot informationAD Administration(adadmin)->Maintain Snapshot Information->Update Current View Snapshot->Update Complete APPL_TOPNote: If a snapshot was never created for that APPL_TOP, you will need to create a new one before proceeding with the clone.Section 2: Cloning Tasks 2.1 Prepare the source system2.1.1 Prepare the source system database tier for cloningLog on to the source system as the ORACLE user, and run the following commands:$ cd [RDBMS ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]$ perl adpreclone.pl dbTier 2.1.2 Prepare the source system application tier for cloningLog on to the source system as the APPLMGR user, and run the following commands on each node that contains an APPL_TOP:$ cd [INST_TOP]/admin/scripts$ perl adpreclone.pl appsTier2.2 Copy the source system to the target system2.2.1 Copy the application tier file systemLog on to the source system application tier nodes as the APPLMGR user and shut down the application tier server processes. Copy the following application tier directories from the source node to the target application tier node: [APPL_TOP] [COMMON_TOP] Applications Technology Stack: [OracleAS Tools ORACLE_HOME] [OracleAS Web IAS_ORACLE_HOME]rsync -aPv apr12dev@192.168.10.101:/u01/r12dev/apps/tech_st .rsync -aPv apr12dev@192.168.10.101:/u01/r12dev/apps/apps_st .ap tier = technology stack + application stacktechnology stack(tech_st) = $ORACLE_HOME + $IAS_ORACLE_HOME application stack(apps_st) = $APPL_TOP + $COMMON_TOP -bash-3.2$ echo $APPL_TOP /u01/r12dev/apps/apps_st/appl-bash-3.2$ echo $COMMON_TOP /u01/r12dev/apps/apps_st/comn-bash-3.2$ echo $ORACLE_HOME /u01/r12dev/apps/tech_st/10.1.2-bash-3.2$ echo $IAS_ORACLE_HOME /u01/r12dev/apps/tech_st/10.1.32.2.2 Copy the database node file systemLog on to the source system database node as the ORACLE user, and then: Perform a normal shutdown of the source system database Copy the database (.dbf) files from the source system to the target system Copy the source database ORACLE_HOME to the target system Start the source Applications system database and application tier processesrsync -aPv orr12dev@192.168.10.101:/u01/r12dev/db/tech_st .rsync -aPv orr12dev@192.168.10.101:/u01/r12dev/db/apps_st .-bash-3.2$ echo $ORACLE_HOME /u01/r12dev/db/tech_st/11.1.0-bash-3.2$ ll /u01/r12dev/db/tech_st/total 4drwxr-xr-x 77 orr12dev dba 4096 Nov 22 01:13 11.1.0-bash-3.2$ ll /u01/r12dev/db/apps_st/total 4drwxr-xr-x 2 orr12dev dba 4096 Nov 17 14:11 data2.3 Configure the target system2.3.1 Configure the target system database serverLog on to the target system as the ORACLE user and enter the following commands:$ cd [RDBMS ORACLE_HOME]/appsutil/clone/bin$ perl adcfgclone.pl dbTier[orr12uat@r12uat bin]$ perl adcfgclone.pl dbTier Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA Oracle Applications Rapid Clone Version 12.0.0 adcfgclone Version 120.31.12010000.8Enter the APPS password : Running:/u01/r12uat/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /u01/r12uat/db/tech_st/11.1.0/appsutil/clone/jlib/java:/u01/r12uat/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/r12uat/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /u01/r12uat/db/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_5777.lst -stage /u01/r12uat/db/tech_st/11.1.0/appsutil/clone 2> /tmp/adcfgclone_5777.err; echo $? > /tmp/adcfgclone_5777.resLog file located at /u01/r12uat/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_1123015149.logProvide the values required for creation of the new Database Context file.Target System Hostname (virtual or normal) [r12uat] : Target Instance is RAC (y/n) [n] : Target System Database SID : r12uatTarget System Base Directory : /u01/r12uatTarget System utl_file_dir Directory List : /usr/tmp, /u01/r12uat/db/tech_st/11.1.0/appsutil/outbound/r12uat_r12uatNumber of DATA_TOP's on the Target System [1] : Target System DATA_TOP Directory 1 [/u01/r12dev/db/apps_st/data] : /u01/r12uat/db/apps_st/dataTarget System RDBMS ORACLE_HOME Directory [/u01/r12uat/db/tech_st/11.1.0] : Do you want to preserve the Display [null] (y/n) : Target System Display [r12uat:0.0] : Do you want the the target system to have the same port values as the source system (y/n) [y] ? : Target System Port Pool [0-99] : 0Checking the port pool 0done: Port Pool 0 is freeReport file located at /u01/r12uat/db/tech_st/11.1.0/appsutil/temp/portpool.lstComplete port information available at /u01/r12uat/db/tech_st/11.1.0/appsutil/temp/portpool.lst...-- verify. SID_hostname.envlsnrctl statussqlplus / as sysdbaselect instance_name,status from v$instance;2.3.2 Configure the target system application tier server nodesLog on to the target system as the APPLMGR user and enter the following commands:$ cd [COMMON_TOP]/clone/bin$ perl adcfgclone.pl appsTiermay need manually create inst directory and change owner to ap owner.[root@r12uat inst]# pwd/u01/r12uat/inst[root@r12uat inst]# ll -lddrwxr-xr-x 3 apr12uat dba 4096 11-23 02:24 .[apr12uat@r12uat bin]$ perl adcfgclone.pl appsTier Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA Oracle Applications Rapid Clone Version 12.0.0 adcfgclone Version 120.31.12010000.8Enter the APPS password : Running:/u01/r12uat/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/r12uat/apps/apps_st/comn/clone/jlib/java:/u01/r12uat/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u01/r12uat/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /u01/r12uat/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_11821.lst -stage /u01/r12uat/apps/apps_st/comn/clone 2> /tmp/adcfgclone_11821.err; echo $? > /tmp/adcfgclone_11821.resLog file located at /u01/r12uat/apps/apps_st/comn/clone/bin/CloneContext_1123022411.logProvide the values required for creation of the new APPL_TOP Context file.Target System Hostname (virtual or normal) [r12uat] : Target System Database SID : r12uatTarget System Database Server Node [r12uat] : Target System Database Domain Name [example.com] : Target System Base Directory : /u01/r12uatTarget System Tools ORACLE_HOME Directory [/u01/r12uat/apps/tech_st/10.1.2] : Target System Web ORACLE_HOME Directory [/u01/r12uat/apps/tech_st/10.1.3] : Target System APPL_TOP Directory [/u01/r12uat/apps/apps_st/appl] : Target System COMMON_TOP Directory [/u01/r12uat/apps/apps_st/comn] : Target System Instance Home Directory [/u01/r12uat/inst] : Target System Root Service [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 to preserve the Display [r12dev:0.0] (y/n) : nTarget System Display [r12uat:0.0] : Do you want the the target system to have the same port values as the source system (y/n) [y] ? : Complete port information available at /u01/r12uat/apps/apps_st/comn/clone/bin/out/r12uat_r12uat/portpool.lstUTL_FILE_DIR on database tier consists of the following directories.1. /usr/tmp2. /usr/tmp3. /u01/r12uat/db/tech_st/11.1.0/appsutil/outbound/r12uat_r12uat4. /u01/r12uat/db/tech_st/11.1.0/appsutil/outbound/r12uat_r12uat5. /usr/tmpChoose a value which will be set as APPLPTMP value on the target node [1] : Creating the new APPL_TOP Context file from : /u01/r12uat/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmpThe new APPL_TOP context file has been created : /u01/r12uat/inst/apps/r12uat_r12uat/appl/admin/r12uat_r12uat.xmlLog file located at /u01/r12uat/apps/apps_st/comn/clone/bin/CloneContext_1123022411.logCheck Clone Context logfile /u01/r12uat/apps/apps_st/comn/clone/bin/CloneContext_1123022411.log for details....--verifysubmit request - Active Users, check if normal completed and output there.Section 3: Finishing Tasks Update profile optionsRapid Clone updates only site level profile options. If any other profile options are set to instance specific values, you must update them manually.Update printer settingsIf the new cloned system needs to utilize different printers, update the target system with the new printer settings now.Update Workflow configuration settingsCloning an Oracle Applications instance will not update the host and instance-specific information used by Oracle Workflow. Review the tables and columns listed in Table 4 to check for any instance-specific data in the Workflow configuration on the target system. Verify the APPLCSF variable settingSource the APPS environment and review that the variable APPLCSF (identifying the top-level directory for concurrent manager log and output files) points to a suitable directory. To modify it, change the value of the s_applcsf variable in the context file and then run AutoConfig.Update the SESSION_COOKIE_DOMAIN value in ICX_PARAMETERSIf the target system is in a different domain name than the source system and SESSION_COOKIE_DOMAIN was not null in the source system, update that value to reflect the new domain name.Re-Implement SSL and SSO configurationIf the Source System was SSL or SSO enabled, and the Target is wished to be SSL or SSO enabled, then reconfigure the Target by following the SSL/SSO documentation. Otherwise, if the Target is wished to be non-SSL or non-SSO, then follow the same SSL/SSO documentation to undo the SSL/SSO setup.REF:Cloning Oracle Applications Release 12 with Rapid Clone [ID 406982.1]FROM MY BLOG: http://blog.csdn.net/t0nsha/article/details/8214791
--EOF--
4. What's the meaning of "options=nocompiledb" when doing adpatch ? when we may try to do this ?
Meaning:
Tells AutoPatch to automatically compile invalid objects in the database after running actions normally found in the database driver.Scenario:In cases where multiple non-merged patches are applied in a maintenance window, you can use nocompiledb to save time. However, merging multiple patches and applying a single merged patch is usually a better strategy.--EOF--