R12.2 Login page freezes

[big]

Hi,
On R12.2.4 DB 11.2.0.4 on AIX

Login page is frozen.
We entere login and password and clic on connection. Login and password zones become empty and no message (for example wrong password) appears. In other words it comebacks to login page.
I found Doc ID 1929675.1, It says Add space to tablespace APPS_TS_ARCHIVE but this TBS is at 80% used.



Then I found 2594008.1
And applied:

{ echo APPS/<PASSWORD>; } | java oracle.apps.fnd.security.AdminSecurityCfg -unlock DBC = $FND_SECURE/CFG.dbc -nopromptmsg

But had this error:
Error: Could not find or load main class oracle.apps.fnd.security.AdminSecurityCfg

Thanks.

[ErmanArslansOracleBlog]

What do you have in Oa Core Managed Server's log + Apache log?
Are there any invalid packages/procedures or function that belong to standard schemas (especially apps)?

[big]

Hi,
Thank you.

For invalide objects:
SQL> select count(*) from dba_objects where status='INVALID' and owner='APPS';

  COUNT(*)
----------
       280
SQL>@?/rdbms/admin/utlrp.sql

SQL>  select count(*) from dba_objects where status='INVALID' and owner='APPS';

  COUNT(*)
----------
        15
SQL> select object_name from dba_objects where status='INVALID' and owner='APPS';

OBJECT_NAME
----------------------------------------
FFP55409_01012007
FFP55409_01012011
FFP55429_01011900
FFP60280_01010001
FFP60342_01010001
FFP60342_01012006
FFP60342_01012008
FFP60342_01012009
FFP60356_01011951
FFP61161_01010001
FFP61867_01010001
FFP61871_01010001
FFP61897_01010001
FFP61912_01010001
SECONDPROC

15 rows selected.
SQL>  ALTER PROCEDURE apps.SECONDPROC compile;

Warning: Procedure altered with compilation errors.

SQL> show error
Errors for PROCEDURE APPS.SECONDPROC:

LINE/COL ERROR
-------- -----------------------------------------------------------------
7/5      PLS-00103: Encountered the symbol "end-of-file" when expecting
         one of the following:
         begin function pragma procedure
Code:
create or replace procedure      secondproc as
 a number;
 procedure hello as
 begin
 execute immediate 'create table testvariables(id number,name1 varchar2(12))';
 -- execute immediate 'insert into testvariables values (1,''dd'');';
 end;

SQL> alter package apps.FFP61912_01010001 compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY APPS.FFP61912_01010001:

LINE/COL ERROR
-------- -----------------------------------------------------------------
513/1    PL/SQL: Statement ignored
513/5    PLS-00306: wrong number or types of arguments in call to
         'GET_ASSG_TERM_DATE'

in .../oacore_server1/logs(run)$ view access.log

xx.xx.192.21 - - [24/Mar/2022:09:10:39 +0100] "GET /OA_HTML/AppsLogin HTTP/1.1" 302 313
xx.xx.192.21 - - [24/Mar/2022:09:10:39 +0100] "GET /OA_HTML/AppsLocalLogin.jsp HTTP/1.1" 302 621
xx.xx.192.21 - - [24/Mar/2022:09:10:40 +0100] "GET /OA_HTML/RF.jsp?function_id=1032925&resp_id=-1&resp_appl_id=-1&security_group_id=0&lang_code=F&oas=mvFFJYIXcBk_xmDwYk
lW0Q..¶ms=Qz.q74Sn0Fpb-nR4ueBm5g HTTP/1.1" 200 19328
xx.xx.192.21 - - [24/Mar/2022:09:10:44 +0100] "GET /OA_HTML/cabo/styles/cache/skyros-desktopEXTN-custom-12_2_4_0_0-ie-11-windows.css HTTP/1.1" 200 80944
xx.xx.192.21 - - [24/Mar/2022:09:10:44 +0100] "GET /OA_HTML/cabo/jsLibs/Common12_2_4_0_0.js HTTP/1.1" 200 147622
xx.xx.192.21 - - [24/Mar/2022:09:10:44 +0100] "GET /OA_HTML/cabo/oajsLibs/oafcoreR122.js HTTP/1.1" 200 55145
xx.xx.192.21 - - [24/Mar/2022:09:10:44 +0100] "GET /OA_HTML/cabo/oajsLibs/oafb.js HTTP/1.1" 200 1278
xx.xx.192.21 - - [24/Mar/2022:09:10:44 +0100] "GET /OA_HTML/cabo/oajsLibs/oaGestureHandler.js HTTP/1.1" 200 37267
xx.xx.192.21 - - [24/Mar/2022:09:10:44 +0100] "GET /OA_HTML/cabo/oajsLibs/FNDWFWorklistService.js HTTP/1.1" 200 23460
xx.xx.192.21 - - [24/Mar/2022:09:10:44 +0100] "GET /OA_HTML/cabo/oajsLibs/popup.js HTTP/1.1" 200 35119
xx.xx.192.21 - - [24/Mar/2022:09:10:44 +0100] "GET /OA_HTML/cabo/oajsLibs/OAFSlideoutMenu_skyros.js HTTP/1.1" 200 175598
xx.xx.192.21 - - [24/Mar/2022:09:10:44 +0100] "GET /OA_HTML/cabo/oajsLibs/oaGestureLib.js HTTP/1.1" 200 41020
10.12.0.68 - - [24/Mar/2022:09:10:44 +0100] "GET /OA_HTML/media/oracle_white_logo.png HTTP/1.1" 200 4132

