Tag Archives: 11i Troubleshooting

Responsibilities Not Appearing After Logon

Posted by on July 20, 2011 No comments

Problem: After logging on to Oracle Applications E-Business Suite, a custom responsibility is not appearing. This responsibility has disappeared for all users.

Solution: Checked My Oracle Support document “During Login Responsibilities Assigned to Users do not Appear in the Navigator Page [ID 565130.1]”. However, this did not resolve the issue.

Under the System Administrator responsibility, navigated to Security > Responsibility > Define, then queried for the responsibility that was not appearing (F11, Ctrl+F11). Under the Available From section on the form, the “Oracle Mobile Applications” option was selected. Selected “Oracle Applications” option, and then saved. After logging out and logging back in, the user was able to access the responsibility.

“Compile Security” Concurrent Request completes in error

Posted by on June 29, 2011 No comments

Problem: When the user runs the concurrent request for “Compile Security”, it completes with error.

Solution: On the database server, the /var directory has completely filled up and there is no free space. This directory is used by E-Business Suite as the temp directory (in reality, EBS uses/usr/tmp, which symbolically links to /var/tmp). The space is filled due to the yum daemon, which automatically downloads updates from Red Hat to the /var/cache/yum directory.

To resolve this issue, log on to the system as the root user and either delete the contents of the /var/cache/yum directory using ‘rm -f /var/cache/yum’, or execute the command ‘yum clean all’. To stop the yum-updatesd daemon, run the command ‘service yum-updatesd stop’ or ‘/etc/init.d/yum-updatesd stop’.

Unable to make a network connection

Posted by on October 6, 2009 No comments

Problem: When configuring Workflow Mailer, and no password is entered for the Inbound Mailer Server (IMAP), the instance pauses for a few seconds, then returns:

Unable to make a network connection

Solution:

If a valid mail server is entered into the Inbound Server Name under Inbound Email Account, but invalid username and password is entered, the following message appears:

Unable to connect to the mail account. Check the host, user name and password.

If a valid mail server is entered into the Inbound Server Name under Inbound Email Account, and a valid username and password is entered, the following message appears:

Validation

Need to put a valid username and password into the Inbound Server Name.

Ensure that the Test Email Address and Reply-To email addresses are different.

e.g. dbadmin@school.com, surajini.shrivastav@school.com

Post-install checks fail after installing

Posted by on December 11, 2008 No comments

Problem:

After installing Oracle Applications E-Business Suite 11.5.10.2 on Windows, the post installation checks (HTTP Check, JSP Check, PHP Check) fail.

Solution:

Install Microsoft XML (msxml3.msi) located in downloadsXML.

Unable to initialize threads

Posted by on December 6, 2008 No comments

Problem:

Running adstpall.sh returns the following error:
[applmgr@ebusinesstest TEST_ebusinesstest]$ ./adstpall.sh apps/apps
You are running adstpall.sh version 115.17
/u0/oracle/testcomn/util/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
Unable to initialize threads: cannot find class java/lang/Thread
Could not create Java VM
Check logfile /u0/oracle/testcomn/admin/log/TEST_ebusinesstest/04061425.log for details
Exiting with status 1
[applmgr@ebusinesstest TEST_ebusinesstest]$

Solution:

Subject:        GLIBC_2.0 not defined in file libc.so.6

Note:275161.1

export LD_ASSUME_KERNEL=2.4.19

Cannot complete applications logon

Posted by on December 5, 2008 No comments

Problem:

Cannot complete applications logon.  You may have entered an invalid applications password, or there may have been a database connect error.

Solution:

Use Metalink Doc ID: 153053.1 to reset the SYSADMIN password to WELCOME.

Internal Server Error

Posted by on December 4, 2008 No comments

Problem:

Internal Server Error when trying to log in to Oracle Applications

Solution:

Ran out of tablespace. Checked alert log to tablespaces to extend.

Changing Domain Name in Oracle Applications 11i

Posted by on October 15, 2008 No comments

This documentation shows how to change the network domain name of the server that houses an Oracle Applications 11i instance (ebusiness).

  1. Log on to the ebusiness server (either on the console or using VNC or PuTTY). Run the network system settings tool (Red Hat menu > System Settings > Network).

Change the server name from ebusiness.support.com to ebusiness. illuminatnm.com. Save the settings. Do not attempt to restart the network services using this tool, since it will disconnect the remote connection tool.

  1. Edit the context file $APPL_TOP/admin/TEST_ebusiness.xml and replace ‘support.com’ with ‘illuminatnm.com’. With vi, use this command:
:%s/support.com/illuminatnm.com/g

Save the context file and exit the text editor.

  1. Stop the application tier services and then run AutoConfig on the database and application tiers:
cd /u0/oracle/testcomn/admin/scripts/TEST_ebusiness
./adstpall.sh

On the database tier:

