Category Archives: ERP - Page 3

Relink Executables In AD_TOP

Posted by on July 23, 2012 No comments

Problem:

How do I relink executables in AD_TOP?

Solution:

Run adrelink.sh from command line to relink all AD executables by performing the following steps:

Open new MS DOS prompt.
Change directory to APPL_TOP.
Run relink[CONTEXT_NAME].cmd where CONTEXT_NAME is set to the customer specific context name. For example, ‘$ relinkVIS_host1.cmd’ where CONTEXT_NAME IS ‘VIS_host1’.
Run the APPS.SH script, as in $ . ./APPS.SH
Run adrelink.sh to relink executables. For example: $ sh adrelink.sh force=y “ad all”

setClassPath: Unable to get PATH from environment or registry

Posted by on July 22, 2012 No comments

Problem:

After installing R12.1.1 Vision instance on Windows 2008, all concurrent processes remain on phase ‘Inactive’ and status ‘No Manager’.

Checked concurrent manager log file, located in:
C:oracleVISinstappsVIS2_hostnamelogsapplconclog

At first, CM_VIS2_hostname.log was blank, but then eventually filled with log information. The following message was seen:

setClassPath: Unable to get PATH from environment or registry!:
The operation completed successfully.

Solution:

The PATH environment variable exceeds 1024 characters.

Shorten the system path (e.g. remove duplicate entries), so that it does not exceed 1024 characters and ensure that the Windows directories are accessible.

Reference:

376946.1 – Some Managers Fail to Start With ‘setClassPath: Unable to get PATH from environment or registry’
199417.1 – Length of CLASSPATH Environment Variable May Cause Errors In Oracle Applications
761687.1 – Concurrent Manager Fails To Start After 11.5.10.2 and 9iAS Upgrade

Perl lib version (v5.6.1) doesn’t match executable version (v5.8.3)

Posted by on July 20, 2012 No comments

Problem:

While cloning E-Business Suite R12 on Windows 2008 to a new machine, the following error appears:

C:oracleTEST2dbtech_st11.1.0appsutilclonebin>perl adcfgclone.pl dbTier
Perl lib version (v5.6.1) doesn't match executable version (v5.8.3) at C:oracle
UAT1appstech_st10.1.2perl5.6.1libMSWin32-x86/Config.pm line 21.
Compilation failed in require at adcfgclone.pl line 28.
BEGIN failed--compilation aborted at adcfgclone.pl line 28.

Solution:

Unset PERl5LIB environment variable.

Read more »

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3395507964_562

Posted by on July 19, 2012 1 comment

Problem:

Checked alert log file  and saw the following errors:

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition 
WRH$_ACTIVE_3395507964_562 by 128 in                 tablespace SYSAUX 
MMON Flush encountered SYSAUX out of space error(1688).
MMON (emergency) purge of WR snapshots (546) and older
ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition 
WRH$_ACTIVE_3395507964_562 by 128 in                 tablespace SYSAUX 
MMON Flush encountered SYSAUX out of space error(1688).
MMON (emergency) purge - nothing to purge, pgsid=0.

Solution:

Add a new datafile to the SYSAUX tablespace.

Read more »

Sharing Violation While Backing Up Oracle on Windows

Posted by on July 18, 2012 No comments

Problem:

While backing up DEV1 instance on Windows 2008, the following error appears:

C:oracleDEV1instappsDEV1_ittl-hrmstestappltmpOFF446.tmp
Sharing violation

Solution:

Ensure that the Oracle processes are stopped in Windows Services.

It appears that there are still (orphan) database processes running. Right click the Taskbar and open Task Manager. Select the Processes tab. From the View menu, click Select columns. In Select Process Page Columns, scroll down the list and check Command Line. Delete any processes that start with C:oracleDEV1.

Help target US/FND/@OAM_WF_GSC_MLR_DETAILS could not be found

Posted by on July 16, 2012 No comments

Problem:

