Sunday, November 12, 2017

FRM-92101: Forms Server Not Starting Up

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.




Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

Thursday, March 30, 2017

Oracle EBS Cloning with File System Cold Backup


Applies to:
Oracle EBS R12.1.3
Database 11.1.0.7.0
Operating System Oracle Enterprise Linux Server 5.8

Description:
Production hostname is EBSPROD
Test hostname is EBSTEST

Solution:
I am going to clone my Production server using file system cold backup.

Execute adpreclone.pl on DB Tier of EBSPROD:
$ cd /d01/oracle/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_ebsprod
$ perl adpreclone.pl dbTier pwd=apps

After completion of above script, then go to APPS Tier of EBSPROD:
$ cd /d01/oracle/PROD/inst/apps/PROD_ebsprod/admin/scripts
$ perl adpreclone.pl appsTier pwd=apps

After complete the above script, shutdown all services of APPS and DB and make tar files:

$ tar -czf PROD_DB_15Mar17_0030.tar.gz /d01/oracle/PROD/db
$ tar -czf PROD_APPS_15Mar17_0030.tar.gz /d01/oracle/PROD/apps
$ tar -czf PROD_INST_15Mar17_0030.tar.gz /d01/oracle/PROD/inst
$ tar -czf PROD_ARC_15Mar17_0030.tar.gz /archivelogs

After installation of OS and all necessary RPM’s and configuration, copy the above files on EBSTEST.

Now untar the above files one by one:

$ tar –xzvf /backup/PROD_DB_15Mar17_0030.tar.gz
$ tar –xzvf /backup/PROD_APPS_15Mar17_0030.tar.gz
$ tar –xzvf /backup/PROD_INST_15Mar17_0030.tar.gz
$ tar –xzvf /backup/PROD_ARC_15Mar17_0030.tar.gz

 

Now start the cloning process on DB Tier first:














Database Tier has been successfully cloned. All services of Database Tier are up and running.

Now we are going to start the cloning process at APPS Tier:









 We have cloned successfully.


Your comments, especially which will help us improve the functionality, will be greatly appreciated.

How to Extend Swap space on LVM Disk Linux

How to Extend Swap space on LVM Disk Linux   Applies to:             Oracle Database 12.2             Oracle Linux 7 Description: ...