May 24, 2012

Exception:Cannot write XdndAware property, on Create weblogic domain wizard

If you are getting blank screen while creating weblogic domain using weblogic configuration domain wizard due to below exception
./config.sh
Exception in thread "AWT-EventQueue-0" sun.awt.X11.XException: Cannot write XdndAware property
        at sun.awt.X11.XDnDDropTargetProtocol.registerDropTarget(XDnDDropTargetProtocol.java:79)
        at sun.awt.X11.XDropTargetRegistry.registerDropSite(XDropTargetRegistry.java:554)
        at sun.awt.X11.XWindowPeer.addDropTarget(XWindowPeer.java:1633)
        at sun.awt.X11.XComponentPeer.addDropTarget(XComponentPeer.java:1509)
        at java.awt.dnd.DropTarget.addNotify(DropTarget.java:493)
        at java.awt.Component.addNotify(Component.java:6689)
        at java.awt.Container.addNotify(Container.java:2565)
        at javax.swing.JComponent.addNotify(JComponent.java:4685)
        at java.awt.Container.addNotify(Container.java:2576)
        at javax.swing.JComponent.addNotify(JComponent.java:4685)
        at java.awt.Container.addNotify(Container.java:2576)
        at javax.swing.JComponent.addNotify(JComponent.java:4685)
        at java.awt.Container.addImpl(Container.java:1066)
        at java.awt.Container.add(Container.java:925)
        at com.oracle.cie.wizard.GUIContext$8.run(GUIContext.java:480)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:646)
        at java.awt.EventQueue.access$000(EventQueue.java:84)
        at java.awt.EventQueue$1.run(EventQueue.java:607)
        at java.awt.EventQueue$1.run(EventQueue.java:605)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:616)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

Workaround:-
Add "-DsuppressSwingDropSupport=true" property to JVM_ARGS in $WL_HOME/common/bin/config.sh file and run.

May 21, 2012

Increase the Size of Tablespace

If you want to increase the size of tablespace, its so simple. You can do this by enterprise manager console. Increase the size of datafile for particular tablespace.
OR
For Example
ALTER DATABASE
DATAFILE ‘/u03/oradata/ userdata02. dbf’
RESIZE 200M;

If you don’t have any free space on that partition of disk then you can add another datafile on the other partition  for particular tablespace.
For example
ALTER TABLESPACE app_data
ADD DATAFILE ‘/u01/oradata/ userdata03. dbf’
SIZE 200M;
Now you can insert data with in this tablespace.

Source: http://mhabib.wordpress.com/2007/03/31/increase-the-size-of-tablespace/

May 10, 2012

ORA-12162 TNS:net service name is incorrectly specified

"ORA-12162 TNS:net service name is incorrectly specified" misleads to verify the tnsnames.ora files for listener settings. But it's a issue with ORACLE_SID (environment variable) value.

Action: For windows: Add a environment value 'ORACLE_SID' and assign with your database name 
eg: set ORACLE_SID=orcl

For Linux: Run export ORACLE_SID=orcl or update the same in  ~/.bashrc file for permanent fix.

Note: You must also have ORACLE_HOME variable set to your Oracle database location.