On the page:
Applications System:DEV1  >   Workflow  >   Service Components  > Component Details: Workflow Notification Mailer: DEV1

after clicking the Help link, the following error appears:

404 NOT FOUND 

An error occurred while retrieving Oracle Applications Help information. 

Help target US/FND/@OAM_WF_GSC_MLR_DETAILS could not be found.

Solution:

Bug in EBS help files. Instead, manually navigate to help file:

Help Contents > Applied Technology > Oracle Workflow > Administrator’s Guide > Oracle Workflow Manager

 

Reference:

Help Files in OAM Error Help Target US/FND/@OAM_WF_GSC_MLR_DETAILS Could Not Be Found [ID 1074282.1]

ERROR – RDA execution failed (9009)

Posted by on July 12, 2012 No comments

Problem:

When running RDA from Application Diagnostics, the following error appears in the output report:

ERROR - RDA execution failed (9009)
ACTION - Review the output of the RDA command (shown below) to determine the cause 
of this error

Solution:

In APPL_TOP, create APPSORA.cmd from APPSSID_hostname.cmd.

Read more »

An error occurred while attempting to establish an Applications File Server connection with the node FNDFS

Posted by on July 5, 2012 No comments

Problem:

In R12, after a concurrent request is run and the log file is viewed, when Tools –> Copy File is selected, a browser window opens and displays the following message:

An error occurred while attempting to establish an Applications File Server 
connection with the node FNDFS_. There may be a network configuration problem, 
or the TNS listener on node FNDFS_ may not be running. Please contact your 
system administrator.

Solution:

Set the RRA: Enabled system profile to Yes at the site level, log off and then log back on.

[amazon asin=0070077290&template=iframe image&chan=default]    [amazon asin=1453742735&template=iframe image&chan=default]    [amazon asin=0615238440&template=iframe image&chan=default]

Predefined HRMS Alerts Missing

Posted by on July 5, 2012 No comments

Problem:

After installing R12 on Windows 2008, the predefined HRMS alerts (referred to in the Alerts documentation) missing.

Solution:

Use the FNDLOAD command to manually upload the missing alerts.

Read more »

perl: error while loading shared libraries: libdb.so.3: cannot open shared object file: Permission denied

Posted by on July 2, 2012 No comments

Problem:

While installing R12 on Linux, the following error appears:

perl: error while loading shared libraries: libdb.so.3: cannot open shared object 
file: Permission denied

General Solution:

– As per an internal Bug:4045349, this is an issue with O/S side installation of compat-db rpm.
libdb.so.3 gets installed when compat-db rpm is installed.

– The O/S installation CD would contain compat-db
e.g compat-db-4.1.25-6.i386.rpm ( may change as per your version ).

– Manually install the compat-db rpm
e..g “rpm -ivh compat-db-4.1.25-6.i386.rpm”
(Contact the O/S Administrator for more information to install the compat-db rpm and correct  command )

– Once it is done, re-try to install the applications. ( if the screen shows the Re-try option )

OR

– Remove/clean the current installation ( refer Note:169402.1 ) and re-install the application.

This would resolve the “..libdb.so.3…” error.

Solution in this situation:

[root@oel5vis4bi lib]# pwd
/usr/lib
[root@oel5vis4bi lib]# ls -al libdb.*
lrwxrwxrwx 1 root root   22 Mar 22 15:01 libdb.so -> ../../lib/libdb-4.3.so
-rwxr-x--- 1 root root 5825 Jul  2 11:53 libdb.so.2
-rw-r--r-- 1 root root 5825 Mar 23 11:40 libdb.so.2.6078836
lrwxrwxrwx 1 root root   19 Mar 23 11:42 libdb.so.3 -> /usr/lib/libdb.so.2
[root@oel5vis4bi lib]#

libdb.so.2 extracted from patch 6078836

Change permission on libdb.so.2 to 644:

chmod 644 libdb.so.2

Reference:

11.5.10 Installation Fail on RedHat Server. Error while loading shared libraries: libdb.so.3 [ID 294043.1]