oafm,forms and oacore not starting up after IP adress change

oafm, forms and oacore not starting up after IP adress change of the Oracle Applications Error from the logs:
adformsctl.sh: exiting with status 204
adoafmctl.sh: exiting with status 204
adoacorectl.sh: exiting with status 204

This is because the OC4J lock files contains the IP adress, after the ip adress change the lock files includes the wrong Ip adress which caused the OJ4J to fail.

To implement the solution perform the following steps:

1 - open a new shell and set your apps environment
2 - cd $ADMIN_SCRIPTS_HOME3 - adopmnctl.sh stop
4 - check if it is really down: ps -ef grep grep opm
5 - delete the following:

rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*

6 - adopmnctl.sh start
7 - check if the issue has been resolved: adapcctl.sh status

http://host:port/forms/frmserlvlet not loading

http://host:port/forms/frmserlvlet does not load after installing formsbuilder11g even after enabling ActiveX controls in Internet explorer. For this, download and install the latest JRE and install it for the URL to work.

Installing Oracle Forms builder & Services 11G in windows

Perform the below steps to install Oracle Forms 11g and forms services on Windows.

- Download Oracle Weblogic server (Navigation: otn.oracle.com > downloads > Middleware: Weblogic server )

- Download Oracle Forms, Reports and Discoverer (Navigation: otn.oracle.com > Downloads > Middleware: Oracle Fusion Middleware 11gR1)

- Extract the two files Disk1_1of2 and ..disk1_2of2 and it creates disk directories (disk1, disk2, disk3 and disk4).

- Double click the setup.exe in the root of the disk1 folder.

- Click install and configure.

- The installer checks for System pre-requisites.

- Choose the Oracle Middleware location. This is where I installed the middleware home of Jdeveloper 11g

- Select Oracle Forms and Reports including the correct server components. And after accepting the defaults in the following steps choose [Finish] and the installation starts.

- The installer installs a one- off patch and then starts the configuration.

- Add TNS entry for the instance in tnsnames.ora under ([HOME_DRIVE]:\Oracle\Middleware\asinst_1)

- The forms builder can be accessed from the following menu (Start > Programs > Oracle classic instance > Developer tools > Forms Builder.)

COMMON ERRORS ENCOUNTERED WHEN COMPILING FORMS WITH A "NON - ORACLE" user

1. Permission denied when running the forms executables
Cause: Non-oracle user does not have access to the ORACLE_HOME/bin/frm* executables
Solution: Allow access and execution of ORACLE_HOME/bin/frm*chmod +rx $ORACLE_HOMEchmod +rx $ORACLE_HOME/binchmod +rx $ORACLE_HOME/bin/frm*

2. Solaris: ld.so.1: frmcmp_batch: fatal: ORACLE_HOME/lib/libig.so.0: Permission deniedSUSE/Linux: error while loading shared libraries: libig.so.0: cannot open shared object file: No such file or directory
Cause: Non-oracle user does not have access to the libraries required by the compiler.
Solution: Allow read/execute access to ORACLE_HOME/libchmod -R +rx ORACLE_HOME/lib

3. Message file ORACLE_HOME/forms/mesg/fmcus.msb not found.
Cause: Forms is trying to display a message (error) but does not have access to the messages file.
Solution: Allow access to Forms messages files:chmod +rx ORACLE_HOME/formschmod -R +rx ORACLE_HOME/forms/mesg

4. FRM-91500: Unable to start/complete the build.
Cause: This error is generic but it may suggest that non-oracle user does not have access to the needed terminal file (.res) or that the environment is not correctly set.
Solution:a) Allow access to the terminal files:chmod -R +rx ORACLE_HOME/forms/admin
b) Edit frmcmp_batch.sh and addTERM=vt220export TERM
For additional troubleshooting of this specific error please check Note 756384.1 and Note 266731.1

5. FRM-91108: Internal Error: unable to initialize PL/SQL.
Cause: User does not have access to the timezone files
Solution: Allow access to "ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"chmod +rx ORACLE_HOME/oracorechmod -R +rx ORACLE_HOME/oracore/zoneinfo

6. Error while trying to retrieve text for error ORA-12154
Cause: Forms is trying to display a message (non-forms error) but does not have access to the messages file.
Solution: Allow access to the RDBMS messages fileschmod +rx ORACLE_HOME/rdbmschmod -R +rx ORACLE_HOME/rdbms/mesg

