dbawiki - User contributions [en]

Backend WLS or EM application seems to be down

2012-01-02T11:24:15Z

10.250.159.106:

This error message appears on its own webpage(omsunavailable.html) when the Grid login page is called. 
Login to the server where the oms is installed:
D:\>set ORACLE_HOME=D:\ORACLE\MIDDLEWARE\oms11g

D:\>cd %ORACLE_HOME%\bin

D:\ORACLE\Middleware\oms11g\BIN>emctl status oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle Management Server is Down

D:\ORACLE\Middleware\oms11g\BIN>emctl start oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Windows service OracleManagementServer_EMGC_OMS1_2 failed to be started
Oracle Management Server is Down
Please check D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log for error details

D:\ORACLE\Middleware\oms11g\BIN>
Log file looks like this:
2012-01-02 11:16:11,140 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS\sysman\log\emctl.log
2012-01-02 11:16:11,171 [Main Thread] INFO wls.OMSController startOMS.497 - admin start is false
2012-01-02 11:16:11,171 [Main Thread] INFO wls.OMSController startOMS.498 - is service is false
2012-01-02 11:16:11,249 [Main Thread] INFO wls.OMSController getEnvProps.356 - Setting trust store system properties: -Dweblogic.security.TrustKeyStore=DemoTrust -Dweblogic.security.SSL.ignoreHostnameVerification=true -Djava.security.egd=file:///dev/urandom
2012-01-02 11:16:11,265 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:16:11,265 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:16:11,265 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:16:11,483 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:16:14,953 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:16:14,953 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:16:14,953 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8
2012-01-02 11:16:14,953 [Main Thread] INFO wls.OMSController startOMS.636 - Issuing net start for oms service...
2012-01-02 11:16:14,968 [Main Thread] INFO wls.OMSController startOMS.643 - net start cmd is [C:\WINDOWS\system32\net.exe, start, OracleManagementServer_EMGC_OMS1_2]
2012-01-02 11:16:15,250 [Thread-2] INFO wls.OMSController run.1159 - <ERR>The requested service has already been started.
2012-01-02 11:16:15,265 [Thread-2] INFO wls.OMSController run.1159 - <ERR>
2012-01-02 11:16:15,265 [Thread-2] INFO wls.OMSController run.1159 - <ERR>More help is available by typing NET HELPMSG 2182.
2012-01-02 11:16:15,265 [Thread-2] INFO wls.OMSController run.1159 - <ERR>
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController processCmd.1018 - wlst process is finished
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController processCmd.1020 - wlst process exited with code 2
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController processCmd.1022 - wlst outstream joined
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController processCmd.1024 - wlst errstream joined
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController startOMS.645 - net start return code is 2
2012-01-02 11:16:15,265 [Main Thread] ERROR wls.OMSController startOMS.648 - Windows service OracleManagementServer_EMGC_OMS1_2 failed to be started
2012-01-02 11:16:15,281 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:16:15,281 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:16:15,281 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:16:15,281 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:16:18,235 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:16:18,235 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:16:18,235 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8

* Manually stopped the OracleManagementServers. From services.msc:
Right click on OracleManagementServer_EMGC_OMS1_1 and stop 
Right click on OracleManagementServer_EMGC_OMS1_2 and stop 
* Attempt to restart the oms using the command line:
D:\ORACLE\Middleware\oms11g\BIN>emctl start oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Windows service OracleManagementServer_EMGC_OMS1_2 successfully started
Oracle Management Server is Up

D:\ORACLE\Middleware\oms11g\BIN>emctl status oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle Management Server is Up

D:\ORACLE\Middleware\oms11g\BIN>
Resulting addition to log file:
2012-01-02 11:21:10,228 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log
2012-01-02 11:21:10,260 [Main Thread] INFO wls.OMSController stopOMS.684 - istopAll is false
2012-01-02 11:21:10,260 [Main Thread] INFO wls.OMSController stopOMS.685 - isForce is false
2012-01-02 11:21:10,260 [Main Thread] INFO wls.OMSController stopOMS.686 - is service is true
2012-01-02 11:21:10,291 [Main Thread] INFO wls.OMSController getEnvProps.356 - Setting trust store system properties: -Dweblogic.security.TrustKeyStore=DemoTrust -Dweblogic.security.SSL.ignoreHostnameVerification=true -Djava.security.egd=file:///dev/urandom
2012-01-02 11:21:10,291 [Main Thread] INFO wls.OMSController stopOMS.702 - Stopping WebTier...
2012-01-02 11:21:10,306 [Main Thread] INFO util.WebTierUtil execCmd.134 - Running the command: D:\Oracle\gc_inst\WebTierIH1\bin\opmnctl.bat stopall
2012-01-02 11:21:45,688 [Main Thread] INFO util.WebTierUtil getProcessResult.196 - opmnctl cmd output: opmnctl stopall: stopping opmn and all managed processes...

2012-01-02 11:21:45,688 [Main Thread] INFO util.WebTierUtil getProcessResult.204 - opmnctl cmd error:
2012-01-02 11:21:45,688 [Main Thread] INFO util.WebTierUtil getProcessResult.208 - opmnctl cmd exited with code 0
2012-01-02 11:21:45,688 [Main Thread] INFO wls.OMSController stopOMS.713 - WebTier Successfully Stopped
2012-01-02 11:21:45,688 [Main Thread] INFO wls.OMSController stopOMS.728 - isStopAll is false
2012-01-02 11:21:45,688 [Main Thread] INFO wls.OMSController stopOMS.729 - isForce is false
2012-01-02 11:21:45,688 [Main Thread] INFO wls.OMSController stopOMS.742 - wlst command is D:/ORACLE/MIDDLE~1\oracle_common\common\bin\wlst.cmd D:/ORACLE/Middleware/oms11g\bin\stopOMS.py
2012-01-02 11:21:45,688 [Main Thread] INFO wls.OMSController stopOMS.743 - Executing the wlst command for stopOMS...
2012-01-02 11:21:46,188 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:21:46,188 [Thread-1] INFO wls.OMSController run.1159 - <OUT>CLASSPATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\lib\tools.jar;D:\ORACLE\MIDDLE~1\utils\config\10.3\config-launch.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\ORACLE\MIDDLE~1\modules\features\weblogic.server.modules_10.3.2.0.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0/lib/ant-all.jar;D:\ORACLE\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emagentSDK.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emCORE.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.http_client_11.1.1.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_cert.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_core.jar;D:/ORACLE/MIDDLE~1/modules/com.bea.core.apache.log4j_1.2.13.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dms_11.1.1/dms.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dconfig-infra_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.fabriccommon_11.1.1/fabric-common.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xmlparserv2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xml.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-pmlib.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-policy-core.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-secpol.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-dependencies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.policies_11.1.1/wsm-seed-policies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/orawsdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/mdds.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/ws_confmbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/org.apache.commons.digester_1.7.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.bind_2.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.activation_1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.stream_1.1.1.0.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.http_client_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxframework.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxspi.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.dconfigbeans_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-ca.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adflogginghandler.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adfsharembean.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/commons-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/jsp-el-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/oracle-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/auditwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/sslconfigwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/oamap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/ossoiap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.auditprovider_11.1.1/jps-wls-auditprovider.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-manifest.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-mbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-upgrade.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-patching.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar
2012-01-02 11:21:46,204 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:21:46,204 [Thread-1] INFO wls.OMSController run.1159 - <OUT>PATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\native;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\native;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\bin;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\Oracle\Middleware\oms11g\\perl\bin;D:\Oracle\Middleware\oms11g\bin;D:\Oracle\Middleware\oms11g\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin\server;D:\Oracle\Middleware\oms11g\oui\lib\win32;D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\native;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\native;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\bin;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\bin;D:\ORACLE\PRODUCT\mdlw\agent11g\bin;D:\ORACLE\PRODUCT\mdlw\oracle_common\bin;D:\ORACLE\PRODUCT\10.2.0\db_1\bin;C:\Program Files (x86)\Support Tools\;C:\NTRESKIT\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\HP OpenView\bin;C:\Program Files\HP OpenView\bin\win64;C:\Program Files\HP OpenView\bin\win64\OpC;C:\Program Files\HP OpenView\bin\;C:\Program Files\HP OpenView\lib\;D:\Oracle\Middleware\oms11g\bin;D:\Oracle\Middleware\oms11g\opmn\bin;D:\Oracle\Middleware\oms11g\opmn\lib;D:\Oracle\Middleware\oms11g\perl\bin;D:\Oracle\Middleware\Oracle_WT\bin;D:\Oracle\Middleware\Oracle_WT\opmn\bin;D:\Oracle\Middleware\Oracle_WT\opmn\lib;D:\Oracle\Middleware\Oracle_WT\perl\bin;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\OmniBack\bin\;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32\oci920_8;C:\WINDOWS;C:\WINDOWS\system32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32\oci920_8
2012-01-02 11:21:46,220 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:21:46,220 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Your environment has been set.
2012-01-02 11:21:46,235 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:21:46,235 [Thread-1] INFO wls.OMSController run.1159 - <OUT>CLASSPATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\lib\tools.jar;D:\ORACLE\MIDDLE~1\utils\config\10.3\config-launch.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\ORACLE\MIDDLE~1\modules\features\weblogic.server.modules_10.3.2.0.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0/lib/ant-all.jar;D:\ORACLE\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emagentSDK.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emCORE.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.http_client_11.1.1.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_cert.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_core.jar;D:/ORACLE/MIDDLE~1/modules/com.bea.core.apache.log4j_1.2.13.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dms_11.1.1/dms.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dconfig-infra_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.fabriccommon_11.1.1/fabric-common.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xmlparserv2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xml.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-pmlib.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-policy-core.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-secpol.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-dependencies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.policies_11.1.1/wsm-seed-policies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/orawsdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/mdds.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/ws_confmbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/org.apache.commons.digester_1.7.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.bind_2.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.activation_1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.stream_1.1.1.0.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.http_client_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxframework.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxspi.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.dconfigbeans_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-ca.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adflogginghandler.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adfsharembean.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/commons-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/jsp-el-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/oracle-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/auditwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/sslconfigwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/oamap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/ossoiap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.auditprovider_11.1.1/jps-wls-auditprovider.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-manifest.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-mbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-upgrade.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-patching.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbembedded57.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbclient57.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbtools57.jar
2012-01-02 11:21:49,501 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:21:49,501 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Initializing WebLogic Scripting Tool (WLST) ...
2012-01-02 11:21:49,501 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:07,067 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Welcome to WebLogic Server Administration Scripting Shell
2012-01-02 11:22:07,067 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:07,067 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Type help() for help on available commands
2012-01-02 11:22:07,067 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:07,614 [Thread-1] INFO wls.OMSController run.1159 - <OUT>is_admin_host is TRUE
2012-01-02 11:22:07,614 [Thread-1] INFO wls.OMSController run.1159 - <OUT>stop_all is FALSE
2012-01-02 11:22:07,614 [Thread-1] INFO wls.OMSController run.1159 - <OUT>forced_flag is FALSE
2012-01-02 11:22:08,724 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Connecting to Node Manager ...
2012-01-02 11:22:10,724 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.22 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=KEYNECTIS ROOT CA,OU=ROOT,O=KEYNECTIS,C=FR". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:22:10,724 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.22 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 3,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:22:10,724 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.22 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 2,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:22:24,258 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully Connected to Node Manager.
2012-01-02 11:22:24,258 [Thread-1] INFO wls.OMSController run.1159 - <OUT>status of node manager:
2012-01-02 11:22:24,274 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Currently connected to Node Manager to monitor the domain GCDomain.
2012-01-02 11:22:24,274 [Thread-1] INFO wls.OMSController run.1159 - <OUT>current status of EMGC_OMS1:
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1159 - <OUT>FAILED_NOT_RESTARTABLE
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Currently connected to Node Manager to monitor the domain GCDomain.
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully disconnected from Node Manager.
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1159 - <OUT>_END_
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1164 - Drainer broke out while loop
2012-01-02 11:22:24,305 [Thread-2] INFO wls.OMSController run.1159 - <ERR>_END_
2012-01-02 11:22:24,305 [Thread-2] INFO wls.OMSController run.1164 - Drainer broke out while loop
2012-01-02 11:22:25,086 [Main Thread] INFO wls.OMSController processCmd.1018 - wlst process is finished
2012-01-02 11:22:25,086 [Main Thread] INFO wls.OMSController processCmd.1020 - wlst process exited with code 2
2012-01-02 11:22:25,086 [Main Thread] INFO wls.OMSController processCmd.1022 - wlst outstream joined
2012-01-02 11:22:25,086 [Main Thread] INFO wls.OMSController processCmd.1024 - wlst errstream joined
2012-01-02 11:22:25,086 [Main Thread] INFO wls.OMSController stopOMS.841 - stop OMS finished with result: 2
2012-01-02 11:22:25,118 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:22:25,118 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:22:25,118 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:22:25,430 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:22:28,931 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:22:28,931 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:22:28,931 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8
2012-01-02 11:22:53,217 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log
2012-01-02 11:22:53,232 [Main Thread] INFO wls.OMSController stopOMS.684 - istopAll is false
2012-01-02 11:22:53,232 [Main Thread] INFO wls.OMSController stopOMS.685 - isForce is false
2012-01-02 11:22:53,232 [Main Thread] INFO wls.OMSController stopOMS.686 - is service is true
2012-01-02 11:22:53,264 [Main Thread] INFO wls.OMSController getEnvProps.356 - Setting trust store system properties: -Dweblogic.security.TrustKeyStore=DemoTrust -Dweblogic.security.SSL.ignoreHostnameVerification=true -Djava.security.egd=file:///dev/urandom
2012-01-02 11:22:53,279 [Main Thread] INFO wls.OMSController stopOMS.702 - Stopping WebTier...
2012-01-02 11:22:53,279 [Main Thread] INFO util.WebTierUtil execCmd.134 - Running the command: D:\Oracle\gc_inst\WebTierIH1\bin\opmnctl.bat stopall
2012-01-02 11:22:54,764 [Main Thread] INFO util.WebTierUtil getProcessResult.196 - opmnctl cmd output: opmnctl stopall: opmn is not running.

