Upgrade 1. 1i to R1. PART 4 in 1. 1i to R1. Expert Oracle. This post is part 4 of the 1. R1. 2. 1. 3 upgrade series. For other parts click on below links. Install Fresh EBS 1. Linux 5 3. 2 Bit PART 1 in 1. R1. 2. 1. 3 upgrade series2 Upgrade database 9. PART 2 in 1. 1i to R1. HR0cDovL2Jsb2cuY3Nkbi5uZXQvc3RhcmljcXh5eg==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center' alt='Oracle Database 10G Release 2 10.2.0.5' title='Oracle Database 10G Release 2 10.2.0.5' />How ORACLE Uses Memory on AIX. Part 3 Locking SGA. In the previous post we discussed how ORACLE allocates shared memory for SGA in AIX and one of the conclusions was. Your Take on Oracle JDBC Drivers NEW Get Oracle JDBC drivers and UCP from the Oracle Maven Repository NEW1. Increase server cpus and ram. On the EBS R12. 1. Server it is good idea to increase RAMCPU so that upgrade process will go smooth. For fresh database with EBS, we. Split configuration Move 1. Database to Linux 6 6. Bit PART 3 in 1. R1. Upgrade 1. TO R1. PART 4 in 1. R1. 2. Upgrade R1. To R1. PART 5 in 1. R1. 2. The objective of the document is to provide all the required setup steps to upgrade EBS 1. R1. 2. 1. 1 version. We have already upgraded our EBS database to 1. EBS R1. 2. 1. 1. The technology stack installed on the R1. Oracle 1. 0g Application Server AS 1. Oracle 1. 0g Application Server AS 1. Oracle Developer 1. Creating a commaseparated list in Oracle SQL. Could use SYSCONNECTBYPATH, XMLELEMENT, SYSXMLAGG, SYSXMLGEN, LISTAGG, WMCONCAT. What to do first Verify your system with cluvfy Overview How can I avoid CW troubleshooting by reading GB of traces step 2 Overview CW startup sequence. DB10gR2-6-SelectConfigurationOption.gif' alt='Oracle Database 10G Release 2 10.2.0.5' title='Oracle Database 10G Release 2 10.2.0.5' />Oracle Forms Java J2. Download Essentials Of Health Policy And Law Second Edition'>Download Essentials Of Health Policy And Law Second Edition. SE native plug in 1. Java Developer Kit JDK 6. This post has been divided into below steps 1. Increase server cpus and ram. Clean up 1. 1i. 3. Convert from jinitiator to native sunoracle jre. Convert tablespace to oatm model. Increase tablespace size. Database upgrade requirements. Modify initialization parameters. Apply 1. 1i. ad. i. Verify temporary tablespace. Prepare an upgrade plan for customizations conditional1. Convert to multiple organizations architecture required1. Drop event alert triggers in custom schemas. Convert oracle alert e mail processing to the workflow notification mailer. Apply interoperability patches for oracle apps 1. Complete all functional steps. Execute the upgrade manual script tums1. Run ad preparation scripts. Gather schema statistics for cbo. Back up database, applications, and customizations recommended2. Stage r. 12. 1 linux x. Run rapid install required2. Ensure that Maintenance Mode is enabled. Apply AD 1. 2. 1. R1. 2. AD. B. 1 7. Apply additional patches in pre install mode. Apply solution from 1. UPGRADE FROM 1. 1. VERY SLOW XDOLOADER TASK HANGS Doc ID 1. Run the American English upgrade patch driver. Revoke solution from 1. UPGRADE FROM 1. 1. VERY SLOW XDOLOADER TASK HANGS Doc ID 1. Disable Maintenance Mode. Reset init. ora parameters. Back up Oracle E Business Suite. Configure and start server processes. Change Default Passwords. Re apply customizations. Re enable custom triggers, constraints, and indexes. Other System Administration Tasks. Install online help recommended3. Review Other Post Upgrade Tasks. ISSUES FACED1. Increase server cpus and ram. On the EBS R1. 2. Server it is good idea to increase RAMCPU so that upgrade process will go smooth. For fresh database with EBS, we used 4 CPUs and 1. GB RAM for both database and application on same server2. Clean up 1. 1i. Clean up 1. Archive old data if possible. Purge 1. 1i Run the oracle concurrent requestworkflow purge program. Use Purge Portal introduced in EBS 1. From System Administrator Responsibility go to OAM and then to PurgingCritical Activities3. Convert from jinitiator to native sunoracle jre. JInitiator is not certified or supported in R1. Already upgraded to JRE 1. Convert tablespace to OATM model. If not already done, Convert Tablespace to OATM model. OATM uses 1. 2 locally managed tablespaces for all products, including the temporary tablespace, system tablespace, and system managed undo SMU tablespace. We already have OATM model. SQL select TABLESPACENAME,STATUS,CONTENTS from dbatablespaces. TABLESPACENAME STATUS CONTENTS. SYSTEM ONLINE PERMANENT. CTXD ONLINE PERMANENT. OWAPUB ONLINE PERMANENT. TEMP ONLINE TEMPORARY. ODM ONLINE PERMANENT. PORTAL ONLINE PERMANENT. APPSUNDOTS1 ONLINE UNDO. APPSTSTXDATA ONLINE PERMANENT. APPSTSTXIDX ONLINE PERMANENT. APPSTSSEED ONLINE PERMANENT. APPSTSINTERFACE ONLINE PERMANENT. APPSTSSUMMARY ONLINE PERMANENT. APPSTSNOLOGGING ONLINE PERMANENT. APPSTSARCHIVE ONLINE PERMANENT. APPSTSQUEUES ONLINE PERMANENT. APPSTSMEDIA ONLINE PERMANENT. OLAP ONLINE PERMANENT. APPSTSTOOLS ONLINE PERMANENT. SYSAUX ONLINE PERMANENT. Increase tablespace size. Expect database size to grow by 2. We increased tablespace size for some of the tablespaces which were low on disk space. Also you can make datafiles auto extend ON Run. SELECT alter database datafile filename autoextend on from dbadatafiles 6. Database upgrade requirements. WE ALREADY UPGRADED TO 1. Modify initialization parameters Remove dbfilemultiblockreadcount parameter. DO NOT RESTORE THIS PARAMETER AFTER THE UPGRADE. Keep dbfileoptimizerreadcount. The default setting is 8. Do not change this parameter. Keep jobqueueprocesses Number of CPUs Keep parallelmaxservers 2 Number of CPUs Keep recyclebinOFFDatabase needs to be restarted for making recyclebinOFF. Also run below command to purge. SQL select owner, count from dbarecyclebin group by owner. SQL purge recyclebin 8. Apply 1. 1i. ad. i. ALREADY APPLIED 1. I. AD. I. 7  in previous post of this series. Verify temporary tablespace. TEMP tablespace should be a locally managed tablespace with a uniform allocation size. If the temporary tablespace is not defined in this way, drop the temporary tablespace and recreate it using the following example as a template Verify SQL select CONTENTS,EXTENTMANAGEMENT,ALLOCATIONTYPE from dbatablespaces where tablespacenameTEMP The query output should be. Contents EXTENTMANAGEMENT ALLOCATIONTYPE. TEMPORARY LOCAL UNIFORMIf not SQL drop tablespace TEMP. SQL create TEMPORARY tablespace TEMP tempfile tsptemp. M EXTENT MANAGEMENT LOCAL. UNIFORM SIZE 1. M To verify that the temporary tablespace has been created, run the following SQL select CONTENTS,EXTENTMANAGEMENT,ALLOCATIONTYPE from dbatablespaces where tablespacenameTEMP After the upgrade, restore the previous storage parameters for the temporary tablespaceand lower the extent size for the temporary tablespace to a value that is less than 1 MBfor example, 1. K. IN OUR CASE WE ALREADY HAVE THE CORRECT TEMP TABLESPACE. Prepare an upgrade plan for customizations conditionalDeveloper team should look into this step and prepare a plan. Convert to multiple organizations architecture requiredConverting to Multiple Organizations does not require you to use multiple operating units or sets of books, but it does enable you to use these features if you desire. Converting to Multiple Organizations does not produce any noticeable change in behavior if you do not define multiple operating units andor sets of books, the conversion is transparent to users. Feeling Sick After Smoking Crack While Pregnant. Below is how we enabled Multi Org just for testing in our 1. STEP A Define at least one Operating Unit. Define at least one Operating Unit, and set the profile option, MO Operating Unit ORGID at Site level, to that Operating Units value. We only have one seeded organization defined. SQL Select ORGANIZATIONID from HRALLORGANIZATIONUNITS. ORGANIZATIONID. . Verify. ORGID profile is blank as of now. SQL select fndprofile. ORGID from dual No rows selected or NULL value. Enable the profile to be updatable. SQL update fndprofileoptions. Y, respenabledflag Y, userenabledflag Y where profileoptionname ORGID and startdateactive lt sysdate and nvlenddateactive, sysdate sysdate 3 Set the profile option DECLARE stat boolean. BEGIN dbmsoutput. FNDPROFILE. SAVEORGID, 0, SITE. IF stat THEN dbmsoutput. Stat TRUE profile updated. ELSE dbmsoutput. Stat FALSE profile NOT updated. END 4 Verify again. SQL select fndprofile.