2
Oct

REP-0004: Warning: Unable to open user preference file

Symptoms:

Concurrent request logfiles have the below error:

REP-0004: Warning: Unable to open user preference file

 

Cause:

The prefs.ora is either missing or non-accessible.

 

Solution:

1. No prefs.ora file in HOME directory:

Oracle Reports will look into the user's HOME directory for the prefs.ora preferences file.  If a prefs.ora file does not exist in your HOME directory, you can copy the prefs.ora file that came with the Oracle Tools.

Read more...

1
Nov

Oracle E-Business Suite Forms not opening in Internet Explorer

Issue:


After logging in and clicking on any form, java installation window opens up even though the correct java version is installed on client PC’s.
This issue is seen on all client machines.

Issue occurs for all EBS Users who are using Internet Explorer.

Cause:

Classid is not set properly in $FORMS_WEB_CONFIG_FILE.
EBS looks for classid to launch the form.

Download Java

Java version already installed
Read more...

23
Aug

Error on libdb Library Starting Oracle EBS Application Services on Linux Platforms

Error :

While starting the application services, Apache services do not start.

Error in the log file:
/dap01/appldev/EBSDEV/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb-4.3.so: cannot open shared object file: No such file or directory

Cause:

This is caused by having an older Oracle HTTP Server installed on a newer Operating System. For the OPatch issue, Perl is expecting to find the /usr/lib/libdb-3.3.so library, but it is missing.
The following command locates a higher version of the library (for example, /usr/lib/libdb-4.1.so)

/libdb ls -al /usr/lib *.so
 
Note that the error can be a newer library, depending which is found and used from the operating system. (e.g., libdb-4.2.so, libdb-4.3.so, libdb-4.4.so, etc).

The correct libdb filename to use should depend on output of ldd httpd, for example:


cd $ORACLE_HOME/Apache/Apache/bin
ldd httpd | grep libdb
libdb.so.2 => /usr/lib/libdb.so.2 (0x00868000)

•In this case, libdb.so.2 is expected
•In this case, having libdb-3.3.so will not help

Read more...

11
Apr

Error on login page of Oracle E-Business Suite

Error:

Unable to generate forwarding URL. Exception: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.

ORA-00257: archiver error. Connect internal only, until freed

Solution:

Check Flash Recovery Area usage:

SELECT
ROUND((A.SPACE_LIMIT / 1024 / 1024 / 1024), 2) AS FLASH_IN_GB,
ROUND((A.SPACE_USED / 1024 / 1024 / 1024), 2) AS FLASH_USED_IN_GB,
ROUND((A.SPACE_RECLAIMABLE / 1024 / 1024 / 1024), 2) AS FLASH_RECLAIMABLE_GB,
SUM(B.PERCENT_SPACE_USED) AS PERCENT_OF_SPACE_USED
FROM
V$RECOVERY_FILE_DEST A,
V$FLASH_RECOVERY_AREA_USAGE B
GROUP BY
SPACE_LIMIT,
SPACE_USED ,
SPACE_RECLAIMABLE;
Read more...

Back to Top