Sunday, December 27, 2020

Correct Way to Make Python3 Default on Linux

 Correct Way to Make Python3 Default on Linux


# update-alternatives --install /usr/bin/python python /usr/bin/python3 1

# update-alternatives --list|grep -i python

python  auto    /usr/bin/python3

# python
Python 3.6.8 (default, Oct  1 2020, 20:32:44)


Posted by at

Wednesday, December 2, 2020

EBS Upgrade Part 10 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

EBS Upgrade Part 10 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

Now the current state of the EBS and DB is 12.1.3 / 19c multi-tenant running on OEL6.

At this stage you can move upgrade the OS from OEL6 to OEL7 and then proceed further. If upgrade is not possible you can perform a outplace migration from OEL6 to OEL7 and then proceed further.

Upgrade from 12.1.3 to 12.2

  • Software / Patch Download and Software Staging
  • Source Environment Review
  • Backup
  • Gather Database Stats -- exec dbms_stats.gather_database_stats(estimate_percent => 15);
  • Implement fix : Fresh Install of EBS 12.2 File System Failed With RW-50004 On /tmp Directory (Doc ID 2311816.1) -- correct the file system
  • Gather System Stats  -- exec dbms_stats.gather_system_stats
  • Rapid Insall - Create Upgrade File System  
  • ETCC to the base 12.2 ( weblogic bsu slowness fixed by a patch)
  • Gather SYS, Fixed Object and Dictionary Statistics (required) -- Page 4-39 -- run this task and perform the validation
  • Gather Schema Stats - skip
  • Drop event alert triggers in custom schemas - no custom top prefixed with XX found - skipping this step
  • OATM verification - verified
  • Application DBA (AD) Tasks Matching - $AD_TOP/sql/adutconf.sql - skipping because version is 12.1.3
  • Oracle E-Business Suite Integrated SOA Gateway - skipping because integration is not in use
  • GUEST user_id - matching to 6 and end_date is null
  • Customer Relationship Management Tasks - does not apply to 12.1.3
  • Financials and Procurement Tasks - Advanced Collections - IEX module is Inactive in FND_APPLICATIONS
  • Financials and Procurement Tasks - Subledger Accounting - XLA.B.3 is Shared - apply Patch 13420532:R12.XLA.B for R12.1.x - Patched
  • Human Resource Management (HRMS) - Object Name : INSERT_POSITION_TXN_INFO -- modified the package from LONG to CLOB
  • Supply Chain Management Tasks - Install Base is Inactive --skipping
  • Supply Chain Management Tasks - Order Management is Shared -- affected column is with NON-NULL status --- verified
  • Supply Chain Management Tasks - Product Hub is Inactive --skipping
  • Supply Chain Management Tasks - Packing Hierarchy Structure Type --skipping
  • Supply Chain Management Tasks - Backing Up User Defined Attributes Data for Items --skipping
  • Supply Chain Management Tasks - Checking for Duplicate Records --validated , as per note and patch instructions there are no duplication rows
  • select 'exec dbms_ijob.broken('||job||',true);' from dba_jobs where broken='N';  , change db to spfile , restart , unlock all the locked stats table
  • Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1) - validation
  • create table bkup_dba_objects_pre_upg_122 as select * from dba_objects;
  • Disable AOL Audit Trail (conditional)
  • Shutdown Apps
  • Download PSU and Apply Latest PSU to Both the RAC Database [ p29141015_121020_Linux-x86-64.zip] and run datapatch post install
  • Install ETCC and Apply all Patches p29408621_12102190416_Linux-x86-64.zip
  • Run DB ETCC to verify recommendations
  • JDK 1.7 Upgrade
  • Init.ora verified
  • Set FAILED_LOGIN_ATTEMPTS to UNLIMITED
  • Maintenance Mode Enabled
  • Trigger Disabled
  • recycle bin verification
  • Apply AD 12.2 upgrade driver , merge with AD Consolidated Upgrade Patch , for adgrants.sql use the one from the merge driver folder + adadmin post install 
  • prepare the CPU + PreInstall driver and apply in preinstall mode
  • Review  tablespace  and TEMP
  • Apply known issues for 12.2 
  • Apply Consolidated Upgrade Patch 12.2.0 after merging with preinstall drivers 
  • create table bkup_dba_objects_post_upg_122 as select * from dba_objects; --- 263 invalids
  • Disable Maintenance Mode
  • DB appsutil and autoconfig
  • JRE on DB home
  • Configuring the Oracle E-Business Suite Release 12.2 Application Tier
  • Enable Online Patching , ETCC ( db only , mt done during staging )
  • Gather system stats
  • Apply GSCC patch and report review and fix violation action
  • create table bkup_dba_objects_post_adop_122 as select * from dba_objects;
  • Review and Extend APPS_TS_TX_DATA & APPS_TS_TX_IDX
  • Review and run the fix by note 2066607.1 for AD ZD invalid objects
  • Apply Online Patching adpatch
  • alter system set cluster_database=true scope=spfile; / srvctl stop database -d prod ; srvctl start database -p prod
  • Page 4-64 Database Initialization Parameters
  • Compile Invalids
  • page 4-62 GSCC reports
  • DB Parameters settings
  • AD and TXK for Release 12.2
  • RUP 12.2.10
  • Product Interoperatability Patch - oracle workflow