2012-01-02 11:22:54,764 [Main Thread] INFO util.WebTierUtil getProcessResult.204 - opmnctl cmd error:
2012-01-02 11:22:54,764 [Main Thread] INFO util.WebTierUtil getProcessResult.208 - opmnctl cmd exited with code 0
2012-01-02 11:22:54,764 [Main Thread] INFO wls.OMSController stopOMS.713 - WebTier Successfully Stopped
2012-01-02 11:22:54,764 [Main Thread] INFO wls.OMSController stopOMS.728 - isStopAll is false
2012-01-02 11:22:54,764 [Main Thread] INFO wls.OMSController stopOMS.729 - isForce is false
2012-01-02 11:22:54,764 [Main Thread] INFO wls.OMSController stopOMS.742 - wlst command is D:/ORACLE/MIDDLE~1\oracle_common\common\bin\wlst.cmd D:/ORACLE/Middleware/oms11g\bin\stopOMS.py
2012-01-02 11:22:54,764 [Main Thread] INFO wls.OMSController stopOMS.743 - Executing the wlst command for stopOMS...
2012-01-02 11:22:55,170 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:55,186 [Thread-1] INFO wls.OMSController run.1159 - <OUT>CLASSPATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\lib\tools.jar;D:\ORACLE\MIDDLE~1\utils\config\10.3\config-launch.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\ORACLE\MIDDLE~1\modules\features\weblogic.server.modules_10.3.2.0.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0/lib/ant-all.jar;D:\ORACLE\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emagentSDK.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emCORE.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.http_client_11.1.1.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_cert.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_core.jar;D:/ORACLE/MIDDLE~1/modules/com.bea.core.apache.log4j_1.2.13.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dms_11.1.1/dms.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dconfig-infra_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.fabriccommon_11.1.1/fabric-common.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xmlparserv2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xml.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-pmlib.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-policy-core.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-secpol.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-dependencies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.policies_11.1.1/wsm-seed-policies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/orawsdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/mdds.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/ws_confmbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/org.apache.commons.digester_1.7.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.bind_2.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.activation_1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.stream_1.1.1.0.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.http_client_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxframework.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxspi.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.dconfigbeans_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-ca.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adflogginghandler.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adfsharembean.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/commons-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/jsp-el-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/oracle-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/auditwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/sslconfigwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/oamap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/ossoiap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.auditprovider_11.1.1/jps-wls-auditprovider.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-manifest.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-mbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-upgrade.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-patching.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar
2012-01-02 11:22:55,202 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:55,202 [Thread-1] INFO wls.OMSController run.1159 - <OUT>PATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\native;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\native;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\bin;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\Oracle\Middleware\oms11g\\perl\bin;D:\Oracle\Middleware\oms11g\bin;D:\Oracle\Middleware\oms11g\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin\server;D:\Oracle\Middleware\oms11g\oui\lib\win32;D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\native;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\native;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\bin;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\bin;D:\ORACLE\PRODUCT\mdlw\agent11g\bin;D:\ORACLE\PRODUCT\mdlw\oracle_common\bin;D:\ORACLE\PRODUCT\10.2.0\db_1\bin;C:\Program Files (x86)\Support Tools\;C:\NTRESKIT\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\HP OpenView\bin;C:\Program Files\HP OpenView\bin\win64;C:\Program Files\HP OpenView\bin\win64\OpC;C:\Program Files\HP OpenView\bin\;C:\Program Files\HP OpenView\lib\;D:\Oracle\Middleware\oms11g\bin;D:\Oracle\Middleware\oms11g\opmn\bin;D:\Oracle\Middleware\oms11g\opmn\lib;D:\Oracle\Middleware\oms11g\perl\bin;D:\Oracle\Middleware\Oracle_WT\bin;D:\Oracle\Middleware\Oracle_WT\opmn\bin;D:\Oracle\Middleware\Oracle_WT\opmn\lib;D:\Oracle\Middleware\Oracle_WT\perl\bin;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\OmniBack\bin\;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32\oci920_8;C:\WINDOWS;C:\WINDOWS\system32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32\oci920_8
2012-01-02 11:22:55,233 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:55,233 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Your environment has been set.
2012-01-02 11:22:55,264 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:55,264 [Thread-1] INFO wls.OMSController run.1159 - <OUT>CLASSPATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\lib\tools.jar;D:\ORACLE\MIDDLE~1\utils\config\10.3\config-launch.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\ORACLE\MIDDLE~1\modules\features\weblogic.server.modules_10.3.2.0.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0/lib/ant-all.jar;D:\ORACLE\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emagentSDK.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emCORE.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.http_client_11.1.1.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_cert.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_core.jar;D:/ORACLE/MIDDLE~1/modules/com.bea.core.apache.log4j_1.2.13.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dms_11.1.1/dms.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dconfig-infra_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.fabriccommon_11.1.1/fabric-common.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xmlparserv2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xml.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-pmlib.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-policy-core.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-secpol.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-dependencies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.policies_11.1.1/wsm-seed-policies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/orawsdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/mdds.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/ws_confmbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/org.apache.commons.digester_1.7.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.bind_2.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.activation_1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.stream_1.1.1.0.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.http_client_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxframework.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxspi.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.dconfigbeans_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-ca.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adflogginghandler.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adfsharembean.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/commons-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/jsp-el-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/oracle-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/auditwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/sslconfigwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/oamap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/ossoiap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.auditprovider_11.1.1/jps-wls-auditprovider.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-manifest.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-mbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-upgrade.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-patching.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbembedded57.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbclient57.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbtools57.jar
2012-01-02 11:22:57,874 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:57,874 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Initializing WebLogic Scripting Tool (WLST) ...
2012-01-02 11:22:57,874 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:23:10,517 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Welcome to WebLogic Server Administration Scripting Shell
2012-01-02 11:23:10,517 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:23:10,517 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Type help() for help on available commands
2012-01-02 11:23:10,517 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:23:11,033 [Thread-1] INFO wls.OMSController run.1159 - <OUT>is_admin_host is TRUE
2012-01-02 11:23:11,033 [Thread-1] INFO wls.OMSController run.1159 - <OUT>stop_all is FALSE
2012-01-02 11:23:11,033 [Thread-1] INFO wls.OMSController run.1159 - <OUT>forced_flag is FALSE
2012-01-02 11:23:12,564 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Connecting to Node Manager ...
2012-01-02 11:23:14,283 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.23 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=KEYNECTIS ROOT CA,OU=ROOT,O=KEYNECTIS,C=FR". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:23:14,283 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.23 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 3,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:23:14,299 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.23 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 2,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:23:25,957 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully Connected to Node Manager.
2012-01-02 11:23:25,973 [Thread-1] INFO wls.OMSController run.1159 - <OUT>status of node manager:
2012-01-02 11:23:25,989 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Currently connected to Node Manager to monitor the domain GCDomain.
2012-01-02 11:23:25,989 [Thread-1] INFO wls.OMSController run.1159 - <OUT>current status of EMGC_OMS1:
2012-01-02 11:23:25,989 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:23:25,989 [Thread-1] INFO wls.OMSController run.1159 - <OUT>FAILED_NOT_RESTARTABLE
2012-01-02 11:23:25,989 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:23:25,989 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Currently connected to Node Manager to monitor the domain GCDomain.
2012-01-02 11:23:26,004 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully disconnected from Node Manager.
2012-01-02 11:23:26,004 [Thread-1] INFO wls.OMSController run.1159 - <OUT>_END_
2012-01-02 11:23:26,004 [Thread-1] INFO wls.OMSController run.1164 - Drainer broke out while loop
2012-01-02 11:23:26,020 [Thread-2] INFO wls.OMSController run.1159 - <ERR>_END_
2012-01-02 11:23:26,020 [Thread-2] INFO wls.OMSController run.1164 - Drainer broke out while loop
2012-01-02 11:23:26,536 [Main Thread] INFO wls.OMSController processCmd.1018 - wlst process is finished
2012-01-02 11:23:26,536 [Main Thread] INFO wls.OMSController processCmd.1020 - wlst process exited with code 2
2012-01-02 11:23:26,536 [Main Thread] INFO wls.OMSController processCmd.1022 - wlst outstream joined
2012-01-02 11:23:26,536 [Main Thread] INFO wls.OMSController processCmd.1024 - wlst errstream joined
2012-01-02 11:23:26,536 [Main Thread] INFO wls.OMSController stopOMS.841 - stop OMS finished with result: 2
2012-01-02 11:23:26,567 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:23:26,567 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:23:26,567 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:23:26,817 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:23:30,365 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:23:30,365 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:23:30,365 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8
2012-01-02 11:23:44,992 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log
2012-01-02 11:23:45,024 [Main Thread] INFO wls.OMSController startOMS.497 - admin start is false
2012-01-02 11:23:45,024 [Main Thread] INFO wls.OMSController startOMS.498 - is service is false
2012-01-02 11:23:45,071 [Main Thread] INFO wls.OMSController getEnvProps.356 - Setting trust store system properties: -Dweblogic.security.TrustKeyStore=DemoTrust -Dweblogic.security.SSL.ignoreHostnameVerification=true -Djava.security.egd=file:///dev/urandom
2012-01-02 11:23:45,102 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:23:45,102 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:23:45,102 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:23:45,383 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:23:48,915 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:23:48,931 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:23:48,931 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8
2012-01-02 11:23:48,931 [Main Thread] INFO wls.OMSController startOMS.636 - Issuing net start for oms service...
2012-01-02 11:23:48,931 [Main Thread] INFO wls.OMSController startOMS.643 - net start cmd is [C:\WINDOWS\system32\net.exe, start, OracleManagementServer_EMGC_OMS1_2]
2012-01-02 11:23:54,291 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log
2012-01-02 11:23:54,322 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:23:54,322 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:23:54,322 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:23:54,619 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:23:58,042 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:23:58,042 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:23:58,042 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8
2012-01-02 11:24:03,402 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log
2012-01-02 11:24:03,433 [Main Thread] INFO wls.OMSController startOMS.497 - admin start is false
2012-01-02 11:24:03,433 [Main Thread] INFO wls.OMSController startOMS.498 - is service is true
2012-01-02 11:24:03,465 [Main Thread] INFO wls.OMSController getEnvProps.356 - Setting trust store system properties: -Dweblogic.security.TrustKeyStore=DemoTrust -Dweblogic.security.SSL.ignoreHostnameVerification=true -Djava.security.egd=file:///dev/urandom
2012-01-02 11:24:03,465 [Main Thread] INFO wls.OMSController startOMS.519 - Starting WebTier...
2012-01-02 11:24:03,465 [Main Thread] INFO util.WebTierUtil execCmd.134 - Running the command: D:\Oracle\gc_inst\WebTierIH1\bin\opmnctl.bat stopall
2012-01-02 11:24:05,137 [Main Thread] INFO util.WebTierUtil getProcessResult.196 - opmnctl cmd output: opmnctl stopall: opmn is not running.

2012-01-02 11:24:05,137 [Main Thread] INFO util.WebTierUtil getProcessResult.204 - opmnctl cmd error:
2012-01-02 11:24:05,137 [Main Thread] INFO util.WebTierUtil getProcessResult.208 - opmnctl cmd exited with code 0
2012-01-02 11:24:05,137 [Main Thread] INFO util.WebTierUtil execCmd.134 - Running the command: D:\Oracle\gc_inst\WebTierIH1\bin\opmnctl.bat startall
2012-01-02 11:24:24,234 [Main Thread] INFO util.WebTierUtil getProcessResult.196 - opmnctl cmd output: opmnctl startall: starting opmn and all managed processes...

2012-01-02 11:24:24,234 [Main Thread] INFO util.WebTierUtil getProcessResult.204 - opmnctl cmd error:
2012-01-02 11:24:24,234 [Main Thread] INFO util.WebTierUtil getProcessResult.208 - opmnctl cmd exited with code 0
2012-01-02 11:24:24,234 [Main Thread] INFO wls.OMSController startOMS.530 - WebTier Successfully Started
2012-01-02 11:24:24,234 [Main Thread] INFO wls.OMSController startOMS.556 - wlst command is D:/ORACLE/MIDDLE~1\oracle_common\common\bin\wlst.cmd D:/ORACLE/Middleware/oms11g\bin\startOMS.py
2012-01-02 11:24:24,234 [Main Thread] INFO wls.OMSController startOMS.557 - Executing the wlst command for startOMS...
2012-01-02 11:24:24,234 [Main Thread] INFO wls.OMSController startOMS.567 - optional admin start is false
2012-01-02 11:24:24,578 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:24,594 [Thread-1] INFO wls.OMSController run.1159 - <OUT>CLASSPATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\lib\tools.jar;D:\ORACLE\MIDDLE~1\utils\config\10.3\config-launch.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\ORACLE\MIDDLE~1\modules\features\weblogic.server.modules_10.3.2.0.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0/lib/ant-all.jar;D:\ORACLE\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emagentSDK.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emCORE.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.http_client_11.1.1.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_cert.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_core.jar;D:/ORACLE/MIDDLE~1/modules/com.bea.core.apache.log4j_1.2.13.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dms_11.1.1/dms.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dconfig-infra_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.fabriccommon_11.1.1/fabric-common.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xmlparserv2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xml.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-pmlib.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-policy-core.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-secpol.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-dependencies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.policies_11.1.1/wsm-seed-policies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/orawsdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/mdds.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/ws_confmbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/org.apache.commons.digester_1.7.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.bind_2.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.activation_1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.stream_1.1.1.0.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.http_client_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxframework.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxspi.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.dconfigbeans_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-ca.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adflogginghandler.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adfsharembean.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/commons-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/jsp-el-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/oracle-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/auditwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/sslconfigwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/oamap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/ossoiap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.auditprovider_11.1.1/jps-wls-auditprovider.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-manifest.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-mbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-upgrade.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-patching.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar
2012-01-02 11:24:24,609 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:24,609 [Thread-1] INFO wls.OMSController run.1159 - <OUT>PATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\native;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\native;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\bin;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\Oracle\Middleware\oms11g\\perl\bin;D:\Oracle\Middleware\oms11g\bin;D:\Oracle\Middleware\oms11g\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin\server;D:\Oracle\Middleware\oms11g\oui\lib\win32;D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\native;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\native;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\bin;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\bin;D:\ORACLE\PRODUCT\mdlw\agent11g\bin;D:\ORACLE\PRODUCT\mdlw\oracle_common\bin;D:\ORACLE\PRODUCT\10.2.0\db_1\bin;C:\Program Files (x86)\Support Tools\;C:\NTRESKIT\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\HP OpenView\bin;C:\Program Files\HP OpenView\bin\win64;C:\Program Files\HP OpenView\bin\win64\OpC;C:\Program Files\HP OpenView\bin\;C:\Program Files\HP OpenView\lib\;D:\Oracle\Middleware\oms11g\bin;D:\Oracle\Middleware\oms11g\opmn\bin;D:\Oracle\Middleware\oms11g\opmn\lib;D:\Oracle\Middleware\oms11g\perl\bin;D:\Oracle\Middleware\Oracle_WT\bin;D:\Oracle\Middleware\Oracle_WT\opmn\bin;D:\Oracle\Middleware\Oracle_WT\opmn\lib;D:\Oracle\Middleware\Oracle_WT\perl\bin;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\OmniBack\bin\;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32\oci920_8;C:\WINDOWS;C:\WINDOWS\system32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32\oci920_8
2012-01-02 11:24:24,625 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:24,625 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Your environment has been set.
2012-01-02 11:24:24,641 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:24,641 [Thread-1] INFO wls.OMSController run.1159 - <OUT>CLASSPATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\lib\tools.jar;D:\ORACLE\MIDDLE~1\utils\config\10.3\config-launch.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\ORACLE\MIDDLE~1\modules\features\weblogic.server.modules_10.3.2.0.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0/lib/ant-all.jar;D:\ORACLE\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emagentSDK.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emCORE.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.http_client_11.1.1.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_cert.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_core.jar;D:/ORACLE/MIDDLE~1/modules/com.bea.core.apache.log4j_1.2.13.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dms_11.1.1/dms.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dconfig-infra_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.fabriccommon_11.1.1/fabric-common.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xmlparserv2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xml.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-pmlib.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-policy-core.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-secpol.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-dependencies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.policies_11.1.1/wsm-seed-policies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/orawsdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/mdds.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/ws_confmbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/org.apache.commons.digester_1.7.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.bind_2.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.activation_1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.stream_1.1.1.0.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.http_client_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxframework.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxspi.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.dconfigbeans_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-ca.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adflogginghandler.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adfsharembean.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/commons-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/jsp-el-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/oracle-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/auditwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/sslconfigwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/oamap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/ossoiap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.auditprovider_11.1.1/jps-wls-auditprovider.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-manifest.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-mbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-upgrade.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-patching.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbembedded57.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbclient57.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbtools57.jar
2012-01-02 11:24:27,626 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:27,626 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Initializing WebLogic Scripting Tool (WLST) ...
2012-01-02 11:24:27,626 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:41,441 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Welcome to WebLogic Server Administration Scripting Shell
2012-01-02 11:24:41,456 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:41,456 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Type help() for help on available commands
2012-01-02 11:24:41,456 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:42,238 [Thread-1] INFO wls.OMSController run.1159 - <OUT>is_admin_host is TRUE
2012-01-02 11:24:42,238 [Thread-1] INFO wls.OMSController run.1159 - <OUT>admin_start is FALSE
2012-01-02 11:24:43,519 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Connecting to Node Manager ...
2012-01-02 11:24:45,191 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.24 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=KEYNECTIS ROOT CA,OU=ROOT,O=KEYNECTIS,C=FR". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:24:45,207 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.24 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 3,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:24:45,207 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.24 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 2,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:24:57,069 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully Connected to Node Manager.
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>status of node manager:
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Currently connected to Node Manager to monitor the domain GCDomain.
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>current status of EMGC_ADMINSERVER:
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>RUNNING
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>current status of EMGC_OMS1:
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>FAILED_NOT_RESTARTABLE
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Starting server EMGC_OMS1
2012-01-02 11:24:57,100 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Starting server EMGC_OMS1 ...
2012-01-02 11:31:10,359 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully started server EMGC_OMS1 ...
2012-01-02 11:31:10,359 [Thread-1] INFO wls.OMSController run.1159 - <OUT>new status of EMGC_OMS1:
2012-01-02 11:31:10,406 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:31:10,406 [Thread-1] INFO wls.OMSController run.1159 - <OUT>RUNNING
2012-01-02 11:31:10,406 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:31:10,406 [Thread-1] INFO wls.OMSController run.1159 - <OUT>wait until EMGC_OMS1 becomes RUNNING
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>RUNNING
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>status of node manager:
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Currently connected to Node Manager to monitor the domain GCDomain.
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>1
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully disconnected from Node Manager.
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>_END_
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1164 - Drainer broke out while loop
2012-01-02 11:31:10,422 [Thread-2] INFO wls.OMSController run.1159 - <ERR>_END_
2012-01-02 11:31:10,422 [Thread-2] INFO wls.OMSController run.1164 - Drainer broke out while loop
2012-01-02 11:31:11,734 [Main Thread] INFO wls.OMSController processCmd.1018 - wlst process is finished
2012-01-02 11:31:11,734 [Main Thread] INFO wls.OMSController processCmd.1020 - wlst process exited with code 0
2012-01-02 11:31:11,734 [Main Thread] INFO wls.OMSController processCmd.1022 - wlst outstream joined
2012-01-02 11:31:11,750 [Main Thread] INFO wls.OMSController processCmd.1024 - wlst errstream joined
2012-01-02 11:31:11,922 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:31:11,922 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:31:11,922 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:31:12,438 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:31:23,455 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.202 - page status code is 200
2012-01-02 11:31:23,455 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.204 - header is null
2012-01-02 11:31:23,455 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 0
2012-01-02 11:31:23,455 [Main Thread] INFO wls.OMSController startOMS.614 - startOMS finished with result: 0
2012-01-02 11:31:23,455 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:31:23,455 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:31:23,455 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:31:23,455 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:31:23,830 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.202 - page status code is 200
2012-01-02 11:31:23,830 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.204 - header is null
2012-01-02 11:31:23,830 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 0
2012-01-02 11:31:27,316 [Thread-1] INFO wls.OMSController run.1159 - <OUT>The OracleManagementServer_EMGC_OMS1_2 service is starting..............................................................................................................................................................................
2012-01-02 11:31:27,534 [Thread-1] INFO wls.OMSController run.1159 - <OUT>The OracleManagementServer_EMGC_OMS1_2 service was started successfully.
2012-01-02 11:31:27,534 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:31:28,050 [Main Thread] INFO wls.OMSController processCmd.1018 - wlst process is finished
2012-01-02 11:31:29,910 [Main Thread] INFO wls.OMSController processCmd.1020 - wlst process exited with code 0
2012-01-02 11:31:29,925 [Main Thread] INFO wls.OMSController processCmd.1022 - wlst outstream joined
2012-01-02 11:31:29,925 [Main Thread] INFO wls.OMSController processCmd.1024 - wlst errstream joined
2012-01-02 11:31:29,925 [Main Thread] INFO wls.OMSController startOMS.645 - net start return code is 0
2012-01-02 11:31:30,004 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:31:30,004 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:31:30,004 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:31:30,004 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:31:31,769 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.202 - page status code is 200
2012-01-02 11:31:31,769 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.204 - header is null
2012-01-02 11:31:31,769 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 0

Backend WLS or EM application seems to be down

2012-01-02T11:23:58Z

10.250.159.106:

This error message appears on its own webpage(omsunavailable.html) when the Grid login page is called.
Login to the server where the oms is installed:
D:\>set ORACLE_HOME=D:\ORACLE\MIDDLEWARE\oms11g

D:\>cd %ORACLE_HOME%\bin

D:\ORACLE\Middleware\oms11g\BIN>emctl status oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle Management Server is Down

D:\ORACLE\Middleware\oms11g\BIN>emctl start oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Windows service OracleManagementServer_EMGC_OMS1_2 failed to be started
Oracle Management Server is Down
Please check D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log for error details

D:\ORACLE\Middleware\oms11g\BIN>
Log file looks like this:
2012-01-02 11:16:11,140 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS\sysman\log\emctl.log
2012-01-02 11:16:11,171 [Main Thread] INFO wls.OMSController startOMS.497 - admin start is false
2012-01-02 11:16:11,171 [Main Thread] INFO wls.OMSController startOMS.498 - is service is false
2012-01-02 11:16:11,249 [Main Thread] INFO wls.OMSController getEnvProps.356 - Setting trust store system properties: -Dweblogic.security.TrustKeyStore=DemoTrust -Dweblogic.security.SSL.ignoreHostnameVerification=true -Djava.security.egd=file:///dev/urandom
2012-01-02 11:16:11,265 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:16:11,265 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:16:11,265 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:16:11,483 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:16:14,953 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:16:14,953 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:16:14,953 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8
2012-01-02 11:16:14,953 [Main Thread] INFO wls.OMSController startOMS.636 - Issuing net start for oms service...
2012-01-02 11:16:14,968 [Main Thread] INFO wls.OMSController startOMS.643 - net start cmd is [C:\WINDOWS\system32\net.exe, start, OracleManagementServer_EMGC_OMS1_2]
2012-01-02 11:16:15,250 [Thread-2] INFO wls.OMSController run.1159 - <ERR>The requested service has already been started.
2012-01-02 11:16:15,265 [Thread-2] INFO wls.OMSController run.1159 - <ERR>
2012-01-02 11:16:15,265 [Thread-2] INFO wls.OMSController run.1159 - <ERR>More help is available by typing NET HELPMSG 2182.
2012-01-02 11:16:15,265 [Thread-2] INFO wls.OMSController run.1159 - <ERR>
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController processCmd.1018 - wlst process is finished
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController processCmd.1020 - wlst process exited with code 2
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController processCmd.1022 - wlst outstream joined
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController processCmd.1024 - wlst errstream joined
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController startOMS.645 - net start return code is 2
2012-01-02 11:16:15,265 [Main Thread] ERROR wls.OMSController startOMS.648 - Windows service OracleManagementServer_EMGC_OMS1_2 failed to be started
2012-01-02 11:16:15,281 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:16:15,281 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:16:15,281 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:16:15,281 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:16:18,235 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:16:18,235 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:16:18,235 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8

* Manually stopped the OracleManagementServers. From services.msc:
Right click on OracleManagementServer_EMGC_OMS1_1 and stop 
Right click on OracleManagementServer_EMGC_OMS1_2 and stop 
* Attempt to restart the oms using the command line:
D:\ORACLE\Middleware\oms11g\BIN>emctl start oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Windows service OracleManagementServer_EMGC_OMS1_2 successfully started
Oracle Management Server is Up

