Author: techgoeasy

Step by step upgrade process to R12.2 Upgrade part -3

R12.2 Upgrade consists of following part Pre Upgrade preparation steps Main upgrade  using Main Upgrade Driver for R12.2.0 (merged with pre-installed Oracle E-Business Suite Consolidated Upgrade Patch for R12.2.0) Online Patching Enablement Applying the latest  R12.AD.C.Delta.n and R12.TXK.C.Delta.n Applying 12.2.n Release Update Pack (RUP) We have already taken care of part 1 and 2 in previous Post We are publishing the step 3 in this … Continue reading Step by step upgrade process to R12.2 Upgrade part -3 »

Step by step upgrade process to R12.2 Upgrade part -2

R12.2 Upgrade consists of following part Pre Upgrade preparation steps Main upgrade  using Main Upgrade Driver for R12.2.0 (merged with pre-installed Oracle E-Business Suite Consolidated Upgrade Patch for R12.2.0) Online Patching Enablement Applying the latest  R12.AD.C.Delta.n and R12.TXK.C.Delta.n Applying 12.2.n Release Update Pack (RUP) We have already taken care of part in previous Post We are publishing the step 2 in this part Main upgrade … Continue reading Step by step upgrade process to R12.2 Upgrade part -2 »

Step by step upgrade process for R12.2 Upgrade Part -1

R12.2 Upgrade consists of following part Pre Upgrade preparation steps Main upgrade  using Main Upgrade Driver for R12.2.0 (merged with pre-installed Oracle E-Business Suite Consolidated Upgrade Patch for R12.2.0) Online Patching Enablement Applying the latest  R12.AD.C.Delta.n and R12.TXK.C.Delta.n Applying 12.2.n Release Update Pack (RUP) We will be taking care of step 1 in this post.We will publish the other steps in seperate posts DOCUMENT REFERENCE … Continue reading Step by step upgrade process for R12.2 Upgrade Part -1 »

How to alter table add column oracle

-You Add a new column using the ALTER TABLE statement. – The table must be contained in your schema To alter a table, or you should either have  ALTER object privilege for the table or the ALTER ANY TABLE system privilege. -If a view, materialized view, trigger,  function-based index, check constraint, function, procedure of package depends on a base table, the alteration of the base table or its columns … Continue reading How to alter table add column oracle »

Top AWR useful queries for R12.2/R12.1 Upgrade

R12.1/R12.2 are pretty big  and time consuming upgrade. We need to find all the long running sql in order to resolve the  R12.2 upgrade performance issues. Since each iteration takes lot of time,it is important ,we tried to find out the performances issues in less iterations. Here are Top AWR useful queries to solve R12.2 upgrade performance issues If SQL is still in memory (cursor cache) the following … Continue reading Top AWR useful queries for R12.2/R12.1 Upgrade »

R12.2 RapidWiz Installed Components and System Requirements

R12.2 is the latest release of Oracle EBS. Here are R12.2 RapidWiz  Installed Components and System Requirements Technology Stack Components For a new Release 12.2 installation, Rapid Install automatically installs and configures the required technology stack components for both the database tier and the application tier. On the database tier, the technology stack includes: Oracle Database 12c Release 1 (12.1.0.2)  (  This is when we don’t … Continue reading R12.2 RapidWiz Installed Components and System Requirements »

Awesome Information on HOTPATCH mode in adop

What is Hotpatch mode in R12.0/R12.1 We add hotpatch to the adpatch option list to apply the patches in the environment without putting it into Maintainance Mode.  This  was quite widely used by the customer to apply the small patches to the environment. This seems to have worked in many cases with out issues. Customer upgrading to R12.2 may tend to use the same practice. … Continue reading Awesome Information on HOTPATCH mode in adop »

How to change the Web Port in EBS 12.2

As we all  know,httpd.conf configuration is managed by FMW  in R12.2, the method to change the webport is quite different in R12.2 Here are the steps to change Web Port in EBS 12.2 – Launch EM Console http://<s_wls_admin_host>.<s_wls_admin_domain>:<s_wls_adminport>/em) – Login as weblogic admin user (s_wls_admin_user) – Select the webtier instance from the Web Tier drop down – Select the Oracle HTTP server component and Advanced Configuration … Continue reading How to change the Web Port in EBS 12.2 »

Solaris OS parameter required for R12.2 Upgrade

R12.2 Upgrade on Solaris Operating requires the below prerequisites to be in place before starting with any upgrade steps Operating System Supported Versions The following table lists the supported operating system versions. Operating System Name Supported Version Oracle Solaris on SPARC (64-bit) 10 (5.10) – 9/10 (Update 9) or higher 1,2,6 Oracle Solaris on SPARC (64-bit) 11 (5.11) – 11.1, SRU 7, Build 5 (11.1.7.5.0) … Continue reading Solaris OS parameter required for R12.2 Upgrade »

EBS Data Model Comparison Report

Oracle provides the  EBS data model comparison report to view the static database object definition changes between two EBS releases Applicable Releases •Release 12.1.3 •Release 12.2.2 •Release 12.2.3 •Release 12.2.4 •Release 12.2.5 •Release 12.2.6 Benefits of EBS Data Model Comparison Report it help users to preview the database object definition changes before upgrading their instances from one release to another we can understand the impact of … Continue reading EBS Data Model Comparison Report »

How to resolve ORA-00904: invalid identifier

ORA-00904: invalid identifier is one of the common error seen. Reference: Oracle documentation One of the most common cause of this error Invalid identifier means the column name entered is either missing or invalid. It also Some time comes  when you used reserved word in Oracle database. Check List to resolve the ORA error  It comes when you put extra comma in the create table … Continue reading How to resolve ORA-00904: invalid identifier »

copy directory linux command examples

While working on project/development in Linux operation system , we often need to  backup the current working folder i.e copy directory .  We will be seeing here various ways to copy directory linux. Linux Operating system provides cp command to copy the files/directory from one place to another  and mv command to move the file/directory.I would explaining each command in details here with many examples … Continue reading copy directory linux command examples »