Sunday, 30 August 2015

EBS : FRM-92100

Error:

While java is loading FRM-92100 error is coming in all Forms.


Solution:

1. Take the backup of $CONTEXT_FILE
2. Change the context file parameter "s_forms_jvm_start_options", and add parameter:
-Doracle.net.disableOob=true
FROM:
<forms_jvm_start_options oa_var="s_forms_jvm_start_options">-server -verbose:gc -Xmx256M -Xms64M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCTimeStamps -XX:+UseTLAB -XX:+UseParallelGC -XX:ParallelGCThreads=2 -Djava.security.policy=$ORACLE_HOME/j2ee/oacore/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -Doracle.security.jazn.config=/d01/UAT/inst/apps/UAT_erpapp02/ora/10.1.3/j2ee/forms/config/jazn.xml</forms_jvm_start_options>
TO:
<forms_jvm_start_options oa_var="s_forms_jvm_start_options">-server -verbose:gc -Xmx256M -Xms64M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCTimeStamps -XX:+UseTLAB -XX:+UseParallelGC -XX:ParallelGCThreads=2 -Djava.security.policy=$ORACLE_HOME/j2ee/oacore/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -Doracle.security.jazn.config=/d01/UAT/inst/apps/UAT_erpapp02/ora/10.1.3/j2ee/forms/config/jazn.xml -Doracle.net.disableOob=true</forms_jvm_start_options>
3. Run Autoconfig
4. Restart the application services

Reference : Intermittently Occurs FRM-92100 For All EBS Forms With "recv failed" Error Code (Doc ID 1908029.1)

Tuesday, 25 August 2015

EBS : Login page alignment issue as Arabic login

Error:

When the login page is changed to arabic login, Some of the login areas are displayed nearly out of the browser window and USERNAME and PASSWORD fields are aligned on the left hand side vs centered.

Solution:

1) Log into the application as the "System administrator" responsibility
2) Choose Profile > System
3) Click in the USER field and add the username GUEST
4) Set the following profile options at user level

Personalize Self-Service Defn = No

5) Save the changes
6) Bounce the E-Business suite web tier services
7) Re-test the login issue

Reference : Main Login Page Layout Issue In BIDI Languages such as Arabic and Hebrew (Doc ID 453279.1)

Wednesday, 12 August 2015

EBS : For specific users after login Null pointer exceptions

Error:

## Detail 0 ##
java.lang.NullPointerException
at java.util.Hashtable.put(Unknown Source)
at oracle.apps.fnd.common.DBPreferenceStore.load(DBPreferenceStore.java:162)
at oracle.apps.fnd.wf.worklist.webui.NtfWorklistCO.processRequest(NtfWorklistCO.java:185)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:604)


Solution:

CREATE TABLE FND_USER_PREFERENCES_BKP AS SELECT * FROM FND_USER_PREFERENCES;
UPDATE FND_USER_PREFERENCES SET PREFERENCE_VALUE='NtfSubject,' WHERE USER_NAME='&User_name' AND PREFERENCE_NAME='ADVANCED_WL_SORT_PREF';
COMMIT;

Reference: You have encountered an unexpected Error for Some Users Login. Stacktrace shows java.lang.NullPointerException related to NtfWorklistCO.class (Doc ID 1684285.1)

Wednesday, 24 June 2015

DB : Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed

Error:
oratest@myserver database]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 61931 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 19999 MB    Passed
Checking monitor: must be configured to display at least 256 colors
    >>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set.    Failed <<<<

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation,

Continue? (y/n) [n] n

User Selected: No

Exiting Oracle Universal Installer, log for this session can be found at /d01/oracle/app/oraInventory/logs/installActions2015-06-24_10-03-30AM.log
[oratest@myserver database]$

Solution:

As a root user in VNC type xhost + to continue the installation
[root@myserver TEST]# xhost +
access control disabled, clients can connect from any host

DB : Installing oracle database fails with inventory owner permission denied

When installing new database as "oratest" new user on the existing server with other databases running in it the installation failed with below error

Error:

[oratest@myserver database]$ ./runInstaller
You do not have sufficient permissions to access the inventory '/d01/oracle/app/oraInventory'. Installation cannot continue. It is required that the primary group of the install user is same as the inventory owner group. Make sure that the install user is part of the inventory owner group and restart the installer.: Permission denied
[oratest@myserver database]$