D:\ORACLE\Middleware\oms11g\BIN>emctl status oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle Management Server is Up

D:\ORACLE\Middleware\oms11g\BIN>
Resulting addition to log file:
2012-01-02 11:21:10,228 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log
2012-01-02 11:21:10,260 [Main Thread] INFO wls.OMSController stopOMS.684 - istopAll is false
2012-01-02 11:21:10,260 [Main Thread] INFO wls.OMSController stopOMS.685 - isForce is false
2012-01-02 11:21:10,260 [Main Thread] INFO wls.OMSController stopOMS.686 - is service is true
2012-01-02 11:21:10,291 [Main Thread] INFO wls.OMSController getEnvProps.356 - Setting trust store system properties: -Dweblogic.security.TrustKeyStore=DemoTrust -Dweblogic.security.SSL.ignoreHostnameVerification=true -Djava.security.egd=file:///dev/urandom
2012-01-02 11:21:10,291 [Main Thread] INFO wls.OMSController stopOMS.702 - Stopping WebTier...
2012-01-02 11:21:10,306 [Main Thread] INFO util.WebTierUtil execCmd.134 - Running the command: D:\Oracle\gc_inst\WebTierIH1\bin\opmnctl.bat stopall
2012-01-02 11:21:45,688 [Main Thread] INFO util.WebTierUtil getProcessResult.196 - opmnctl cmd output: opmnctl stopall: stopping opmn and all managed processes...

2012-01-02 11:21:45,688 [Main Thread] INFO util.WebTierUtil getProcessResult.204 - opmnctl cmd error:
2012-01-02 11:21:45,688 [Main Thread] INFO util.WebTierUtil getProcessResult.208 - opmnctl cmd exited with code 0
2012-01-02 11:21:45,688 [Main Thread] INFO wls.OMSController stopOMS.713 - WebTier Successfully Stopped
2012-01-02 11:21:45,688 [Main Thread] INFO wls.OMSController stopOMS.728 - isStopAll is false
2012-01-02 11:21:45,688 [Main Thread] INFO wls.OMSController stopOMS.729 - isForce is false
2012-01-02 11:21:45,688 [Main Thread] INFO wls.OMSController stopOMS.742 - wlst command is D:/ORACLE/MIDDLE~1\oracle_common\common\bin\wlst.cmd D:/ORACLE/Middleware/oms11g\bin\stopOMS.py
2012-01-02 11:21:45,688 [Main Thread] INFO wls.OMSController stopOMS.743 - Executing the wlst command for stopOMS...
2012-01-02 11:21:46,188 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:21:46,188 [Thread-1] INFO wls.OMSController run.1159 - <OUT>CLASSPATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\lib\tools.jar;D:\ORACLE\MIDDLE~1\utils\config\10.3\config-launch.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\ORACLE\MIDDLE~1\modules\features\weblogic.server.modules_10.3.2.0.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0/lib/ant-all.jar;D:\ORACLE\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emagentSDK.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emCORE.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.http_client_11.1.1.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_cert.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_core.jar;D:/ORACLE/MIDDLE~1/modules/com.bea.core.apache.log4j_1.2.13.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dms_11.1.1/dms.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dconfig-infra_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.fabriccommon_11.1.1/fabric-common.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xmlparserv2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xml.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-pmlib.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-policy-core.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-secpol.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-dependencies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.policies_11.1.1/wsm-seed-policies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/orawsdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/mdds.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/ws_confmbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/org.apache.commons.digester_1.7.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.bind_2.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.activation_1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.stream_1.1.1.0.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.http_client_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxframework.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxspi.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.dconfigbeans_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-ca.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adflogginghandler.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adfsharembean.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/commons-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/jsp-el-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/oracle-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/auditwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/sslconfigwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/oamap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/ossoiap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.auditprovider_11.1.1/jps-wls-auditprovider.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-manifest.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-mbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-upgrade.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-patching.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar
2012-01-02 11:21:46,204 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:21:46,204 [Thread-1] INFO wls.OMSController run.1159 - <OUT>PATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\native;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\native;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\bin;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\Oracle\Middleware\oms11g\\perl\bin;D:\Oracle\Middleware\oms11g\bin;D:\Oracle\Middleware\oms11g\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin\server;D:\Oracle\Middleware\oms11g\oui\lib\win32;D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\native;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\native;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\bin;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\bin;D:\ORACLE\PRODUCT\mdlw\agent11g\bin;D:\ORACLE\PRODUCT\mdlw\oracle_common\bin;D:\ORACLE\PRODUCT\10.2.0\db_1\bin;C:\Program Files (x86)\Support Tools\;C:\NTRESKIT\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\HP OpenView\bin;C:\Program Files\HP OpenView\bin\win64;C:\Program Files\HP OpenView\bin\win64\OpC;C:\Program Files\HP OpenView\bin\;C:\Program Files\HP OpenView\lib\;D:\Oracle\Middleware\oms11g\bin;D:\Oracle\Middleware\oms11g\opmn\bin;D:\Oracle\Middleware\oms11g\opmn\lib;D:\Oracle\Middleware\oms11g\perl\bin;D:\Oracle\Middleware\Oracle_WT\bin;D:\Oracle\Middleware\Oracle_WT\opmn\bin;D:\Oracle\Middleware\Oracle_WT\opmn\lib;D:\Oracle\Middleware\Oracle_WT\perl\bin;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\OmniBack\bin\;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32\oci920_8;C:\WINDOWS;C:\WINDOWS\system32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32\oci920_8
2012-01-02 11:21:46,220 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:21:46,220 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Your environment has been set.
2012-01-02 11:21:46,235 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:21:46,235 [Thread-1] INFO wls.OMSController run.1159 - <OUT>CLASSPATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\lib\tools.jar;D:\ORACLE\MIDDLE~1\utils\config\10.3\config-launch.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\ORACLE\MIDDLE~1\modules\features\weblogic.server.modules_10.3.2.0.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0/lib/ant-all.jar;D:\ORACLE\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emagentSDK.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emCORE.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.http_client_11.1.1.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_cert.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_core.jar;D:/ORACLE/MIDDLE~1/modules/com.bea.core.apache.log4j_1.2.13.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dms_11.1.1/dms.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dconfig-infra_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.fabriccommon_11.1.1/fabric-common.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xmlparserv2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xml.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-pmlib.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-policy-core.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-secpol.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-dependencies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.policies_11.1.1/wsm-seed-policies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/orawsdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/mdds.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/ws_confmbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/org.apache.commons.digester_1.7.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.bind_2.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.activation_1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.stream_1.1.1.0.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.http_client_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxframework.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxspi.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.dconfigbeans_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-ca.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adflogginghandler.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adfsharembean.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/commons-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/jsp-el-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/oracle-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/auditwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/sslconfigwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/oamap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/ossoiap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.auditprovider_11.1.1/jps-wls-auditprovider.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-manifest.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-mbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-upgrade.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-patching.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbembedded57.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbclient57.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbtools57.jar
2012-01-02 11:21:49,501 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:21:49,501 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Initializing WebLogic Scripting Tool (WLST) ...
2012-01-02 11:21:49,501 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:07,067 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Welcome to WebLogic Server Administration Scripting Shell
2012-01-02 11:22:07,067 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:07,067 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Type help() for help on available commands
2012-01-02 11:22:07,067 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:07,614 [Thread-1] INFO wls.OMSController run.1159 - <OUT>is_admin_host is TRUE
2012-01-02 11:22:07,614 [Thread-1] INFO wls.OMSController run.1159 - <OUT>stop_all is FALSE
2012-01-02 11:22:07,614 [Thread-1] INFO wls.OMSController run.1159 - <OUT>forced_flag is FALSE
2012-01-02 11:22:08,724 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Connecting to Node Manager ...
2012-01-02 11:22:10,724 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.22 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=KEYNECTIS ROOT CA,OU=ROOT,O=KEYNECTIS,C=FR". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:22:10,724 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.22 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 3,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:22:10,724 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.22 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 2,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:22:24,258 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully Connected to Node Manager.
2012-01-02 11:22:24,258 [Thread-1] INFO wls.OMSController run.1159 - <OUT>status of node manager:
2012-01-02 11:22:24,274 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Currently connected to Node Manager to monitor the domain GCDomain.
2012-01-02 11:22:24,274 [Thread-1] INFO wls.OMSController run.1159 - <OUT>current status of EMGC_OMS1:
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1159 - <OUT>FAILED_NOT_RESTARTABLE
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Currently connected to Node Manager to monitor the domain GCDomain.
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully disconnected from Node Manager.
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1159 - <OUT>_END_
2012-01-02 11:22:24,305 [Thread-1] INFO wls.OMSController run.1164 - Drainer broke out while loop
2012-01-02 11:22:24,305 [Thread-2] INFO wls.OMSController run.1159 - <ERR>_END_
2012-01-02 11:22:24,305 [Thread-2] INFO wls.OMSController run.1164 - Drainer broke out while loop
2012-01-02 11:22:25,086 [Main Thread] INFO wls.OMSController processCmd.1018 - wlst process is finished
2012-01-02 11:22:25,086 [Main Thread] INFO wls.OMSController processCmd.1020 - wlst process exited with code 2
2012-01-02 11:22:25,086 [Main Thread] INFO wls.OMSController processCmd.1022 - wlst outstream joined
2012-01-02 11:22:25,086 [Main Thread] INFO wls.OMSController processCmd.1024 - wlst errstream joined
2012-01-02 11:22:25,086 [Main Thread] INFO wls.OMSController stopOMS.841 - stop OMS finished with result: 2
2012-01-02 11:22:25,118 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:22:25,118 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:22:25,118 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:22:25,430 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:22:28,931 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:22:28,931 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:22:28,931 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8
2012-01-02 11:22:53,217 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log
2012-01-02 11:22:53,232 [Main Thread] INFO wls.OMSController stopOMS.684 - istopAll is false
2012-01-02 11:22:53,232 [Main Thread] INFO wls.OMSController stopOMS.685 - isForce is false
2012-01-02 11:22:53,232 [Main Thread] INFO wls.OMSController stopOMS.686 - is service is true
2012-01-02 11:22:53,264 [Main Thread] INFO wls.OMSController getEnvProps.356 - Setting trust store system properties: -Dweblogic.security.TrustKeyStore=DemoTrust -Dweblogic.security.SSL.ignoreHostnameVerification=true -Djava.security.egd=file:///dev/urandom
2012-01-02 11:22:53,279 [Main Thread] INFO wls.OMSController stopOMS.702 - Stopping WebTier...
2012-01-02 11:22:53,279 [Main Thread] INFO util.WebTierUtil execCmd.134 - Running the command: D:\Oracle\gc_inst\WebTierIH1\bin\opmnctl.bat stopall
2012-01-02 11:22:54,764 [Main Thread] INFO util.WebTierUtil getProcessResult.196 - opmnctl cmd output: opmnctl stopall: opmn is not running.

2012-01-02 11:22:54,764 [Main Thread] INFO util.WebTierUtil getProcessResult.204 - opmnctl cmd error:
2012-01-02 11:22:54,764 [Main Thread] INFO util.WebTierUtil getProcessResult.208 - opmnctl cmd exited with code 0
2012-01-02 11:22:54,764 [Main Thread] INFO wls.OMSController stopOMS.713 - WebTier Successfully Stopped
2012-01-02 11:22:54,764 [Main Thread] INFO wls.OMSController stopOMS.728 - isStopAll is false
2012-01-02 11:22:54,764 [Main Thread] INFO wls.OMSController stopOMS.729 - isForce is false
2012-01-02 11:22:54,764 [Main Thread] INFO wls.OMSController stopOMS.742 - wlst command is D:/ORACLE/MIDDLE~1\oracle_common\common\bin\wlst.cmd D:/ORACLE/Middleware/oms11g\bin\stopOMS.py
2012-01-02 11:22:54,764 [Main Thread] INFO wls.OMSController stopOMS.743 - Executing the wlst command for stopOMS...
2012-01-02 11:22:55,170 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:55,186 [Thread-1] INFO wls.OMSController run.1159 - <OUT>CLASSPATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\lib\tools.jar;D:\ORACLE\MIDDLE~1\utils\config\10.3\config-launch.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\ORACLE\MIDDLE~1\modules\features\weblogic.server.modules_10.3.2.0.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0/lib/ant-all.jar;D:\ORACLE\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emagentSDK.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emCORE.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.http_client_11.1.1.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_cert.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_core.jar;D:/ORACLE/MIDDLE~1/modules/com.bea.core.apache.log4j_1.2.13.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dms_11.1.1/dms.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dconfig-infra_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.fabriccommon_11.1.1/fabric-common.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xmlparserv2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xml.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-pmlib.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-policy-core.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-secpol.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-dependencies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.policies_11.1.1/wsm-seed-policies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/orawsdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/mdds.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/ws_confmbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/org.apache.commons.digester_1.7.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.bind_2.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.activation_1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.stream_1.1.1.0.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.http_client_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxframework.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxspi.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.dconfigbeans_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-ca.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adflogginghandler.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adfsharembean.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/commons-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/jsp-el-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/oracle-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/auditwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/sslconfigwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/oamap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/ossoiap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.auditprovider_11.1.1/jps-wls-auditprovider.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-manifest.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-mbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-upgrade.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-patching.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar
2012-01-02 11:22:55,202 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:55,202 [Thread-1] INFO wls.OMSController run.1159 - <OUT>PATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\native;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\native;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\bin;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\Oracle\Middleware\oms11g\\perl\bin;D:\Oracle\Middleware\oms11g\bin;D:\Oracle\Middleware\oms11g\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin\server;D:\Oracle\Middleware\oms11g\oui\lib\win32;D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\native;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\native;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\bin;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\bin;D:\ORACLE\PRODUCT\mdlw\agent11g\bin;D:\ORACLE\PRODUCT\mdlw\oracle_common\bin;D:\ORACLE\PRODUCT\10.2.0\db_1\bin;C:\Program Files (x86)\Support Tools\;C:\NTRESKIT\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\HP OpenView\bin;C:\Program Files\HP OpenView\bin\win64;C:\Program Files\HP OpenView\bin\win64\OpC;C:\Program Files\HP OpenView\bin\;C:\Program Files\HP OpenView\lib\;D:\Oracle\Middleware\oms11g\bin;D:\Oracle\Middleware\oms11g\opmn\bin;D:\Oracle\Middleware\oms11g\opmn\lib;D:\Oracle\Middleware\oms11g\perl\bin;D:\Oracle\Middleware\Oracle_WT\bin;D:\Oracle\Middleware\Oracle_WT\opmn\bin;D:\Oracle\Middleware\Oracle_WT\opmn\lib;D:\Oracle\Middleware\Oracle_WT\perl\bin;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\OmniBack\bin\;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32\oci920_8;C:\WINDOWS;C:\WINDOWS\system32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32\oci920_8
2012-01-02 11:22:55,233 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:55,233 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Your environment has been set.
2012-01-02 11:22:55,264 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:55,264 [Thread-1] INFO wls.OMSController run.1159 - <OUT>CLASSPATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\lib\tools.jar;D:\ORACLE\MIDDLE~1\utils\config\10.3\config-launch.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\ORACLE\MIDDLE~1\modules\features\weblogic.server.modules_10.3.2.0.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0/lib/ant-all.jar;D:\ORACLE\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emagentSDK.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emCORE.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.http_client_11.1.1.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_cert.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_core.jar;D:/ORACLE/MIDDLE~1/modules/com.bea.core.apache.log4j_1.2.13.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dms_11.1.1/dms.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dconfig-infra_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.fabriccommon_11.1.1/fabric-common.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xmlparserv2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xml.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-pmlib.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-policy-core.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-secpol.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-dependencies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.policies_11.1.1/wsm-seed-policies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/orawsdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/mdds.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/ws_confmbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/org.apache.commons.digester_1.7.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.bind_2.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.activation_1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.stream_1.1.1.0.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.http_client_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxframework.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxspi.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.dconfigbeans_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-ca.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adflogginghandler.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adfsharembean.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/commons-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/jsp-el-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/oracle-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/auditwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/sslconfigwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/oamap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/ossoiap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.auditprovider_11.1.1/jps-wls-auditprovider.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-manifest.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-mbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-upgrade.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-patching.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbembedded57.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbclient57.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbtools57.jar
2012-01-02 11:22:57,874 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:22:57,874 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Initializing WebLogic Scripting Tool (WLST) ...
2012-01-02 11:22:57,874 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:23:10,517 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Welcome to WebLogic Server Administration Scripting Shell
2012-01-02 11:23:10,517 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:23:10,517 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Type help() for help on available commands
2012-01-02 11:23:10,517 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:23:11,033 [Thread-1] INFO wls.OMSController run.1159 - <OUT>is_admin_host is TRUE
2012-01-02 11:23:11,033 [Thread-1] INFO wls.OMSController run.1159 - <OUT>stop_all is FALSE
2012-01-02 11:23:11,033 [Thread-1] INFO wls.OMSController run.1159 - <OUT>forced_flag is FALSE
2012-01-02 11:23:12,564 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Connecting to Node Manager ...
2012-01-02 11:23:14,283 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.23 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=KEYNECTIS ROOT CA,OU=ROOT,O=KEYNECTIS,C=FR". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:23:14,283 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.23 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 3,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:23:14,299 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.23 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 2,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:23:25,957 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully Connected to Node Manager.
2012-01-02 11:23:25,973 [Thread-1] INFO wls.OMSController run.1159 - <OUT>status of node manager:
2012-01-02 11:23:25,989 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Currently connected to Node Manager to monitor the domain GCDomain.
2012-01-02 11:23:25,989 [Thread-1] INFO wls.OMSController run.1159 - <OUT>current status of EMGC_OMS1:
2012-01-02 11:23:25,989 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:23:25,989 [Thread-1] INFO wls.OMSController run.1159 - <OUT>FAILED_NOT_RESTARTABLE
2012-01-02 11:23:25,989 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:23:25,989 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Currently connected to Node Manager to monitor the domain GCDomain.
2012-01-02 11:23:26,004 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully disconnected from Node Manager.
2012-01-02 11:23:26,004 [Thread-1] INFO wls.OMSController run.1159 - <OUT>_END_
2012-01-02 11:23:26,004 [Thread-1] INFO wls.OMSController run.1164 - Drainer broke out while loop
2012-01-02 11:23:26,020 [Thread-2] INFO wls.OMSController run.1159 - <ERR>_END_
2012-01-02 11:23:26,020 [Thread-2] INFO wls.OMSController run.1164 - Drainer broke out while loop
2012-01-02 11:23:26,536 [Main Thread] INFO wls.OMSController processCmd.1018 - wlst process is finished
2012-01-02 11:23:26,536 [Main Thread] INFO wls.OMSController processCmd.1020 - wlst process exited with code 2
2012-01-02 11:23:26,536 [Main Thread] INFO wls.OMSController processCmd.1022 - wlst outstream joined
2012-01-02 11:23:26,536 [Main Thread] INFO wls.OMSController processCmd.1024 - wlst errstream joined
2012-01-02 11:23:26,536 [Main Thread] INFO wls.OMSController stopOMS.841 - stop OMS finished with result: 2
2012-01-02 11:23:26,567 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:23:26,567 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:23:26,567 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:23:26,817 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:23:30,365 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:23:30,365 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:23:30,365 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8
2012-01-02 11:23:44,992 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log
2012-01-02 11:23:45,024 [Main Thread] INFO wls.OMSController startOMS.497 - admin start is false
2012-01-02 11:23:45,024 [Main Thread] INFO wls.OMSController startOMS.498 - is service is false
2012-01-02 11:23:45,071 [Main Thread] INFO wls.OMSController getEnvProps.356 - Setting trust store system properties: -Dweblogic.security.TrustKeyStore=DemoTrust -Dweblogic.security.SSL.ignoreHostnameVerification=true -Djava.security.egd=file:///dev/urandom
2012-01-02 11:23:45,102 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:23:45,102 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:23:45,102 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:23:45,383 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:23:48,915 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:23:48,931 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:23:48,931 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8
2012-01-02 11:23:48,931 [Main Thread] INFO wls.OMSController startOMS.636 - Issuing net start for oms service...
2012-01-02 11:23:48,931 [Main Thread] INFO wls.OMSController startOMS.643 - net start cmd is [C:\WINDOWS\system32\net.exe, start, OracleManagementServer_EMGC_OMS1_2]
2012-01-02 11:23:54,291 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log
2012-01-02 11:23:54,322 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:23:54,322 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:23:54,322 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:23:54,619 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:23:58,042 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:23:58,042 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:23:58,042 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8
2012-01-02 11:24:03,402 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log
2012-01-02 11:24:03,433 [Main Thread] INFO wls.OMSController startOMS.497 - admin start is false
2012-01-02 11:24:03,433 [Main Thread] INFO wls.OMSController startOMS.498 - is service is true
2012-01-02 11:24:03,465 [Main Thread] INFO wls.OMSController getEnvProps.356 - Setting trust store system properties: -Dweblogic.security.TrustKeyStore=DemoTrust -Dweblogic.security.SSL.ignoreHostnameVerification=true -Djava.security.egd=file:///dev/urandom
2012-01-02 11:24:03,465 [Main Thread] INFO wls.OMSController startOMS.519 - Starting WebTier...
2012-01-02 11:24:03,465 [Main Thread] INFO util.WebTierUtil execCmd.134 - Running the command: D:\Oracle\gc_inst\WebTierIH1\bin\opmnctl.bat stopall
2012-01-02 11:24:05,137 [Main Thread] INFO util.WebTierUtil getProcessResult.196 - opmnctl cmd output: opmnctl stopall: opmn is not running.

