How to export the MetaData from MDS

Steps to export the MetaData from MDS for an application running on weblogic server. Here we are using WebLogic Scripting Tools to export.

1. Run wlst.sh from $BEAHOME/oracle_common/common/bin/wlst.sh

2. Connect the Weblogic server as mention:

wls:/offline> connect()

Please enter your username :weblogic

Please enter your password :

Please enter your server URL [t3://localhost:7001] :t3://localhost:9113

Connecting to t3://localhost:9113 with userid weblogic ...

Successfully connected to managed Server 'managedServer1' that belongs to domain 'DefaultDomain'

3. To list all the available commands

wls:/DefaultDomain/serverConfig> help('all') or wls:/dev2/serverConfig> help();

4. For get specific command description

wls:/DefaultDomain/serverConfig> help('exportMetadata')

5. The following example exports all metadata files from the application "app1" deployed in the server "server1":

wls:/weblogic/serverConfig> exportMetadata(application='app1', server='server1', toLocation='/tmp/myrepos',docs='/**')

Location changed to domainRuntime tree. This is a read-only tree with DomainMBean as the root.

For more help, use help(domainRuntime)

Executing operation: exportMetadata.

"exportMetadata" operation completed. Summary of "exportMetadata" operation is:

List of documents successfully transferred:

/mypackage/write.xml

/mypackage/write1.xml

/mypackage/mdssys/cust/user/user1/write1.xml.xml

/mypackage/mdssys/cust/user/user2/write2.xml.xml

/sample1.jspx

5 documents successfully transferred.

Shell script to rename the files as per requirement.

Shell script to rename .xml files to .properties

for NAME in *.xml;

do

length=${#NAME};

echo ${NAME} ${length};

mv ${NAME} ${NAME:0:${length}-4}.properties

done;

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.

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/

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.