14 March 2012

Step by Step Upgradation of Oracle EBS 11.5.10.2 to R12.1.1 on Linux 32bit Part -2

Db Upgradation Steps   Click here





















 

Apply TUMS patch 7705743

[oracle@ebus 11.5.0]$ cd /disk2/TEST/testappl/ad/11.5.0/patch/115/sql/
[oracle@ebus sql]$ sqlplus apps/apps @adtums.sql

SQL*Plus: Release 8.0.6.0.0 - Production on Mon Feb 20 11:43:05 2012

(c) Copyright 1999 Oracle Corporation.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

DOC>*==========================================================================*
DOC>|               Copyright (c) 2001 Oracle Corporation                      |
DOC>|                       All rights reserved.                               |
DOC>*==========================================================================*/
Enter value for 1: /usr/tmp

PL/SQL procedure successfully completed.

Commit complete.

Input truncated to 5 characters
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ebus sql]$

Review TUMS log file

Apply below patch 7197489

[oracle@ebus 7197489]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 20 11:57:14 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @adgncons.sql
Enter value for 1: apps
Enter value for 2: apps
Connected.

Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ebus dbhome_1]$ mkdir dbf
[oracle@ebus dbhome_1]$ cd -
/oracle/patches/7197489
[oracle@ebus 7197489]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 20 11:59:13 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @adcrtbsp.sql
Enter password for SYSTEM:
Connected.

Tablespace created.


Tablespace created.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ebus 7197489]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 20 12:02:00 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @adgrants.sql
Connected.
---------------------------------------------------
--- adgrants.sql started at 2012-02-20 12:02:03 ---

Creating PL/SQL profiler objects.

---------------------------------------------------
--- profload.sql started at 2012-02-20 12:02:03 ---
Package created.
Grant succeeded.
Synonym created.
Library created.
Package body created.

Testing for correct installation
SYS.DBMS_PROFILER successfully loaded.

PL/SQL procedure successfully completed.
-----------------------------------------------------
--- profload.sql completed at 2012-02-20 12:02:03 ---
--------------------------------------------------
--- proftab.sql started at 2012-02-20 12:02:03 ---

Table dropped.

Table dropped.


Table dropped.


Sequence dropped.


Table created.


Comment created.


Table created.


Comment created.


Table created.


Comment created.


Sequence created.
-----------------------------------------------------
--- profltab.sql completed at 2012-02-20 12:02:04 ---


Creating PL/SQL Package AD_DBMS_METADATA.


Package created.


Package body created.


End of Creating PL/SQL Package AD_DBMS_METADATA.

Enter value for 1: apps

PL/SQL procedure successfully completed.


Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ebus 7197489]$


Apply 4684603 Patch

Error:-
Start time for file is: Tue Feb 21 2012 14:30:15

sqlplus -s APPS/***** @/disk2/TEST11/apps/apps_st/appl/amv/12.0.0/patch/115/sql/amviccd.sql &un_amv &pw_amv
Connected.
DECLARE
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11422: linguistic initialization failed
DRG-11446: supplied knowledge base file
/disk2/PROD11/prod11db/11.2.0/dbhome_1/ctx/data/enlx/droldUS.dat not installed
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366
ORA-06512: at "SYS.DBMS_SQL", line 1053
ORA-06512: at line 56

Reference :-

1. Download the Oracle Examples Installation (formally Companion CD)

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html

2. Unzip the Oracle Examples Installation

$ unzip linux.x64_11gR2_examples.zip

3. Goto the location in the installation media for the CTX Filegroups

$ cd examples/stage/Components/oracle.ctx.companion/11.2.0.1.0/1/DataFiles

4. unzip the CTX Knowledge base files

$ unzip filegroup1.jar
Archive: filegroup1.jar
inflating: ctx/data/enlx/drofdUS.dat
inflating: ctx/data/enlx/drofiUS.dat
inflating: ctx/data/enlx/droldUS.dat
inflating: ctx/data/enlx/droliUS.dat
inflating: ctx/data/enlx/drolkUS.dat
inflating: ctx/data/enlx/drolsUS.dat

5. Goto the location of the knowledge base files we just extracted and copy them to the Oracle Database Home location

$ cd ctx/data/enlx/
$ cp * $ORACLE_HOME/ctx/data/enlx

[oracle@ebus enlx]$ cp -r DataFiles/ctx/data/enlx/dro
drofdUS.dat  drofiUS.dat  droldUS.dat  droliUS.dat  drolkUS.dat  drolsUS.dat
[oracle@ebus enlx]$ cp -r DataFiles/ctx/data/enlx/dro* .
[oracle@ebus enlx]$ ls
DataFiles  dren.ds  dren.is  drofdUS.dat  drofiUS.dat  droldUS.dat  droliUS.dat  drolkUS.dat  drolsUS.dat
[oracle@ebus enlx]$

Result :-

    Fixed: file amviccn.sql  on worker  1 for product amv username AMV.
Restarted: file amviccd.sql  on worker  3 for product amv username AMV.

Error:-

   FAILED: file jtfiaibu.sql on worker  4 for product jtf username JTF.
 Deferred: file jtfiaibu.sql on worker  4 for product jtf username JTF.               (Deferment number 2 for this job)
 Assigned: file jtfiaibu.sql on worker  1 for product jtf username JTF.
   FAILED: file jtfiaibu.sql on worker  1 for product jtf username JTF.

ATTENTION: All workers either have failed or are waiting:

           FAILED: file jtfiaibu.sql on worker  1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Solution:-

[oracle@ebus log]$ . /disk2/PROD11/prod11db/11.2.0/dbhome_1/profile
[oracle@ebus log]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 21 16:03:06 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public')

PL/SQL procedure successfully completed.

SQL>

Result:-

Restarted: file jtfiaibu.sql on worker  1 for product jtf username JTF.
Completed: file jtfiaibu.sql on worker  1 for product jtf username JTF.

ERROR:FNDLOAD

Solution:
Manually load the fndload and skip the worker and restart all the worker.

Uploading from the data file /disk2/TEST11/apps/apps_st/appl/ams/12.0.0/patch/115/import/US/amscitem.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/disk2/TEST11/apps/apps_st/appl/ibc/12.0.0/patch/115/import/ibccitem.lct, /disk2/TEST11/apps/apps_st/appl/ams/12.0.0/patch/115/import/US/amscitem.ldt) to staging tables
Dumping LCT file /disk2/TEST11/apps/apps_st/appl/ibc/12.0.0/patch/115/import/ibccitem.lct into FND_SEED_STAGE_CONFIG
Dumping LDT file /disk2/TEST11/apps/apps_st/appl/ams/12.0.0/patch/115/import/US/amscitem.ldt into FND_SEED_STAGE_ENTITY
A database error occurred:
  ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

The error occurred while executing the following statement:
  INSERT INTO FND_SEED_STAGE_ENTITY (SEQ, CONFIG_ID, TOP_ENTITY_SEQ, LAST_DB_UPDATED_BY, LAST_DB_UPDATE_DATE, LAST_FILE_UPDATED_BY, LAST_FILE_UPDATE_DATE, ACTION, EXEC_STATUS, COMMIT_FLAG, BIND_VAR_METADATA, PARENT_PK_VALUE ,BIND_VALUE0 ,BIND_VALUE1 ,BIND_VALUE2 ,BIND_VALUE3 ,BIND_VALUE4 ,BIND_VALUE5 ,BIND_VALUE6 ,BIND_VALUE7 ,BIND_VALUE8 ,BIND_VALUE9 ,BIND_VALUE10 ,BIND_VALUE11 ,BIND_VALUE12 ,BIND_VALUE13 ,BIND_VALUE14 ,BIND_VALUE15 ,BIND_VALUE16 ,BIND_VALUE17 ,BIND_VALUE18 ,BIND_VALUE19 ,BIND_VALUE20 ,BIND_VALUE21 ,BIND_VALUE22 ,BIND_VALUE23 ,BIND_VALUE24 ,BIND_VALUE25 ,BIND_VALUE26 ,BIND_VALUE27 ,BIND_VALUE28 ,BIND_VALUE29 ,BIND_VALUE30) VALUES (:seq, :config_id, :top_entity_seq, NULL, NULL, NULL, NULL, 'IGNORE', '0', NULL, :bvar_metadata, :parent_pk_value ,:bind_value0 ,:bind_value1 ,:bind_value2 ,:bind_value3 ,:bind_value4 ,:bind_value5 ,:bind_value6 ,:bind_value7 ,:bind_value8 ,:bind_value9 ,:bind_value10 ,:bind_value11 ,:bind_value12 ,:bind_value13 ,:bind_value14 ,:bind_value15 ,:bind_value16 ,:bind_value17 ,:bind_value18 ,:bind_value19 ,:bind_value20 ,:bind_value21 ,:bind_value22 ,:bind_value23 ,:bind_value24 ,:bind_value25 ,:bind_value26 ,:bind_value27 ,:bind_value28 ,:bind_value29 ,:bind_value30)


Concurrent request completed
Current system time is Mon Feb 27 13:46:53 2012

Solution :-

oracle@ebus driver]$ export NLS_LANG=American_America.UTF8

oracle@ebus driver]$FNDLOAD APPS/APPS 0 Y UPLOAD @IBC:patch/115/import/ibccitem.lct @AMS:patch/115/import/US/amscitem.ldt -
Log filename : L243594.log


Report filename : O243594.out
[oracle@ebus driver]$

Error:-
  FAILED: file pyusupprocruleoi.sql on worker  3 for product pay username HR.
   FAILED: file jtftkhis.sql on worker  1 for product jtf username JTF.

Reference:-

Script Czhist.Sql Fails During Application Of Patch 6678700 [ID 1281478.1

Solution:-
[oracle@ebus log]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 28 09:46:42 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('APPLSYS','FND_STATTAB');

PL/SQL procedure successfully completed.

SQL>

Result:-

Restarted: file jtftkhis.sql on worker  1 for product jtf username JTF.
Restarted: file pyusupprocruleoi.sql on worker  3 for product pay username HR.
Completed: file jtftkhis.sql on worker  1 for product jtf username JTF.


[oracle@ebus bin]$ perl adbldxml.pl appsuser=apps appspass=apps jtop=/disk2/PROD11/prod11db/11.2.0/dbhome_1/jre/

Starting context file generation for db tier..
Using JVM from /disk2/PROD11/prod11db/11.2.0/dbhome_1/jre//bin/java to execute java programs..

The log file for this adbldxml session is located at:
/disk2/PROD11/prod11db/11.2.0/dbhome_1/appsutil/log/adbldxml_03011242.log

The context file has been created at:
/disk2/PROD11/prod11db/11.2.0/dbhome_1/appsutil/TEST_ebus.xml
[oracle@ebus bin]$

Part 3   Click here

No comments: