ISSUE -> Private url redirecting to DMZ url
+ Able to reproduce the issue
Login to https://oracler12test2.orclsourcing.com
tried below navigation, it is redirecting to DMZ url
Workflow Administrator Web Applications -> Administrator Workflow ->Status Monitor
error:
System Administrator is not a valid responsibility for the current user. Please contact your
System Administrator
OBSERVATION/FINDINGS
=====================
BELOW PROFILE ARE SET TO DMZ url at site level and are null at server level
Application Framework Agent https://oracler12test2-dmz.orclsourcing.com:443
Applications JSP Agent https://oracler12test2-dmz.orclsourcing.com:443
Applications Web Agent https://oracler12test2-dmz.orclsourcing.com:443/pls/TIOI2I
Apps Servlet Agent https://oracler12test2-dmz.orclsourcing.com:443/OA_HTML
Solution:
=========
Changed below profile
Application Framework Agent
From https://oracler12test2-dmz.orclsourcing.com:443
To https://oracler12test2.orclsourcing.com:443
Applications JSP Agent
From https://oracler12test2-dmz.orclsourcing.com:443
To https://oracler12test2.orclsourcing.com:443
Applications Web Agent
From https://oracler12test2-dmz.orclsourcing.com:443/pls/TIOI2I
To https://oracler12test2.orclsourcing.com:443/pls/TIOI2I
Apps Servlet Agent
From https://oracler12test2-dmz.orclsourcing.com:443/OA_HTML
To https://oracler12test2.orclsourcing.com:443/OA_HTML
+ Corrected below profiles at server(mohioil009) level
Application Framework Agent https://oracler12test2-dmz.orclsourcing.com:443
Applications JSP Agent https://oracler12test2-dmz.orclsourcing.com:443
Applications Web Agent https://oracler12test2-dmz.orclsourcing.com:443/pls/TIOI2I
Apps Servlet Agent https://oracler12test2-dmz.orclsourcing.com:443/OA_HTML
+ Now Issue fixed ( not redirecting to DMZ url)
========================================================
ISSUE: jtflogin.jsp page failing
http://aohsitgr06.orclsourcing.com:10015/OA_HTML/jtflogin.jsp -- not working
SOLUTION:
==> Issue was with missing classfiles under $COMMON_TOP/${CONTEXT_NAME}/_pages.
==> Restored backup and issued fixed.
========================================================
Issue: AppsLocalLogin.jsp not working.. blank page diaplays
oacore applicationlog
----------------------------
javax.servlet.ServletException: java.lang.RuntimeException: Guest user/pwd does not exist or
match: GUEST/ORACLE
SQL> select FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
--------------------------------------------------------------------------------
N
Solution:
---------
EBS R12 Login Page Is Not Coming Up - java.lang.RuntimeException: Guest user/pwd does not exist or
match: GUEST/ORACLE (Doc ID 1673030.1)
========================================================
ISSUE DMZ url redirecting
DMZ url Fix:
$FND_SECURE/PWWFNI.dbc on DMZ had wrong server id.
corrected dbc file and that fix the DMZ url redirection issue.
SOLUTION:
cd $FND_SECURE
bash-3.00$ diff PNNFNI.dbc PNNFNI.dbc_Oct31_Orig
4c4
< APPL_SERVER_ID=65DD894AE9ADC6E5E040558CF632429E23820455064877020381049937104107
---
> APPL_SERVER_ID=6595AEA65D9BFE3FE040558CF6325E0C33748155693022171005269635221930
bash-3.00$
========================================================
ISSUE :when clicking on https://ssinsite1.vbgov.com it is not redirecting to https://ssinsite1.vbgov.com//OA_HTML/AppsLogin
solution change in /pcov1i/inst/apps/PCOV1I_mohcovb010/portal/index.html
bash-3.2$ diff index.html_bkp2dec12 index.html
22c22
< <META http-equiv=REFRESH content="1; URL=https://ssinsite1.vbgov.com">
---
> <META http-equiv=REFRESH content="1; URL=https://ssinsite1.vbgov.com/OA_HTML/AppsLogin">
26c26
< The E-Business Home Page is located at <a href="https://ssinsite1.vbgov.com">https://ssinsite1.vbgov.com</a><br>
---
> The E-Business Home Page is located at <a href="https://ssinsite1.vbgov.com/OA_HTML/AppsLogin">https://ssinsite1.vbgov.com/OA_HTML/AppsLogin</a><br>
28c28
< <A HREF="https://ssinsite1.vbgov.com">here</A>.
---
> <A HREF="https://ssinsite1.vbgov.com/OA_HTML/AppsLogin">here</A>.
bash-3.2$
========================================================
Issue : AppsLocalLogin.jsp Not working after MT bounce
Solution:
changed LONG_RUNNING_JVM to false in oc4j.properties
rotoorap01:apdsenzi>pwd
/dsenzi/inst/apps/DSENZI_rotoorap01/ora/10.1.3/j2ee/oacore/config
rotoorap01:apdsenzi>diff oc4j.properties oc4j.properties.bkp28oct
46c46
< LONG_RUNNING_JVM=false
---
> LONG_RUNNING_JVM=true
rotoorap01:apdsenzi>
Bounced MT
AppsLocalLogin.jsp working Now
========================================================
LOGIN :
Issue Url https://csvtprd.usco.com/OA_HTML/AppsLogin --> not working
error
You have encountered an unexpected error. Please contact the System Administrator for assistance."
oracle.apps.fnd.cache.CacheException;
SOlution
---------
As per note ID 418130.1
Run Concurrent manger job "Synchronize Workflow Local Tables" as sysadmin.
As you may be unable to login to applications to run the program you may also try this approach to run the request manually:
SQL> begin apps.wf_local_synch.BULKSYNCHRONIZATION(P_ORIG_SYSTEM=>'ALL',
P_PARALLEL_PROCESSES=>2,
P_LOGGING=>'LOGGING', P_RAISEERRORS=>TRUE,
P_TEMPTABLESPACE=>'APPS_TS_TX_DATA'); END;
/ 2 3 4 5
PL/SQL procedure successfully completed.
SQL>
+ bounced Databse
+ started Mt services
Url https://csvtprd.usco.com/OA_HTML/AppsLogin --> working now
========================================================
Issue : url home page not working after disable of SSL ( appslocallogin.jsp working)
Solution
========
$ diff $INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf
$INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf_bkpnew
1163,1164c1163,1164
< #LoadModule certheaders_module libexec/mod_certheaders.so
< #include "/sexc2i/inst/apps/SEXC2I_aohsexcc34/ora/10.1.3/Apache/Apache/conf/ssl_terminator.conf"
---
> LoadModule certheaders_module libexec/mod_certheaders.so
> include "/sexc2i/inst/apps/SEXC2I_aohsexcc34/ora/10.1.3/Apache/Apache/conf/ssl_terminator.conf"
==============================================================
Issue : url home page not working after disable of SSL ( appslocallogin.jsp working)
Solution
========
$ diff $INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf
$INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf_bkpnew
1163,1164c1163,1164
< #LoadModule certheaders_module libexec/mod_certheaders.so
< #include "/sexc2i/inst/apps/SEXC2I_aohsexcc34/ora/10.1.3/Apache/Apache/conf/ssl_terminator.conf"
---
> LoadModule certheaders_module libexec/mod_certheaders.so
> include "/sexc2i/inst/apps/SEXC2I_aohsexcc34/ora/10.1.3/Apache/Apache/conf/ssl_terminator.conf"
$
==============================================================
login issue
Issue: url https://dhcm.cov.com not working , Error with HTTP-500 ( Internal server error )
oacore log
===========
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
Observation
=============
SQL> select name,created from v$database;
NAME CREATED
--------- ---------------
DNOILI 15-MAR-12
SQL> sho parameter sec_case_sensitive_logon
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
cause:
sec_case_sensitive_logon need to to FALSE
SOLUTION (Doc ID 1335176.1)
=========
changed sec_case_sensitive_logon to FALSE in PARAMETER FILE
+ Bounced Database & MT
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE
SQL>
Login Issue resolved
Able to login to the url https://dhcm.cov.com
==============================================================
ISSUE:Login URLs Not working after the action plan
SYMPTOMS: getting below error when login to the application url
Request URI:/OA_HTML/OA.jsp Exception:java.lang.ClassFormatError:
oracle/apps/fnd/security/HTMLProcessor (Truncated class file)
SOLUTION: replaced the HTMLProcessor.class file from backup(snapshot)
$ pwd
/plsfri/applmgr/common/java/oracle/apps/fnd/security
rwxr-xr-x 1 applsfri aaplsfri 6281 Aug 3 2008 HTMLProcessor.class
-rwxr-xr-x 1 applsfri aaplsfri 6372 Jun 26 12:31 HTMLProcessor.class_Old
Issue solved.
==============================================================
DMZ url redirect issue
The Follwoing Profile options are not(null) set at server level for Public MT aohsmich39 and aohsmich40
changed the below profile options at server level for Public MT aohsmich39 and aohsmich40
Application Framework Agent https://tstmbcapps.mkercorp.com:443
Applications JSP Agent https://tstmbcapps.mkercorp.com:443
Apps Servlet Agent https://tstmbcapps.mkercorp.com:443/OA_HTML
Applications Web Agent https://tstmbcapps.mkercorp.com:443/pls/TMIC1I
DMZ URl https://tstmbcapps.mkercorp.com --> working fine now
Thanks,
==============================================================
DMZ url https://csctest.poalsea.com.mx-> not working
Observation/Findings
--------------------
+ ServerName is incorect in Httpd.conf file
on node 12
bash-3.00$ grep ServerName httpd.conf
# ServerName allows you to set a host name which is sent back to clients for
ServerName appsalseatest.orclsourcing.com
on node 12
bash-3.00$ grep ServerName httpd.conf
# ServerName allows you to set a host name which is sent back to clients for
ServerName appsalseatest.orclsourcing.com
SOLUTION:
---------
Corrected ServerName in httpd.conf on both the DMZ nodes aohsalse11 and aohsalse12
bash-3.00$ hostname
aohsalse11
bash-3.00$ diff httpd.conf httpd.conf_abkp5apr
413,414c413
< #ServerName appsalseatest.orclsourcing.com
< ServerName csctest.grupoalsea.com.mx
---
> ServerName appsalseatest.orclsourcing.com
bash-3.00$
bash-3.00$ hostname
aohsalse12
bash-3.00$ diff httpd.conf httpd.conf_abkp5apr
413,414c413,414
< #ServerName appsalseatest.orclsourcing.com
< ServerName csctest.grupoalsea.com.mx
---
> ServerName appsalseatest.orclsourcing.com
>
DMZ url https://csctest.poalsea.com.mx-> working
Thanks,
==============================================================
ISSUE:
When accessing url https://oracletnob6i.obleenyinc.com
getting below error:
"You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details. "
error log
=========
[Tue Jul 28 00:19:19 2015] [error] [client 141.147.35.221] [ecid: 1438060759:129.155.128.8:19831:0:11,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
[Tue Jul 28 00:19:20 2015] [error] [client 141.147.35.221] [ecid: 1438060760:129.155.128.8:19831:0:12,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
[Tue Jul 28 00:20:24 2015] [error] [client 141.147.67.10] [ecid: 1438060824:129.155.128.8:19830:0:10,0] File does not exist: /tnob6i/inst/apps/TNOB6I_aohsnobl12/portal/favicon.ico
[Tue Jul 28 00:20:24 2015] [error] [client 141.147.67.10] [ecid: 1438060824:129.155.128.8:19830:0:11,0] File does not exist: /tnob6i/inst/apps/TNOB6I_aohsnobl12/portal/favicon.ico
[Tue Jul 28 00:20:31 2015] [error] [client 141.147.53.182] [ecid: 1438060831:129.155.128.8:19832:0:10,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
[Tue Jul 28 00:20:31 2015] [error] [client 141.147.53.182] [ecid: 1438060831:129.155.128.8:19832:0:11,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
[Tue Jul 28 00:20:31 2015] [error] [client 141.147.53.182] [ecid: 1438060831:129.155.128.8:19832:0:12,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_ILLEGAL_CONNTEST_MODE. Tokens: TEST_MODE_VAL = 1 ;
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1247)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2215)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:557)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:439)
at _OA._jspService(_OA.java:205)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:308)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:407)
at _RF._jspService(_RF.java:217)
Findings
==========
cd /tnob6i/inst/.zfs/snapshot/.531YYPJ-exp30Jul15_aohsnobl11_TNOB6I_PROJ_20150723_0030/apps/TNOB6I_aohsnobl12/ora/10.1.3/j2ee/oacore/config
-bash-3.2$ diff oc4j.properties /tnob6i/inst/apps/TNOB6I_aohsnobl12/ora/10.1.3/j2ee/oacore/config/oc4j.properties
90c90,92
< #
---
> #Added below parameter as per Bug 17157260
>
> oa.connection.testmode=1
-bash-3.2$
Solution:
========
+ Restored oc4j.properties from snapshot
+ Issue Fixed
+ now able to access url https://oracletnob6i.obleenyinc.com/ without any issue
Thanks,
==============================================================
issue:
when navingting to Application Administrator responsibility
below error occurs
Function not available to this responsibility.
Change responsibilities or contact System Administrator
FINDNIGS:
=========
+ XBOL_TOP entry missing in formservlet.ini file
bash-3.00$ diff formservlet.ini /ptrivi/product/iAS/Apache/Jserv/etc/formservlet.ini
1c1
< $Header: txkGenFormServletIni.pl 115.17 2006/08/18 06:09:49 sbandla noship $
---
> $Header: txkGenFormServletIni.pl 115.20 2010/05/26 09:55:54 jmajumde noship $
55c55,56
< FND_SECURE=/ptrivi/applmgr/11510/fnd/11.5.0/secure/PTRIVI_aohstriv05
---
> FND_SECURE=/ptrivi/applmgr/11510/fnd/11.5.0/secure/PTRIVI_aohstriv05
> FORMS60_RECORD_GROUP_MAX=1000000
57c58
< APPLMSG=mesg
---
> APPLMSG=mesg
67a69
> FORMS60_SCROLL_ALL_BUT_ONE=TRUE
225a228
> IZU_TOP=/ptrivi/applmgr/11510/izu/11.5.0
278d280
< XBOL_TOP=/ptrivi/applmgr/CUSTOM/xbol/11.5.0
SOLUTION:
========
bash-3.00$ diff formservlet.ini formservlet.ini_abkp27may14
281d280
< XBOL_TOP=/ptrivi/applmgr/CUSTOM/xbol/11.5.0
bash-3.00$
Able to navigate to Application Administrator and other functions
+ ISSUE FIXED
==============================================================
ISSUE: WHILE LOGGING TO APPLICATION URL
BELOW ERROR OCCURS:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your
request.
Please contact the server administrator, apdcyp3i@orclsourcing.com and inform them of the
time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
SOLUTION:
=========
+ RAN Aoljtest https://cydev3.press.com/OA_HTML/jsp/fnd/aoljtest.jsp
+ Generated jar files from adadmin
+ compiled jsps
+ bounced apache server
issue fixed
==============================================================
ISSUE: application url not working
error
Request-URI Too Large
The requested URL's length exceeds the capacity limit for this server.
request failed: URI too long
Action Plan
-------------
+ Bring down MT services
+ run autoconfig
+ start the services
+ retest the issue
Thanks,
==============================================================
Issue:
"Application Diagnostics" responsibility does not visible on home page ( for sysadmin user)
background
-----------
'application Diagnostics' resp does not assigned as direct responsibility , but assigned as indirect responsibility.
When trying to add 'application Diagnostics' resp to sysadmin , erroring out saying that responsibility is already exists
solution/workaround:
--------------------
from "user administrator" Resp check the role "application Diagnostics" it was not assigned.
Assigned role "application Diagnostics" to sysadmin user
+ logout and reloggedin
"Application Diagnostics" responsibility visible on home page ( for sysadmin user)
==============================================================
Application Diagnostics ' for these three users GOPAL.BIAL,RAVER.KAPR,ROBINSON.MAY
are Inherited From 'Purchasing Super User ' responsibility
Inherited roles can only be revoked through the originating roles
1. User Management responsibility
2. Then go to Roles/Responsibilities tab and query the role/responsibility (Purchasing Super User ).
3.Click on 'View in Hierarchy'.
4. Remove the 'Application Diagnostics' responsibility.
Please note that this will also remove the indirect role for all the users who have the role/ responsibility assigned to them.
If you do not want it to be removed for all users then please create a new role without the inheritance and assign this role to the user who needs it.
Thanks,
==============================================================
ISSUE: private url redirects to pulic after providing username pwd
cause: NODE TRUST LEVEL profile was set to external at site level.
profile_optdetails.sql
PROFILE_OPTION_ID SHORT_NAME NAME LEVEL_SET CONTEXT VALUE LAST_UPDATE_DATE
----------------- ------------------------------ --------------------------- ----------------- ------ ------------------
7511 NODE_TRUST_LEVEL Node Trust Level Server mohPSNL010 3 26-JAN-13
7511 NODE_TRUST_LEVEL Node Trust Level Server mohPSNL040 3 17-JAN-15
7511 NODE_TRUST_LEVEL Node Trust Level Site 3 17-JAN-15
3 rows selected.
solution:
SQL> select PROFILE_OPTION_VALUE from fnd_profile_option_values where level_id=10001 and PROFILE_OPTION_ID=7511;
PROFILE_OPTION_VALUE
--------------------------------------------------
3
1 row selected.
Elapsed: 00:00:00.02
SQL> update fnd_profile_option_values set PROFILE_OPTION_VALUE=2 where level_id=10001 and PROFILE_OPTION_ID=7511;
1 row updated.
Elapsed: 00:00:00.01
SQL> commit;
Commit complete.
Elapsed: 00:00:00.01
SQL> select PROFILE_OPTION_VALUE from fnd_profile_option_values where level_id=10001 and PROFILE_OPTION_ID=7511;
PROFILE_OPTION_VALUE
--------------------------------------------------
2
1 row selected.
==============================================================
issue:
application url not workinng after updating fnd_user table
SQL> update fnd_user set end_date = '24-Apr-2012' where ( end_date is null or end_date >
sysdate) AND USER_NAME NOT IN ('KALANIG','JOVANOVL','WILSONJA','WUR');
2759 rows updated.
SOlution
=========
Removed end date from GUEST and SYSADMIN users
SQL> update fnd_user set end_date=NULL where USER_NAME='GUEST';
1 row updated.
SQL> update fnd_user set end_date=NULL where USER_NAME='SYSADMIN';
1 row updated.
SQL> commit;
Iuusue fixed , url working fine..
==============================================================
+ Able to reproduce the issue
Login to https://oracler12test2.orclsourcing.com
tried below navigation, it is redirecting to DMZ url
Workflow Administrator Web Applications -> Administrator Workflow ->Status Monitor
error:
System Administrator is not a valid responsibility for the current user. Please contact your
System Administrator
OBSERVATION/FINDINGS
=====================
BELOW PROFILE ARE SET TO DMZ url at site level and are null at server level
Application Framework Agent https://oracler12test2-dmz.orclsourcing.com:443
Applications JSP Agent https://oracler12test2-dmz.orclsourcing.com:443
Applications Web Agent https://oracler12test2-dmz.orclsourcing.com:443/pls/TIOI2I
Apps Servlet Agent https://oracler12test2-dmz.orclsourcing.com:443/OA_HTML
Solution:
=========
Changed below profile
Application Framework Agent
From https://oracler12test2-dmz.orclsourcing.com:443
To https://oracler12test2.orclsourcing.com:443
Applications JSP Agent
From https://oracler12test2-dmz.orclsourcing.com:443
To https://oracler12test2.orclsourcing.com:443
Applications Web Agent
From https://oracler12test2-dmz.orclsourcing.com:443/pls/TIOI2I
To https://oracler12test2.orclsourcing.com:443/pls/TIOI2I
Apps Servlet Agent
From https://oracler12test2-dmz.orclsourcing.com:443/OA_HTML
To https://oracler12test2.orclsourcing.com:443/OA_HTML
+ Corrected below profiles at server(mohioil009) level
Application Framework Agent https://oracler12test2-dmz.orclsourcing.com:443
Applications JSP Agent https://oracler12test2-dmz.orclsourcing.com:443
Applications Web Agent https://oracler12test2-dmz.orclsourcing.com:443/pls/TIOI2I
Apps Servlet Agent https://oracler12test2-dmz.orclsourcing.com:443/OA_HTML
+ Now Issue fixed ( not redirecting to DMZ url)
========================================================
ISSUE: jtflogin.jsp page failing
http://aohsitgr06.orclsourcing.com:10015/OA_HTML/jtflogin.jsp -- not working
SOLUTION:
==> Issue was with missing classfiles under $COMMON_TOP/${CONTEXT_NAME}/_pages.
==> Restored backup and issued fixed.
========================================================
Issue: AppsLocalLogin.jsp not working.. blank page diaplays
oacore applicationlog
----------------------------
javax.servlet.ServletException: java.lang.RuntimeException: Guest user/pwd does not exist or
match: GUEST/ORACLE
SQL> select FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
--------------------------------------------------------------------------------
N
Solution:
---------
EBS R12 Login Page Is Not Coming Up - java.lang.RuntimeException: Guest user/pwd does not exist or
match: GUEST/ORACLE (Doc ID 1673030.1)
========================================================
ISSUE DMZ url redirecting
DMZ url Fix:
$FND_SECURE/PWWFNI.dbc on DMZ had wrong server id.
corrected dbc file and that fix the DMZ url redirection issue.
SOLUTION:
cd $FND_SECURE
bash-3.00$ diff PNNFNI.dbc PNNFNI.dbc_Oct31_Orig
4c4
< APPL_SERVER_ID=65DD894AE9ADC6E5E040558CF632429E23820455064877020381049937104107
---
> APPL_SERVER_ID=6595AEA65D9BFE3FE040558CF6325E0C33748155693022171005269635221930
bash-3.00$
========================================================
ISSUE :when clicking on https://ssinsite1.vbgov.com it is not redirecting to https://ssinsite1.vbgov.com//OA_HTML/AppsLogin
solution change in /pcov1i/inst/apps/PCOV1I_mohcovb010/portal/index.html
bash-3.2$ diff index.html_bkp2dec12 index.html
22c22
< <META http-equiv=REFRESH content="1; URL=https://ssinsite1.vbgov.com">
---
> <META http-equiv=REFRESH content="1; URL=https://ssinsite1.vbgov.com/OA_HTML/AppsLogin">
26c26
< The E-Business Home Page is located at <a href="https://ssinsite1.vbgov.com">https://ssinsite1.vbgov.com</a><br>
---
> The E-Business Home Page is located at <a href="https://ssinsite1.vbgov.com/OA_HTML/AppsLogin">https://ssinsite1.vbgov.com/OA_HTML/AppsLogin</a><br>
28c28
< <A HREF="https://ssinsite1.vbgov.com">here</A>.
---
> <A HREF="https://ssinsite1.vbgov.com/OA_HTML/AppsLogin">here</A>.
bash-3.2$
========================================================
Issue : AppsLocalLogin.jsp Not working after MT bounce
Solution:
changed LONG_RUNNING_JVM to false in oc4j.properties
rotoorap01:apdsenzi>pwd
/dsenzi/inst/apps/DSENZI_rotoorap01/ora/10.1.3/j2ee/oacore/config
rotoorap01:apdsenzi>diff oc4j.properties oc4j.properties.bkp28oct
46c46
< LONG_RUNNING_JVM=false
---
> LONG_RUNNING_JVM=true
rotoorap01:apdsenzi>
Bounced MT
AppsLocalLogin.jsp working Now
========================================================
LOGIN :
Issue Url https://csvtprd.usco.com/OA_HTML/AppsLogin --> not working
error
You have encountered an unexpected error. Please contact the System Administrator for assistance."
oracle.apps.fnd.cache.CacheException;
SOlution
---------
As per note ID 418130.1
Run Concurrent manger job "Synchronize Workflow Local Tables" as sysadmin.
As you may be unable to login to applications to run the program you may also try this approach to run the request manually:
SQL> begin apps.wf_local_synch.BULKSYNCHRONIZATION(P_ORIG_SYSTEM=>'ALL',
P_PARALLEL_PROCESSES=>2,
P_LOGGING=>'LOGGING', P_RAISEERRORS=>TRUE,
P_TEMPTABLESPACE=>'APPS_TS_TX_DATA'); END;
/ 2 3 4 5
PL/SQL procedure successfully completed.
SQL>
+ bounced Databse
+ started Mt services
Url https://csvtprd.usco.com/OA_HTML/AppsLogin --> working now
========================================================
Issue : url home page not working after disable of SSL ( appslocallogin.jsp working)
Solution
========
$ diff $INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf
$INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf_bkpnew
1163,1164c1163,1164
< #LoadModule certheaders_module libexec/mod_certheaders.so
< #include "/sexc2i/inst/apps/SEXC2I_aohsexcc34/ora/10.1.3/Apache/Apache/conf/ssl_terminator.conf"
---
> LoadModule certheaders_module libexec/mod_certheaders.so
> include "/sexc2i/inst/apps/SEXC2I_aohsexcc34/ora/10.1.3/Apache/Apache/conf/ssl_terminator.conf"
==============================================================
Issue : url home page not working after disable of SSL ( appslocallogin.jsp working)
Solution
========
$ diff $INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf
$INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf_bkpnew
1163,1164c1163,1164
< #LoadModule certheaders_module libexec/mod_certheaders.so
< #include "/sexc2i/inst/apps/SEXC2I_aohsexcc34/ora/10.1.3/Apache/Apache/conf/ssl_terminator.conf"
---
> LoadModule certheaders_module libexec/mod_certheaders.so
> include "/sexc2i/inst/apps/SEXC2I_aohsexcc34/ora/10.1.3/Apache/Apache/conf/ssl_terminator.conf"
$
==============================================================
login issue
Issue: url https://dhcm.cov.com not working , Error with HTTP-500 ( Internal server error )
oacore log
===========
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
Observation
=============
SQL> select name,created from v$database;
NAME CREATED
--------- ---------------
DNOILI 15-MAR-12
SQL> sho parameter sec_case_sensitive_logon
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
cause:
sec_case_sensitive_logon need to to FALSE
SOLUTION (Doc ID 1335176.1)
=========
changed sec_case_sensitive_logon to FALSE in PARAMETER FILE
+ Bounced Database & MT
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE
SQL>
Login Issue resolved
Able to login to the url https://dhcm.cov.com
==============================================================
ISSUE:Login URLs Not working after the action plan
SYMPTOMS: getting below error when login to the application url
Request URI:/OA_HTML/OA.jsp Exception:java.lang.ClassFormatError:
oracle/apps/fnd/security/HTMLProcessor (Truncated class file)
SOLUTION: replaced the HTMLProcessor.class file from backup(snapshot)
$ pwd
/plsfri/applmgr/common/java/oracle/apps/fnd/security
rwxr-xr-x 1 applsfri aaplsfri 6281 Aug 3 2008 HTMLProcessor.class
-rwxr-xr-x 1 applsfri aaplsfri 6372 Jun 26 12:31 HTMLProcessor.class_Old
Issue solved.
==============================================================
DMZ url redirect issue
The Follwoing Profile options are not(null) set at server level for Public MT aohsmich39 and aohsmich40
changed the below profile options at server level for Public MT aohsmich39 and aohsmich40
Application Framework Agent https://tstmbcapps.mkercorp.com:443
Applications JSP Agent https://tstmbcapps.mkercorp.com:443
Apps Servlet Agent https://tstmbcapps.mkercorp.com:443/OA_HTML
Applications Web Agent https://tstmbcapps.mkercorp.com:443/pls/TMIC1I
DMZ URl https://tstmbcapps.mkercorp.com --> working fine now
Thanks,
==============================================================
DMZ url https://csctest.poalsea.com.mx-> not working
Observation/Findings
--------------------
+ ServerName is incorect in Httpd.conf file
on node 12
bash-3.00$ grep ServerName httpd.conf
# ServerName allows you to set a host name which is sent back to clients for
ServerName appsalseatest.orclsourcing.com
on node 12
bash-3.00$ grep ServerName httpd.conf
# ServerName allows you to set a host name which is sent back to clients for
ServerName appsalseatest.orclsourcing.com
SOLUTION:
---------
Corrected ServerName in httpd.conf on both the DMZ nodes aohsalse11 and aohsalse12
bash-3.00$ hostname
aohsalse11
bash-3.00$ diff httpd.conf httpd.conf_abkp5apr
413,414c413
< #ServerName appsalseatest.orclsourcing.com
< ServerName csctest.grupoalsea.com.mx
---
> ServerName appsalseatest.orclsourcing.com
bash-3.00$
bash-3.00$ hostname
aohsalse12
bash-3.00$ diff httpd.conf httpd.conf_abkp5apr
413,414c413,414
< #ServerName appsalseatest.orclsourcing.com
< ServerName csctest.grupoalsea.com.mx
---
> ServerName appsalseatest.orclsourcing.com
>
DMZ url https://csctest.poalsea.com.mx-> working
Thanks,
==============================================================
ISSUE:
When accessing url https://oracletnob6i.obleenyinc.com
getting below error:
"You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details. "
error log
=========
[Tue Jul 28 00:19:19 2015] [error] [client 141.147.35.221] [ecid: 1438060759:129.155.128.8:19831:0:11,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
[Tue Jul 28 00:19:20 2015] [error] [client 141.147.35.221] [ecid: 1438060760:129.155.128.8:19831:0:12,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
[Tue Jul 28 00:20:24 2015] [error] [client 141.147.67.10] [ecid: 1438060824:129.155.128.8:19830:0:10,0] File does not exist: /tnob6i/inst/apps/TNOB6I_aohsnobl12/portal/favicon.ico
[Tue Jul 28 00:20:24 2015] [error] [client 141.147.67.10] [ecid: 1438060824:129.155.128.8:19830:0:11,0] File does not exist: /tnob6i/inst/apps/TNOB6I_aohsnobl12/portal/favicon.ico
[Tue Jul 28 00:20:31 2015] [error] [client 141.147.53.182] [ecid: 1438060831:129.155.128.8:19832:0:10,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
[Tue Jul 28 00:20:31 2015] [error] [client 141.147.53.182] [ecid: 1438060831:129.155.128.8:19832:0:11,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
[Tue Jul 28 00:20:31 2015] [error] [client 141.147.53.182] [ecid: 1438060831:129.155.128.8:19832:0:12,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_ILLEGAL_CONNTEST_MODE. Tokens: TEST_MODE_VAL = 1 ;
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1247)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2215)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:557)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:439)
at _OA._jspService(_OA.java:205)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:308)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:407)
at _RF._jspService(_RF.java:217)
Findings
==========
cd /tnob6i/inst/.zfs/snapshot/.531YYPJ-exp30Jul15_aohsnobl11_TNOB6I_PROJ_20150723_0030/apps/TNOB6I_aohsnobl12/ora/10.1.3/j2ee/oacore/config
-bash-3.2$ diff oc4j.properties /tnob6i/inst/apps/TNOB6I_aohsnobl12/ora/10.1.3/j2ee/oacore/config/oc4j.properties
90c90,92
< #
---
> #Added below parameter as per Bug 17157260
>
> oa.connection.testmode=1
-bash-3.2$
Solution:
========
+ Restored oc4j.properties from snapshot
+ Issue Fixed
+ now able to access url https://oracletnob6i.obleenyinc.com/ without any issue
Thanks,
==============================================================
issue:
when navingting to Application Administrator responsibility
below error occurs
Function not available to this responsibility.
Change responsibilities or contact System Administrator
FINDNIGS:
=========
+ XBOL_TOP entry missing in formservlet.ini file
bash-3.00$ diff formservlet.ini /ptrivi/product/iAS/Apache/Jserv/etc/formservlet.ini
1c1
< $Header: txkGenFormServletIni.pl 115.17 2006/08/18 06:09:49 sbandla noship $
---
> $Header: txkGenFormServletIni.pl 115.20 2010/05/26 09:55:54 jmajumde noship $
55c55,56
< FND_SECURE=/ptrivi/applmgr/11510/fnd/11.5.0/secure/PTRIVI_aohstriv05
---
> FND_SECURE=/ptrivi/applmgr/11510/fnd/11.5.0/secure/PTRIVI_aohstriv05
> FORMS60_RECORD_GROUP_MAX=1000000
57c58
< APPLMSG=mesg
---
> APPLMSG=mesg
67a69
> FORMS60_SCROLL_ALL_BUT_ONE=TRUE
225a228
> IZU_TOP=/ptrivi/applmgr/11510/izu/11.5.0
278d280
< XBOL_TOP=/ptrivi/applmgr/CUSTOM/xbol/11.5.0
SOLUTION:
========
bash-3.00$ diff formservlet.ini formservlet.ini_abkp27may14
281d280
< XBOL_TOP=/ptrivi/applmgr/CUSTOM/xbol/11.5.0
bash-3.00$
Able to navigate to Application Administrator and other functions
+ ISSUE FIXED
==============================================================
ISSUE: WHILE LOGGING TO APPLICATION URL
BELOW ERROR OCCURS:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your
request.
Please contact the server administrator, apdcyp3i@orclsourcing.com and inform them of the
time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
SOLUTION:
=========
+ RAN Aoljtest https://cydev3.press.com/OA_HTML/jsp/fnd/aoljtest.jsp
+ Generated jar files from adadmin
+ compiled jsps
+ bounced apache server
issue fixed
==============================================================
ISSUE: application url not working
error
Request-URI Too Large
The requested URL's length exceeds the capacity limit for this server.
request failed: URI too long
Action Plan
-------------
+ Bring down MT services
+ run autoconfig
+ start the services
+ retest the issue
Thanks,
==============================================================
Issue:
"Application Diagnostics" responsibility does not visible on home page ( for sysadmin user)
background
-----------
'application Diagnostics' resp does not assigned as direct responsibility , but assigned as indirect responsibility.
When trying to add 'application Diagnostics' resp to sysadmin , erroring out saying that responsibility is already exists
solution/workaround:
--------------------
from "user administrator" Resp check the role "application Diagnostics" it was not assigned.
Assigned role "application Diagnostics" to sysadmin user
+ logout and reloggedin
"Application Diagnostics" responsibility visible on home page ( for sysadmin user)
==============================================================
Application Diagnostics ' for these three users GOPAL.BIAL,RAVER.KAPR,ROBINSON.MAY
are Inherited From 'Purchasing Super User ' responsibility
Inherited roles can only be revoked through the originating roles
1. User Management responsibility
2. Then go to Roles/Responsibilities tab and query the role/responsibility (Purchasing Super User ).
3.Click on 'View in Hierarchy'.
4. Remove the 'Application Diagnostics' responsibility.
Please note that this will also remove the indirect role for all the users who have the role/ responsibility assigned to them.
If you do not want it to be removed for all users then please create a new role without the inheritance and assign this role to the user who needs it.
Thanks,
==============================================================
ISSUE: private url redirects to pulic after providing username pwd
cause: NODE TRUST LEVEL profile was set to external at site level.
profile_optdetails.sql
PROFILE_OPTION_ID SHORT_NAME NAME LEVEL_SET CONTEXT VALUE LAST_UPDATE_DATE
----------------- ------------------------------ --------------------------- ----------------- ------ ------------------
7511 NODE_TRUST_LEVEL Node Trust Level Server mohPSNL010 3 26-JAN-13
7511 NODE_TRUST_LEVEL Node Trust Level Server mohPSNL040 3 17-JAN-15
7511 NODE_TRUST_LEVEL Node Trust Level Site 3 17-JAN-15
3 rows selected.
solution:
SQL> select PROFILE_OPTION_VALUE from fnd_profile_option_values where level_id=10001 and PROFILE_OPTION_ID=7511;
PROFILE_OPTION_VALUE
--------------------------------------------------
3
1 row selected.
Elapsed: 00:00:00.02
SQL> update fnd_profile_option_values set PROFILE_OPTION_VALUE=2 where level_id=10001 and PROFILE_OPTION_ID=7511;
1 row updated.
Elapsed: 00:00:00.01
SQL> commit;
Commit complete.
Elapsed: 00:00:00.01
SQL> select PROFILE_OPTION_VALUE from fnd_profile_option_values where level_id=10001 and PROFILE_OPTION_ID=7511;
PROFILE_OPTION_VALUE
--------------------------------------------------
2
1 row selected.
==============================================================
issue:
application url not workinng after updating fnd_user table
SQL> update fnd_user set end_date = '24-Apr-2012' where ( end_date is null or end_date >
sysdate) AND USER_NAME NOT IN ('KALANIG','JOVANOVL','WILSONJA','WUR');
2759 rows updated.
SOlution
=========
Removed end date from GUEST and SYSADMIN users
SQL> update fnd_user set end_date=NULL where USER_NAME='GUEST';
1 row updated.
SQL> update fnd_user set end_date=NULL where USER_NAME='SYSADMIN';
1 row updated.
SQL> commit;
Iuusue fixed , url working fine..
==============================================================
No comments:
Post a Comment