Post Upgrade Task

  • Start services , Health Check
  • Concurrent Manager Post Upgrade Programs
  • check for running job and make sure all finish
  • Obsolete Schema drop
  • Drop dangling synonyms
  • shutdown application
  • Online help patch 12.2.0
  • Online help patch 12.2.10


NLS task

  • apply base NLS patch 12.2.0
  • apply NLS and TXK AR patch
  • apply NLS patch 12.2.10
  • apply base NLS help patch 12.2.0 
  • apply base NLS help patch 12.2.10
  • wf patch


Post Upgrade Release Task

  • Application Customization Migration 
  • Additional Licensing
  • Patch 28984562  for workflow
  • Patch as per 2357700.1  for workflow
  • Connection Leak Patches
  • Instance Stabilization - oacore sizing 4 per node with 2gb heap , 2 forms servlet engine per node with 2gb heap
  • run fs_clone force=yes
  • Create Mainfest File for NLS
  • hrglobal
  • dummy cutover
  • Mailer Configuration
  • UTL Folder Update
  • Node Addition
  • LB Configuration
With this we are done with the upgrade to EBS 12.2 on Database 19c

Refer to the Index Page to see the full flow of the upgrade. 


Posted by at

EBS Upgrade Part 9 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

EBS Upgrade Part 9 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

Now the current state of the EBS and DB is 12.1.3 / 11.2.0.4 running on OEL6. Well to get to EBS 12.2 Database 19c there are two ways. 

  • The best way is to keep 11.2.0.4 database and upgrade EBS 12.1.3 to EBS 12.2. This is stable and kind of been done for some years now.
  • The recent supported way is to get the database upgrade to 19c multi-tenant architecture on EBS 12.1.3 and then run upgrade EBS to 12.2
Well the second is being certified but not many customers have gone through this in 2020. So I would suggest to choose option 1. But what if you are in EBS 12.1.3 and you have upgraded your database to 19c. You have to go through option 2.

So I have decided to go by Option 2 to see what is the complication.

Here are the steps involved to upgrade to 19c
  • Pre - Database Upgrade From 11.2.0.4 to 19c (19.3)
  • Database Installaion 19c (19.3)
  • Database Upgrade19c (19.3)
  • Post Database Upgrade19c (19.3)
  • Convert Database to Multitenant Architecture

Refer to the Index Page to see the full flow of the upgrade. 


Posted by at

EBS Upgrade Part 8 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

EBS Upgrade Part 8 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

Now we are in 12.1.1 , we can directly move to 12.1.3 or 12.2. This step can be differed if you want to move to 12.2

Upgrade Application 12.1.1 to 12.1.3

  • Complete Action as per Document 761570.1
  • Database Specific Patches Applied as per Document 761570.1
  • Upgrading to the OracleAS 10g 10.1.3.4  Doc ID 728531.1
  • Apply R12.AD.B.DELTA.3 Patch 9239089
  • mv /dev/random /dev/random_original;ln -s /dev/urandom /dev/random
  • Relink Error Fix 2057857.1
  • Use AutoPatch to apply  12.1.3 Patch 9239090 + post Patch
  • Online Help Patch 9239095
  • Apply Patch 9817770 and Patch 9966055
  • Run DB and MT Autoconfig with appsutil configuration
  • Run adpreclone on DB and MT
  • Disable Maintenance Mode
  • Start Services and Health Check
  • Gather Schema Stats - Run Now and Schedule Every Week
  • Configure Database RMAN and MT Backup