2012-01-02 11:24:05,137 [Main Thread] INFO util.WebTierUtil getProcessResult.204 - opmnctl cmd error:
2012-01-02 11:24:05,137 [Main Thread] INFO util.WebTierUtil getProcessResult.208 - opmnctl cmd exited with code 0
2012-01-02 11:24:05,137 [Main Thread] INFO util.WebTierUtil execCmd.134 - Running the command: D:\Oracle\gc_inst\WebTierIH1\bin\opmnctl.bat startall
2012-01-02 11:24:24,234 [Main Thread] INFO util.WebTierUtil getProcessResult.196 - opmnctl cmd output: opmnctl startall: starting opmn and all managed processes...

2012-01-02 11:24:24,234 [Main Thread] INFO util.WebTierUtil getProcessResult.204 - opmnctl cmd error:
2012-01-02 11:24:24,234 [Main Thread] INFO util.WebTierUtil getProcessResult.208 - opmnctl cmd exited with code 0
2012-01-02 11:24:24,234 [Main Thread] INFO wls.OMSController startOMS.530 - WebTier Successfully Started
2012-01-02 11:24:24,234 [Main Thread] INFO wls.OMSController startOMS.556 - wlst command is D:/ORACLE/MIDDLE~1\oracle_common\common\bin\wlst.cmd D:/ORACLE/Middleware/oms11g\bin\startOMS.py
2012-01-02 11:24:24,234 [Main Thread] INFO wls.OMSController startOMS.557 - Executing the wlst command for startOMS...
2012-01-02 11:24:24,234 [Main Thread] INFO wls.OMSController startOMS.567 - optional admin start is false
2012-01-02 11:24:24,578 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:24,594 [Thread-1] INFO wls.OMSController run.1159 - <OUT>CLASSPATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\lib\tools.jar;D:\ORACLE\MIDDLE~1\utils\config\10.3\config-launch.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\ORACLE\MIDDLE~1\modules\features\weblogic.server.modules_10.3.2.0.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0/lib/ant-all.jar;D:\ORACLE\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emagentSDK.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emCORE.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.http_client_11.1.1.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_cert.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_core.jar;D:/ORACLE/MIDDLE~1/modules/com.bea.core.apache.log4j_1.2.13.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dms_11.1.1/dms.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dconfig-infra_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.fabriccommon_11.1.1/fabric-common.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xmlparserv2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xml.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-pmlib.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-policy-core.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-secpol.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-dependencies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.policies_11.1.1/wsm-seed-policies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/orawsdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/mdds.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/ws_confmbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/org.apache.commons.digester_1.7.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.bind_2.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.activation_1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.stream_1.1.1.0.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.http_client_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxframework.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxspi.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.dconfigbeans_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-ca.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adflogginghandler.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adfsharembean.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/commons-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/jsp-el-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/oracle-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/auditwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/sslconfigwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/oamap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/ossoiap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.auditprovider_11.1.1/jps-wls-auditprovider.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-manifest.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-mbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-upgrade.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-patching.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar
2012-01-02 11:24:24,609 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:24,609 [Thread-1] INFO wls.OMSController run.1159 - <OUT>PATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\native;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\native;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\bin;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\Oracle\Middleware\oms11g\\perl\bin;D:\Oracle\Middleware\oms11g\bin;D:\Oracle\Middleware\oms11g\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin\server;D:\Oracle\Middleware\oms11g\oui\lib\win32;D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\native;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\native;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\bin;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\jre\bin;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\bin;D:\ORACLE\PRODUCT\mdlw\agent11g\bin;D:\ORACLE\PRODUCT\mdlw\oracle_common\bin;D:\ORACLE\PRODUCT\10.2.0\db_1\bin;C:\Program Files (x86)\Support Tools\;C:\NTRESKIT\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\HP OpenView\bin;C:\Program Files\HP OpenView\bin\win64;C:\Program Files\HP OpenView\bin\win64\OpC;C:\Program Files\HP OpenView\bin\;C:\Program Files\HP OpenView\lib\;D:\Oracle\Middleware\oms11g\bin;D:\Oracle\Middleware\oms11g\opmn\bin;D:\Oracle\Middleware\oms11g\opmn\lib;D:\Oracle\Middleware\oms11g\perl\bin;D:\Oracle\Middleware\Oracle_WT\bin;D:\Oracle\Middleware\Oracle_WT\opmn\bin;D:\Oracle\Middleware\Oracle_WT\opmn\lib;D:\Oracle\Middleware\Oracle_WT\perl\bin;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\OmniBack\bin\;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32\oci920_8;C:\WINDOWS;C:\WINDOWS\system32;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\native\win\32\oci920_8
2012-01-02 11:24:24,625 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:24,625 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Your environment has been set.
2012-01-02 11:24:24,641 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:24,641 [Thread-1] INFO wls.OMSController run.1159 - <OUT>CLASSPATH=D:\ORACLE\MIDDLE~1\patch_wls1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\patch_oepe1032\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\ORACLE\MIDDLE~1\JROCKI~1.5-3\lib\tools.jar;D:\ORACLE\MIDDLE~1\utils\config\10.3\config-launch.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\ORACLE\MIDDLE~1\modules\features\weblogic.server.modules_10.3.2.0.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\ORACLE\MIDDLE~1\modules\ORGAPA~1.0/lib/ant-all.jar;D:\ORACLE\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emagentSDK.jar;D:/ORACLE/Middleware/oms11g/sysman/jlib/emCORE.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.http_client_11.1.1.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_cert.jar;D:/ORACLE/MIDDLE~1/oracle_common/modules/oracle.osdt_11.1.1/osdt_core.jar;D:/ORACLE/MIDDLE~1/modules/com.bea.core.apache.log4j_1.2.13.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.odl_11.1.1/ojdl2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dms_11.1.1/dms.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.dconfig-infra_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.fabriccommon_11.1.1/fabric-common.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xmlparserv2.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.xdk_11.1.0/xml.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-pmlib.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-policy-core.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-secpol.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.common_11.1.1/wsm-dependencies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.wsm.policies_11.1.1/wsm-seed-policies.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/orawsdl.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/mdds.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.webservices_11.1.1/ws_confmbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/org.apache.commons.digester_1.7.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.bind_2.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.activation_1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/../modules/javax.xml.stream_1.1.1.0.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.http_client_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxframework.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jmx_11.1.1/jmxspi.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.dconfigbeans_11.1.1.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share.ca_11.1.1/adf-share-ca.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adflogginghandler.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/adfsharembean.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/commons-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/jsp-el-api.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.adf.share_11.1.1/oracle-el.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/auditwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/sslconfigwlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/oamap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/ossoiap_help.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/common/wlst/resources/jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.auditprovider_11.1.1/jps-wls-auditprovider.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-manifest.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-mbeans.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-upgrade.jar;D:\ORACLE\MIDDLE~1\ORACLE~1/modules/oracle.jps_11.1.1/jps-patching.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\ORACLE\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbembedded57.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbclient57.jar;D:\ORACLE\MIDDLE~1\WLSERV~1.3\common\eval\pointbase\lib\pbtools57.jar
2012-01-02 11:24:27,626 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:27,626 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Initializing WebLogic Scripting Tool (WLST) ...
2012-01-02 11:24:27,626 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:41,441 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Welcome to WebLogic Server Administration Scripting Shell
2012-01-02 11:24:41,456 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:41,456 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Type help() for help on available commands
2012-01-02 11:24:41,456 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:42,238 [Thread-1] INFO wls.OMSController run.1159 - <OUT>is_admin_host is TRUE
2012-01-02 11:24:42,238 [Thread-1] INFO wls.OMSController run.1159 - <OUT>admin_start is FALSE
2012-01-02 11:24:43,519 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Connecting to Node Manager ...
2012-01-02 11:24:45,191 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.24 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=KEYNECTIS ROOT CA,OU=ROOT,O=KEYNECTIS,C=FR". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:24:45,207 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.24 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 3,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:24:45,207 [Thread-1] INFO wls.OMSController run.1159 - <OUT><2-jan-2012 11.24 u. CET> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 2,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
2012-01-02 11:24:57,069 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully Connected to Node Manager.
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>status of node manager:
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Currently connected to Node Manager to monitor the domain GCDomain.
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>current status of EMGC_ADMINSERVER:
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>RUNNING
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>current status of EMGC_OMS1:
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>FAILED_NOT_RESTARTABLE
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:24:57,084 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Starting server EMGC_OMS1
2012-01-02 11:24:57,100 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Starting server EMGC_OMS1 ...
2012-01-02 11:31:10,359 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully started server EMGC_OMS1 ...
2012-01-02 11:31:10,359 [Thread-1] INFO wls.OMSController run.1159 - <OUT>new status of EMGC_OMS1:
2012-01-02 11:31:10,406 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:31:10,406 [Thread-1] INFO wls.OMSController run.1159 - <OUT>RUNNING
2012-01-02 11:31:10,406 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:31:10,406 [Thread-1] INFO wls.OMSController run.1159 - <OUT>wait until EMGC_OMS1 becomes RUNNING
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>RUNNING
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>status of node manager:
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Currently connected to Node Manager to monitor the domain GCDomain.
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>1
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>Successfully disconnected from Node Manager.
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1159 - <OUT>_END_
2012-01-02 11:31:10,422 [Thread-1] INFO wls.OMSController run.1164 - Drainer broke out while loop
2012-01-02 11:31:10,422 [Thread-2] INFO wls.OMSController run.1159 - <ERR>_END_
2012-01-02 11:31:10,422 [Thread-2] INFO wls.OMSController run.1164 - Drainer broke out while loop
2012-01-02 11:31:11,734 [Main Thread] INFO wls.OMSController processCmd.1018 - wlst process is finished
2012-01-02 11:31:11,734 [Main Thread] INFO wls.OMSController processCmd.1020 - wlst process exited with code 0
2012-01-02 11:31:11,734 [Main Thread] INFO wls.OMSController processCmd.1022 - wlst outstream joined
2012-01-02 11:31:11,750 [Main Thread] INFO wls.OMSController processCmd.1024 - wlst errstream joined
2012-01-02 11:31:11,922 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:31:11,922 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:31:11,922 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:31:12,438 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:31:23,455 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.202 - page status code is 200
2012-01-02 11:31:23,455 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.204 - header is null
2012-01-02 11:31:23,455 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 0
2012-01-02 11:31:23,455 [Main Thread] INFO wls.OMSController startOMS.614 - startOMS finished with result: 0
2012-01-02 11:31:23,455 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:31:23,455 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:31:23,455 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:31:23,455 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:31:23,830 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.202 - page status code is 200
2012-01-02 11:31:23,830 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.204 - header is null
2012-01-02 11:31:23,830 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 0
2012-01-02 11:31:27,316 [Thread-1] INFO wls.OMSController run.1159 - <OUT>The OracleManagementServer_EMGC_OMS1_2 service is starting..............................................................................................................................................................................
2012-01-02 11:31:27,534 [Thread-1] INFO wls.OMSController run.1159 - <OUT>The OracleManagementServer_EMGC_OMS1_2 service was started successfully.
2012-01-02 11:31:27,534 [Thread-1] INFO wls.OMSController run.1159 - <OUT>
2012-01-02 11:31:28,050 [Main Thread] INFO wls.OMSController processCmd.1018 - wlst process is finished
2012-01-02 11:31:29,910 [Main Thread] INFO wls.OMSController processCmd.1020 - wlst process exited with code 0
2012-01-02 11:31:29,925 [Main Thread] INFO wls.OMSController processCmd.1022 - wlst outstream joined
2012-01-02 11:31:29,925 [Main Thread] INFO wls.OMSController processCmd.1024 - wlst errstream joined
2012-01-02 11:31:29,925 [Main Thread] INFO wls.OMSController startOMS.645 - net start return code is 0
2012-01-02 11:31:30,004 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:31:30,004 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:31:30,004 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:31:30,004 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:31:31,769 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.202 - page status code is 200
2012-01-02 11:31:31,769 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.204 - header is null
2012-01-02 11:31:31,769 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 0

Backend WLS or EM application seems to be down

2012-01-02T10:28:57Z

10.250.159.106:

This error message appears on its own webpage(omsunavailable.html) when the Grid login page is called.
=== Things to check ===
* OMS listener
Login to the server where the oms is installed:
D:\>set ORACLE_HOME=D:\ORACLE\MIDDLEWARE\oms11g

D:\>cd %ORACLE_HOME%\bin

D:\ORACLE\Middleware\oms11g\BIN>emctl status oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle Management Server is Down

D:\ORACLE\Middleware\oms11g\BIN>emctl start oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Windows service OracleManagementServer_EMGC_OMS1_2 failed to be started
Oracle Management Server is Down
Please check D:/Oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log for error details

D:\ORACLE\Middleware\oms11g\BIN>
Log file looks like this:
2012-01-02 11:16:11,140 [Main Thread] DEBUG wls.OMSController main.173 - Log location is D:/Oracle/gc_inst/em/EMGC_OMS\sysman\log\emctl.log
2012-01-02 11:16:11,171 [Main Thread] INFO wls.OMSController startOMS.497 - admin start is false
2012-01-02 11:16:11,171 [Main Thread] INFO wls.OMSController startOMS.498 - is service is false
2012-01-02 11:16:11,249 [Main Thread] INFO wls.OMSController getEnvProps.356 - Setting trust store system properties: -Dweblogic.security.TrustKeyStore=DemoTrust -Dweblogic.security.SSL.ignoreHostnameVerification=true -Djava.security.egd=file:///dev/urandom
2012-01-02 11:16:11,265 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:16:11,265 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:16:11,265 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:16:11,483 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:16:14,953 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:16:14,953 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:16:14,953 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8
2012-01-02 11:16:14,953 [Main Thread] INFO wls.OMSController startOMS.636 - Issuing net start for oms service...
2012-01-02 11:16:14,968 [Main Thread] INFO wls.OMSController startOMS.643 - net start cmd is [C:\WINDOWS\system32\net.exe, start, OracleManagementServer_EMGC_OMS1_2]
2012-01-02 11:16:15,250 [Thread-2] INFO wls.OMSController run.1159 - <ERR>The requested service has already been started.
2012-01-02 11:16:15,265 [Thread-2] INFO wls.OMSController run.1159 - <ERR>
2012-01-02 11:16:15,265 [Thread-2] INFO wls.OMSController run.1159 - <ERR>More help is available by typing NET HELPMSG 2182.
2012-01-02 11:16:15,265 [Thread-2] INFO wls.OMSController run.1159 - <ERR>
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController processCmd.1018 - wlst process is finished
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController processCmd.1020 - wlst process exited with code 2
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController processCmd.1022 - wlst outstream joined
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController processCmd.1024 - wlst errstream joined
2012-01-02 11:16:15,265 [Main Thread] INFO wls.OMSController startOMS.645 - net start return code is 2
2012-01-02 11:16:15,265 [Main Thread] ERROR wls.OMSController startOMS.648 - Windows service OracleManagementServer_EMGC_OMS1_2 failed to be started
2012-01-02 11:16:15,281 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.140 - HTTP port in emgc property file: 7201
2012-01-02 11:16:15,281 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.141 - HTTPS port in emgc property file: 7301
2012-01-02 11:16:15,281 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.157 - Using http port.
2012-01-02 11:16:15,281 [Main Thread] DEBUG oms.StatusOMSCmd processStatusOMS.197 - Attempting to connect to http://Sdiora06.ont.local:7201/em/console/logon/logon
2012-01-02 11:16:18,235 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.228 - Failed to connect to em login page
2012-01-02 11:16:18,235 [Main Thread] INFO oms.StatusOMSCmd processStatusOMS.229 - Connection refused: connect
2012-01-02 11:16:18,235 [Main Thread] INFO wls.OMSController statusOMS.980 - statusOMS finished with result: 8

Backend WLS or EM application seems to be down

2012-01-02T10:13:24Z

10.250.159.106:

Backend WLS or EM application seems to be down

2012-01-02T09:37:40Z

10.250.159.106:

This error can happen for a number of reasons.
=== Things to check ===

Backend WLS or EM application seems to be down

2012-01-02T09:37:08Z

10.250.159.106: Created page with "This error can happen for a number of reasons. == Things to check =="

This error can happen for a number of reasons.
== Things to check ==

Grid Control

2012-01-02T09:36:08Z

10.250.159.106:

==Definitions==
* OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR
* OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA
* OMA - Management Agent - This is a perl program that runs on the database host (one for all databases on the host) and uploads data to the OMS

==Agent Unreachable==
* Is the agent running?
From SQL*Plus:
select username,program from v$session where LOWER (program) like 'emagent%';
If no rows selected, the agent is not running.
or
From Unix:
. oraenv
agent11g (how to see [[which databases are running on the machine]])
emctl status agent

ps -ef|grep [a]gent
There should be a handful. If only a few, kill them and restart the agent.
emctl start agent

'''Check the agent log in $ORACLE_HOME/sysman/log'''

