Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Forms Active Sessions
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.
Best Answer
-
In Fusion Middleware Control under the Forms instance, open the User Sessions page.
Answers
-
In Fusion Middleware Control under the Forms instance, open the User Sessions page.
-
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.
-
There is no option to download.
I don’t believe OHS has a similar page as the Forms Sessions page.
-
So It shows only active sessions, Is there any options to see the forms user session history?
-
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.
-
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.
-
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.
-