Post Upgrade 12.1.3 Open Issues

  • Missing System Administrator Responsibility for SYSADMIN , recompile JSP
  • CM Not Coming up , rebuild CM view using cpadmin
  • Slow Standard Manager , run GSS
  • Tablespace Space Addition
  • Apply Patch 9707056 as per 1559441.1
  • Apply patch as per Note 1581955.1 and 1489097.1
  • Set SGA to 8 GB , enable AMM
  • WF_DEFERRED rebuild as per 286394.1
  • WF_CONTROL rebuild as per 1663093.1
  • Start Workflow Agents
  • Run Bulk Responsibilities Sync Custom Program
  • Run Sync Workflow Concurrent Program
With this EBS 12.1.3 migration is completed. We can open the system for users. I am taking this forward to EBS 12.2

Refer to the Index Page to see the full flow of the upgrade. 

Posted by at

EBS Upgrade Part 7 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

 EBS Upgrade Part 7 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

Now we have moved database form 9i RHEL 4 to 11gR2 OEL 6. We should be good to start with the 12.1 Upgrade. The below procedure will help Upgrading Application from 11.5.9 to 12.1.1

  • Stage CD Creation
  • Source adjkey –initialize
  • Restart DB with 1000 as process parameter
  • Apply 11i.AD.I.6 , Superseeded by 11i.AD.I.7
  • Run TUMS utility , install patch 7705743 
  • Convert to Multiple Organizations architecture
  • Drop event alert triggers in custom schemas
  • Review sizes of old and new tablespaces
  • Run AD preparation scripts
  • Convert Oracle Alert E-mail Processing to the WF Mailer 
  • Customer Relationship Management Tasks
  • Incentive Compensation
  • TeleService
  • Mobile Field Service
  • Financials and Procurement Tasks
  • General Ledger
  • iPayments
  • Internet Expenses
  • Subledger Accounting
  • Leasing and Finance Management Tasks
  • Projects Tasks
  • Public Sector/University Tasks
  • Supply Chain Management Tasks
  • Depot Repair
  • Enterprise Asset Management
  • Process Manufacturing
  • Service Contracts
  • Drop MRC Schema
  • Enable Maintenance Mode
  • Gather schema statistics
  • Build Repo and  enable addons channel in .repo file
  • yum install oracle-ebs-server-R12-preinstall -y
  • mv /usr/bin/unzip /usr/bin/unzip-ver6
  • replace unzip with https://oss.oracle.com/el4/unzip/unzip.tar
  • Run Rapid Install to install the upgrade file system
  • Enable Maintenance Mode
  • Perform Task from 2057857.1 to avoid relink errors
  • Merge Upgrade Driver 7461070,9474320,9179588
  • ADPatch Merged Upgrade Driver from /u03/soft/upgrade_driver
  • Download Apply PreInstall patch as per Note : 1448102.2
  • mv /dev/random /dev/random_original;ln -s /dev/urandom /dev/random
  • SQL> GRANT UNLIMITED TABLESPACE TO apps and applsys
  • Apply PreInstall + u6678700.drv -- following Note : 1448102.2
  • Disable Maintenance Mode
  • Run Rapid Install to Configuration the Application 12.1.1
  • Apply FIx 879522.1
  • Copy JRE from MT to DB keep under appsutil folder
  • Perform Finish the Upgrade Task
  • Help Patch u6746000.drv
  • Backup

Refer to the Index Page to see the full flow of the upgrade. 

Posted by at

EBS Upgrade Part 6 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

EBS Upgrade Part 6 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

