Ansible Tutorial in Japanese. Setup Wordpress server and check with ServerSpec. 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. Split configuration Move 1. Database to Linux 6 6. Yum Install Httpd No Package Httpd Available On The App' title='Yum Install Httpd No Package Httpd Available On The App' />Or How I spent the Saturday of Labor Day weekend. Because it was so hot outside, I decided to do some server maintenance. Used yum and the ius repository to. Narrator RPM is used to install local software packages. Once a package is installed, the RPM package database is updated with the package information. Configure Oracle Clients for LDAP. The next step is to setup the Oracle Net configuration files on the client for net service name resolution through LDAP. 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. Who should read this book This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and. To run require libcurldev or libcurldevelon rpm linux based git clone httpsgithub. CoolerVoid0d1n need libcurl to run sudo aptget install libcurldev. Oracle 1. 0g Application Server AS 1. Oracle 1. 0g Application Server AS 1. Oracle Developer 1. Oracle Forms Java J2. 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. Medium Robbins Pathology Free: Full Version Software. 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. 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. ORGID from dual. FNDPROFILE. VALUESPECIFICORGID. Now it shows value as 0. STEP B Run Convert to Multi Org process. Go to Adadmin Maintain Applications Database Entities menu Convert to Multi Org. This step can take some time.