Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Tuesday, January 05, 2010

Oracle Applications Upgrade to 12.1.2

Pre-requisites:

Applications should be of 12.1.1


For upgrading Oracle Applications from12.0.x to 12.1.1 please refer my blogpost


http://balajiabhi.blogspot.com/2009/07/upgrade-oracle-e-business-suite-1205-to.html


Web OH should be above 10.1.3.4


Step:1

Download AD_B_2 (8502056)


Download R121RUP2 (7303033)


Download Online Help patch (7303032)


Step:2


Apply 8502056:


Copy adgrants.sql from admin directory of the patch directory and copy to Database Oracle HOME/appsutil/admin


Source the Database environment file:


Run adgrants.sql as


Sqlplus /nolog


@adgrants.sql APPS


Source the Application Environment file


Apply the unified driver of 8502056 on the Application tier using adpatch


Be Sure that you have WEB_OH as 10.1.3.4 and above.


You can see that in WEB_OH (ORACLE_APPS_BASE/apps/tech_st/10.1.3/config/ias.properties) version.


Step 3:


Apply 7303033 using adpatch with default options.


  • Be sure that you have enough space in APPS_TS_TX_DATA and APPS_TS_TX_IDX before starting the patch application.

After application of patch 7303033, it is advised to apply the online Help patch no. 7303032 using adpatch with default options


After application of these patches,


Please run autoconfig on the apps Tier and then make the appsutil.zip file from $AD_TOP/bin/perl

admkappsutil.pl


Copy the file to the $RDBMS_ORACLE_HOME and unzip the file.


Run autoconfig on the Database Tier.


It is mandatory to do a preclone on both the tiers which will enable to create a new clone directory structures during cloning.


Startup the instance.


Verify the upgrade using apps account in the backend


SQL> select release_name from FND_PRODUCT_GROUPS;


RELEASE_NAME

--------------------------------------------------

12.1.2


SQL>


Front end:



From the Forms:






Issues:


One object becomes invalid after application of the main patch.


OBJECT_NAME OWNER OBJECT_TYPE


------------------------------ ------------------- ----------------------------------

PA_PWP_SUMM_PKG APPS PACKAGE BODY


When you try to compile the object manually as apps, we got the following error:


SQL> alter package PA_PWP_SUMM_PKG compile body;


Warning: Package Body altered with compilation errors.


SQL> show err


Errors for PACKAGE BODY PA_PWP_SUMM_PKG:


LINE/COL ERROR

-------- -----------------------------------------------------------------

342/1 PL/SQL: SQL Statement ignored

375/10 PL/SQL: ORA-00942: table or view does not exist



I raised SR against this error. Let me update any fix for this. Until now, the upgrade is uneventful.


Cheers!!!!

Saturday, January 02, 2010

ORA-00001: unique constraint (APPLSYS.AD_SNAPSHOT_FILES_U2) violated in R12 (12.1.1)

Happy and Prosperous New Year 2010!!!

Today I need to discuss an issue while planning to upgrade my 12.1.1 instance to 12.1.2 using the patch 7303033 released recently by Oracle.

While updating the snapshot information through adadmin, i got the error as follows:

AD Administration error:
adusnapUpdateGlobalView(): Error while executing statement

AD Administration error:
ORA-00001: unique constraint (APPLSYS.AD_SNAPSHOT_FILES_U2) violated
ORA-06512: at "APPS.AD_FILE_UTIL", line 2535
ORA-06512: at line 3


AD Administration error:
adusnapStoreInDB(): Error calling adusnapUpdateGlobalView()

Failed to store APPL_TOP Snapshot to tables
adusnapMaintainSnapshot() : Error calling adusnapUpdateCurrentView2()
Error calling adusnapPartialCurVw()
Error calling adusnapMaintainSnapshot

Fix:
use the sql as below as apps user:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select distinct(snapshot_id) from ad_snapshot_files;

SNAPSHOT_ID
-----------
129
128
132
-130
130
131

6 rows selected.

SQL>
Note, the negative number -130, we need to delete the entry and retry with adadmin

SQL> delete from ad_snapshot_files where snapshot_id=-130;

84196 rows deleted.

SQL>

Rerun adadmin, it should continue normally.

Cheers!!!
Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Labels

11.5.1. to 11.5.5 Cloning Procedure. 11g 11i 11i and R12 11i Autoconfig 11i Cloning 12.1.1 SSL 2 Node RAC Adconfig.sh errors out adgennls.pl adop Advanced Replication Apache version Apex Apex for Oracle database Apex Installation Apex Installation on Oracle E Business Suite. 11i with Apex Apex on 11i Apex on Oracle 11i Apex402 apexins.sql APPL_TOP Character Application Express Application server Issue APPLSYS password Apps Password Asynchronous Replication Autoconfig Autoconfig Managed Beehive Bit of operating system Block block media corrupt BPEL Central Inventory Character Set Conversion Cloning of 11i Cloning of Oracle Applications Clusterware Concurrent CPU 2011 CPU 2012 April CPU 2012 January. CPU 2012 October CRS custom top Custom Top Creation Database . Database Query Dataguard DBMS_REPAIR Demantra . Domain Name E Business Suite Migration EBS 12.2 EPM exp/imp Oracle Applications Flashback table flows_020200 FND_TOP/resource FNDCPASS FNDCPUCF Forms server upgrade Forms startup FRM-92101 Fusion Middleware Hostname Hot Backup Hot cloning HotBackup Hotbackup Cloning of Oracle Apps hrglobal.drv. NLS Saudi Arabian HRMS hyperion Import and Export Oracle Applications Install Oracle Installation of R12 Installation Steps integration Oracle EBS Issues Database issues Oracle EBS Issues with Upgrade 12.1.1 Java Mission Control Java Upgrade java/sql/SavePoint JInitiator Junk Characters Language Translation Linux Linux Migration listener trace Listner version Local Inventory Login Page Master-Master Replication Memory Tuning Multiple Language NLS Non-Autoconfig Enabled OBIEE 11g Installation OBIEE Issues OIM Opatch version OpenSSL ora-01031 Oracle oracle 11g Oracle Announcement Oracle Application servers Oracle Application services Oracle Applications Oracle Applications 11i oracle applications 12.2 Oracle Applications Cloning Oracle Applications Upgrade Oracle Applications. Oracle Apps cloning Oracle BPEL oracle certifications oracle database Oracle Database RMAN Oracle Database upgradation Oracle DB oracle E Business suite 12.2 Oracle EBS oracle EPM Oracle Forms Logo oracle Fusion Applications Oracle Inventory oracle news Oracle OUI Oracle R12 oracle Sun Solaris Oracle Tuning Oracle Virtual Box Oracle Webgate Oracle WMA configuration orcladmin password for Oracle Applications Pasta Configuration pasta.cfg patch PDF Performance Physical Standby Platform migration Printer Configuration Profile Option R12 RAC Rapid Install Rapidwiz Real Application Clusters 10g Recovery RMAN RMAN Recovery SA Gosi Service Oriented Architecture SOA SQLTXPLAIN SSL Configuration step-by-step upgrade Sun solaris Swap Tablespace Trace Enable Trace file Translation Synchronization Patch transport tablespace tuning Tuning SGA uifont.ali Underscore Universal Content Management updates.oracle.com Upgradation of 12.0.5 to 12.1.1 Upgrade Upgrade 11g Upgrade Apps Upgrade DB Upgrade to 11g UTF8 version of oracle applications versions Web server upgrade weblogic windows workflow version XML Publisher version