How do I check Data Guard apply lag?

Query V$DATAGUARD_STATS and review the Apply Lag value.

How do I check Data Guard transport lag?

Query V$DATAGUARD_STATS and review the Transport Lag value.

How do I detect archive gaps?

Use SELECT * FROM V$ARCHIVE_GAP.

What is RMAN Backup Validation?

RMAN Backup Validation verifies Oracle backup integrity and recoverability without performing a restore.

What does RESTORE DATABASE VALIDATE do?

It verifies that RMAN backups can be restored successfully without actually restoring files.

How do I detect Oracle block corruption?

Use V$DATABASE_BLOCK_CORRUPTION and RMAN VALIDATE DATABASE CHECK LOGICAL.

What are the most important Oracle DBA interview topics?

Oracle Architecture, RMAN, Backup and Recovery, Data Guard, RAC, Performance Tuning, Security, and Troubleshooting are the most important Oracle DBA interview topics.

Is Oracle DBA still a good career in 2026?

Yes. Oracle DBA remains a strong career path due to the widespread use of Oracle databases in enterprise environments.

What Oracle version should I learn in 2026?

Oracle 19c and Oracle 23ai are the most valuable Oracle database versions to learn in 2026.

Forms Server Not Starting Up / Forms Server Start Up Issue

Applies to:

Oracle Enterprise Linux – Version: 5

Oracle EBS R12

Description:

After cloning EBS R12 successfully on a new server machine, when I am going to access any form on EBS clone it did not open the page and show the following error:

FRM-92101: Forms Server
Java Exception:
oracle.forms.net.ConnectionException: Forms session <1> failed during startup: no response from runtime process
at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source)
at oracle.forms.net.HTTPNStream.getResponse(Unknown Source)

I have restarted all the services of application and database but the problem is same. I have also restarted the whole machine/server but still the same issue.

Cause and Solution:

I found the following error:

In $LOG_HOME/ora/10.1.3/j2ee/<oacore>/<oacore>_<default_group_1>/application.log

$LOG_HOME/ora/10.1.3/j2ee/<forms>/<forms>_<default_group_1>/application.log

$LOG_HOME/ora/10.1.3/j2ee/<oafm>/<oafm>_<default_group_1>/application.log

12/11/17 20:42:50 formsweb: Forms session <2> exception stack trace:
oracle.forms.engine.RunformException: Forms session <2> failed during startup: no response from runtime process
at oracle.forms.servlet.RunformProcess.connect(Unknown Source)
at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)
12/11/17 20:42:50 formsweb: Forms session <3> aborted: runtime process failed during startup with errors /d01/app/oracle/ebstest/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory
12/11/17 20:42:50 formsweb: Forms session <3> exception stack trace:
oracle.forms.engine.RunformException: Forms session <3> failed during startup: no response from runtime process.

The above issue caused due to the incorrect version or missing of openmotif21 package.

Please check the oracle document 402310.1 Oracle Applications Installation and Upgrade Notes

in order to identify the missing RPM.

After installing the required RPM openmotif21-2.1.30-11.EL5 above problem has been resolved.

Download Required RPM from:
https://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/

👉 Check our complete guide: Oracle Error Codes Guide

Author Box

About the Author

Rana Abdul Wahid is an experienced Oracle Database Administrator with expertise in Oracle Database Administration, Oracle Data Guard, RMAN Backup & Recovery, Oracle RAC, Oracle E-Business Suite, Performance Tuning, and High Availability Solutions.

Through this blog, he shares practical Oracle DBA solutions, troubleshooting guides, interview preparation resources, and production-tested best practices for database professionals worldwide.