Forms Active Sessions

Soofi

Hi All,

Is there any report available in EM/Console to get the list of active sessions for Oracle Forms?

I can see access.log in <Domain_home>/Servers/WLS_FORMS/logs/. But I wanna know is there any other reports available in weblogic.

Michael Ferrante-Oracle

In Fusion Middleware Control under the Forms instance, open the User Sessions page.

Michael Ferrante-Oracle

In Fusion Middleware Control under the Forms instance, open the User Sessions page.

Soofi

I don't see any option to download the report.

Is it possible I can download the report?

@Michael Ferrante-Oracle is there a report for ohs? I need to reconcile http and https calls to the server since I configured ssl in ohs.

Michael Ferrante-Oracle

There is no option to download.

I don’t believe OHS has a similar page as the Forms Sessions page.

Soofi

So It shows only active sessions, Is there any options to see the forms user session history?

Michael Ferrante-Oracle

No. That may be something you can do with the full Enterprise Manager product, but that would need to be confirmed. Because much of the session information is stored in the DB when the user connects (from the Forms app), you can create your own audit-like system by accessing V$SESSION. There are probably many other ways to do audit functionality. What I suggested is just one idea off the top of my head.

Soofi

May I know what do you mean by "full Enterprise Manager product"?

Also, Whether Oracle DB(Oracle Database 19c Enterprise Edition Release 19.0.0.0.0) internally stores DB login attempts in any of its audit table?

like UNIFIED_AUDIT_TRAIL stores data for specific database actions.

Michael Ferrante-Oracle

Information about Enterprise Manager can be found here:

https://www.oracle.com/enterprise-manager/

Forms connects to the DB just like any other client/user connecting via OracleNet (aka SqlNet). So whatever auditing is available in those non-Forms cases should work the same way with Forms. You should post your DB audit questions in one of the DB forums. However, keep in mind that many people in those forum areas may not be familiar with Forms and therefore you should post your question somewhat generically and not Forms specific.

Soofi

Thanks @Michael Ferrante-Oracle for your swift response.

Regards,

Soofi