With the Database now running on OEL5 , the 11g Database did not open properly so decided to move to OEL6 server. Now follow the below procedure to migrate Database 11gR2 from OEL5 64Bit to OEL6 64Bit. 

  • Shutdown DB
  • Backup Database and OraData
  • Move Binaries from OEL5 to OEL6
  • Create User/Group and RPM/Kernel Settings
  • Unzip Oracle Home and OraData , Create User/Groups
  • Cloning an Oracle Home
  • Set Environment for SID EBSDB
  • Create spfile to pfile
  • Modify Refrences for file system mount
  • Create pfile from spfile
  • ReCreate Control File by taking trace
  • Validate Alert.log
  • Start Database
  • alter system set compatible='11.2.0.4' scope=spfile;
  • Restart Database and validate alert.log
  • alter system set optimizer_features_enable='11.2.0.4' scope=spfile;
  • Restart Database and validate alert.log
  • Configure Listener
  • Backup Database and OraData
  • Transfer and untar appsutil from 9i MT to 11g MT , NO Autoconfig
  • Update EBS 11.5.9 Context File with the New Database Hostname
  • Update /etc/hosts with the IP and Hostname
  • Run Autoconfig and verify logs for no errors
  • Validate apps login from MT 11.5.9
  • --DO NOT START APPLICATION 11.5.9 Services---
  • Shutdown DB and Apply 11.2.0.4 RDBMS patch ( 7 patches )

Refer to the Index Page to see the full flow of the upgrade. 

Posted by at

EBS Upgrade Part 5 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

 EBS Upgrade Part 5 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

Well now we are on OEL5.11 Server and this would be a best option to move 10g to 11gR2. Here are the below steps that was performed to Upgrade Database 10gR2 to 11gR2

  • Install 11.2.0.4 DB Home
  • Install Sample CD for 11.2.0.4
  • Create nls/data/9idata directory
  • Apply 11.2.0.4 RDBMS patch ( 7 patches )
  • Perform DB upgrade task as per note 1058763.1 (10-16)
  • Skip Post Upgrade Task -- will perform after moving to OEL 6

Refer to the Index Page to see the full flow of the upgrade. 

Posted by at

EBS Upgrade Part 4 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

EBS Upgrade Part 4 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

This is going to be challenging. These decisions involve a lot of understanding about the complexity underlying. So we are on 10g 32-bit on RHEL 4 and want to move to 11g. The best possible route after reading a bunch of oracle documentation came to a conclusion that will build a RHEL 5 OS and do a OS migration. Then post the migration decided to upgrade the database to 11g.

Well there was a limitation for me and may not for all. I need a RHEL 5 server which I do not have. So I had another laptop where I spinned off a Virtual Box and Installed a Guest OS 5.11.

Migrate Database 10gR2 from RHEL4 32Bit to OEL5 64Bit

  • Move the 10g64 Cold Backup RHEL to oel5 stage folder
  • Install RPM and Kernel Settings
  • Install Base 10.2.0.1 64 bit
  • Install Companion 10.2.0.1 64 bit
  • Install PatchSet 10.2.0.5
  • Backup Oracle Home
  • Copy OH,ORADATA,CONTROL file from 32bit to 64bit
  • Pretask for 64bit Migration
  • Set Environment ORACLE_HOME,ORACLE_SID,PATH
  • Migrate to 64bit - recreate control file
  • Recompile Invalids
  • Post Activity
  • Backup Oracle Home and OraData Cold Backup

Refer to the Index Page to see the full flow of the upgrade. 

Posted by at

EBS Upgrade Part 3 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

EBS Upgrade Part 3 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

Following Doc ID 761570.1 , Path A: Standard Upgrade Path , this path will take the database to 10g and then further to 11g

Upgrade Database from 9.2.0.8 to 10.2.0.5

  • Install base 10.2.0.1 and then Patch to 10.2.0.5
  • Migrate to Oracle Portal 10g - skip it
  • Backup Context File , Update not required as per Note
  • Export OLAP analytical workspaces
  • DBUA Upgrade will fail with java exceptions - go Manual
  • Follow Document 316889.1 for Manual Upgrade
  • Upgrade
  • Recompile Invalids
  • Post Upgrade Steps 
  • Backup

We are now at 10.2.0.5 and the next step is towards 11g. But wait RHEL 4 is 32 bit. What ? See you in the next post.

