Tuesday, May 26, 2009

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.

1 comment:

tikitodo said...

there are many ways of data recovery pdf, try this application if you’d like to get better results