7. ORA-12154: TNS:could not resolve the connect identifier specified
Cause: Forms executables cannot read the required ".ora" files required for making a successful DB connection.
Solution: Allow access to the "$ORACLE_HOME/network/admin/" folderchmod +rx ORACLE_HOME/network/chmod -R +rx ORACLE_HOME/network/admin/*

8. FRM-10043: Cannot open file. orFRM-10044: Cannot create file.
Cause: Incorrect access to the FMB specified
Solution: Check if all the folders contained in the "module" parameter are having "rx" right for other users.Also, check if the "non-oracle" user has "rwx" access to the FMB

9. FRM-30087: Unable to create form file $ORACLE_HOME/forms/test.fmx
Cause: Non-oracle user cannot write in the "output" directory or the mentioned fmx exists but user cannot overwrite it.
Solution: By default the FMX is being created in the same directory with the FMB.Give write permission in that folder and check if FMXs with the same name are already there and if the non-oracle user can overwrite them.Also, make use of the "output_file=" parameter within the compile command to specify a location (with correct access) where the FMX should be created.

Forms Version Not Showing On 'About Oracle Applications' Form From Help Menu

While doing post-installation step for upgrading Forms/Reports 10g, version number is Blank under 'Forms Server' on 'About Application'form from Help menu.

The issue is caused by the following setup:Missing setup of FND: Diagnostics profile option

To implement the solution, execute the following steps:

- Go into the responsibility: System Administrator
- Navigate to MENUPATH > System -> Profile.
- FND: Diagnostics set to Y = Yes
- Bounce middle-tier server for this change to take affect.
- Retest the issue.

Script to find Apache, Java, JRE, Forms version for Oracle E-Business Suite R12

The shell script below can be used to collect Apache, Java, Client JRE, Forms, Perl, PL/SQL versions and Forms communication mode from a Oracle R12 environment. This script should be run only in a *nix environment against a R12 instance only.

The script shows the output on screen, which is also captured in the file "zz_.txt" which is created in the current directory




(
echo "Script Started "
date
## The script shows output on screen and creates file named hostname_date.txt file in current ## directory
## Collect the Apache version
echo "*****Apache Version*****"
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v
echo " "
## Collect perl version
echo "*****perl version******"
$IAS_ORACLE_HOME/perl/bin/perl -v|grep built
echo " "
## Collect Java version
echo "******Java Version******"
sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"
echo " "
## Collect client JRE version
echo "*****Client JRE version*****"
cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35
echo " "
## Collect Forms version
echo "*****Forms Version*****"
$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
echo " "
## Collect PL/SQL Version
echo "*****PL/SQL Version****"
$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version
echo " "
## Collect Forms communication mode
echo "****Forms Communication Mode****"
cat $FORMS_WEB_CONFIG_FILE|grep serverURL=
echo "If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet"
echo " "
echo "Script Completed Successfully and it has generated the file zz`hostname`_`date +%m%d%y.%H%M`.txt file in current directory"
echo "Script completed "
date
) 2>&1 | tee zz`hostname`_`date +%m%d%y.%H%M`.txt

How to Get the Forms,PLL,LDT,Reports Version from O/S level

Login in as the user who owns the application file system,

1. Forms

When considering forms one needs to get the version from $JA_TOP and $AU_TOP as well.

Navigate to cd $JA_TOP/forms/US

Execute command --- > strings -a grep '$Header'

Example

strings -a JAINPORE.fmx grep '$Header'

Navigate to cd $AU_TOP/forms/US

Execute command --- > strings -a grep '$Header'

Example

strings -a JAINPORE.fmb grep '$Header'

2. Reports

Navigate to cd $JA_TOP/reports/US

Execute command --- > strings -a grep '$Header'

Example

strings -a JAINARDR.rdf grep '$Header'

3. Library files

Navigate to cd $AU_TOP/resource

Execute command --- > strings -a grep '$Header'

Example

strings -a CUSTOM.pll grep '$Header'

4. LDT

Navigate to cd $JA_TOP/patch/115/import/US

Execute command --- > strings -a grep '$Header'

Example

strings -a jai115cp_F.ldt grep '$Header'