Where is Apache log?

Regards.

[big]

Hi,
Ichanged the code:
create or replace procedure secondproc as
 a number;
 procedure hello as
 begin
 execute immediate 'create table testvariables(id number, name1 varchar2(12) )';
 -- execute immediate 'insert into testvariables values (1,''dd'')';
 end;
begin
 hello;
end;
/
SQL>ALTER PROCEDURE apps.SECONDPROC compile;



Procedure altered.
In Apache log I had:
[OHS] [ERROR:32] [OHS-9999] [core.c] [client_id: xxx] [host_id: xxx] [host_addr: xxx] [tid: 2314] [user: xxx]
[ecid: 000003Xdhp_Fs1c5xjt1iW02Gk1I0000TI] [rid: 0] [VirtualHost: main]  File does not exist: /xxxx/portal/favicon.ico
I copied from another server and restarted apache:
./adapcctl.sh stop
./adapcctl.sh start

And the message:  File does not exist disappeared.


But the loop back problem persiste.

Regards.

[ErmanArslansOracleBlog]

This can be ignored Big -> File does not exist: /xxxx/portal/favicon.ico

[ErmanArslansOracleBlog]

*What is the SECONDPROC? Is it custom?
*you should check other standard (belong to non-custom schemas) invalid objects as well. (in addition to the ones that belong to apps)

Bytheway, Apache logs are under $IAS_ORACLE_HOME/instances/*/diagnostics/logs/OHS/EBS_web_*/*log

[big]

Thanks.
I don't think that SECONDPROC is custom.

More over we found in revers proxy log :

Code Message Description
SEC7112
"Script from [URL] was blocked due to mime type mismatch"

The HTTP response header for the JavaScript file that is specified by the URL has an "X-Content-Type-Options: nosniff "header, and did not have a content type declaration.

How and where mime type is defined for that ?

Thanks.

[ErmanArslansOracleBlog]

You have a reverse proxy there?  Why don't you say it in the first place??
Then that may be the issue.
check the config on reverse proxy.

This may be related with the security hardenings that are done on the reverse proxy.. Please ask your reverse proxy admin to check on his/or her side.

We don't have an EBS-specific document for this error that you see in your reverse proxy log, but we have one for Primavera -> Error: "SEC7112: Script from URL was blocked due to mime type mismatch" Or "Loading failed for the SCRIPT with source "URL" And "ReferenceError: NotificationsPollerAction is not defined" In Browser Network Developer Tools Browsing Web Pages In P6 (Doc ID 2475022.1)

There , you see, the cause is given as "having “X-Content-Type-Options: nosniff” HTTP Header within IIS (or any web server)." The action for the solution is taken on the web server side -- in your case, reverse proxy side of course.

Also check ->

E-Business Suite R12.2 : Is It Supported / Certified To Implement A Reverse Proxy Only Configuration In A DMZ Environment ? (Doc ID 2308126.1)
E-Business Suite Technology Stack Steps For Implementing A Reverse Proxy Alone In A DMZ Configuration - R12 (Doc ID 726953.1)

[big]

Thank you Erman.

I'll check it on monday.

Regards.