DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, January 30, 2013

Error Code 160 With OPatch, Crash In $ORACLE_HOME/jdk/jre/bin/libj9jit23.so (Unhandled Exception )



Error:

======

Error Code 160 With OPatch, Crash In $ORACLE_HOME/jdk/jre/bin/libj9jit23.so (Unhandled Exception )

cskront1(/app/oracle/product/11.1.0/OPatch): ./opatch lsinventory
Unhandled exception
Type=Segmentation error vmState=0x00000000
J9Generic_Signal_Number=00000004 Signal_Number=0000000b Error_Value=00000000 Signal_Code=00000033
Handler1=09001000A0ABBC78 Handler2=09001000A0AB3538
R0=0000000000000000 R1=0FFFFFFFFFFFB8B0 R2=0000000000000011 R3=0000000000000017
R4=07000000001AB028 R5=00000001115D7D80 R6=00000001115D7CB8 R7=00000001115D7CB8
R8=0000000000000000 R9=00000001115D7D80 R10=0000000110256648 R11=0900000006330C38
R12=00000001109E5AD8 R13=000000011000EAA0 R14=00000001115D7D80 R15=00000001101F5700
R16=0000000110A8BAF0 R17=000000011151B278 R18=09001000A0ABF3B0 R19=0000000000000041
R20=000000011151A508 R21=00000001115D7F28 R22=00000001101F5780 R23=0000000000000000
R24=0000000003FCC9D8 R25=07000000001A77C0 R26=FFFFFFFFFFFFFFFF R27=0000000000000017
R28=07000000001AB1E8 R29=0000000000000002 R30=0000000000000015 R31=0000000000000000
IAR=0900000006330C38 LR=00000001102567FC MSR=A00000000000D032 CTR=0900000006330C38
CR=8254508420000006 FPSCR=8202000000000000 XER=2000000682020000
FPR0 0000000800000008 (f: 8.000000, d: 1.697597e-313)
FPR1 41e0000000000000 (f: 0.000000, d: 2.147484e+09)
FPR2 3fe8000000000000 (f: 0.000000, d: 7.500000e-01)
FPR3 c530000000000000 (f: 0.000000, d: -1.934281e+25)
FPR4 3f30000000000000 (f: 0.000000, d: 2.441406e-04)
FPR5 3fd6666666666666 (f: 1717986944.000000, d: 3.500000e-01)
FPR6 3ff0000000000000 (f: 0.000000, d: 1.000000e+00)
FPR7 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR8 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR9 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR10 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR11 4026000000000000 (f: 0.000000, d: 1.100000e+01)
FPR12 3fe8000000000000 (f: 0.000000, d: 7.500000e-01)
FPR13 4020800000000000 (f: 0.000000, d: 8.250000e+00)
FPR14 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR15 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR16 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR17 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR18 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR19 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR20 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR21 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR22 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR23 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR24 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR25 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR26 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR27 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR28 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR29 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR30 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR31 0000000000000000 (f: 0.000000, d: 0.000000e+00)
Module=/app/oracle/product/11.1.0/jdk/jre/bin/libj9jit23.so
Module_base_address=0900000006306000
Target=2_30_20070131_11312_BHdSMr (AIX 6.1)
CPU=ppc64 (8 logical CPUs) (0x400000000 RAM)
JVMDUMP006I Processing Dump Event "gpf", detail "" - Please Wait.
JVMDUMP007I JVM Requesting System Dump using '/app/oracle/product/11.1.0/OPatch/core.20110915.083824.27656416.dmp'
JVMDUMP010I System Dump written to /app/oracle/product/11.1.0/OPatch/core.20110915.083824.27656416.dmp
JVMDUMP007I JVM Requesting Snap Dump using '/app/oracle/product/11.1.0/OPatch/Snap0001.20110915.083824.27656416.trc'
JVMDUMP010I Snap Dump written to /app/oracle/product/11.1.0/OPatch/Snap0001.20110915.083824.27656416.trc
JVMDUMP007I JVM Requesting Java Dump using '/app/oracle/product/11.1.0/OPatch/javacore.20110915.083824.27656416.txt'
JVMDUMP010I Java Dump written to /app/oracle/product/11.1.0/OPatch/javacore.20110915.083824.27656416.txt
JVMDUMP013I Processed Dump Event "gpf", detail "".

OPatch failed with error code 160


Scenario:

========
While running opatch lsinventory we get the above error. 
We are running 11.1.0.7 With R12.1.1 in IBM AIX 6.1  64 bit.

Cause

======
The JAVA_COMPILER environment variable needs to be set to NONE.

Solution:

=========
Export the environment variable JAVA_COMPILER=NONE
export JAVA_COMPILER=NONE

