R12 AppsLocalLogin shows blank page

This issue has already been reported to me twice, so I am documenting this for future:

R12 AppsLocalLogin shows blank page

A check of logs shows this:

cd $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1
vi application.log
Go to the end of the file

11/05/31 15:38:07.918 html: LeakSetting:
global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false
ignoring:null
11/05/31 15:39:40.810 html: chain failed
javax.servlet.ServletException: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:899)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:816)
at _AppsLocalLogin._jspService(_AppsLocalLogin.java:303)
at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.5.0) ].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[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.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.5.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:298)
at java.lang.Thread.run(Thread.java:662)


Start an sqlplus session

SQL> conn apps/appspassword
Connected.
SQL> select fnd_web_sec.validate_login('GUEST','ORACLE') FROM DUAL;
select fnd_web_sec.validate_login('GUEST','ORACLE') FROM DUAL
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Check the Database Alert Log
Tue May 31 15:50:51 2011
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x108250218, ioc_pin_shared_executable_object()+1240] [flags: 0x0, count: 1]
Errors in file /appsr1213/oracle/11.2.0/admin/vision_vision/diag/rdbms/vision/vision/trace/vision_ora_10944.trc (incident=121312):
ORA-07445: exception encountered: core dump [ioc_pin_shared_executable_object()+1240] [SIGSEGV] [ADDR:0x0] [PC:0x108250218] [Address not mapped to object] []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue May 31 15:50:54 2011
Sweep [inc][121312]: completed

If you open two unix sessions side by side:

First session: connect to sqlplus as apps and execute
select fnd_web_sec.validate_login('GUEST','ORACLE') FROM DUAL;

Second session: tail Database alert log

You'll notice that whenever this sql is executed in first session, the alert log will immediately log an ORA-07445 error.

This is an 11.2.0.2 bug. The workaround is to bounce the database and listener. Once I learn more about this bug, I'll update this post.

Can't locate strict.pm in @INC

On running adcfgclone.pl on 11.2.0.2 RDBMS ORACLE_HOME, the following error occurred.

$ perl adcfgclone.pl dbTechStack
Can't locate strict.pm in @INC (@INC contains: /erpR1213/oracle/11.2.0/perl/lib/5.8.3 /erpR1213/oracle/11.2.0/perl/lib/site_perl/5.8.3 /erpR1213/oracle/11.2.0/appsutil/perl ../lib/5.10.0/sun4-solaris-thread-multi-64 ../lib/5.10.0 ../lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 ../lib/site_perl/5.10.0 ../lib/5.10.0 ../lib/5.10.0/sun4-solaris-thread-multi-64 ../lib/site_perl .) at adcfgclone.pl line 27.
BEGIN failed--compilation aborted at adcfgclone.pl line 27.


This is a known issue and now documented in My Oracle Support Article ADPreclone Fails When Can't Find Strict.PM Following Database Upgrade to 11gR2 [ID 1139403.1].

11.2.0.2 ships with perl 5.10.0. So you need to change the values of context variables pointing to PERL5LIB and ADPERLPRG inside the context file.

vi $CONTEXT_FILE
Global replace 5.8.3 with 5.10.0
Save
cd $ORACLE_HOME/appsutil/template
vi adxdbctx.tmp
Global replace 5.8.3 with 5.10.0

Run adcfgclone.pl, or adconfig or adpreclone.pl and it will work now.

Files in which OTM stores IP address and port

During the recent upgrade of OTM v6.1.0 to OTM v6.2.1, I discovered that OTM stores IP address of its servers in the following files:

$GLOG_HOME/tomcat/conf/server.xml
$GLOG_HOME/weblogic/domains/otm/config/config.xml.fresh
$GLOG_HOME/apache/conf/httpd.conf
$GLOG_HOME/apache/conf/workers.properties


For Apache and Weblogic services, OTM listens on virtual IP of the instance, so there is no port conflict as the Virtual_IP:Port remains unique.

However, the Tomcat component listens on localhost on port 8007 by default. So if you have two OTM instances share the same physical box as application tier, you need to change the default port of 8007 to some other port which is available. This change is made in $GLOG_HOME/tomcat/conf/server.xml.

DBUA unable to recognize oracle user as unix owner when unix uid is 9 digits

While upgrading an Oracle instance from 11.2.0.1 to 11.2.0.2, through DBUA I discovered a bug. If the unix uid of the oracle user is 9 digit, DBUA refuses to recognize oracle as the unix owner of the software. This issue doesn't occur with older oracle ids which were 5 digit. We got a similar issue in past with runInstaller for which an SR was logged and Oracle opened bug 10205927. For the current issue with DBUA, I have logged a new SR

Till this bug is fixed by Oracle, DBUA will fail for any instance whose oracle user has unix uid of 9 digit. All upgrades to 11.2.0.2 on such instances will have to use the manual upgrade process.

I'll update this post with more details, after Oracle responds on the SR.

Multiple FFP invalid objects after installing R12.1.3

We got 250+ invalid objects whose name started with FFP:

FFP55375_01011990 FFP50508_01011900 FFP50512_01011900 FFP52744_01071999 FFP50510_01011900 FFP52724_01071999 FFP55355_01011990 FFP55058_01011990 FFP60833_01012000 FFP60793_01012004 FFP60963_01012000 FFP60964_01012000 FFP60606_01011990 FFP60607_01011990

A quick search on My Oracle support revealed some articles with similar errors for 11i:

Applied Patch 9062727 (11i.Hr_pf.K.Delta.5) And Left With FFP<######> Invalid Packages [ID 1096417.1]

The above article pointed to this article:

How to compile fast formula from the server (via FFXBCP) (Doc ID 167689.1) and I executed this command:

$ FFXBCP apps/apps 0 Y %% %%

Log filename : L5826316.log

Report filename : O5826316.out

All the FFP invalids were resolved after executing the above command.

ORA-00904: "AD_PA_MISC"."GET_TOTAL_TIME": invalid identifier

I upgraded a freshly installed R12.1.1 Vision instance to 12.1.3 by applying patch 9239090. Howerver I got errors wherever adtimrpt.sql was executed after a patch similar to this:

sqlplus -s APPS/APPS @/jaer12/appl/ad/12.0.0/sql/adtimrpt.sql 550206 adt550206

The spooled file would give this error:

Product Information page

1

rpad(ad_pa_misc.get_total_time(inner.session_id,

*

ERROR at line 5:

ORA-00904: "AD_PA_MISC"."GET_TOTAL_TIME": invalid identifier

I checked the instance for availability of package AD_PA_MISC, and found that it was non existant.

So I checked what files created this package by

cd $AD_TOP/patch/115/sql

grep ad_pa_misc *

adpamisb.pls:REM | Body for ad_pa_misc package

adpamisb.pls:CREATE or REPLACE package body ad_pa_misc as

adpamisb.pls:END ad_pa_misc;

adpamiss.pls:REM | Specification for ad_pa_misc package

adpamiss.pls:CREATE OR REPLACE package ad_pa_misc as

adpamiss.pls:end ad_pa_misc;

So adpamiss.pls is the package specification and adpamisb.pls is the package body.

I connected as apps and executed adpamisb.pls and adpamiss.pls

This has created the missing ad_pa_misc package. I re-executed the failing sql again and it succeded this time:

sqlplus -s APPS/APPS @/jaer12/appl/ad/12.0.0/sql/adtimrpt.sql 550206 adt550206

Spooling to adt550206.lst

Spooling to adt550206.csv