Wednesday, 14 January 2015

Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server

Getting DISPLAY error while Oracle EBS R12 installation or running script which require GUI

[applmgr@test$ sh bsu.sh
No protocol specified
Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable.

    at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
    at sun.awt.X11GraphicsEnvironment.access$200(X11GraphicsEnvironment.java:65)
    at sun.awt.X11GraphicsEnvironment$1.run(X11GraphicsEnvironment.java:110)
    at java.security.AccessController.doPrivileged(Native Method)
    at sun.awt.X11GraphicsEnvironment.<clinit>(X11GraphicsEnvironment.java:74)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:190)
    at java.awt.GraphicsEnvironment.createGE(GraphicsEnvironment.java:102)
    at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:81)
    at sun.swing.SwingUtilities2.isLocalDisplay(SwingUtilities2.java:1457)
    at javax.swing.plaf.metal.MetalLookAndFeel.initComponentDefaults(MetalLookAndFeel.java:1556)
    at javax.swing.plaf.basic.BasicLookAndFeel.getDefaults(BasicLookAndFeel.java:148)
    at javax.swing.plaf.metal.MetalLookAndFeel.getDefaults(MetalLookAndFeel.java:1592)
    at javax.swing.UIManager.setLookAndFeel(UIManager.java:536)
    at javax.swing.UIManager.setLookAndFeel(UIManager.java:576)
    at javax.swing.UIManager.initializeDefaultLAF(UIManager.java:1345)
    at javax.swing.UIManager.initialize(UIManager.java:1455)
    at javax.swing.UIManager.maybeInitialize(UIManager.java:1422)
    at javax.swing.UIManager.getDefaults(UIManager.java:656)
    at javax.swing.UIManager.put(UIManager.java:985)
    at com.bea.plateng.common.ui.gui.GUIHelper.initPLAF(GUIHelper.java:69)
    at com.bea.plateng.patch.gui.PatchGUIHelper.startGui(PatchGUIHelper.java:90)
    at com.bea.plateng.patch.Patch.main(Patch.java:338)


Findings: From root user I am able to open the GUI

Solution:
To open up your display for all users from all hosts as your normal user you can do this with :
Login from root user and run xhost +
Now, retest the issue.

Friday, 9 January 2015

insert_fcp failed due to ORA-00060: deadlock detected while waiting for resource

After bouncing the R12 application the concurrent managers are not getting up.

The error message in ICM log:
ORACLE error 60 in insert_fcp
Cause: insert_fcp failed due to ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "APPS.FND_CP_FNDSM", line 134
ORA-06512: at line 1.

Even after bouncing the application multiple times the issue persists.

I have also executed the setup clean, cmclean and autoconfig but it did not work for me.

Then I tried "Concurrent Managers Will Not Start ORACLE error 60 in insert_fcp (Doc ID 1256084.1)" , but again no luck.

Finally,After searching it on google, I got the solution.

The root cause was APPS user password was in Grace period.

SQL> select ACCOUNT_STATUS,EXPIRY_DATE,PROFILE from dba_users where username='APPS';

ACCOUNT_STATUS                   EXPIRY_DA PROFILE
-------------------------------- --------- ------------------------------
EXPIRED(GRACE)                             DEFAULT


After changing the APPS password the issue got resolved.