Solution:
Change the oratest user group to same as the group of oraInventory

As a root user change the "oratest" group to "dba" as below

useradd -G dba oratest

Monday, 8 June 2015

EBS : dbTier autoconfig fails with afdbprf.sh adcrobj.sh

Error:

adcvmlog.xml renamed to /oradb/oracle/11.2.0.3/appsutil/log/TEST_drebsdb01/06080947/adcvmlog.xml.06080948


[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>

  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /oradb/oracle/11.2.0.3/appsutil/install/TEST_drebsdb01
      afdbprf.sh              INSTE8_PRF         1

  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /oradb/oracle/11.2.0.3/appsutil/install/TEST_drebsdb01
      adcrobj.sh              INSTE8_APPLY       1


AutoConfig is exiting with status 2

AutoConfig execution completed on Mon Jun  8 09:48:27 2015

Time taken for AutoConfig execution to complete : 0 mins  49 secs


Solution:

Enter the correct apps password while running autoconfig and check whether APPS account is locked by connecting as SYSDBA
SQL> select USERNAME,ACCOUNT_STATUS,LOCK_DATE from dba_users where USERNAME='APPS';

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE
------------------------------ -------------------------------- ---------------
APPS                           LOCKED                           08-JUN-15

SQL> alter user apps account unlock;

User altered.

SQL> select USERNAME,ACCOUNT_STATUS,LOCK_DATE from dba_users where USERNAME='APPS';

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE
------------------------------ -------------------------------- ---------------
APPS                           OPEN

now re-run the autoconfig in dbTier

Sunday, 31 May 2015

EBS : Login to application gets "unable to authenticate session" or "ORA-01403 error"

When we login to the application we get unable to authenticate session or ORA-01403 error

ERROR:

<PRE>Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 has been detected in FND_SESSION_MANAGEMENT.CHECK_SESSION. Your session is no longer valid. </PRE> 

Servlet error: An exception occurred. The current application deployment descriptors do

Solution 1

1. Execute the following scripts from $FND_TOP/patch/115/sql as apps user:
SQL> @AFICXSMS.pls %
SQL> @AFICXSMB.pls %
2. Bounce the server.
3. Retest the issue.

Reference :Login Page Throws Error 1403: Java.Sql.Sqlexception: Ora-01403: No Data Found Ora-06512: At Line 1 H (Doc ID 1336030.1)


Solution 2:

 "Unable to authenticate session"

1. Open a new explorer window using its own session cookie by selecting File -> New Session from the Menu Bar in an existing browser window. (IE9 Users may have to enable the Menu Bar first by right clicking the browser header frame and selecting Menu Bar.)
2. Run from the command line adding the -noframemerging parameter
    e.g. Start -> Run -> iexplore -noframemerging
3. Create a new IE icon adding the -noframemerging parameter
    e.g. Start -> Program Files
4. Right click on the Internet Explorer icon and select Properties

5. Add -noframemerging to the end of the link in the Target field
    e.g."C:\Program Files\Internet Explorer\iexplore.exe" -noframemerging
6. Click the OK button to close the window

Reference : R12: Using IE8 to access two EBS Instances runs in error "Unable To Authenticate Session" (Doc ID 1098563.1)

Solution 3:

1. Go to Control Panel
2. Select Java Control Panel from the list.
3. From the popup window (Java Control Panel), uncheck "Enable the next-generation Java Plug-in" option.
4. Click "Apply" and click "OK"
5. Clear browsing history (Internet Explorer Menu Bar: Tools --> Delete Browsing History) and close all the browser sessions.
6. Open IE browser and try to access Oracle Applications, if the issue still persists reboot the system.

Solution 4:

Disable Internet Explorer add-ons:

  • Click "Tools" and select "Internet Options".
  • Click "Advanced" tab on the right.
  • Under "Browsing", remove/uncheck the "Enable third-party browser extensions" check box.
  • Click "OK" and close all opened Internet Explorer.
  • Open New Internet Explorer 



Oracle : Database Startup Time

 Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT     instance_name,     to_char(startup_time,...