=== [[Backend WLS or EM application seems to be down]] ===
=== To list targets known to an agent: ===
emctl config agent listtargets
It looks at the file $AGENT_HOME/sysman/emd/targets.xml

Manually add targets by editing this file and running:
emctl config agent addtargets $AGENT_HOME/sysman/emd/targets.xml

Check state and upload directories under $AGENT_HOME/sysman/emd for .err files

==Some useful Metalink Master Documents related to Grid Control==
*Master Index for Managing Oracle Database and Listener with Grid Control [ID 1304021.1]
*Master Note for 10g Grid Control Agent Process Control (Start, Stop & Status) & Configuration [ID 1082009.1]
*How to Run the RDA against a Grid Control Installation [ID 1057051.1]
*How to Run the RDA against a Grid Control Installation Release 11g [ID 1190193.1]
*Grid Control Target Maintenance: Steps to Diagnose Issues Related to "Agent Unreachable" Status [ID 271126.1]
*Master Note for 10g Grid Control Enterprise Manager Communication and Upload issues [ID 1086343.1]
*Master Note for Target Maintenance Through 10g Enterprise Manager Grid Control [ID 1202453.1]
*Receiving agent unreachable notification emails very often after 10.2.0.4 agent upgrade [ID 752296.1]
*Healthcheck Metric failing for a 10.2.0.4 Target Database with 10.2.0.4 Agent [ID 602633.1]

Grid Control

2012-01-02T09:35:34Z

10.250.159.106:

==Definitions==
* OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR
* OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA
* OMA - Management Agent - This is a perl program that runs on the database host (one for all databases on the host) and uploads data to the OMS

==Agent Unreachable==
* Is the agent running?
From SQL*Plus:
select username,program from v$session where LOWER (program) like 'emagent%';
If no rows selected, the agent is not running.
or
From Unix:
. oraenv
agent11g (how to see [[which databases are running on the machine]])
emctl status agent

ps -ef|grep [a]gent
There should be a handful. If only a few, kill them and restart the agent.
emctl start agent

'''Check the agent log in $ORACLE_HOME/sysman/log'''

=== Backend WLS or EM application seems to be down ===
=== To list targets known to an agent: ===
emctl config agent listtargets
It looks at the file $AGENT_HOME/sysman/emd/targets.xml

Manually add targets by editing this file and running:
emctl config agent addtargets $AGENT_HOME/sysman/emd/targets.xml

Check state and upload directories under $AGENT_HOME/sysman/emd for .err files

==Some useful Metalink Master Documents related to Grid Control==
*Master Index for Managing Oracle Database and Listener with Grid Control [ID 1304021.1]
*Master Note for 10g Grid Control Agent Process Control (Start, Stop & Status) & Configuration [ID 1082009.1]
*How to Run the RDA against a Grid Control Installation [ID 1057051.1]
*How to Run the RDA against a Grid Control Installation Release 11g [ID 1190193.1]
*Grid Control Target Maintenance: Steps to Diagnose Issues Related to "Agent Unreachable" Status [ID 271126.1]
*Master Note for 10g Grid Control Enterprise Manager Communication and Upload issues [ID 1086343.1]
*Master Note for Target Maintenance Through 10g Enterprise Manager Grid Control [ID 1202453.1]
*Receiving agent unreachable notification emails very often after 10.2.0.4 agent upgrade [ID 752296.1]
*Healthcheck Metric failing for a 10.2.0.4 Target Database with 10.2.0.4 Agent [ID 602633.1]

(Re)create user/schema using DataPump

2011-12-20T15:36:31Z

10.250.159.106:

If the user does not yet exist on the destination database, just import it using the procedure outlined [[DataPump|here]].