Reference:

=========
Error Code 160 With OPatch, Crash In $ORACLE_HOME/jdk/jre/bin/libj9jit23.so (Unhandled Exception Type=Segmentation Error Vmstate=0x00000000 J9Generic_Signal_Number=...) [ID 1359047.1]

Friday, January 11, 2013

Error while loading shared libraries: libdb.so.2: cannot open shared object file


Error :
=====
Error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory R12.1.1 Installation on Linux 5.4
I was Installing Oracle E-Biz R12.1.1 on OEL 5.4 - 32 Bit for Internal use. All OS pre-requisites has been configured as per the MOS tech note for Installation and all pre-req check from the rapidwiz Installer went fine.
At last steps of Installation during validating system configuration it failed on HTTP, loginpage, Help Directory and JSP.

When checked all services were up and running except web server.
At last steps of Installation during validating system configuration it failed on HTTP, loginpage, Help Directory and JSP.
When checked all services were up and running except web server.
When checked all services were up and running except web server.

checking status of OPMN managed processes...
Processes in Instance: VIS_SYSR12.DOYEN.IN
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |   13776 | Alive
OC4JGroup:default_group          | OC4J:forms         |   13703 | Alive
OC4JGroup:default_group          | OC4J:oacore        |   13617 | Alive
HTTP_Server                      | HTTP_Server        |   13560 | Down
Http_server is shown as Down.
checking status of OPMN managed processes...
Processes in Instance: VIS_SYSR12.DOYEN.IN
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |   13776 | Alive
OC4JGroup:default_group          | OC4J:forms         |   13703 | Alive
OC4JGroup:default_group          | OC4J:oacore        |   13617 | Alive
HTTP_Server                      | HTTP_Server        |   13560 | Down 
Http_server is shown as Down.
Error messages recorded in logfiles:
Installation logfile:

Installation logfile:

HTTP
-----
checking URL = http://SYSR12.DOYEN.IN:8010
RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Help Page
----------
checking URL = http://SYSR12.DOYEN.IN:8010/OA_HTML/help
RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Virtual Directory
------------------
RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
JSP
----
checking URL = http://SYSR12.DOYEN.IN:8010/OA_HTML/jtfTestCookie.jsp
RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page
-----------
RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing.

HTTP 
----- 
checking URL = http://SYSR12.DOYEN.IN:8010
RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 
Help Page
----------
checking URL = http://SYSR12.DOYEN.IN:8010/OA_HTML/help
RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Virtual Directory
------------------
RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
JSP
----
checking URL = http://SYSR12.DOYEN.IN:8010/OA_HTML/jtfTestCookie.jsp
RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page
-----------
RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing.

Help Page 
---------- 
checking URL = http://SYSR12.DOYEN.IN:8010/OA_HTML/help 
RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 
Virtual Directory
------------------
RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
JSP
----
checking URL = http://SYSR12.DOYEN.IN:8010/OA_HTML/jtfTestCookie.jsp
RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page
-----------
RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing.

Virtual Directory 
------------------ 
RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 
JSP
----
checking URL = http://SYSR12.DOYEN.IN:8010/OA_HTML/jtfTestCookie.jsp
RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page
-----------
RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing.

JSP 
---- 
checking URL = http://SYSR12.DOYEN.IN:8010/OA_HTML/jtfTestCookie.jsp 
RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 
Login Page
-----------
RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing.

Login Page 
----------- 
RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing.

07/04/11-10:23:44 :: adapcctl.sh: starting OPMN managed OHS instance
opmnctl: starting opmn managed processes...
================================================================================
opmn id=SYSR12.DOYEN.IN:6210
    0 of 1 processes started.
ias-instance id=VIS_SYSR12.DOYEN.IN
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
    HTTP_Server/HTTP_Server/HTTP_Server/
Error
--> Process (index=1,uid=83499476,pid=12821)
    failed to start a managed process after the maximum retry limit
    Log:
    /u02/oracle/VIS/inst/apps/VIS_/logs/ora/10.1.3/opmn/HTTP_Server~1.log

07/04/11-10:23:44 :: adapcctl.sh: starting OPMN managed OHS instance
opmnctl: starting opmn managed processes...
================================================================================
opmn id=SYSR12.DOYEN.IN:6210
    0 of 1 processes started.
ias-instance id=VIS_SYSR12.DOYEN.IN
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
    HTTP_Server/HTTP_Server/HTTP_Server/
Error
--> Process (index=1,uid=83499476,pid=12821)
    failed to start a managed process after the maximum retry limit
    Log:
    /u02/oracle/VIS/inst/apps/VIS_/logs/ora/10.1.3/opmn/HTTP_Server~1.log



/u02/oracle/VIS/inst/apps/VIS_/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/u02/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

/u02/oracle/VIS/inst/apps/VIS_/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/u02/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
Cause:
1) Shutdown all application services.
2) create link for library file as below
ln -s   /usr/lib/libgdbm.so.2.0.0  /usr/lib/libdb.so.2
3) Startup all application services.
Now you should be able to access the application.
Scenario :
========


 While Installing we got the following Error
  
Error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory R12.1.1 Installation on Linux 5.4







Apache logfiles:




======

http web server unable to start due to missing library.
Solution:
=======






























Thursday, January 10, 2013

ORA-04062 signature of package APPS.WSH_DELIVERY_DETAILS_INV has been changes


Error message: 
===========

APP-WSH-231210 An unexpected Error Occurred for Line .. The Error is ORA-04062 signature of package APPS.WSH_DELIVERY_DETAILS_INV has been changes

EBS R12.1.1
DB 11.1.0.7.0



Scenario when the error occurs :
=======================

while checking transaction status in Order Management
Responsibility - Order Management Super User, Vision Operations (USA)
Navigation : Shipping >> Transaction

Reference :

WSHFSTRX: ORA-04062: Signature of package APPS.WSH_DELIVERY_DETAILS_INV [ID 1303005.1]

Solution :
=======

a) Apply patch 8294645 (For EBS 12.1)
b) Drop package APPS.WSH_DELIVERY_DETAILS_INV
c) Create package spec and body by running  $WSH_TOP/patch/115/sql/@WSHDDICS.pls & @WSHDDICB.pls
d) Finally compile forms WSHSTREF.fmb, WSHFSTRX.fmb, WSHQSSUI.fmb


Note :

We have moved the fmb and the pls manually instead of applying this patch as we face some problem in applying it in other instance :


Steps to follow :

1.Download the patch and copy the pls file from the patch (8294645) to WSH_TOP/patch/115/sql by taking the existing as backup
2. Copy the fmb file from patch (8294645) to AU_TOP/forms/US by taking the existing as backup
3. Now drop the package APPS.WSH_DELIVERY_DETAILS_INV
4. Create package spec and body by running  $WSH_TOP/patch/115/sql/@WSHDDICS.pls & @WSHDDICB.pls as apps user
5. compile the fmb and move the fmx to WSH_TOP/forms/US
6. Retest the issue

[applmgr@sysr12 sql]$ pwd
/R12/apps/apps_st/appl/wsh/12.0.0/patch/115/sql

[applmgr@sysr12 sql]$ mv WSHDDICS.pls WSHDDICS.pls_bkp
[applmgr@sysr12 sql]$ mv WSHDDICB.pls WSHDDICB.pls_bkp

Now copy those three files from the patch directory

Now Drop the package APPS.WSH_DELIVERY_DETAILS_INV

[applmgr@sysr12 sql]$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jan 10 13:13:03 2013

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

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

SQL> @WSHDDICS.pls

Package created.

Commit complete.

SQL> @WSHDDICB.pls

Package body created.

Commit complete.

Now copy the fmb from the patch location to AU_TOP/forms/US

/R12/apps/apps_st/appl/au/12.0.0/forms/US

Now compile the forms

frmcmp_batch module=/R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHSTREF.fmb userid=apps/apps output_file=/R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHSTREF.fmx module_type=form compile_all=special

frmcmp_batch module=/R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHQSSUI.fmb userid=apps/apps output_file=/R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHQSSUI.fmx module_type=form compile_all=special

frmcmp_batch module=/R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHFSTRX.fmb userid=apps/apps output_file=/R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHFSTRX.fmx module_type=form compile_all=special

[applmgr@sysr12 US]$mv  /R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHSTREF.fmx $WSH_TOP/forms/US/WSHSTREF.fmx
[applmgr@sysr12 US]$mv  /R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHQSSUI.fmx $WSH_TOP/forms/US/WSHQSSUI.fmx
[applmgr@sysr12 US]$mv  /R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHFSTRX.fmx $WSH_TOP/forms/US/WSHFSTRX.fmx

/R12/apps/apps_st/appl/au/12.0.0/forms/US
[applmgr@sysr12 US]$ mv WSHSTREF.fmx /R12/apps/apps_st/appl/wsh/12.0.0/forms/US/WSHSTREF.fmx
[applmgr@sysr12 US]$ mv WSHQSSUI.fmx /R12/apps/apps_st/appl/wsh/12.0.0/forms/US/WSHQSSUI.fmx
[applmgr@sysr12 US]$ mv WSHFSTRX.fmx /R12/apps/apps_st/appl/wsh/12.0.0/forms/US/WSHFSTRX.fmx

Now bouce the opmn after clearing the Persistance