Jsp cannot be accessed after installing RPS3 patch for Oracle EBS 12.1.3

 

After installing RPS3 (Recommended patch set) for Oracle EBS 12.1.3 (Patch number 20203366) , some JSP files no longer can be accessed from browser.

We are talking mostly about custom JSP files.

After logs investigation I found the following error 

JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Writer already retrieved

I opened the JSP file and found that there is a code :

response.getWriter()

I suspected that it may be the root cause of the problem. So instead of using  response.getWriter() I just used out variable that you get for “free” in JSP.

I mean instead of:

response.getWriter().println(“Hello”)

just use

out.println(“Hello”)

Recompile the JSP, restart adoacore.ctl and the problem is gone

 

Solution for ORA-00603: ORACLE server session terminated by fatal error when compiling PL/SQL package

 

I was running some installation of DB objects with “sqlplus” utility and this is what I got

SQL> @XX_OM_DRH_PROCESS_UTIL.pkb

create or replace package body XX_OM_DRH_PROCESS_UTIL is

*

ERROR at line 1:

ORA-00603: ORACLE server session terminated by fatal error

The sad part is that the package is OK. If I open it in “PL/SQL Developer” I can compile it without any problems. But if I run it through “sqlplus” or “alter package XX_OM_DRH_PROCESS_UTIL  compile” it gives me the error above.

I spend several hours trying to understand what can be wrong. One of my managers eventually provided the solution. All you need to do is to execute the following

SQL> alter session set events = '10932 trace name context level 32768';

Session altered.

SQL> @XX_OM_DRH_PROCESS_UTIL.pkb

Package body created.

SQL>