If however, the user(schema) already exists, it will have to be dropped and re-created before the data can be imported. 
But, before dropping the schema, run [[Extract ddl with "dbms metadata.get ddl"#Get User DDL with related grants|this script]] to generate the correct DDL beforehand! 
After this DDL has been run and the results stored, the following command can be executed:
drop user <schema name> cascade;
Now, recreate the schema with the above-mentioned DDL 
The dumpfile (or a part thereof) can now be imported to fill up the currently empty schema:
impdp <usr>/<pwd> parfile=schema.par
where schema.par would look like this:
directory=DP_IMPORT
dumpfile=<db_name>_DP.DMP
schemas=(<schema name>)

and/or maybe one or more of the following:
exclude=grants
tables=(<schema name>.<table name>)
remap_tablespace=old:new
Finally, recompile all invalid objects:
exec utl_recomp.recomp_serial();
or
exec utl_recomp.recomp_parallel(4);
or
@?\rdbms\admin\utlrp.sql
or
@?\rdbms\admin\utlprp.sql(4)

and the grants are different on the destination database than they were on the source database, they should be retained. This can be accomplished by excluding grants when importing.

The schema should ideally be checked beforehand that it does not own objects like 'type's that may exist elsewhere...

(Re)create user/schema using DataPump

2011-12-20T15:34:39Z

10.250.159.106:

If the user does not yet exist on the destination database, just import it using the procedure outlined [[DataPump|here]].

If however, the user(schema) already exists, it will have to be dropped and re-created before the data can be imported. 
But, before dropping the schema, run [[Extract ddl with "dbms metadata.get ddl"#Get User DDL with related grants|this script]] to generate the correct DDL beforehand! 
After this DDL has been run and the results stored, the following command can be executed:
drop user <schema name> cascade;
Now, recreate the schema with the above-mentioned DDL 
Now the dumpfile (or a part thereof) can be imported to fill up the now empty schema:
impdp <usr>/<pwd> parfile=schema.par
where schema.par would look like this:
directory=DP_IMPORT
dumpfile=<db_name>_DP.DMP
schemas=(<schema name>)

and/or maybe one or more of the following:
exclude=grants
tables=(<schema name>.<table name>)
remap_tablespace=old:new
Finally, recompile all invalid objects:
exec utl_recomp.recomp_serial();
or
exec utl_recomp.recomp_parallel(4);
or
@?\rdbms\admin\utlrp.sql
or
@?\rdbms\admin\utlprp.sql(4)

and the grants are different on the destination database than they were on the source database, they should be retained. This can be accomplished by excluding grants when importing.

The schema should ideally be checked beforehand that it does not own objects like 'type's that may exist elsewhere...

(Re)create user/schema using DataPump

2011-12-20T15:18:12Z

10.250.159.106:

If the user does not yet exist on the destination database, just import it using the procedure outlined [[DataPump|here]].

If however, the user(schema) already exists, it will have to be dropped and re-created before the data can be imported. 
So before dropping the schema, run [[Extract ddl with "dbms metadata.get ddl"#Get User DDL with related grants|this script]] to generate the correct DDL beforehand!
and the grants are different on the destination database than they were on the source database, they should be retained. This can be accomplished by excluding grants when importing.

drop user <schema name> cascade;

The schema should ideally be checked beforehand that it does not own objects like 'type's that may exist elsewhere...

Import the schema:
impdp <usr>/<pwd> parfile=schema.par
where schema.par would look like this:
schemas=<schema name>
exclude=grants
Finally, recompile all invalid objects:
exec utl_recomp.recomp_serial();
or
exec utl_recomp.recomp_parallel(4);
or
@utlrp.sql
or
@utlprp.sql(4)

Extract ddl with "dbms metadata.get ddl"

2011-12-20T15:17:37Z

10.250.159.106:

===Different ways of extracting ddl===
set pagesize 0
set linesize 30000
set long 500000
set longchunksize 500000
set trimspool on
set feed off
spool deedeeyell.sql
select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;'
from dba_objects where owner = UPPER('&&schema')
and object_type = 'INDEX'
and ...
/
spool off

=== Get the semi-colon to be appended ===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, ‘SQLTERMINATOR’, TRUE );
=== Make the pretty output ===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );
=== Don't recreate storage clause on tables/indexes ===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'STORAGE', false );
=== Return DDL as VARCHAR2 instead of CLOB ===
*Use get_ddl_text insead of get_ddl
=== Get lots of DDL at once ===
select ‘select dbms_metadata.get_ddl(”’|| object_type || ”’,
”’||object_name||”’,”&&schema”) FROM dual;’
from dba_objects where owner = UPPER(‘&&schema’)
where 1=1
and object_type = ‘INDEX’

select ‘select dbms_metadata.get_ddl(”’ || type || ”’,
”’ || name || ”’, ”’ || UPPER(‘&&schema’) || ”’) FROM dual;’
from dba_object_size
where 1=1
and owner = UPPER(‘&&schema’)
and type = ‘TABLE’; — change to each of the valid types

=== Get User DDL with related grants ===
set long 5000000
set pages 0
set lines 2000
set feedb off
set verif off
col deedeeyell for a1000 word_wrap

exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'SQLTERMINATOR', true );

exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );

select dbms_metadata.get_ddl('USER', username) deedeeyell
from dba_users
where 1=1
and username = '&&username'
union all
select dbms_metadata.get_granted_ddl('ROLE_GRANT', username)
from dba_users
where 1=1
and username = '&username'
union all
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', username)
from dba_users
where 1=1
and username = '&username'
union all
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', username)
from dba_users
where 1=1
and username = '&username'

=== Get View DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_view.sql
select DBMS_METADATA.GET_DDL ('VIEW', '&&view_name', '&&schema')||chr(10)||'/' eskewell from dual;
spool off
===Get Trigger DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_trigger.sql
select dbms_metadata.get_ddl('TRIGGER', '&trigger_name','&schema') ddl
from dual
spool off

===Extract DDL for a table without its integrity contraints===
If you are having trouble recreating table data because of integrity contraints, trying importing the data first, then the constraints:
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS', FALSE);
then extract the ddl using one of the methods above. 
Finally, extract the constraint ddl and run it separately:
dbms_metadata.get_ddl('REF_CONSTRAINT','&&contraint_name');

===Generate DDL and store it in a table===
from: [http://www.myoracleguide.com/s/gen_schema.htm] 
create table ddl_scripts(
object_name varchar2(50),
object_type varchar2(30),
text varchar2(4000));

-- Format the DDL text using trigger

create or replace trigger ddl_scripts_format_trg before insert on ddl_scripts
for each row
declare
n1 number;
n2 number;
BEGIN
n1 := instr(:new.text, '"."',1,1);
n2 := instr(:new.text, '"', 1,1);
if n1<50 then
:new.text := replace(substr(:new.text,1,n2-1)||substr(:new.text,n1+3), '"', null);
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
end if;
END;
/

---- Run the following PL/SQL code to insert DDL scripts into the above table
---- Comment the object types that are not required
---- Additional filter can be added for the cursor queries

declare
a1 varchar2(32767);
str varchar2(32767);
n1 number;
cur_user varchar2(30);
begin
select '"'||upper(username)||'"."' into cur_user from user_users;
for c1 in(select a.table_name from user_tables a where a.table_name
not in(select object_name from user_recyclebin) order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TABLE', c1.table_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TABLE', a1);
for c2 in(select index_name from user_indexes where table_name=c1.table_name and index_type in('NORMAL', 'BITMAP') order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('INDEX', c2.index_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'INDEX', a1);
END LOOP;
END LOOP;

-- Trigger scripts
for c1 in(select table_name, trigger_name from user_triggers where trigger_name
not in(select object_name from user_recyclebin) order by 1,2) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TRIGGER', c1.trigger_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TRIGGER', a1);
END LOOP;

-- Views
for c1 IN(select view_name from user_views order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('VIEW', c1.view_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.view_name, 'VIEW', a1);
END LOOP;

-- Sequence Scripts
for c1 IN(select sequence_name from user_sequences order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SEQUENCE', c1.sequence_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.sequence_name, 'SEQUENCE', a1);
END LOOP;

-- Directoryies
for c1 in(select directory_name from all_directories order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('DIRECTORY', c1.directory_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.directory_name, 'DIRECTORY', a1);
END LOOP;

-- Materialized Views
for c1 in(select mview_name from user_mviews order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW', c1.mview_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.mview_name, 'MATERIALIZED VIEW', a1);
END LOOP;

-- Materialized View Logs
for c1 in(select log_table from user_mview_logs order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG', c1.log_table), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.log_table, 'MATERIALIZED_VIEW_LOG', a1);
END LOOP;

-- Synonyms
for c1 in(select synonym_name from user_synonyms order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SYNONYM', c1.synonym_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.synonym_name, 'SYNONYM', a1);
END LOOP;

-- Types
for c1 in(select type_name from user_types order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TYPE', c1.type_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.type_name, 'TYPE', a1);
END LOOP;
END;
/

-- Query the table ddl_scripts
SQL> set pagesize 0
SQL> set linesize 32767
SQL> set trimspool ON
SQL spool c:\temp\ddl.txt
SQL> select text from ddl_scripts order by
case when object_type in('TABLE', 'INDEX', 'TRIGGER') then 0 else 1 end,
object_name, decode(object_type, 'TABLE',1,'TRIGGER',3,'INDEX',2);

SQL> spool off

All possible extractable keywords can be found here:[http://psoug.org/reference/dbms_metadata.html]

(Re)create user/schema using DataPump

2011-12-20T14:53:17Z

10.250.159.106:

If the user does not yet exist on the destination database, just import it using the procedure outlined [[DataPump|here]].

If however, the user(schema) already exists, it will have to be dropped and re-created before the data can be imported. 
So before dropping the schema, run [[Extract ddl with "dbms metadata.get ddl":Get User DDL with related grants|this script]] to generate the correct DDL beforehand!
and the grants are different on the destination database than they were on the source database, they should be retained. This can be accomplished by excluding grants when importing.

drop user <schema name> cascade;

The schema should ideally be checked beforehand that it does not own objects like 'type's that may exist elsewhere...

Import the schema:
impdp <usr>/<pwd> parfile=schema.par
where schema.par would look like this:
schemas=<schema name>
exclude=grants
Finally, recompile all invalid objects:
exec utl_recomp.recomp_serial();
or
exec utl_recomp.recomp_parallel(4);
or
@utlrp.sql
or
@utlprp.sql(4)

(Re)create user/schema using DataPump

2011-12-20T14:43:03Z

10.250.159.106:

(Re)create user/schema using DataPump

2011-12-20T14:37:49Z

10.250.159.106:

Extract ddl with "dbms metadata.get ddl"

2011-12-14T15:26:54Z

10.250.159.106: /* Get User DDL with related grants */

===Different ways of extracting ddl===
set pagesize 0
set linesize 30000
set long 500000
set longchunksize 500000
set trimspool on
set feed off
spool deedeeyell.sql
select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;'
from dba_objects where owner = UPPER('&&schema')
and object_type = 'INDEX'
and ...
/
spool off

===Get the semi-colon to be appended===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, ‘SQLTERMINATOR’, TRUE );
===Make the pretty output===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );
===Don't recreate storage clause on tables/indexes===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'STORAGE', false );
===Return DDL as VARCHAR2 instead of CLOB===
*Use get_ddl_text insead of get_ddl
=== Get lots of DDL at once===
select ‘select dbms_metadata.get_ddl(”’|| object_type || ”’,
”’||object_name||”’,”&&schema”) FROM dual;’
from dba_objects where owner = UPPER(‘&&schema’)
where 1=1
and object_type = ‘INDEX’

select ‘select dbms_metadata.get_ddl(”’ || type || ”’,
”’ || name || ”’, ”’ || UPPER(‘&&schema’) || ”’) FROM dual;’
from dba_object_size
where 1=1
and owner = UPPER(‘&&schema’)
and type = ‘TABLE’; — change to each of the valid types

===Get User DDL with related grants===
set long 5000000
set pages 0
set lines 2000
set feedb off
set verif off
col deedeeyell for a1000 word_wrap

exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'SQLTERMINATOR', true );

exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );

select dbms_metadata.get_ddl('USER', username) deedeeyell
from dba_users
where 1=1
and username = '&&username'
union all
select dbms_metadata.get_granted_ddl('ROLE_GRANT', username)
from dba_users
where 1=1
and username = '&username'
union all
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', username)
from dba_users
where 1=1
and username = '&username'
union all
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', username)
from dba_users
where 1=1
and username = '&username'

=== Get View DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_view.sql
select DBMS_METADATA.GET_DDL ('VIEW', '&&view_name', '&&schema')||chr(10)||'/' eskewell from dual;
spool off
===Get Trigger DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_trigger.sql
select dbms_metadata.get_ddl('TRIGGER', '&trigger_name','&schema') ddl
from dual
spool off

===Extract DDL for a table without its integrity contraints===
If you are having trouble recreating table data because of integrity contraints, trying importing the data first, then the constraints:
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS', FALSE);
then extract the ddl using one of the methods above. 
Finally, extract the constraint ddl and run it separately:
dbms_metadata.get_ddl('REF_CONSTRAINT','&&contraint_name');

===Generate DDL and store it in a table===
from: [http://www.myoracleguide.com/s/gen_schema.htm] 
create table ddl_scripts(
object_name varchar2(50),
object_type varchar2(30),
text varchar2(4000));

-- Format the DDL text using trigger

create or replace trigger ddl_scripts_format_trg before insert on ddl_scripts
for each row
declare
n1 number;
n2 number;
BEGIN
n1 := instr(:new.text, '"."',1,1);
n2 := instr(:new.text, '"', 1,1);
if n1<50 then
:new.text := replace(substr(:new.text,1,n2-1)||substr(:new.text,n1+3), '"', null);
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
end if;
END;
/

---- Run the following PL/SQL code to insert DDL scripts into the above table
---- Comment the object types that are not required
---- Additional filter can be added for the cursor queries

declare
a1 varchar2(32767);
str varchar2(32767);
n1 number;
cur_user varchar2(30);
begin
select '"'||upper(username)||'"."' into cur_user from user_users;
for c1 in(select a.table_name from user_tables a where a.table_name
not in(select object_name from user_recyclebin) order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TABLE', c1.table_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TABLE', a1);
for c2 in(select index_name from user_indexes where table_name=c1.table_name and index_type in('NORMAL', 'BITMAP') order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('INDEX', c2.index_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'INDEX', a1);
END LOOP;
END LOOP;

-- Trigger scripts
for c1 in(select table_name, trigger_name from user_triggers where trigger_name
not in(select object_name from user_recyclebin) order by 1,2) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TRIGGER', c1.trigger_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TRIGGER', a1);
END LOOP;

-- Views
for c1 IN(select view_name from user_views order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('VIEW', c1.view_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.view_name, 'VIEW', a1);
END LOOP;

-- Sequence Scripts
for c1 IN(select sequence_name from user_sequences order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SEQUENCE', c1.sequence_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.sequence_name, 'SEQUENCE', a1);
END LOOP;

-- Directoryies
for c1 in(select directory_name from all_directories order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('DIRECTORY', c1.directory_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.directory_name, 'DIRECTORY', a1);
END LOOP;

-- Materialized Views
for c1 in(select mview_name from user_mviews order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW', c1.mview_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.mview_name, 'MATERIALIZED VIEW', a1);
END LOOP;

-- Materialized View Logs
for c1 in(select log_table from user_mview_logs order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG', c1.log_table), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.log_table, 'MATERIALIZED_VIEW_LOG', a1);
END LOOP;

-- Synonyms
for c1 in(select synonym_name from user_synonyms order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SYNONYM', c1.synonym_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.synonym_name, 'SYNONYM', a1);
END LOOP;

-- Types
for c1 in(select type_name from user_types order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TYPE', c1.type_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.type_name, 'TYPE', a1);
END LOOP;
END;
/

-- Query the table ddl_scripts
SQL> set pagesize 0
SQL> set linesize 32767
SQL> set trimspool ON
SQL spool c:\temp\ddl.txt
SQL> select text from ddl_scripts order by
case when object_type in('TABLE', 'INDEX', 'TRIGGER') then 0 else 1 end,
object_name, decode(object_type, 'TABLE',1,'TRIGGER',3,'INDEX',2);

SQL> spool off

All possible extractable keywords can be found here:[http://psoug.org/reference/dbms_metadata.html]

Extract ddl with "dbms metadata.get ddl"

2011-12-14T15:26:38Z

10.250.159.106: /* Get User DDL with related grants */

===Different ways of extracting ddl===
set pagesize 0
set linesize 30000
set long 500000
set longchunksize 500000
set trimspool on
set feed off
spool deedeeyell.sql
select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;'
from dba_objects where owner = UPPER('&&schema')
and object_type = 'INDEX'
and ...
/
spool off

===Get the semi-colon to be appended===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, ‘SQLTERMINATOR’, TRUE );
===Make the pretty output===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );
===Don't recreate storage clause on tables/indexes===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'STORAGE', false );
===Return DDL as VARCHAR2 instead of CLOB===
*Use get_ddl_text insead of get_ddl
=== Get lots of DDL at once===
select ‘select dbms_metadata.get_ddl(”’|| object_type || ”’,
”’||object_name||”’,”&&schema”) FROM dual;’
from dba_objects where owner = UPPER(‘&&schema’)
where 1=1
and object_type = ‘INDEX’

select ‘select dbms_metadata.get_ddl(”’ || type || ”’,
”’ || name || ”’, ”’ || UPPER(‘&&schema’) || ”’) FROM dual;’
from dba_object_size
where 1=1
and owner = UPPER(‘&&schema’)
and type = ‘TABLE’; — change to each of the valid types

===Get User DDL with related grants===
set long 5000000
set pages 0
set lines 2000
set feedb off
set verif off
col deedeeyell for a1000 word_wrap

exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'SQLTERMINATOR', true );

exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );

select dbms_metadata.get_ddl('USER', username) deedeeyell
from dba_users
where 1=1
and username = '&&username'
union all
select dbms_metadata.get_granted_ddl('ROLE_GRANT', username)
from dba_users
where 1=1
and username = '&username'
union all
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', username)
from dba_users
where 1=1
and username = '&username'
union all
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', username)
from dba_users
where 1=1
and username = '&username'

=== Get View DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_view.sql
select DBMS_METADATA.GET_DDL ('VIEW', '&&view_name', '&&schema')||chr(10)||'/' eskewell from dual;
spool off
===Get Trigger DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_trigger.sql
select dbms_metadata.get_ddl('TRIGGER', '&trigger_name','&schema') ddl
from dual
spool off

===Extract DDL for a table without its integrity contraints===
If you are having trouble recreating table data because of integrity contraints, trying importing the data first, then the constraints:
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS', FALSE);
then extract the ddl using one of the methods above. 
Finally, extract the constraint ddl and run it separately:
dbms_metadata.get_ddl('REF_CONSTRAINT','&&contraint_name');

===Generate DDL and store it in a table===
from: [http://www.myoracleguide.com/s/gen_schema.htm] 
create table ddl_scripts(
object_name varchar2(50),
object_type varchar2(30),
text varchar2(4000));

-- Format the DDL text using trigger

create or replace trigger ddl_scripts_format_trg before insert on ddl_scripts
for each row
declare
n1 number;
n2 number;
BEGIN
n1 := instr(:new.text, '"."',1,1);
n2 := instr(:new.text, '"', 1,1);
if n1<50 then
:new.text := replace(substr(:new.text,1,n2-1)||substr(:new.text,n1+3), '"', null);
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
end if;
END;
/

---- Run the following PL/SQL code to insert DDL scripts into the above table
---- Comment the object types that are not required
---- Additional filter can be added for the cursor queries

declare
a1 varchar2(32767);
str varchar2(32767);
n1 number;
cur_user varchar2(30);
begin
select '"'||upper(username)||'"."' into cur_user from user_users;
for c1 in(select a.table_name from user_tables a where a.table_name
not in(select object_name from user_recyclebin) order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TABLE', c1.table_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TABLE', a1);
for c2 in(select index_name from user_indexes where table_name=c1.table_name and index_type in('NORMAL', 'BITMAP') order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('INDEX', c2.index_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'INDEX', a1);
END LOOP;
END LOOP;

-- Trigger scripts
for c1 in(select table_name, trigger_name from user_triggers where trigger_name
not in(select object_name from user_recyclebin) order by 1,2) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TRIGGER', c1.trigger_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TRIGGER', a1);
END LOOP;

-- Views
for c1 IN(select view_name from user_views order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('VIEW', c1.view_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.view_name, 'VIEW', a1);
END LOOP;

-- Sequence Scripts
for c1 IN(select sequence_name from user_sequences order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SEQUENCE', c1.sequence_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.sequence_name, 'SEQUENCE', a1);
END LOOP;

-- Directoryies
for c1 in(select directory_name from all_directories order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('DIRECTORY', c1.directory_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.directory_name, 'DIRECTORY', a1);
END LOOP;

-- Materialized Views
for c1 in(select mview_name from user_mviews order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW', c1.mview_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.mview_name, 'MATERIALIZED VIEW', a1);
END LOOP;

-- Materialized View Logs
for c1 in(select log_table from user_mview_logs order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG', c1.log_table), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.log_table, 'MATERIALIZED_VIEW_LOG', a1);
END LOOP;

-- Synonyms
for c1 in(select synonym_name from user_synonyms order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SYNONYM', c1.synonym_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.synonym_name, 'SYNONYM', a1);
END LOOP;

-- Types
for c1 in(select type_name from user_types order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TYPE', c1.type_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.type_name, 'TYPE', a1);
END LOOP;
END;
/

-- Query the table ddl_scripts
SQL> set pagesize 0
SQL> set linesize 32767
SQL> set trimspool ON
SQL spool c:\temp\ddl.txt
SQL> select text from ddl_scripts order by
case when object_type in('TABLE', 'INDEX', 'TRIGGER') then 0 else 1 end,
object_name, decode(object_type, 'TABLE',1,'TRIGGER',3,'INDEX',2);

SQL> spool off

All possible extractable keywords can be found here:[http://psoug.org/reference/dbms_metadata.html]

Extract ddl with "dbms metadata.get ddl"

2011-12-14T15:25:49Z

10.250.159.106: /* Get User DDL with related grants */

===Different ways of extracting ddl===
set pagesize 0
set linesize 30000
set long 500000
set longchunksize 500000
set trimspool on
set feed off
spool deedeeyell.sql
select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;'
from dba_objects where owner = UPPER('&&schema')
and object_type = 'INDEX'
and ...
/
spool off

===Get the semi-colon to be appended===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, ‘SQLTERMINATOR’, TRUE );
===Make the pretty output===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );
===Don't recreate storage clause on tables/indexes===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'STORAGE', false );
===Return DDL as VARCHAR2 instead of CLOB===
*Use get_ddl_text insead of get_ddl
=== Get lots of DDL at once===
select ‘select dbms_metadata.get_ddl(”’|| object_type || ”’,
”’||object_name||”’,”&&schema”) FROM dual;’
from dba_objects where owner = UPPER(‘&&schema’)
where 1=1
and object_type = ‘INDEX’

select ‘select dbms_metadata.get_ddl(”’ || type || ”’,
”’ || name || ”’, ”’ || UPPER(‘&&schema’) || ”’) FROM dual;’
from dba_object_size
where 1=1
and owner = UPPER(‘&&schema’)
and type = ‘TABLE’; — change to each of the valid types

===Get User DDL with related grants===
set long 5000000
set pages 0
set lines 2000
set feedb off
set verif off

exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'SQLTERMINATOR', true );

exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );

select dbms_metadata.get_ddl('USER', username) deedeeyell
from dba_users
where 1=1
and username = '&&username'
union all
select dbms_metadata.get_granted_ddl('ROLE_GRANT', username)
from dba_users
where 1=1
and username = '&username'
union all
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', username)
from dba_users
where 1=1
and username = '&username'
union all
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', username)
from dba_users
where 1=1
and username = '&username'

=== Get View DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_view.sql
select DBMS_METADATA.GET_DDL ('VIEW', '&&view_name', '&&schema')||chr(10)||'/' eskewell from dual;
spool off
===Get Trigger DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_trigger.sql
select dbms_metadata.get_ddl('TRIGGER', '&trigger_name','&schema') ddl
from dual
spool off

===Extract DDL for a table without its integrity contraints===
If you are having trouble recreating table data because of integrity contraints, trying importing the data first, then the constraints:
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS', FALSE);
then extract the ddl using one of the methods above. 
Finally, extract the constraint ddl and run it separately:
dbms_metadata.get_ddl('REF_CONSTRAINT','&&contraint_name');

===Generate DDL and store it in a table===
from: [http://www.myoracleguide.com/s/gen_schema.htm] 
create table ddl_scripts(
object_name varchar2(50),
object_type varchar2(30),
text varchar2(4000));

-- Format the DDL text using trigger

create or replace trigger ddl_scripts_format_trg before insert on ddl_scripts
for each row
declare
n1 number;
n2 number;
BEGIN
n1 := instr(:new.text, '"."',1,1);
n2 := instr(:new.text, '"', 1,1);
if n1<50 then
:new.text := replace(substr(:new.text,1,n2-1)||substr(:new.text,n1+3), '"', null);
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
end if;
END;
/

---- Run the following PL/SQL code to insert DDL scripts into the above table
---- Comment the object types that are not required
---- Additional filter can be added for the cursor queries

declare
a1 varchar2(32767);
str varchar2(32767);
n1 number;
cur_user varchar2(30);
begin
select '"'||upper(username)||'"."' into cur_user from user_users;
for c1 in(select a.table_name from user_tables a where a.table_name
not in(select object_name from user_recyclebin) order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TABLE', c1.table_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TABLE', a1);
for c2 in(select index_name from user_indexes where table_name=c1.table_name and index_type in('NORMAL', 'BITMAP') order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('INDEX', c2.index_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'INDEX', a1);
END LOOP;
END LOOP;

-- Trigger scripts
for c1 in(select table_name, trigger_name from user_triggers where trigger_name
not in(select object_name from user_recyclebin) order by 1,2) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TRIGGER', c1.trigger_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TRIGGER', a1);
END LOOP;

-- Views
for c1 IN(select view_name from user_views order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('VIEW', c1.view_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.view_name, 'VIEW', a1);
END LOOP;

-- Sequence Scripts
for c1 IN(select sequence_name from user_sequences order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SEQUENCE', c1.sequence_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.sequence_name, 'SEQUENCE', a1);
END LOOP;

-- Directoryies
for c1 in(select directory_name from all_directories order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('DIRECTORY', c1.directory_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.directory_name, 'DIRECTORY', a1);
END LOOP;

-- Materialized Views
for c1 in(select mview_name from user_mviews order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW', c1.mview_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.mview_name, 'MATERIALIZED VIEW', a1);
END LOOP;

-- Materialized View Logs
for c1 in(select log_table from user_mview_logs order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG', c1.log_table), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.log_table, 'MATERIALIZED_VIEW_LOG', a1);
END LOOP;

-- Synonyms
for c1 in(select synonym_name from user_synonyms order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SYNONYM', c1.synonym_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.synonym_name, 'SYNONYM', a1);
END LOOP;

-- Types
for c1 in(select type_name from user_types order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TYPE', c1.type_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.type_name, 'TYPE', a1);
END LOOP;
END;
/

-- Query the table ddl_scripts
SQL> set pagesize 0
SQL> set linesize 32767
SQL> set trimspool ON
SQL spool c:\temp\ddl.txt
SQL> select text from ddl_scripts order by
case when object_type in('TABLE', 'INDEX', 'TRIGGER') then 0 else 1 end,
object_name, decode(object_type, 'TABLE',1,'TRIGGER',3,'INDEX',2);

SQL> spool off

All possible extractable keywords can be found here:[http://psoug.org/reference/dbms_metadata.html]

Using dbms xmlgen as a means of dynamic SQL

2011-12-13T08:49:40Z

10.250.159.106: Created page with " select table_name , to_number( extractvalue( xmltype( dbms_xmlgen.getxml( 'select count(*) c from '||table_name) ),'/ROWSET/ROW/C') ) count from user_tables; TABLE_NA..."

select table_name
, to_number( extractvalue( xmltype( dbms_xmlgen.getxml( 'select count(*) c from '||table_name) ),'/ROWSET/ROW/C') ) count
from user_tables;

TABLE_NAME COUNT
------------------------------ ------
DEPT 4
EMP 14
BONUS 0
SALGRADE 5

===A more complex example===
SQL> create table mpi_memgc(x number, y varchar2(10), z varchar2(10))
Table created.
SQL> insert into mpi_memgc values (1,'bla','bli ')
1 row created.
SQL> commit
Commit complete.

SQL> select
'select count(*) c from "'||table_name||'" where "'||column_name||
'" like ''% '' or "'||column_name||
'" like '' %''' query,
table_name,column_name,
to_number(extractvalue(xmltype(dbms_xmlgen.getxml(
'select count(*) c from "'||table_name||'" where "'||column_name||
'" like ''% '' or "'||column_name||
'" like '' %''')),'/ROWSET/ROW/C')) count
from user_tab_columns
where table_name like 'MPI_MEMGC%'
and table_name not like '%_H'
and data_type = 'VARCHAR2'
order by 1;

QUERY
--------------------------------------------------------------------------------
TABLE_NAME COLUMN_NAME COUNT
------------------------------ ------------------------------ ----------
select count(*) c from "MPI_MEMGC" where "Y" like '% ' or "Y" like ' %'
MPI_MEMGC Y 0

select count(*) c from "MPI_MEMGC" where "Z" like '% ' or "Z" like ' %'
MPI_MEMGC Z 1

XML

2011-12-13T08:33:29Z

10.250.159.106: Created page with "*Using dbms_xmlgen as a means of dynamic SQL"

*[[Using dbms_xmlgen as a means of dynamic SQL]]

Extract ddl with "dbms metadata.get ddl"

2011-12-12T15:27:57Z

10.250.159.106:

===Different ways of extracting ddl===
set pagesize 0
set linesize 30000
set long 500000
set longchunksize 500000
set trimspool on
set feed off
spool deedeeyell.sql
select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;'
from dba_objects where owner = UPPER('&&schema')
and object_type = 'INDEX'
and ...
/
spool off

===Get the semi-colon to be appended===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, ‘SQLTERMINATOR’, TRUE );
===Make the pretty output===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );
===Don't recreate storage clause on tables/indexes===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'STORAGE', false );
===Return DDL as VARCHAR2 instead of CLOB===
*Use get_ddl_text insead of get_ddl
=== Get lots of DDL at once===
select ‘select dbms_metadata.get_ddl(”’|| object_type || ”’,
”’||object_name||”’,”&&schema”) FROM dual;’
from dba_objects where owner = UPPER(‘&&schema’)
where 1=1
and object_type = ‘INDEX’

select ‘select dbms_metadata.get_ddl(”’ || type || ”’,
”’ || name || ”’, ”’ || UPPER(‘&&schema’) || ”’) FROM dual;’
from dba_object_size
where 1=1
and owner = UPPER(‘&&schema’)
and type = ‘TABLE’; — change to each of the valid types

===Get User DDL with related grants===
select dbms_metadata.get_ddl('USER', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('ROLE_GRANT', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', username) || '/' ddl
from dba_users;
=== Get View DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_view.sql
select DBMS_METADATA.GET_DDL ('VIEW', '&&view_name', '&&schema')||chr(10)||'/' eskewell from dual;
spool off
===Get Trigger DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_trigger.sql
select dbms_metadata.get_ddl('TRIGGER', '&trigger_name','&schema') ddl
from dual
spool off

===Extract DDL for a table without its integrity contraints===
If you are having trouble recreating table data because of integrity contraints, trying importing the data first, then the constraints:
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS', FALSE);
then extract the ddl using one of the methods above. 
Finally, extract the constraint ddl and run it separately:
dbms_metadata.get_ddl('REF_CONSTRAINT','&&contraint_name');

===Generate DDL and store it in a table===
from: [http://www.myoracleguide.com/s/gen_schema.htm] 
create table ddl_scripts(
object_name varchar2(50),
object_type varchar2(30),
text varchar2(4000));

-- Format the DDL text using trigger

create or replace trigger ddl_scripts_format_trg before insert on ddl_scripts
for each row
declare
n1 number;
n2 number;
BEGIN
n1 := instr(:new.text, '"."',1,1);
n2 := instr(:new.text, '"', 1,1);
if n1<50 then
:new.text := replace(substr(:new.text,1,n2-1)||substr(:new.text,n1+3), '"', null);
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
end if;
END;
/

---- Run the following PL/SQL code to insert DDL scripts into the above table
---- Comment the object types that are not required
---- Additional filter can be added for the cursor queries

declare
a1 varchar2(32767);
str varchar2(32767);
n1 number;
cur_user varchar2(30);
begin
select '"'||upper(username)||'"."' into cur_user from user_users;
for c1 in(select a.table_name from user_tables a where a.table_name
not in(select object_name from user_recyclebin) order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TABLE', c1.table_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TABLE', a1);
for c2 in(select index_name from user_indexes where table_name=c1.table_name and index_type in('NORMAL', 'BITMAP') order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('INDEX', c2.index_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'INDEX', a1);
END LOOP;
END LOOP;

-- Trigger scripts
for c1 in(select table_name, trigger_name from user_triggers where trigger_name
not in(select object_name from user_recyclebin) order by 1,2) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TRIGGER', c1.trigger_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TRIGGER', a1);
END LOOP;

-- Views
for c1 IN(select view_name from user_views order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('VIEW', c1.view_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.view_name, 'VIEW', a1);
END LOOP;

-- Sequence Scripts
for c1 IN(select sequence_name from user_sequences order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SEQUENCE', c1.sequence_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.sequence_name, 'SEQUENCE', a1);
END LOOP;

-- Directoryies
for c1 in(select directory_name from all_directories order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('DIRECTORY', c1.directory_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.directory_name, 'DIRECTORY', a1);
END LOOP;

-- Materialized Views
for c1 in(select mview_name from user_mviews order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW', c1.mview_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.mview_name, 'MATERIALIZED VIEW', a1);
END LOOP;

-- Materialized View Logs
for c1 in(select log_table from user_mview_logs order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG', c1.log_table), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.log_table, 'MATERIALIZED_VIEW_LOG', a1);
END LOOP;

-- Synonyms
for c1 in(select synonym_name from user_synonyms order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SYNONYM', c1.synonym_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.synonym_name, 'SYNONYM', a1);
END LOOP;

-- Types
for c1 in(select type_name from user_types order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TYPE', c1.type_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.type_name, 'TYPE', a1);
END LOOP;
END;
/

-- Query the table ddl_scripts
SQL> set pagesize 0
SQL> set linesize 32767
SQL> set trimspool ON
SQL spool c:\temp\ddl.txt
SQL> select text from ddl_scripts order by
case when object_type in('TABLE', 'INDEX', 'TRIGGER') then 0 else 1 end,
object_name, decode(object_type, 'TABLE',1,'TRIGGER',3,'INDEX',2);

SQL> spool off

All possible extractable keywords can be found here:[http://psoug.org/reference/dbms_metadata.html]

Extract ddl with "dbms metadata.get ddl"

2011-12-12T15:27:19Z

10.250.159.106:

===Different ways of extracting ddl===
set pagesize 0
set linesize 30000
set long 500000
set longchunksize 500000
set trimspool on
set feed off
spool deedeeyell.sql
select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;'
from dba_objects where owner = UPPER('&&schema')
and object_type = 'INDEX'
and ...
/
spool off

===Get the semi-colon to be appended===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, ‘SQLTERMINATOR’, TRUE );
===Make the pretty output===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );
===Don't recreate storage clause on tables/indexes===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'STORAGE', false );
===Return DDL as VARCHAR2 instead of CLOB===
*Use get_ddl_text insead of get_ddl
=== Get lots of DDL at once===
select ‘select dbms_metadata.get_ddl(”’|| object_type || ”’,
”’||object_name||”’,”&&schema”) FROM dual;’
from dba_objects where owner = UPPER(‘&&schema’)
where 1=1
and object_type = ‘INDEX’

select ‘select dbms_metadata.get_ddl(”’ || type || ”’,
”’ || name || ”’, ”’ || UPPER(‘&&schema’) || ”’) FROM dual;’
from dba_object_size
where 1=1
and owner = UPPER(‘&&schema’)
and type = ‘TABLE’; — change to each of the valid types

===Get User DDL with related grants===
select dbms_metadata.get_ddl('USER', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('ROLE_GRANT', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', username) || '/' ddl
from dba_users;
=== Get View DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_view.sql
select DBMS_METADATA.GET_DDL ('VIEW', '&&view_name', '&&schema')||chr(10)||'/' eskewell from dual;
spool off
===Get Trigger DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_trigger.sql
select dbms_metadata.get_ddl('TRIGGER', '&trigger_name','&schema') ddl
from dual
spool off

===Extract DDL for a table without its integrity contraints===
If you are having trouble recreating table data because of integrity contraints, trying importing the data first, then the constraints:
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS', FALSE);
then extract the ddl using one of the methods above. 
Finally, extract the constraint ddl and run it separately:
dbms_metadata.get_ddl('REF_CONSTRAINT','&&contraint_name');

===Generate DDL and store it in a table===
from: [http://www.myoracleguide.com/s/gen_schema.htm] 
create table ddl_scripts(
object_name varchar2(50),
object_type varchar2(30),
text varchar2(4000));

-- Format the DDL text using trigger

create or replace trigger ddl_scripts_format_trg before insert on ddl_scripts
for each row
declare
n1 number;
n2 number;
BEGIN
n1 := instr(:new.text, '"."',1,1);
n2 := instr(:new.text, '"', 1,1);
if n1<50 then
:new.text := replace(substr(:new.text,1,n2-1)||substr(:new.text,n1+3), '"', null);
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
end if;
END;
/

---- Run the following PL/SQL code to insert DDL scripts into the above table
---- Comment the object types that are not required
---- Additional filter can be added for the cursor queries

declare
a1 varchar2(32767);
str varchar2(32767);
n1 number;
cur_user varchar2(30);
begin
select '"'||upper(username)||'"."' into cur_user from user_users;
for c1 in(select a.table_name from user_tables a where a.table_name
not in(select object_name from user_recyclebin) order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TABLE', c1.table_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TABLE', a1);
for c2 in(select index_name from user_indexes where table_name=c1.table_name and index_type in('NORMAL', 'BITMAP') order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('INDEX', c2.index_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'INDEX', a1);
END LOOP;
END LOOP;

-- Trigger scripts
for c1 in(select table_name, trigger_name from user_triggers where trigger_name
not in(select object_name from user_recyclebin) order by 1,2) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TRIGGER', c1.trigger_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TRIGGER', a1);
END LOOP;

-- Views
for c1 IN(select view_name from user_views order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('VIEW', c1.view_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.view_name, 'VIEW', a1);
END LOOP;

-- Sequence Scripts
for c1 IN(select sequence_name from user_sequences order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SEQUENCE', c1.sequence_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.sequence_name, 'SEQUENCE', a1);
END LOOP;

-- Directoryies
for c1 in(select directory_name from all_directories order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('DIRECTORY', c1.directory_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.directory_name, 'DIRECTORY', a1);
END LOOP;

-- Materialized Views
for c1 in(select mview_name from user_mviews order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW', c1.mview_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.mview_name, 'MATERIALIZED VIEW', a1);
END LOOP;

-- Materialized View Logs
for c1 in(select log_table from user_mview_logs order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG', c1.log_table), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.log_table, 'MATERIALIZED_VIEW_LOG', a1);
END LOOP;

-- Synonyms
for c1 in(select synonym_name from user_synonyms order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SYNONYM', c1.synonym_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.synonym_name, 'SYNONYM', a1);
END LOOP;

-- Types
for c1 in(select type_name from user_types order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TYPE', c1.type_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.type_name, 'TYPE', a1);
END LOOP;
END;
/

-- Query the table ddl_scripts
SQL> set pagesize 0
SQL> set linesize 32767
SQL> set trimspool ON
SQL spool c:\temp\ddl.txt
SQL> select text from ddl_scripts order by
case when object_type in('TABLE', 'INDEX', 'TRIGGER') then 0 else 1 end,
object_name, decode(object_type, 'TABLE',1,'TRIGGER',3,'INDEX',2);

SQL> spool off

All possible extractable keywords can be found [http://psoug.org/reference/dbms_metadata.html|here]

Extract ddl with "dbms metadata.get ddl"

2011-12-12T15:17:24Z

10.250.159.106:

===Different ways of extracting ddl===
set pagesize 0
set linesize 30000
set long 500000
set longchunksize 500000
set trimspool on
set feed off
spool deedeeyell.sql
select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;'
from dba_objects where owner = UPPER('&&schema')
and object_type = 'INDEX'
and ...
/
spool off

===Get the semi-colon to be appended===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, ‘SQLTERMINATOR’, TRUE );
===Make the pretty output===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );
===Don't recreate storage clause on tables/indexes===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'STORAGE', false );

=== Get lots of DDL at once===
select ‘select dbms_metadata.get_ddl(”’|| object_type || ”’,
”’||object_name||”’,”&&schema”) FROM dual;’
from dba_objects where owner = UPPER(‘&&schema’)
where 1=1
and object_type = ‘INDEX’

select ‘select dbms_metadata.get_ddl(”’ || type || ”’,
”’ || name || ”’, ”’ || UPPER(‘&&schema’) || ”’) FROM dual;’
from dba_object_size
where 1=1
and owner = UPPER(‘&&schema’)
and type = ‘TABLE’; — change to each of the valid types

===Get User DDL with related grants===
select dbms_metadata.get_ddl('USER', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('ROLE_GRANT', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', username) || '/' ddl
from dba_users;
=== Get View DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_view.sql
select DBMS_METADATA.GET_DDL ('VIEW', '&&view_name', '&&schema')||chr(10)||'/' eskewell from dual;
spool off
===Get Trigger DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_trigger.sql
select dbms_metadata.get_ddl('TRIGGER', '&trigger_name','&schema') ddl
from dual
spool off

===Extract DDL for a table without its integrity contraints===
If you are having trouble recreating table data because of integrity contraints, trying importing the data first, then the constraints:
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS', FALSE);
then extract the ddl using one of the methods above. 
Finally, extract the constraint ddl and run it separately:
dbms_metadata.get_ddl('REF_CONSTRAINT','&&contraint_name');

===Generate DDL and store it in a table===
from: [http://www.myoracleguide.com/s/gen_schema.htm] 
create table ddl_scripts(
object_name varchar2(50),
object_type varchar2(30),
text varchar2(4000));

-- Format the DDL text using trigger

create or replace trigger ddl_scripts_format_trg before insert on ddl_scripts
for each row
declare
n1 number;
n2 number;
BEGIN
n1 := instr(:new.text, '"."',1,1);
n2 := instr(:new.text, '"', 1,1);
if n1<50 then
:new.text := replace(substr(:new.text,1,n2-1)||substr(:new.text,n1+3), '"', null);
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
end if;
END;
/

---- Run the following PL/SQL code to insert DDL scripts into the above table
---- Comment the object types that are not required
---- Additional filter can be added for the cursor queries

declare
a1 varchar2(32767);
str varchar2(32767);
n1 number;
cur_user varchar2(30);
begin
select '"'||upper(username)||'"."' into cur_user from user_users;
for c1 in(select a.table_name from user_tables a where a.table_name
not in(select object_name from user_recyclebin) order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TABLE', c1.table_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TABLE', a1);
for c2 in(select index_name from user_indexes where table_name=c1.table_name and index_type in('NORMAL', 'BITMAP') order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('INDEX', c2.index_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'INDEX', a1);
END LOOP;
END LOOP;

-- Trigger scripts
for c1 in(select table_name, trigger_name from user_triggers where trigger_name
not in(select object_name from user_recyclebin) order by 1,2) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TRIGGER', c1.trigger_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TRIGGER', a1);
END LOOP;

-- Views
for c1 IN(select view_name from user_views order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('VIEW', c1.view_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.view_name, 'VIEW', a1);
END LOOP;

-- Sequence Scripts
for c1 IN(select sequence_name from user_sequences order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SEQUENCE', c1.sequence_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.sequence_name, 'SEQUENCE', a1);
END LOOP;

-- Directoryies
for c1 in(select directory_name from all_directories order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('DIRECTORY', c1.directory_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.directory_name, 'DIRECTORY', a1);
END LOOP;

-- Materialized Views
for c1 in(select mview_name from user_mviews order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW', c1.mview_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.mview_name, 'MATERIALIZED VIEW', a1);
END LOOP;

-- Materialized View Logs
for c1 in(select log_table from user_mview_logs order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG', c1.log_table), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.log_table, 'MATERIALIZED_VIEW_LOG', a1);
END LOOP;

-- Synonyms
for c1 in(select synonym_name from user_synonyms order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SYNONYM', c1.synonym_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.synonym_name, 'SYNONYM', a1);
END LOOP;

-- Types
for c1 in(select type_name from user_types order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TYPE', c1.type_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.type_name, 'TYPE', a1);
END LOOP;
END;
/

-- Query the table ddl_scripts
SQL> set pagesize 0
SQL> set linesize 32767
SQL> set trimspool ON
SQL spool c:\temp\ddl.txt
SQL> select text from ddl_scripts order by
case when object_type in('TABLE', 'INDEX', 'TRIGGER') then 0 else 1 end,
object_name, decode(object_type, 'TABLE',1,'TRIGGER',3,'INDEX',2);

SQL> spool off

Extract ddl with "dbms metadata.get ddl"

2011-12-12T15:16:44Z

10.250.159.106:

===Different ways of extracting ddl===
set pagesize 0
set linesize 30000
set long 500000
set longchunksize 500000
set trimspool on
set feed off
spool deedeeyell.sql
select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;'
from dba_objects where owner = UPPER('&&schema')
and object_type = 'INDEX'
and ...
/
spool off

===Get the semi-colon to be appended===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, ‘SQLTERMINATOR’, TRUE );
===Make the pretty output===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );
===Don't recreate storage clause on tables/indexes===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'STORAGE', false );

=== Get lots of DDL at once===
select ‘select dbms_metadata.get_ddl(”’|| object_type || ”’,
”’||object_name||”’,”&&schema”) FROM dual;’
from dba_objects where owner = UPPER(‘&&schema’)
where 1=1
and object_type = ‘INDEX’

select ‘select dbms_metadata.get_ddl(”’ || type || ”’,
”’ || name || ”’, ”’ || UPPER(‘&&schema’) || ”’) FROM dual;’
from dba_object_size
where 1=1
and owner = UPPER(‘&&schema’)
and type = ‘TABLE’; — change to each of the valid types

===Get User DDL with related grants===
select dbms_metadata.get_ddl('USER', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('ROLE_GRANT', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', username) || '/' ddl
from dba_users;
=== Get View DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_view.sql
select DBMS_METADATA.GET_DDL ('VIEW', '&&view_name', '&&schema')||chr(10)||'/' eskewell from dual;
spool off
===Get Trigger DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_trigger.sql
select dbms_metadata.get_ddl('TRIGGER', '&trigger_name','&schema') ddl
from dual
spool off

===Extract DDL for a table without its integrity contraints===
If you are having trouble recreating table data because of integrity contraints, trying importing the data first, then the constraints:
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS', FALSE);
then extract the ddl using one of the methods above. 
Finally, extract the constraint ddl and run it separately:
dbms_metadata.get_ddl('REF_CONSTRAINT','&&contraint_name');

===Generate DDL and store it in a table===
from: [http://www.myoracleguide.com/s/gen_schema.htm|http://www.myoracleguide.com/s/gen_schema.htm] 
create table ddl_scripts(
object_name varchar2(50),
object_type varchar2(30),
text varchar2(4000));

-- Format the DDL text using trigger

create or replace trigger ddl_scripts_format_trg before insert on ddl_scripts
for each row
declare
n1 number;
n2 number;
BEGIN
n1 := instr(:new.text, '"."',1,1);
n2 := instr(:new.text, '"', 1,1);
if n1<50 then
:new.text := replace(substr(:new.text,1,n2-1)||substr(:new.text,n1+3), '"', null);
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
end if;
END;
/

---- Run the following PL/SQL code to insert DDL scripts into the above table
---- Comment the object types that are not required
---- Additional filter can be added for the cursor queries

declare
a1 varchar2(32767);
str varchar2(32767);
n1 number;
cur_user varchar2(30);
begin
select '"'||upper(username)||'"."' into cur_user from user_users;
for c1 in(select a.table_name from user_tables a where a.table_name
not in(select object_name from user_recyclebin) order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TABLE', c1.table_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TABLE', a1);
for c2 in(select index_name from user_indexes where table_name=c1.table_name and index_type in('NORMAL', 'BITMAP') order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('INDEX', c2.index_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'INDEX', a1);
END LOOP;
END LOOP;

-- Trigger scripts
for c1 in(select table_name, trigger_name from user_triggers where trigger_name
not in(select object_name from user_recyclebin) order by 1,2) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TRIGGER', c1.trigger_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TRIGGER', a1);
END LOOP;

-- Views
for c1 IN(select view_name from user_views order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('VIEW', c1.view_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.view_name, 'VIEW', a1);
END LOOP;

-- Sequence Scripts
for c1 IN(select sequence_name from user_sequences order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SEQUENCE', c1.sequence_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.sequence_name, 'SEQUENCE', a1);
END LOOP;

-- Directoryies
for c1 in(select directory_name from all_directories order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('DIRECTORY', c1.directory_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.directory_name, 'DIRECTORY', a1);
END LOOP;

-- Materialized Views
for c1 in(select mview_name from user_mviews order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW', c1.mview_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.mview_name, 'MATERIALIZED VIEW', a1);
END LOOP;

-- Materialized View Logs
for c1 in(select log_table from user_mview_logs order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG', c1.log_table), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.log_table, 'MATERIALIZED_VIEW_LOG', a1);
END LOOP;

-- Synonyms
for c1 in(select synonym_name from user_synonyms order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SYNONYM', c1.synonym_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.synonym_name, 'SYNONYM', a1);
END LOOP;

-- Types
for c1 in(select type_name from user_types order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TYPE', c1.type_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.type_name, 'TYPE', a1);
END LOOP;
END;
/

-- Query the table ddl_scripts
SQL> set pagesize 0
SQL> set linesize 32767
SQL> set trimspool ON
SQL spool c:\temp\ddl.txt
SQL> select text from ddl_scripts order by
case when object_type in('TABLE', 'INDEX', 'TRIGGER') then 0 else 1 end,
object_name, decode(object_type, 'TABLE',1,'TRIGGER',3,'INDEX',2);

SQL> spool off

Extract ddl with "dbms metadata.get ddl"

2011-12-12T15:15:45Z

10.250.159.106:

===Different ways of extracting ddl===
set pagesize 0
set linesize 30000
set long 500000
set longchunksize 500000
set trimspool on
set feed off
spool deedeeyell.sql
select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;'
from dba_objects where owner = UPPER('&&schema')
and object_type = 'INDEX'
and ...
/
spool off

===Get the semi-colon to be appended===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, ‘SQLTERMINATOR’, TRUE );
===Make the pretty output===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );
===Don't recreate storage clause on tables/indexes===
exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'STORAGE', false );

=== Get lots of DDL at once===
select ‘select dbms_metadata.get_ddl(”’|| object_type || ”’,
”’||object_name||”’,”&&schema”) FROM dual;’
from dba_objects where owner = UPPER(‘&&schema’)
where 1=1
and object_type = ‘INDEX’

select ‘select dbms_metadata.get_ddl(”’ || type || ”’,
”’ || name || ”’, ”’ || UPPER(‘&&schema’) || ”’) FROM dual;’
from dba_object_size
where 1=1
and owner = UPPER(‘&&schema’)
and type = ‘TABLE’; — change to each of the valid types

===Get User DDL with related grants===
select dbms_metadata.get_ddl('USER', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('ROLE_GRANT', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', username) || '/' ddl
from dba_users;
=== Get View DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_view.sql
select DBMS_METADATA.GET_DDL ('VIEW', '&&view_name', '&&schema')||chr(10)||'/' eskewell from dual;
spool off
===Get Trigger DDL===
set long 3000000
set lines 1000
set pages 0
set trimspool on
set feedb off
col eskewell for a1000
spool ddl_trigger.sql
select dbms_metadata.get_ddl('TRIGGER', '&trigger_name','&schema') ddl
from dual
spool off

===Extract DDL for a table without its integrity contraints===
If you are having trouble recreating table data because of integrity contraints, trying importing the data first, then the constraints:
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS', FALSE);
then extract the ddl using one of the methods above. 
Finally, extract the constraint ddl and run it separately:
dbms_metadata.get_ddl('REF_CONSTRAINT','&&contraint_name');

===Generate DDL and store it in a table==
from: [http://www.myoracleguide.com/s/gen_schema.htm]
create table ddl_scripts(
object_name varchar2(50),
object_type varchar2(30),
text varchar2(4000));

-- Format the DDL text using trigger

create or replace trigger ddl_scripts_format_trg before insert on ddl_scripts
for each row
declare
n1 number;
n2 number;
BEGIN
n1 := instr(:new.text, '"."',1,1);
n2 := instr(:new.text, '"', 1,1);
if n1<50 then
:new.text := replace(substr(:new.text,1,n2-1)||substr(:new.text,n1+3), '"', null);
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
:new.text := ltrim(rtrim(:new.text, chr(10)), chr(10));
:new.text := ltrim(rtrim(:new.text, chr(32)), chr(32));
end if;
END;
/

---- Run the following PL/SQL code to insert DDL scripts into the above table
---- Comment the object types that are not required
---- Additional filter can be added for the cursor queries

declare
a1 varchar2(32767);
str varchar2(32767);
n1 number;
cur_user varchar2(30);
begin
select '"'||upper(username)||'"."' into cur_user from user_users;
for c1 in(select a.table_name from user_tables a where a.table_name
not in(select object_name from user_recyclebin) order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TABLE', c1.table_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TABLE', a1);
for c2 in(select index_name from user_indexes where table_name=c1.table_name and index_type in('NORMAL', 'BITMAP') order by 1)
LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('INDEX', c2.index_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'INDEX', a1);
END LOOP;
END LOOP;

-- Trigger scripts
for c1 in(select table_name, trigger_name from user_triggers where trigger_name
not in(select object_name from user_recyclebin) order by 1,2) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TRIGGER', c1.trigger_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.table_name, 'TRIGGER', a1);
END LOOP;

-- Views
for c1 IN(select view_name from user_views order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('VIEW', c1.view_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.view_name, 'VIEW', a1);
END LOOP;

-- Sequence Scripts
for c1 IN(select sequence_name from user_sequences order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SEQUENCE', c1.sequence_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.sequence_name, 'SEQUENCE', a1);
END LOOP;

-- Directoryies
for c1 in(select directory_name from all_directories order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('DIRECTORY', c1.directory_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.directory_name, 'DIRECTORY', a1);
END LOOP;

-- Materialized Views
for c1 in(select mview_name from user_mviews order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW', c1.mview_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.mview_name, 'MATERIALIZED VIEW', a1);
END LOOP;

-- Materialized View Logs
for c1 in(select log_table from user_mview_logs order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG', c1.log_table), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.log_table, 'MATERIALIZED_VIEW_LOG', a1);
END LOOP;

-- Synonyms
for c1 in(select synonym_name from user_synonyms order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SYNONYM', c1.synonym_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.synonym_name, 'SYNONYM', a1);
END LOOP;

-- Types
for c1 in(select type_name from user_types order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('TYPE', c1.type_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.type_name, 'TYPE', a1);
END LOOP;
END;
/

-- Query the table ddl_scripts
SQL> set pagesize 0
SQL> set linesize 32767
SQL> set trimspool ON
SQL spool c:\temp\ddl.txt
SQL> select text from ddl_scripts order by
case when object_type in('TABLE', 'INDEX', 'TRIGGER') then 0 else 1 end,
object_name, decode(object_type, 'TABLE',1,'TRIGGER',3,'INDEX',2);

SQL> spool off

Extract ddl with "dbms metadata.get ddl"

2011-12-12T15:02:50Z

10.250.159.106:

Extract ddl with "dbms metadata.get ddl"

2011-12-12T15:02:25Z

10.250.159.106:

Extract ddl with "dbms metadata.get ddl"

2011-12-12T14:59:34Z

10.250.159.106:

Extract ddl with "dbms metadata.get ddl"

2011-12-12T14:51:59Z

10.250.159.106:

Extract ddl with "dbms metadata.get ddl"

2011-12-12T14:51:25Z

10.250.159.106:

Extract ddl with "dbms metadata.get ddl"

2011-12-12T14:50:28Z

10.250.159.106:

Extract ddl with "dbms metadata.get ddl"

2011-12-12T14:47:34Z

10.250.159.106: /* Different ways of extracting ddl */

Datapump

2011-12-09T13:25:52Z

10.250.159.106:

===Use the flashback parameter to export and import a consistent dump===

expdp <user>/<pwd> parfile=db_params.par

where db_params.par would look like this:
flashback_time=”to_timestamp (to_char (sysdate, ‘YYYY-MM-DD HH24:MI:SS’), ‘YYYY-MM-DD HH24:MI:SS’)”
directory=DATAPUMP_DIR
dumpfile=db_schema.dmp
schemas=(apps,test)

This performs a consistent dump of 2 schemas

Keeping the parameters in a file like this allows you to reuse it for the import:

impdp <user>/<pwd> parfile=db_params.par

===Monitoring Datapump sessions===
select s.sid
, s.serial#
from v$session s
, dba_datapump_sessions dps
where s.saddr = dps.saddr;

Once the session is identified, you can see the parallel query slave sessions spawned off by the main DataPump session by querying the V$PX_SESSION view:
select sid from v$px_session
where qcsid = <DP Session ID>;

===How long will it take to export?===
DataPump sends information about its progress to the longops view and can be consulted thus:
select sid
, serial#
, sofar
, totalwork
from v$session_longops
where 1=1
and opname = '<DP Job Name>'
and sofar != totalwork
/

===Enable trace mode===
Two trace possibilities are available, standard and full:
impdp trace=0480300 ...
provides standard tracing. Trace files will be in user-dump_dest
impdp trace=1FF0300 ...
provides full tracing. Trace files will be in user-dump_dest

===Enabling SQL trace===
Cannot simply use:
alter session set sql_trace=true;
as DataPump starts another session. An event has to be set:
select sid
, serial#
, username
, program
from v$session
where 1=1
and upper(program) like '%(DW%)'
or upper(program) like '%(DM%)'
/
then use the sid and serial# to set the event:
exec dbms_system.set_ev(<sid>, <serial#>, 10046, 12, '');
Trace files will be in user-dump_dest

For the full beans on what DataPump can do, visit [http://www.rampant-books.com/art_nanda_datapump.htm|Arup Nanda's DataPump page]

Datapump

2011-12-09T13:24:58Z

10.250.159.106:

Datapump

2011-12-09T13:23:25Z

10.250.159.106:

Datapump

2011-12-09T13:22:54Z

10.250.159.106:

==Use the flashback parameter to export and import a consistent dump==

expdp <user>/<pwd> parfile=db_params.par

where db_params.par would look like this:
flashback_time=”to_timestamp (to_char (sysdate, ‘YYYY-MM-DD HH24:MI:SS’), ‘YYYY-MM-DD HH24:MI:SS’)”
directory=DATAPUMP_DIR
dumpfile=db_schema.dmp
schemas=(apps,test)

This performs a consistent dump of 2 schemas

Keeping the parameters in a file like this allows you to reuse it for the import:

impdp <user>/<pwd> parfile=db_params.par

===Monitoring Datapump sessions===
select s.sid
, s.serial#
from v$session s
, dba_datapump_sessions dps
where s.saddr = dps.saddr;

Once the session is identified, you can see the parallel query slave sessions spawned off by the main DataPump session by querying the V$PX_SESSION view:
select sid from v$px_session
where qcsid = <DP Session ID>;

===How long will it take to export?===
DataPump sends information about its progress to the longops view and can be consulted thus:
select sid
, serial#
, sofar
, totalwork
from v$session_longops
where 1=1
and opname = '<DP Job Name>'
and sofar != totalwork
/

===Enable trace mode===
Two trace possibilities are available, standard and full:
impdp trace=0480300 ...
provides standard tracing. Trace files will be in user-dump_dest
impdp trace=1FF0300 ...
provides full tracing. Trace files will be in user-dump_dest

===Enabling SQL trace===
Cannot simply use:
alter session set sql_trace=true;
as DataPump starts another session. An event has to be set:
select sid
, serial#
, username
, program
from v$session
where 1=1
and upper(program) like '%(DW%)'
or upper(program) like '%(DM%)'
/
then use the sid and serial# to set the event:
exec dbms_system.set_ev(<sid>, <serial#>, 10046, 12, '');
Trace files will be in user-dump_dest

Datapump

2011-12-09T13:11:34Z

10.250.159.106:

Datapump

2011-12-09T13:04:16Z

10.250.159.106:

ORA-28112: failed to execute policy function

2011-12-09T12:58:48Z

10.250.159.106:

===Problem===
Getting error "'''ORA-28112: failed to execute policy function'''" when exporting or importing using [[DataPump]]
During expdp is accompanied by "'''ORA-31693: Table data object "SYSMAN"."MGMT_IP_REPORT_DEF" failed to load/unload and is being skipped due to error:'''"
===Reason===
This happens due to audit policies being defined on the table but the policy function is defined in another schema.

===Solution===
Either drop the policy after importing the table with:
begin
for rec in (select * from dba_audit_policies where object_schema = 'SYSMAN') loop
dbms_fga.drop_policy(object_schema => rec.object_schema,
object_name => rec.object_name,
policy_name => rec.policy_name);
end loop;
end;
/
or exclude the policies during export by adding this to the .par file:
exclude=FGA_POLICY
or even better, give the necessary grants to the exporting user...
grant exempt access policy to impexpusr;
The dba role and sysdba have this automatically.

ORA-28112: failed to execute policy function

2011-12-09T12:48:48Z

10.250.159.106:

===Problem===
Getting error "'''ORA-28112: failed to execute policy function'''" when exporting or importing using DataPump
During expdp is accompanied by "'''ORA-31693: Table data object "SYSMAN"."MGMT_IP_REPORT_DEF" failed to load/unload and is being skipped due to error:'''"
===Reason===
This happens due to audit policies being defined on the table but the policy function is defined in another schema.

===Solution===
Either drop the policy after importing the table with:
begin
for rec in (select * from dba_audit_policies where object_schema = 'SYSMAN') loop
dbms_fga.drop_policy(object_schema => rec.object_schema,
object_name => rec.object_name,
policy_name => rec.policy_name);
end loop;
end;
/
or exclude the policies during export by adding this to the .par file:
exclude=FGA_POLICY
or even better, give the necessary grants to the exporting user...
grant exempt access policy to impexpusr;
The dba role and sysdba have this automatically.

ORA-28112: failed to execute policy function

2011-12-09T12:48:28Z

10.250.159.106:

Target has encountered metric evaluation errors

2011-12-08T14:05:47Z

10.250.159.106:

The reasons for this error are manysome!

Is it related to the WebLogicServer targets? Try [[WebLogic Server reports "target has encountered metric evaluation errors" in Grid|this]]

Is it related to a listener? 
Under the Errors sub-tab, the error message reads "Target is in broken state. Reason - Compute dynamic property takes too long"? 
From: 
Oracle® Enterprise Manager 
System Monitoring Plug-in Troubleshooting Guide 
Release 12 (12.0) 
E10314-11 
November 2010 

''Cause'' 
This behavior occurs when target, agent, or both and/or target system
become slow or heavily loaded and computation of dynamic properties take
longer than the default timeout value.
''Workaround'' 
Execute the following command:
emctl reload agent dynamicproperties <target name>:<target type>
OR 
You can alternatively resubmit the target instance properties:
*Click on the Monitoring Configuration link (under the Related Links section on the plug-in target home page).
*Re-enter the encrypted properties.
*Click OK.Try re-confirming the listener configuration page (without making any changes):
OR 
Targets : All Targets
Search for "Listener"
Click the radio button next to the listener that's not up and click the "Configure" button.
Check the details are ok and click "OK"

Target has encountered metric evaluation errors

2011-12-08T14:04:56Z

10.250.159.106:

The reasons for this error are manysome!

Is it related to the WebLogicServer targets? Try [[WebLogic Server reports "target has encountered metric evaluation errors" in Grid|this]]

Is it related to a listener? 
Under the Errors sub-tab, the error message reads "Target is in broken state. Reason - Compute dynamic property takes too long"? 
From: 
Oracle® Enterprise Manager 
System Monitoring Plug-in Troubleshooting Guide 
Release 12 (12.0) 
E10314-11 
November 2010 

''Cause'' 
This behavior occurs when target, agent, or both and/or target system
become slow or heavily loaded and computation of dynamic properties take
longer than the default timeout value.
''Workaround'' 
Execute the following command:
emctl reload agent dynamicproperties <target name>:<target type>
OR 
You can alternatively resubmit the target instance properties:
*Click on the Monitoring Configuration link (under the Related Links section on the plug-in target home page).
*Re-enter the encrypted properties.
*Click OK.Try re-confirming the listener configuration page (without making any changes):
Targets : All Targets
Search for "Listener"
Click the radio button next to the listener that's not up and click the "Configure" button.
Check the details are ok and click "OK"

Target has encountered metric evaluation errors

2011-12-08T14:04:29Z

10.250.159.106:

The reasons for this error are manysome!

Is it related to the WebLogicServer targets? Try [[WebLogic Server reports "target has encountered metric evaluation errors" in Grid|this]]

Is it related to a listener? 
Under the Errors sub-tab, the error message reads "Target is in broken state. Reason - Compute dynamic property takes too long"? 
From: 
Oracle® Enterprise Manager 
System Monitoring Plug-in Troubleshooting Guide 
Release 12 (12.0) 
E10314-11 
November 2010 

''Cause'' 
This behavior occurs when target, agent, or both and/or target system
become slow or heavily loaded and computation of dynamic properties take
longer than the default timeout value.
''Workaround'' 
Execute the following command:
emctl reload agent dynamicproperties <target name>:<target type>
OR 
You can alternatively resubmit the target instance properties:
*Click on the Monitoring Configuration link (under the Related Links section on the plug-in target home page).
*Re-enter the encrypted properties.
*Click OK.Try re-confirming the listener configuration page (without making any changes):
Targets : All Targets
Search for "Listener"
Click the radio button next to the listener that's not up and click the "Configure" button.
Check the details are ok and click "OK"

Target has encountered metric evaluation errors

2011-12-08T14:04:06Z

10.250.159.106:

The reasons for this error are manysome!

Is it related to the WebLogicServer targets? Try [[WebLogic Server reports "target has encountered metric evaluation errors" in Grid|this]]

Is it related to a listener? 
Under the Errors sub-tab, the error message reads "Target is in broken state. Reason - Compute dynamic property takes too long"? 
From: 
Oracle® Enterprise Manager 
System Monitoring Plug-in Troubleshooting Guide 
Release 12 (12.0) 
E10314-11 
November 2010 

''Cause'' 
This behavior occurs when target, agent, or both and/or target system
become slow or heavily loaded and computation of dynamic properties take
longer than the default timeout value.
''Workaround'' 
Execute the following command:
emctl reload agent dynamicproperties <target name>:<target type>
OR 
You can alternatively resubmit the target instance properties:
*Click on the Monitoring Configuration link (under the Related Links section
on the plug-in target home page).
*Re-enter the encrypted properties.
*Click OK.Try re-confirming the listener configuration page (without making any changes):
Targets : All Targets
Search for "Listener"
Click the radio button next to the listener that's not up and click the "Configure" button.
Check the details are ok and click "OK"

Target has encountered metric evaluation errors

2011-12-08T14:03:22Z

10.250.159.106:

The reasons for this error are manysome!

Is it related to the WebLogicServer targets? Try [[WebLogic Server reports "target has encountered metric evaluation errors" in Grid|this]]

Is it related to a listener? 
Under the Errors sub-tab, the error message reads "Target is in broken state. Reason - Compute dynamic property takes too long"? 
From: 
Oracle® Enterprise Manager 
System Monitoring Plug-in Troubleshooting Guide 
Release 12 (12.0) 
E10314-11 
November 2010 

''Cause''
This behavior occurs when target, agent, or both and/or target system
become slow or heavily loaded and computation of dynamic properties take
longer than the default timeout value.
''Workaround''
Execute the following command:
emctl reload agent dynamicproperties <target name>:<target type>
OR
You can alternatively resubmit the target instance properties:
1. Click on the Monitoring Configuration link (under the Related Links section
on the plug-in target home page).
2. Re-enter the encrypted properties.
3. Click OK.Try re-confirming the listener configuration page (without making any changes):
Targets : All Targets
Search for "Listener"
Click the radio button next to the listener that's not up and click the "Configure" button.
Check the details are ok and click "OK"

Target has encountered metric evaluation errors

2011-12-08T14:01:45Z

10.250.159.106:

The reasons for this error are manysome!

Is it related to the WebLogicServer targets? Try [[WebLogic Server reports "target has encountered metric evaluation errors" in Grid|this]]

Is it related to a listener? 
Under the Errors sub-tab, the error message reads "Target is in broken state. Reason - Compute dynamic property takes too long"? 
Cause — This behavior occurs when target, agent, or both and/or target system
become slow or heavily loaded and computation of dynamic properties take
longer than the default timeout value.
Workaround — Execute the following command:
emctl reload agent dynamicproperties <target name>:<target type>
OR
You can alternatively resubmit the target instance properties:
1. Click on the Monitoring Configuration link (under the Related Links section
on the plug-in target home page).
2. Re-enter the encrypted properties.
3. Click OK.Try re-confirming the listener configuration page (without making any changes):
Targets : All Targets
Search for "Listener"
Click the radio button next to the listener that's not up and click the "Configure" button.
Check the details are ok and click "OK"

Extract ddl with "dbms metadata.get ddl"

2011-12-08T13:49:49Z

10.250.159.106:

===Different ways of extracting ddl===
set pagesize 0
set linesize 30000
set long 500000
set longchunksize 500000
set trimspool on
set feed off

select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;'
from dba_objects where owner = UPPER('&&schema')
and object_type = 'INDEX'
and ...
/

Get the semi-colon to be appended:
exec dbms_metadata.set_transform_param(DBMS_METADATA.SESSION_TRANSFORM, ‘SQLTERMINATOR’, TRUE );

SELECT ‘select dbms_metadata.get_ddl(”’|| object_type || ”’,
”’||object_name||”’,”&&schema”) FROM dual;’
from dba_objects where owner = UPPER(‘&&schema’)
and object_type = ‘INDEX’

SELECT ‘select dbms_metadata.get_ddl(”’ || type || ”’,
”’ || name || ”’, ”’ || UPPER(‘&&schema’) || ”’) FROM dual;’
FROM dba_object_size
WHERE owner = UPPER(‘&&schema’)
AND type = ‘TABLE’; — change to each of the valid types

set long 3000000
set lines 1000
set pages 0
set feedb off
col eskewell for a1000
spool deedeeyell
select DBMS_METADATA.GET_DDL ('VIEW', 'V_CMDB_MESSAGEFLOW', 'SAPBW')||chr(10)||'/' eskewell from dual;
spool off

===Extract ddl for a table without its integrity contraints===
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS', FALSE);
then extract the ddl using one of the methods above. 
Finally, extract the constraint ddl and run it separately:
DBMS_METADATA.GET_DDL('REF_CONSTRAINT','<REF_CONS_NAME>');

Extract ddl with "dbms metadata.get ddl"

2011-12-08T13:46:23Z

10.250.159.106:

===Different ways of extracting ddl===
set pagesize 0
set linesize 30000
set long 500000
set longchunksize 500000
set trimspool on
set feed off

select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;'
from dba_objects where owner = UPPER('&&schema')
and object_type = 'INDEX'
and ...
/

SELECT ‘select dbms_metadata.get_ddl(”’|| object_type || ”’,
”’||object_name||”’,”&&schema”)||chr(10)||”/” FROM dual;’
from dba_objects where owner = UPPER(‘&&schema’)
and object_type = ‘INDEX’

exec dbms_metadata.set_transform_param(DBMS_METADATA.SESSION_TRANSFORM, ‘SQLTERMINATOR’, TRUE );

SELECT ‘select dbms_metadata.get_ddl(”’ || type || ”’,
”’ || name || ”’, ”’ || UPPER(‘&&schema’) || ”’) || chr(10) || ”/” FROM dual;’
FROM dba_object_size
WHERE owner = UPPER(‘&&schema’)
AND type = ‘TABLE’; — change to each of the valid types

set long 3000000
set lines 1000
set pages 0
set feedb off
col eskewell for a1000
spool deedeeyell
select DBMS_METADATA.GET_DDL ('VIEW', 'V_CMDB_MESSAGEFLOW', 'SAPBW')||chr(10)||'/' eskewell from dual;
spool off

===Extract ddl for a table without its integrity contraints===
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS', FALSE);
then extract the ddl using one of the methods above. 
Finally, extract the constraint ddl and run it separately:
DBMS_METADATA.GET_DDL('REF_CONSTRAINT','<REF_CONS_NAME>');

Target has encountered metric evaluation errors

2011-12-08T13:45:14Z

10.250.159.106: