Let me share a list of issues I faced when migrating a single node Oracle ebs r12.1.3 environment from Linux x86_64 to multinode Solaris SPARC machines. I have already shared ppt that was point of discussion before migration.
Please note that below is set of issues and respective solutions while migration. I have not covered steps for migration in this post. I would also like to share list of references from metalink that were very handy during complete migration process.
·
Export/import
process for 12.0 or 12.1 using 11gR1 or 11gR2 (Doc ID 741818.1)
-
This
document will be primarily used for database migration.
·
Application Tier
Platform Migration with Oracle E-Business Suite Release 12 (Doc ID 438086.1)
-
Apps
tier will be migrated referring above document.
·
Using AutoConfig
to Manage System Configurations in Oracle E-Business Suite Release 12 (Doc ID
387859.1)
-
We will be using this document to generate context file and executing
autoconfig successfully.
·
Upgrading to the
Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12
(Doc ID 454811.1)
-
Referred
for IAS_HOME upgrade
·
R12.1.1 : Oracle
E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Oracle
Solaris on SPARC (64-bit) - Doc ID 761568.1
1.1. Appendix 1a
Error Details –
22:57:15 SQL> exec
ctx_ddl.sync_index('IBC.IBC_ATTRIBUTE_BUNDLES_CTX');
BEGIN ctx_ddl.sync_index('IBC.IBC_ATTRIBUTE_BUNDLES_CTX');
END;
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-11422: linguistic initialization
failed
DRG-11446: supplied knowledge base file
/u02/oracle/ERPDEV/db/11.2.0/ctx/data/enlx/droldUS.dat
not installed
ORA-06512: at "CTXSYS.DRUE",
line 160
ORA-06512: at "CTXSYS.CTX_DDL",
line 948
ORA-06512: at line 1
References –
Solution –
a. Download the
Oracle Examples Installation (formally Companion CD)
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html
b. Unzip the
Oracle Examples Installation
$ unzip
linux.x64_11gR2_examples.zip
c. Go to the
location in the installation media for the CTX File groups
$ cd
examples/stage/Components/oracle.ctx.companion/11.2.0.1.0/1/DataFiles
d. 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
e. Go to 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
1.2. Appendix 1b
Error Details –
Enter value for 1:
Enter value for 2: Enter value for 3: ERROR:
ORA-12705: Cannot
access NLS data files or invalid environment specified
References –
AutoConfig is Failing with status 4 for a
New Database with NLS Environment Error ORA-12705 (Doc ID 1612017.1)
Solution –
1. Run the $ORACLE_HOME/nls/data/old/cr9idata.pl script to
create the $ORACLE_HOME/nls/data/9idata directory.
2. After creating the directory, make sure that the ORA_NLS10 environment variable is set to the full path of the 9idata directory whenever you enable the 11g Oracle home.
3. Verify there are files in 9idata directory.
2. After creating the directory, make sure that the ORA_NLS10 environment variable is set to the full path of the 9idata directory whenever you enable the 11g Oracle home.
3. Verify there are files in 9idata directory.
4. export
ORA_NLS10=/u01/oratst/ERPDEV/db/11.2.0/nls/data/9idata.
1.3.
Appendix 1c
Error Details –
Logfile - $INST_TOP/logs
Unzip Count:83
Processing Disk1....
RC-20200: Fatal: Could not find Unzip. At this time
only Native UnZip 5.X is supported.
Please make sure you have UnZip 5.X in your path and
try again...
Cannot execute install of Applications Technology
Stack
References –
Rapidwiz
Fails with error: RC-20200: Fatal: Could not find Unzip (Doc ID 858844.1)
https://community.oracle.com/message/11581966#11581966
Solution 1 –
1.
Update StartCD by renaming current one present in
Stage directory (/backup/R12.1.1_Dump/StageR12)
2.
Copy and unzip patch p8639046_R12_GENERIC.zip. This should
overwrite files present in StartCD
Solution 2 –
1.
Upgrade unzip
version present under /root/unzip541
1.4.
Appendix 1d
Error Details –
While applying patch - 16778382 on 10.1.2
HOME for ebs r12.1.3 env.
ld: warning: file libucrypto.so.1:
required by /usr/lib/libnsl.so, not found
Undefined first referenced
symbol in file
MD5Init /usr/lib/libnsl.so
MD5Final /usr/lib/libnsl.so
MD5Update /usr/lib/libnsl.so
ld: fatal: symbol referencing errors
make: Fatal error: Command failed for
target `/u01/appltst/ERPDEV/apps/tech_st/10.1.2/lib3
2/librw.so'
References –
http://erman-arslan-s-oracle-forum-read-only-until-june-12.2340467.n4.nabble.com/Reports-td3613.html
Solution 2 –
This was resolved after setting in
.profile on apps node-
export LD_OPTIONS="-L/lib
-L/lib/sparcv9"
1.5.
Appendix 1e
One-off patches failed with below error.
"Run One-off Generic OPatches"
configuration assistant has failed.
NOTE: this issue can be avoided with
fixing patch with 8920270
Solution –
1) Make a backup of the file
$ORACLE_HOME/config/run_opatch_generic.sh
cd $ORACLE_HOME/config
cp run_opatch_generic.sh run_opatch_generic.sh.pre8920270
2) Edit the $ORACLE_HOME/config/run_opatch_generic.sh
and add the line
"-ocmrf
<$ORACLE_HOME>/config/ias.properties" immediately after the -silent
switch. i.e.
#!/bin/sh
#
#opatch apply -silent -oh
<ORACLE_HOME> -invPtrLoc <OH/oraInst.loc> <opatch dir>#
#
<oracle_home>/OPatch/opatch apply
-silent -ocmrf <oracle_home>/config/ias.properties -oh
<oracle_home> -invPtrLoc <oracle_home>/oraInst.loc
<oracle_home>/opatches/4601861
if [ "$?" != "0" ];
then
echo "OPatch did not complete
successfully..."
exit 1
fi
3) Make a backup of the file
$ORACLE_HOME/config/run_opatch.sh
cd $ORACLE_HOME/config
cp run_opatch.sh run_opatch.sh.pre8920270
4) Edit the
$ORACLE_HOME/config/run_opatch.sh and add the line
"-ocmrf
<$ORACLE_HOME>/config/ias.properties" immediately after the -silent
switch.
5) If this is a GUI install then retry the
configuration assistant "Run One-off Generic OPatches". For a failure
in the silent install
a) Set the LD_LIBRARY_PATH
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib
b) Set the PERL5LIB
export
PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1:$PERL5LIB
6) Try “Run One-off Generic OPatches”
again.
1.6.
Appendix 1f
Error Details –
References –
Wrong Source
Reference In Inventory Comps.Xml (Doc ID 580306.1)
R12.x COPYRETRY
Error occurs writing to file dsaServer.sh when applying IAS patch 8626084 (Doc
ID 1086315.1)
Solution -
cd $IAS_OH/inventory/ContentsXML
cp comps.xml comps.xml25mar2019
sed
"s#/d4/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3#/u01/appltst/ERPDEV/apps/tech_st/10.1.3#g"
comps.xml > comps_fixed.xml
View comps_fixed.xml
file and after validation, replace it with original comps.xml file.
mv comps_fixed.xml
comps.xml
1.7.
Appendix 1g
Error Details –
Start opmn
services before upgrading IAS_OH.
./adopmnctl
startall
1.8.
Appendix 1h
Error Details –
Error Snippet from
Apache log -
--------
19/03/27 23:08:05
Start process
--------
Can't stat
executable
/u01/appltst/ERPDEV/inst/apps/ERPDEV_erpmgntstapp/ora/10.1.3/Apache/Apache/bin/.apachectl
Reference –
SR 3-19706670330 : Spin-off for SR
3-19705183621: Can't stat executable .apachectl
Solution
–
1. Download and review the readme of Patch 12722501.
/mig_backup/dev_bkp/apache_issue_patch_solaris/p12722501_101350_SOLARIS
2. Apply patch 12722501 in Oracle Application
Server 10.1.3.5 Oracle Home
using OPatch after a backup.
3. Run AutoConfig (adautocfg.sh) on the
application tier.
1.9.
Appendix 1i
Error Details –
The Export Extraction feature is not popping-up any reports in ERP
Cannot Export Data from E-Business Suite to Excel.
The Export Extraction feature is not popping-up any reports in ERP
Cannot Export Data from E-Business Suite to Excel.
Issue has been
resolved for "The Export Extraction feature is not popping-up any reports
in ERP"
Below are
reference notes and action plan performed to resolve this -
1. Domain Index -
FND_LOBS_CTX was in failed/unusable state.
2. Sample test
case -
SQL> set serveroutput on;
declare
db_file number;
mime_type varchar2(255) :='text/plain' ;
out_string varchar2(32767) :='Just some
plain text that is stored' ;
web_server_prefix varchar2(500);
url varchar2(500);
begin
db_file :=fnd_gfm.file_create(content_type
=>mime_type,program_name=>
'export');
fnd_gfm.file_write_line(db_file,out_string);
db_file :=fnd_gfm.file_close(db_file);
url:=fnd_gfm.construct_download_url(fnd_web_config.gfm_agent,db_file,TRUE)
;
SQL>
2 3 dbms_output.put_line(url);
4 end;
/
5 6 7
8 9 10
11 12 13
14 15 16
declare
*
ERROR at line 1:
ORA-29861: domain index is marked
LOADING/FAILED/UNUSABLE
ORA-06512: at "APPS.FND_GFM",
line 696
ORA-06512: at line 8
3. Action
performed -
Drop and recreated
domain index -
SQL> DROP INDEX APPLSYS.FND_LOBS_CTX;
Index dropped.
SQL> @$FND_TOP/sql/aflobbld.sql applsys
apps
PL/SQL procedure successfully completed.
Commit complete.
4. Testcase 2 -
SQL> set serveroutput on;
declare
db_file number;
mime_type varchar2(255) :='text/plain' ;
out_string varchar2(32767) :='Just some plain
text that is stored' ;
web_server_prefix varchar2(500);
url varchar2(500);
begin
db_file :=fnd_gfm.file_create(content_type
=>mime_type,program_name=>
'export');
SQL>
2 3 4
5 6 7
8
fnd_gfm.file_write_line(db_file,out_string);
9 10 db_file :=fnd_gfm.file_close(db_file);
url:=fnd_gfm.construct_download_url(fnd_web_config.gfm_agent,db_file,TRUE)
;
dbms_output.put_line(url);
11
12 end;
/ 13
14 15 16
https://erpprdapp.psuad.ac.ae:443/OA_HTML/fndgfm.jsp?mode=download_blob&fid=1257
513&accessid=286223592715738799812792060162859000305
PL/SQL procedure successfully completed.
SQL>
Reference Notes -
1. Cannot Export
Data from E-Business Suite to Excel (Doc ID 731921.1)
2. ORA-29861:
Domain Index Is Marked LOADING/FAILED/UNUSABLE In Package OE_Atchmt_UTIL
Procedure Delete (Doc ID 2247134.1)