Refer to the Index Page to see the full flow of the upgrade.

Posted by at

EBS Upgrade Part 2 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

EBS Upgrade Part 2 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

Wow had a change to upgrade 9i database after a long time. 

Upgrade Database from 9.2.0.3 to 9.2.0.8

  • Download and Unzip p4547809_92080_LINUX.zip 32bit
  • Shutdown Application and Database
  • Backup 9.2.0.3 Oracle Home
  • Run 9.2.0.8 Patch Set Update on 9.2.0.3 Oracle Home
  • Complete Post Install Action on for Patch 4547809
  • Database and Server was Hung
  • Changed Database to NoArchive Log Mode
  • Restarted Post Install Action on for Patch 4547809
  • Restart Database and Recompile Invalids
  • Start Database and Application + Health Check
  • Cold Backup with all Service Down

We are now at 9.2.0.8 which is eligible for a direct upgrade to 10.2.0.5. In the next step I will be upgrading the database to 10g.

Refer to the Index Page to see the full flow of the upgrade.

Posted by at

EBS Upgrade Part 1 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

EBS Upgrade Part 1 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

The first step towards getting this insance up was to build a RHEL 4. Hmm this was a challenge to bring up a OS with RHEL 4 in 2020. So had a old laptop and got the OS up and running then did the below task to get the EBS 11.5.9 Up and Running

  • Validate and Untar DB and MT binaries
  • perl adcfgclone.pl dbTechStack
  • Manually Recover the Database , SID Change to EBSDB
  • perl adcfgclone.pl dbconfig
  • Database Validation
  • Update MT Stage Context File with Fix for IAS/8.0.6 Home
  • Update DB SID/Hostname in the Stage Context File
  • Fix instconf.drv and remove em entries and files
  • perl adcfgclone.pl appsTier
  • Post Cloning Start Fails - apply patch and relink all
  • Restart Services and Health Check

After restore figured out that the database is 9.2.0.3 and still needs a one layer up level to 9.2.0.4. In the next part I will be upgrading it. 

Refer to the Index Page to see the full flow of the upgrade.

Posted by at

EBS Upgrade 11.5.x Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7 - Index Page

EBS Upgrade 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

It is December and learning time. Was doing a cleanup of old drive and found a TAR Backup of Vision 11.5.9 with Database 9.2.0.3 which I took it 15 years back. I remember the Operating System was RHEL 4.

So this is what I am going to do ....

Going to take this instance to  EBS 12.2 Database 19c OEL 8

This page is going to be the Index Page and I will update all the links for the rest of the journey here. I hope this will help someone.

Index Page



Posted by at

Tuesday, December 1, 2020

EBS 12.1 and 12.2 + 19c Database Release

EBS 12.1 and 12.2 Product running 11.2.0.4 Database it is time to move forward to 19c Database Release.

19c CDB/PDB with EBS is a learning curve. Be it upgrade / migration / cloning -- we will have to face Container and Pluggable Database Feature.



So here is my recommendation to be competitive 

  • Read EBS PDB/CDB Documents on Support Website 
  • Read Cloning Documentation on Support Website
  • Next Level : Read RAC PDB/CDB for EBS
I am going to start a series of blog post on these topic. 

Reference Document

  • Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (Doc ID 2655839.2)
  • Using Oracle Database 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.1 (MOS Note 2530680.1)
  • Using Oracle 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.2 (Doc ID 2530665.1)
  • Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c (MOS Note 2580629.1)
  • Database Initialization Parameter Settings for Oracle E-Business Suite Release 12 (MOS Note 396009.1)
  • Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)
  • Cloning Oracle E-Business Suite Release 12.1 with Multitenant Database using Rapid Clone (Doc ID 2560690.1)
  • Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1)
  • Cloning Oracle E-Business Suite Release 12.2 RAC Enabled Systems with Rapid Clone (Doc ID 1679270.1)
  • Oracle E-Business Suite Release 12.1: Adding or Deleting 19c Oracle RAC Nodes (Doc ID 2617780.1)
  • Oracle E-Business Suite Release 12.2: Adding or Deleting 19c Oracle RAC Nodes (Doc ID 2608028.1)

Posted by at
Subscribe to: Posts (Atom)

Popular Posts