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.

Saturday 27 December 2014

R12.2 installation failed with Cannot find oraInventory error

Issue: R12.2.0 installation failed with Cannot find oraInventory error on Linux

    Trying local inventory in Oracle Home...
    Cannot find oraInventory
    Please create oraInst.loc in the proper directory for your operating system.
    The contents should look like this:
    inventory_loc=/oracle/oraInventory
    where "/oracle/oraInventory" is the direcotry where the central inventory is to be located.

When I checked the oraInst.loc in the /etc location, it was not there. So, I have manually created.

In cases where the OraInventory is missing or otherwise corrupt, recreate the oraInventory directory on UNIX systems, using the following steps.

[root@Test]# vi /etc/oraInst.loc
inventory_loc=/oracle/product/oraInventory
inst_group=dba

Change the inventory location as the per your directory structure.

[root@Test]# ls -lrt /etc/oraInst.loc
-rw-r--r--. 1 root root 58 Dec  9 00:26 /etc/oraInst.loc

[root@Test]# chmod 644 /etc/oraInst.loc

[root@Test]# ls -lrt /etc/oraInst.loc
-rw-r--r--. 1 root root 58 Dec  9 00:26 /etc/oraInst.loc

Retry the R12 installation