cd /u0/oracle/testdb/9.2.0
. TEST_ebusiness.env
cd /u0/oracle/testdb/9.2.0/appsutil/scripts/TEST_ebusiness
./adautocfg.sh

On the application tier:

cd /u0/oracle/testappl
. APPSORA.env
cd /u0/oracle/testcomn/admin/scripts/TEST_ebusiness
./adautocfg.sh

Run the database tier and application tier AutoConfig processes in separate sessions (terminal windows).

  1. As the root user, update the hosts file on the server (/etc/hosts) to reflect the new host name:
x.x.x.x   ebusiness.illuminatnm.com   ebusiness
  1. As the root user, restart network services:
service network restart
  1. As the applmgr user, bounce the application tier services.
cd /u0/oracle/testcomn/admin/scripts/TEST_ebusiness
./adstpall.sh
(wait five minutes)
./adstrtal.sh
  1. Log on to the E-Business TEST application on the client machine using the new URL:
http://ebusiness.illuminatnm.com:8001

If E-Business Suite does not launch properly, reboot the server. After booting, start the application tier services. Then log on to the TEST instance.

Metalink References:

Note: 177311.1 – How to Change Domain Name in Oracle Applications 11i

Note: 342332.1 – Troubleshooting Login Problems in Oracle Applications 11i (11.5.2 – 11.5.10+)

Insufficient privileges for cloning

Posted by on September 23, 2008 No comments

Problem:

When trying to log on to the newly cloned TEST instance as sysadmin user, the following error appears:

You have insufficient privileges for the current operation. Please contact your System Administrator.

Solution:

Used URL:

http://ebusinesstest.support.com:8001/OA_HTML/jsp/fnd/aoljtest.jsp

to compare differences between TEST and PROD. Noticed that JSP Ping not working on both.

In Metalink, searched for error:

java.lang.StringIndexOutOfBoundsException: String index out of range: -1

Checked document: Subject:  Troubleshooting Login (Doc ID:  Note:178437.1), “3. Login: java.lang.StringIndexOutOfBoundsException when log into jtflogin.jsp”

In SQL*Plus, executed the following code:

select SESSION_COOKIE_DOMAIN from icx_parameters;

update icx.icx_parameters set SESSION_COOKIE_DOMAIN = ‘.support.com’;

commit;

select SESSION_COOKIE_DOMAIN from icx_parameters;

Tested logon on ebusinesstest, working now.

Reference:

Subject:  Configuring and Troubleshooting the Self Service Framework 5.5.2 with 11i (Doc ID:  Note:177095.1)

Important 11i Files, Directories, Locations

Posted by on September 19, 2008 No comments

This documentation lists important files, directories and locations.

Output for adadmin and adpatch:

$APPL_TOP/admin/<SID>/log

Output for concurrent requests:

$COMMON_TOP/admin/log/<CONTEXT_NAME>

$COMMON_TOP/admin/out/<CONTEXT_NAME>

Output files from installation:

Database logfile:

$ORACLE_HOME/appsutil/log/<CONTEXT_NAME>

e.g. C:oraclevisdb9.2.0appsutillogVIS_eam 11060210.log

Appltop logfile:

$APPL_TOP/admin/<CONTEXT_NAME>/log

e.g. C:oraclevisappladminVIS_eamlog11060210.log

Output files from running AutoConfig:

Database logfile:

<RDBMS ORACLE_HOME>/appsutil/log/<CONTEXT_NAME> /<MMDDhhmm>/adconfig.log

e.g. C:oraclevisdb9.2.0appsutillogVIS_eam 11160751adconfig.log

Appltop logfile:

<APPL_TOP>/admin/<CONTEXT_NAME>/log/<MMDDhhmm>

e.g. C:oraclevisappladminVIS_eamlog11060210.log

Output files from running TUMS:

$COMMON_TOP/temp

Database context file:

<RDBMS ORACLE_HOME>/appsutil/<CONTEXT_NAME>.xml

e.g. C:oraclevasudb9.2.0appsutilVASU_localhost.xml

Application context file:

$APPL_TOP/admin/<CONTEXT_NAME>.xml

e.g. C:oraclevasuappladminVASU_localhost.xml

Concurrent manager log file:

$APPLCSF/$APPLLOG/SID_MMDD.mgr

JInitiator files:

$APPL_TOP/admin/appltop.cer

$APPL_TOP/admin/adsign.txt

$APPL_TOP/admin/adcert.txt

$HOME/identitydb.obj (/home/applmgr)

Launch Forms Logon:

http://<server>:<port>/dev60cgi/f60cgi

Launch Self Service Personal Home Page Mode (“Personal Home Page”):

http://<server>:<port>/OA_HTML/US/ICXINDEX.htm

Launch Self Service Personal Home Page Mode (“Framework only”):

http://<server>:<port>/oa_servlets/AppsLogin

Test your Webserver setup for Self Service Framework Applications:

http://ebusinesstest.support.com:8001/OA_HTML/jsp/fnd/aoljtest.jsp