Marc Kelderman

Subscribe to Marc Kelderman feed
This blog is all about Oracle SOA related products; SCA, OSB, BPEL, BPM, Rules, Workflow.Marc Kelderman SOA Bloghttp://www.blogger.com/profile/13131001868435096782noreply@blogger.comBlogger170125
Updated: 5 hours 17 min ago

Changing SOA properties via WLST

Mon, 2016-03-14 09:30


Hereby a script to change some properties for SOA Suite. These are some generic settings such as:
  • soa-infra
  • AuditLevelGlobalTxMaxRetry
  • DisableCompositeSensors
  • DisableSpringSESensors
  • mediator
  • AuditLevel
  • bpel
  • AuditLevel
  • SyncMaxWaitTime
  • Recovery Schedule Config
import java.io.IOException;
import java.net.MalformedURLException;
import java.util.HashMap;
import java.util.Map;
import java.util.Set;
import javax.management.Attribute;
import javax.management.MBeanServerConnection;
import javax.management.ObjectName;
import javax.management.Query;
import javax.management.QueryExp;
import javax.management.openmbean.CompositeDataSupport;
import javax.management.openmbean.OpenDataException;
import javax.management.remote.JMXConnectorFactory;
import javax.management.remote.JMXServiceURL;

connect('weblogic', 'Welcome1', 't3://myhost:7001')
domainRuntime()

#
# soa-infra
#
SOAInfraConfigobj = ObjectName('oracle.as.soainfra.config:Location=MS1,name=soa-infra,type=SoaInfraConfig,Application=soa-infra')

# Off, Production and Development
SOAattribute = Attribute('AuditLevel', 'Production')
mbs.setAttribute(SOAInfraConfigobj, SOAattribute)

print '*** soa-infra: set AuditLevel', mbs.getAttribute(SOAInfraConfigobj, 'AuditLevel')

SOAattribute = Attribute('GlobalTxMaxRetry', 0)
mbs.setAttribute(SOAInfraConfigobj, SOAattribute)
print '*** soa-infra: set GlobalTxMaxRetry', mbs.getAttribute(SOAInfraConfigobj, 'GlobalTxMaxRetry')

SOAattribute = Attribute('DisableCompositeSensors', true)
mbs.setAttribute(SOAInfraConfigobj, SOAattribute)
print '*** soa-infra: set DisableCompositeSensors', mbs.getAttribute(SOAInfraConfigobj, 'DisableCompositeSensors')

SOAattribute = Attribute('DisableSpringSESensors', true)
mbs.setAttribute(SOAInfraConfigobj, SOAattribute)
print '*** soa-infra: set DisableSpringSESensors', mbs.getAttribute(SOAInfraConfigobj, 'DisableSpringSESensors')

#
# Mediator
#
SOAInfraConfigobj = ObjectName('oracle.as.soainfra.config:Location=MS1,name=mediator,type=MediatorConfig,Application=soa-infra')

SOAattribute = Attribute('AuditLevel', 'Inherit')
mbs.setAttribute(SOAInfraConfigobj, SOAattribute)
print '*** mediator: set AuditLevel', mbs.getAttribute(SOAInfraConfigobj, 'AuditLevel')

#
# BPEL
#

SOAInfraConfigobj = ObjectName('oracle.as.soainfra.config:Location=MS1,name=bpel,type=BPELConfig,Application=soa-infra')

SOAattribute = Attribute('SyncMaxWaitTime', 120)
mbs.setAttribute(SOAInfraConfigobj, SOAattribute)

print '*** bpel: set SyncMaxWaitTime', mbs.getAttribute(SOAInfraConfigobj, 'SyncMaxWaitTime')

# AuditLevel
#   off: 0
#   inherit: 1
#   minimal: 2
#   production: 3
#   development: 4
#   onerror: 5

SOAattribute = Attribute('AuditLevel', 'production')
mbs.setAttribute(SOAInfraConfigobj, SOAattribute)
print '*** bpel: set AuditLevel', mbs.getAttribute(SOAInfraConfigobj, 'AuditLevel')

#javax.management.ObjectName
SOAInfraConfigobj = ObjectName('oracle.as.soainfra.config:Location=mwpton-MS1,name=bpel,type=BPELConfig,Application=soa-infra')

#javax.management.openmbean.CompositeDataSupport
rec_config_obj  = mbs.getAttribute(SOAInfraConfigobj, 'RecoveryConfig')

rec_keySet = rec_config_obj.getCompositeType().keySet()
rec_keys = rec_keySet.toArray()
rec_keyitems = [ rec_key for rec_key in rec_keys ]

#javax.management.openmbean.CompositeDataSupport
rec_cluster_obj = rec_config_obj.get('ClusterConfig')
rec_recurrr_obj = rec_config_obj.get('RecurringScheduleConfig')
rec_startup_obj = rec_config_obj.get('StartupScheduleConfig')

#
# StartupScheduleConfig
#
cnt = 0

# java.util.Collections.UnmodifiableSet
keySet = rec_startup_obj.getCompositeType().keySet()

# array
keys = keySet.toArray()

# list
keyitems = [ key for key in keys ]

# array
values = rec_startup_obj.getAll(keyitems)

for key in keys:
  if key == 'maxMessageRaiseSize':
    values[cnt] = 0
    print '*** bpel: set RecurringScheduleConfig:maxMessageRaiseSize ' + key + ' to value ' + str(values[cnt])
  cnt = cnt + 1

#javax.management.openmbean.CompositeDataSupport
new_rec_startup_obj = CompositeDataSupport(rec_startup_obj.getCompositeType(), keyitems, values)

#
# RecurringScheduleConfig
#
cnt = 0

keySet = rec_recurrr_obj.getCompositeType().keySet()
keys = keySet.toArray()
keyitems = [ key for key in keys ]
values = rec_recurrr_obj.getAll(keyitems)

for key in keys:
  if key == 'maxMessageRaiseSize':
    values[cnt] = 0
    print '*** bpel: set RecurringScheduleConfig:maxMessageRaiseSize ' + key + ' to value ' + str(values[cnt])
  if key == 'startWindowTime':
    values[cnt] = "00:00"
    print '*** bpel: set RecurringScheduleConfig:startWindowTime ' + key + ' to value ' + str(values[cnt])
  if key == 'stopWindowTime':
    values[cnt] = "00:00"
    print '*** bpel: set RecurringScheduleConfig:stopWindowTime ' + key + ' to value ' + str(values[cnt])
  cnt = cnt + 1

#javax.management.openmbean.CompositeDataSupport
new_rec_recurrr_obj = CompositeDataSupport(rec_recurrr_obj.getCompositeType(), keyitems, values)

pyMap = { "ClusterConfig":rec_cluster_obj, "RecurringScheduleConfig":new_rec_recurrr_obj, "StartupScheduleConfig":new_rec_startup_obj }
javaMap = java.util.HashMap()
for k in pyMap.keys():
  javaMap[k] = pyMap[k]

new_rec_config_obj = CompositeDataSupport(rec_config_obj.getCompositeType(), javaMap)

#javax.management.Attribute
SOAattribute = Attribute('RecoveryConfig', new_rec_config_obj)

mbs.setAttribute(SOAInfraConfigobj, SOAattribute)

Oracle Fusion Middleware patchset 7, the release notes

Fri, 2013-04-05 08:58
As of April 2013, patchset 6 is out for the whole Oracle Fusion Middleware stack. It is always hard to find the release notes on the Oracle Website. To many clicks. Here are the releae notes of Weblogic, SOA Suite, Service Bus, AIA and JDeveloper. Note thate PS6 refers to version 11.1.1.7

Release Notes:
Here is an overview on the new features:

https://soacommunity.wordpress.com/2013/05/14/oracle-service-integration-soa-products-whats-new-in-11-1-1-7-ps6/?goback=.gde_3608174_member_240800548

APEX: Running multiple version on single Weblogic Server

Wed, 2012-12-19 07:51
Sometimes you would like to have multiple versions of APEX running on one Weblogic Server, or Weblogic Cluster. For example, you would like to run APEX version 4.0 and version 4.2 along each other.

To configure this is rather simple and straight forward. The trick is to use the various WAR files; apex.war and images.war under a different name and use plan files to manipulate the root and image directories.

The following actions should be carried out:

make sure you have different WAR files of the APEX application in a single directory on your Admin server:

$ cd /data/deploy
$ ls -1
apex.4.0.war
apex.4.2.war
images.4.0.war
images.4.2.war


Create a plan directory to store your plan-files to overule the WEB properties

$ mkdir -p /data/user_projects/domains/APEX/plan/apex
$ ls -1
plan-images.4.0.xml
plan-images.4.2.xml
plan.4.0.xml
plan.4.2.xml


Make sure you have these files in this directory. Here is an example of the APEX plan-images file, to create your own plan file:

plan-images.4.2.xml
<?xml version='1.0' encoding='UTF-8'?> 
<deployment-plan xmlns="http://xmlns.oracle.com/weblogic/deployment-plan" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/weblogic/deployment-plan http://xmlns.oracle.com/weblogic/deployment-plan/1.0/deployment-plan.xsd" global-variables="false">
 
<application-name>apex.war


  <variable-definition>
     
<variable>
         
<name>apex-images-root</name>
         
<value>apex-images-42</value>
     
</variable>
 
</variable-definition>

 
<module-override>

   
<module-name>images.4.2.war</module-name>
   
<module-type>war</module-type>

   
<module-descriptor external="false">
     
<root-element>weblogic-web-app</root-element>
     
<uri>WEB-INF/weblogic.xml</uri>

     
<variable-assignment>
       
<name>apex-images-root</name>
       
<xpath>/weblogic-web-app/context-root</xpath>
     
</variable-assignment>

   
</module-descriptor>
 
</module-override>

 
<config-root>/data/tmp/apex</config-root> </deployment-plan>

Here is an example of the APEX plan file:

plan.4.2.xml 
<?xml version='1.0' encoding='UTF-8'?> 
<deployment-plan xmlns="http://xmlns.oracle.com/weblogic/deployment-plan" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/weblogic/deployment-plan http://xmlns.oracle.com/weblogic/deployment-plan/1.0/deployment-plan.xsd" global-variables="false">
 
<application-name>apex.4.2.war</application-name>

 
<variable-definition>
     
<variable>
         
<name>apex-root</name>
         
<value>apex-42</value>
     
</variable>
     
<variable>
         
<name>apex-config</name>
         
<value>/data/configuration/4.2</value>
     
</variable>
 
</variable-definition>

 
<module-override>
   
<module-name>apex.4.2.war</module-name>
   
<module-type>war</module-type>

   
<module-descriptor external="false">
     
<root-element>weblogic-web-app</root-element>
     
<uri>WEB-INF/weblogic.xml</uri>

     
<variable-assignment>
       
<name>apex-root</name>
       
<xpath>/weblogic-web-app/context-root</xpath>
     
</variable-assignment>

   
</module-descriptor>

   
<module-descriptor external="false">
     
<root-element>web-app</root-element>
     
<uri>WEB-INF/web.xml</uri>

     
<variable-assignment>
        
<name>apex-config</name>
        
<xpath>/web-app/context-param/[param-name="config.dir"]/param-value</xpath>
        
<operation>add

      </variable-assignment>

   
</module-descriptor>
 
</module-override>

 
<config-root>/data/tmp/apex</config-root></deployment-plan>

Now comes the deployment part, which is straight forward as a normal application.
  • Logon to Adminconsole
  • Lock & Edit to open session
  • Deploy images.4.0.war with plan file plan-images.4.0.xml
  • Deploy images.4.2.war with plan file plan-images.4.2.xml
  • Deploy apex.4.0.war with plan file plan.4.0.xml
  • Deploy apex.4.2.war with plan file plan.4.2.xml
  • Activate changes
  • Start running the images applications for all requests
  • Start running the apex applications for all requests
While we have overuled the default images direcotry from '/i' into '/apex-images-42' or '/apex-images-40', we should run some SQL scripts to update the APEX data. The following SQL code should be execute on the database for the specific APEX version

declare
    l_stmt varchar2(4000);
begin
    l_stmt := 'create or replace package wwv_flow_image_prefix
is
    g_image_prefix       constant varchar2(255) := ''/
apex-images-42/'';
end wwv_flow_image_prefix;';

    execute immediate l_stmt;
end;
/

update wwv_flows
       set flow_image_prefix = '/apex-images-42/'
     where flow_image_prefix = '/i/';

commit;

begin
    wwv_flow_page_cache_api.purge_all;
end;
/

commit;

begin
    dbms_utility.compile_schema(schema => 'APEX_040200', compile_all => FALSE);
end;
/


Now you are able to run multiple APEX applications from onw Weblogic Server/Cluster:

http://:/apex-42
http://:/apex-40


Review: Oracle SOA Suite 11g Administration Handbook

Sat, 2012-09-22 07:34
While Packt Publishing is almost ready to publish their 1000th title. They will celebrate this with an  the event. As the mentioned on their site:

"Packt would like you to join them in celebrating this milestone with a surprise gift. Revisit Packt’s website between the 28th and 30th of September to redeem your gift, or sign up for an account with us now to receive a notification email.

Packt supports many of the Open Source projects covered by its books through a project royalty donation, which has contributed over $400,000 to Open Source projects. As part of the 1000th book celebration Packt is allocating $30,000 to share between projects and authors."
I had the opportunity to review the new administration handbook of the Oracle SOA Suite 11g.


 






Here are my comments on this book.

The book is filling a gap in the Oracle SOA world. This book is really focusing on administration and monitoring of the SOA11g environment. The book is not a summary of the Oracle Manuals with some screen shots based on an example application, but it gives you also different best practises, idea's, and good examples on maintaining your environment.

The chapter on tuning your SOA11g environment is very good! It covers O/S, application server, database and the various component within the SOA Suite.

I missing only a good script in the chapter on maintaining  your SOA instances. The examples are based on the de supplied scripts of Oracle, but those script do not purge all the data.



Extreme performance boost on OSB11g and CLOB objects

Wed, 2012-09-19 13:33
When using the JCA DbAdpater in the Oracle Service Bus (OSB11g) normal operations running fine. Most of us using the DbAdapter for simple DML actions (Select/Insert/Update/Delete).

There is a huge performance degradation when you read LOB objects from the DbAdapter. When reading a CLOB from a table, and this CLOB contains a document of 3MB, we saw that the OSB server consumes 100% CPU for a long time.
This results in time-outs, broken-pipe, connection lostd and all those kind of messages. First of all you look into your own environment to find this issue;
  • Is the server configured correctly
  • Is the network up and running
  • Is the query correct
  • Is the Proxy service programmed in the correct way
I found out that this huge CPU consuming action is a bug (!) that exists from patch set #2 (11.1.1.3). Only for this release a patch was created. The fix was not put into the code of the next patch sets.

To summarize; make sure you have patch for your OSB environement for bug 1294800 (PS2) or 14630697 (PS5)  or ask Oracle Support for a backport for you release.

WLST Script changing logfile location

Thu, 2012-05-31 13:06
While I was migrating Forms6i to Forms11g patch set #5, the configuration tool of Forms11g is a bit strict. In the silent install it is not possible to set de locations of the log files. Here is the script that will set new filename locations of all the Managed Servers and Admin Server in the domain. It also set the filename location of all the ODL logging.

fmwlogging.py:
#
# usage:
#
# ${ORACLE_HOME}/common/bin/wlst.sh [domain-name] [admin-server-url] [password]
#

import os
import sys
import traceback
import getopt

loggingEnabled=True
# rotationType="none", "bySize", "byTime"
# logFileSeverity="Trace", "Debug", "Info", "Notice", "Warning"
# rotateLogOnStartup=False, True
rotationType="none"
logFileSeverity="Warning"
rotateLogOnStartup=True

def editMode():
edit()
startEdit()

def editActivate():
save()
activate(block="true")

def updateLog(domain_name, logMB, logType):
print "**** Start updateLog()"

fileName = ""
if logType == "Access":
logMB.setLoggingEnabled(loggingEnabled)
fileName = "/data/logs/" + domain_name + "/" + logMB.getName() + "_access.log"
elif logType == "Server":
fileName = "/data/logs/" + domain_name + "/" + logMB.getName() + ".log"
elif logType == "Datasource":
fileName = "/data/logs/" + domain_name + "/" + logMB.getName() + "_datasource.log"
elif logType == "Domain":
logMB.setLogFileSeverity(logFileSeverity)
fileName = "/data/logs/" + domain_name + "/" + domain_name + ".log"

print "**** " + logType + " " + fileName
logMB.setFileName(fileName)
logMB.setRotationType(rotationType)


logMB.setRotateLogOnStartup(rotateLogOnStartup)

print "**** Finished updateLog()"

def changeLogPath(domain_name):
print "**** Start changeLogPath()"

domainConfig()
editMode()

logMB = getMBean("/Log/" + domain_name)
updateLog(domain_name, logMB, logType="Domain")

editActivate()

servers = cmo.getServers()

editMode()
for server in servers:
serverName = server.getName()

logMB = getMBean("/Servers/" + serverName + "/Log/" + serverName)
updateLog(domain_name, logMB, "Server")

httpLogMB = getMBean("/Servers/" + serverName + "/WebServer/" + serverName + "/WebServerLog/" + serverName)
updateLog(domain_name, httpLogMB, "Access")

DSLogMB = getMBean("/Servers/" + serverName + "/DataSource/" + serverName + "/DataSourceLogFile/" + serverName)
updateLog(domain_name, DSLogMB, "Datasource")

editActivate()
print "**** Finished changeLogPath()"

def usage():
print "Usage"
print "./fmwlogging.py $1"

def parse_input():
print "***** Start parse_input()"

domain_name = sys.argv[1]
admin_server = sys.argv[2]
admin_password = sys.argv[3]

return domain_name, admin_server, admin_password

print "***** Start parse_input()"

# Connectionsettings
def connectToServer(username, password, adminurl):
print "***** Start connectToServer()"

connect(username, password, adminurl)

print "***** Finished connectToServer()"

#Definition to disconnect from a server
def disconnectFromServer():
print "***** Start disconnectFromServer()"

disconnect()

print "***** Finished disconnectFromServer()"
exit()

def changeODLPath(domain_name):
print "***** Start changeODLPath()"

domainConfig()
managedServers=cmo.getServers()

#Get Runtime for our server
for managedServer in managedServers:
sname=managedServer.getName()
path = "/Servers/" + sname
cd(path)

print "***** Changing server: " + sname
lh = listLogHandlers(target=sname)
for l in lh:
lname = l.get("name")
lprops = l.get("properties")
removeprops=[]
for prop in lprops:
if prop.get("name") == "maxFileSize":
removeprops.append("maxFileSize")
elif prop.get("name") == "maxLogSize":
removeprops.append("maxLogSize")

odlfile = "/data/logs/" + domain_name + "/" + sname + "-" + lname + "-diagnostic.log"
configureLogHandler(target=sname, name=lname, path=odlfile,removeProperty=removeprops)

print "***** Finished changeODLPath()"

def main(domain_name, admin_server, admin_password):
print "***** Start main()"

connectToServer("weblogic", admin_password, admin_server)

# do the change the ODL log files on all servers ( Admin, managed)
# changeODLPath(domain_name)

# do the change the standard log files on all servers ( Admin, managed)
changeLogPath(domain_name)

# Calling disconnectFromServer definition with no arguments
disconnectFromServer()

print "***** Finished main()"

try:
print "** start()"

domain_name, admin_server, admin_password = parse_input()
main(domain_name, admin_server, admin_password)

print "** finished()"

except Exception, (e):
print "ERROR: An unexpected error occurred!"
traceback.print_exc()
dumpStack()
print "ERROR: Failed to configure fmw diagnostic logging " + domain_name + "!!"

#EOF


Reference: Weblogic MBean Documentation

OEM12c Patchset install: Updated cleanup script

Tue, 2012-04-10 08:51
I have updated my script to force a clean-up of de repository of OEM12c with the latest patch set. There were some new roles and synonyms introduced. The old script of OEM12c is here, new one is here, logon as sys user with sysdba priveliges:

delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Metadata Services';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Authorization Policy Manager';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Oracle Platform Security Services';
commit;

drop user SYSMAN cascade;
drop user SYSMAN_MDS cascade;
drop user MGMT_VIEW cascade;
drop user SYSMAN_RO cascade;
drop user SYSMAN_OPSS cascade;
drop user BIP cascade;
drop user SYSMAN_APM cascade;
drop role MGMT_USER;
drop role MGMT_ECM_VIEW;

drop public synonym SMP_EMD_TARGET_OBJ_ARRAY;
drop public synonym SMP_EMD_TARGET_OBJ;
drop public synonym SMP_EMD_STRING_ARRAY_ARRAY;
drop public synonym SMP_EMD_STRING_ARRAY;
drop public synonym SMP_EMD_NVPAIR_ARRAY;
drop public synonym SMP_EMD_NVPAIR;
drop public synonym SMP_EMD_INTEGER_ARRAY_ARRAY;
drop public synonym SMP_EMD_INTEGER_ARRAY;
drop public synonym SMP_EMD_DELETE_REC_ARRAY;
drop public synonym SMP_EMD_AVAIL_OBJ;
drop public synonym SETEMVIEWUSERCONTEXT;
drop public synonym MGMT_VIEW_UTIL;
drop public synonym MGMT_USER;
drop public synonym MGMT_TYPE_PROPERTIES;
drop public synonym MGMT_TARGET_PROPERTIES;
drop public synonym MGMT_TARGET_MEMBERSHIPS;
drop public synonym MGMT_TARGET_BLACKOUTS;
drop public synonym MGMT_TARGETS;
drop public synonym MGMT_TARGET;
drop public synonym MGMT_STRING_METRIC_HISTORY;
drop public synonym MGMT_SEVERITY_OBJ;
drop public synonym MGMT_SEVERITY_ARRAY;
drop public synonym MGMT_SEVERITY;
drop public synonym MGMT_PREFERENCES;
drop public synonym MGMT_PAF_PROCS_LATEST;
drop public synonym MGMT_PAF_JOBS;
drop public synonym MGMT_PAF$STATES;
drop public synonym MGMT_PAF$PROCEDURES;
drop public synonym MGMT_PAF$INSTANCES;
drop public synonym MGMT_PAF$APPLICATIONS;
drop public synonym MGMT_NAME_VALUES;
drop public synonym MGMT_NAME_VALUE;
drop public synonym MGMT_METRIC_THRESHOLDS;
drop public synonym MGMT_METRIC_ERRORS;
drop public synonym MGMT_METRIC_COLLECTIONS;
drop public synonym MGMT_METRICS_RAW;
drop public synonym MGMT_METRICS_COMPOSITE_KEYS;
drop public synonym MGMT_METRICS_1HOUR;
drop public synonym MGMT_METRICS_1DAY;
drop public synonym MGMT_METRICS;
drop public synonym MGMT_MESSAGES;
drop public synonym MGMT_LONG_TEXT;
drop public synonym MGMT_LOG;
drop public synonym MGMT_JOB_TARGET;
drop public synonym MGMT_JOB_SCHEDULE;
drop public synonym MGMT_JOB_PARAMETER;
drop public synonym MGMT_JOB_OUTPUT;
drop public synonym MGMT_JOB_EXEC_SUMMARY;
drop public synonym MGMT_JOB_EXECUTION;
drop public synonym MGMT_JOB_EXECPLAN;
drop public synonym MGMT_JOBS;
drop public synonym MGMT_JOB;
drop public synonym MGMT_IP_TGT_GUID_ARRAY;
drop public synonym MGMT_GUID_OBJ;
drop public synonym MGMT_GUID_ARRAY;
drop public synonym MGMT_GLOBAL;
drop public synonym MGMT_DELTA_VALUES;
drop public synonym MGMT_DELTA_VALUE;
drop public synonym MGMT_DELTA_ID_VALUES;
drop public synonym MGMT_DELTA_IDS;
drop public synonym MGMT_DELTA_ENTRY_VALUES;
drop public synonym MGMT_DELTA_ENTRY;
drop public synonym MGMT_DELTA;
drop public synonym MGMT_CURRENT_SEVERITY;
drop public synonym MGMT_CURRENT_METRIC_ERRORS;
drop public synonym MGMT_CURRENT_METRICS;
drop public synonym MGMT_CURRENT_AVAILABILITY;
drop public synonym MGMT_CREDENTIAL;
drop public synonym MGMT_COLLECTION_PROPERTIES;
drop public synonym MGMT_AVAILABILITY;
drop public synonym MGMT_AS_ECM_UTIL;
drop public synonym MGMT_ADMIN;
drop public synonym MGMT$WEBSPHERE_MODULES;
drop public synonym MGMT$WEBSPHERE_JDBCDATASOURCE;
drop public synonym MGMT$WEBSPHERE_APPLICATION;
drop public synonym MGMT$WEBLOGIC_SERVER;
drop public synonym MGMT$WEBLOGIC_MODULES;
drop public synonym MGMT$WEBLOGIC_JDBCDATASOURCE;
drop public synonym MGMT$WEBLOGIC_APPLICATION;
drop public synonym MGMT$WEBCACHE_TO_OHS_ROUTING;
drop public synonym MGMT$WEBCACHE_SITEMAPPINGS;
drop public synonym MGMT$WEBCACHE_SITEALIASES;
drop public synonym MGMT$WEBCACHE_PERFRELATED;
drop public synonym MGMT$WEBCACHE_ORIGIN_SERVERS;
drop public synonym MGMT$WEBCACHE_ORIGINSERVERS;
drop public synonym MGMT$WEBCACHE_OPERATIONPORTS;
drop public synonym MGMT$WEBCACHE_LISTENPORTS;
drop public synonym MGMT$WEBCACHE_CONFIGFILES;
drop public synonym MGMT$WEBCACHE_CLUSTERMEMBERS;
drop public synonym MGMT$WEBCACHE_CLUSTERINFO;
drop public synonym MGMT$TXN_PERF_RAW;
drop public synonym MGMT$TXN_PERF_HOUR;
drop public synonym MGMT$TXN_PERF_DAY;
drop public synonym MGMT$TEMPLATE_POLICY_SETTINGS;
drop public synonym MGMT$TEMPLATE_METRIC_SETTINGS;
drop public synonym MGMT$TEMPLATE_METRICCOLLECTION;
drop public synonym MGMT$TEMPLATES;
drop public synonym MGMT$TARGET_TYPE_PROPERTIES;
drop public synonym MGMT$TARGET_TYPE_DEF;
drop public synonym MGMT$TARGET_TYPE;
drop public synonym MGMT$TARGET_PROPERTIES;
drop public synonym MGMT$TARGET_POLICY_SETTINGS;
drop public synonym MGMT$TARGET_POLICY_EVAL_SUMM;
drop public synonym MGMT$TARGET_POLICIES;
drop public synonym MGMT$TARGET_NOTIF_METR_NOTCOV;
drop public synonym MGMT$TARGET_NOTIFICATION_RULES;
drop public synonym MGMT$TARGET_METRIC_SETTINGS;
drop public synonym MGMT$TARGET_METRIC_COLLECTIONS;
drop public synonym MGMT$TARGET_MEMBERS;
drop public synonym MGMT$TARGET_FLAT_MEMBERS;
drop public synonym MGMT$TARGET_COMPOSITE;
drop public synonym MGMT$TARGET_COMPONENTS;
drop public synonym MGMT$TARGET_ASSOCIATIONS;
drop public synonym MGMT$TARGET;
drop public synonym MGMT$STORAGE_REPORT_VOLUME;
drop public synonym MGMT$STORAGE_REPORT_PATHS;
drop public synonym MGMT$STORAGE_REPORT_NFS;
drop public synonym MGMT$STORAGE_REPORT_LOCALFS;
drop public synonym MGMT$STORAGE_REPORT_KEYS;
drop public synonym MGMT$STORAGE_REPORT_ISSUES;
drop public synonym MGMT$STORAGE_REPORT_DISK;
drop public synonym MGMT$STORAGE_REPORT_DATA;
drop public synonym MGMT$STEP_METRICS_RAW;
drop public synonym MGMT$STEP_METRICS_HOURLY;
drop public synonym MGMT$STEP_METRICS_DAILY;
drop public synonym MGMT$STEP_GROUPS;
drop public synonym MGMT$STEPS;
drop public synonym MGMT$SOFTWARE_PATCHSETS;
drop public synonym MGMT$SOFTWARE_PATCHES_IN_HOMES;
drop public synonym MGMT$SOFTWARE_OTHERS;
drop public synonym MGMT$SOFTWARE_ONEOFF_PATCHES;
drop public synonym MGMT$SOFTWARE_HOME_PROPERTIES;
drop public synonym MGMT$SOFTWARE_HOMES;
drop public synonym MGMT$SOFTWARE_DEPENDENCIES;
drop public synonym MGMT$SOFTWARE_COMP_PATCHSET;
drop public synonym MGMT$SOFTWARE_COMPONENT_PSU;
drop public synonym MGMT$SOFTWARE_COMPONENT_PATCH;
drop public synonym MGMT$SOFTWARE_COMPONENT_ONEOFF;
drop public synonym MGMT$SOFTWARE_COMPONENTS;
drop public synonym MGMT$RAC_TOPOLOGY;
drop public synonym MGMT$RACDB_INTERCONNECTS;
drop public synonym MGMT$PR_HOME_INFO;
drop public synonym MGMT$PR_HOMES_AFFECTED_COUNT;
drop public synonym MGMT$PR_APPL_PATCHES_TO_OH_TGT;
drop public synonym MGMT$PR_APPL_PATCHES_TO_OH;
drop public synonym MGMT$POLICY_VIOL_NOTIF_LOG;
drop public synonym MGMT$POLICY_VIOL_ANNOTATIONS;
drop public synonym MGMT$POLICY_VIOLATION_HISTORY;
drop public synonym MGMT$POLICY_VIOLATION_CURRENT;
drop public synonym MGMT$POLICY_VIOLATION_CTXT;
drop public synonym MGMT$POLICY_VIOLATION_CONTEXT;
drop public synonym MGMT$POLICY_PARAMETERS;
drop public synonym MGMT$POLICIES;
drop public synonym MGMT$PA_RECOM_METRIC_SOURCE;
drop public synonym MGMT$PA_AFFTED_TARGETS;
drop public synonym MGMT$PA_AFFTED_HOST_OH;
drop public synonym MGMT$PA_AFFTED_HOST_GUID_OH;
drop public synonym MGMT$PATCH_ADVISORIES;
drop public synonym MGMT$OVM_VS_VSP_ASSOC;
drop public synonym MGMT$OVM_VS_PERF_SUMMARY;
drop public synonym MGMT$OVM_OS_HW_SUMMARY;
drop public synonym MGMT$OVM_HW_NIC;
drop public synonym MGMT$OVM_GVM_SUMMARY;
drop public synonym MGMT$OS_SUMMARY;
drop public synonym MGMT$OS_PROPERTIES;
drop public synonym MGMT$OS_PATCHES;
drop public synonym MGMT$OS_KERNEL_PARAMS;
drop public synonym MGMT$OS_HW_SUMMARY;
drop public synonym MGMT$OS_FS_MOUNT;
drop public synonym MGMT$OS_COMPONENTS;
drop public synonym MGMT$ORACLE_SW_GRP_TARGETS;
drop public synonym MGMT$ORACLE_SW_GRP_INSTALL;
drop public synonym MGMT$ORACLE_SW_ENT_TARGETS;
drop public synonym MGMT$ORACLE_SW_ENT_INSTALL;
drop public synonym MGMT$OHS_VIRTUALHOSTS;
drop public synonym MGMT$OHS_PERFRELATED;
drop public synonym MGMT$OHS_LISTENADDRESSES;
drop public synonym MGMT$OHS_GENERAL;
drop public synonym MGMT$OHS_CONFIGFILES;
drop public synonym MGMT$OHS_CIPHERSUITES;
drop public synonym MGMT$OC4J_WEBMODULEURLS;
drop public synonym MGMT$OC4J_WEBMODULESETTINGS;
drop public synonym MGMT$OC4J_RESOURCECONFIG;
drop public synonym MGMT$OC4J_PORTRANGES;
drop public synonym MGMT$OC4J_NATIVEDATASOURCES;
drop public synonym MGMT$OC4J_MODULES;
drop public synonym MGMT$OC4J_MANAGEDDATASOURCES;
drop public synonym MGMT$OC4J_J2EE_MODULES;
drop public synonym MGMT$OC4J_GLOBALWEBSETTINGS;
drop public synonym MGMT$OC4J_DEPLOYED_APPS;
drop public synonym MGMT$OC4J_DEPLOYEDAPPS;
drop public synonym MGMT$OC4J_DATASOURCES;
drop public synonym MGMT$OC4J_CONNECTIONPOOLS;
drop public synonym MGMT$OC4J_CONFIGFILES;
drop public synonym MGMT$OC4J_APPLICATIONINFO;
drop public synonym MGMT$OC4J_ALL_DATA_SOURCES;
drop public synonym MGMT$MS_LATEST_APPLIED;
drop public synonym MGMT$MS_APPLY_HISTORY;
drop public synonym MGMT$MISSING_TARGETS_IN_GROUPS;
drop public synonym MGMT$MISSING_TARGETS;
drop public synonym MGMT$METRIC_HOURLY;
drop public synonym MGMT$METRIC_ERROR_HISTORY;
drop public synonym MGMT$METRIC_ERROR_CURRENT;
drop public synonym MGMT$METRIC_DETAILS_SINGLE_STR;
drop public synonym MGMT$METRIC_DETAILS_SINGLE_NUM;
drop public synonym MGMT$METRIC_DETAILS_MULTI_STR;
drop public synonym MGMT$METRIC_DETAILS_MULTI_NUM;
drop public synonym MGMT$METRIC_DETAILS;
drop public synonym MGMT$METRIC_DAILY;
drop public synonym MGMT$METRIC_CURRENT;
drop public synonym MGMT$METRIC_COLLECTION;
drop public synonym MGMT$METRIC_CATEGORIES;
drop public synonym MGMT$MESSAGES;
drop public synonym MGMT$JOB_TARGETS;
drop public synonym MGMT$JOB_STEP_HISTORY;
drop public synonym MGMT$JOB_NOTIFICATION_LOG;
drop public synonym MGMT$JOB_EXECUTION_HISTORY;
drop public synonym MGMT$JOB_ANNOTATIONS;
drop public synonym MGMT$JOBS;
drop public synonym MGMT$JBOSS_RESCONF;
drop public synonym MGMT$JBOSS_PROTOCONF;
drop public synonym MGMT$JBOSS_POOLSCONF;
drop public synonym MGMT$JBOSS_DSCONF;
drop public synonym MGMT$JBOSS_APPSCONF;
drop public synonym MGMT$INTERFACE_STATS;
drop public synonym MGMT$IAS_SIMPLE_PORTS;
drop public synonym MGMT$IAS_PORT_RANGES;
drop public synonym MGMT$IAS_PORTS;
drop public synonym MGMT$IAS_OPMNCONFIG;
drop public synonym MGMT$IAS_MEMBERTARGETS;
drop public synonym MGMT$IAS_INSTALL_SETTINGS;
drop public synonym MGMT$IAS_GENERAL;
drop public synonym MGMT$IAS_DEPLOYEDAPPS;
drop public synonym MGMT$IAS_DCMCONFIG;
drop public synonym MGMT$IAS_CONSOLECONFIG;
drop public synonym MGMT$IAS_CONFIG_PROPS;
drop public synonym MGMT$IAS_CONFIGFILES;
drop public synonym MGMT$HW_NIC;
drop public synonym MGMT$HOSTPATCH_HOST_COMPL;
drop public synonym MGMT$HOSTPATCH_HOSTS;
drop public synonym MGMT$HOSTPATCH_GRP_COMPL_HIST;
drop public synonym MGMT$HOSTPATCH_GROUPS;
drop public synonym MGMT$HOMES_AFFECTED;
drop public synonym MGMT$HA_RMAN_CONFIG_ALL;
drop public synonym MGMT$HA_RMAN_CONFIG;
drop public synonym MGMT$HA_MTTR;
drop public synonym MGMT$HA_INIT_PARAMS_ALL;
drop public synonym MGMT$HA_INIT_PARAMS;
drop public synonym MGMT$HA_INFO_ALL;
drop public synonym MGMT$HA_INFO;
drop public synonym MGMT$HA_FILES_ALL;
drop public synonym MGMT$HA_FILES;
drop public synonym MGMT$HA_BACKUP;
drop public synonym MGMT$GRP_METRICS_RAW;
drop public synonym MGMT$GRP_METRICS_HOURLY;
drop public synonym MGMT$GRP_METRICS_DAILY;
drop public synonym MGMT$GROUP_MEMBERS;
drop public synonym MGMT$GROUP_FLAT_MEMBERSHIPS;
drop public synonym MGMT$GROUP_DERIVED_MEMBERSHIPS;
drop public synonym MGMT$ESA_WITH_GRANT_REPORT;
drop public synonym MGMT$ESA_WITH_ADMIN_REPORT;
drop public synonym MGMT$ESA_TRC_AUD_PERM_REP_NT;
drop public synonym MGMT$ESA_TRC_AUD_PERM_REPORT;
drop public synonym MGMT$ESA_TABSP_OWNERS_REPORT;
drop public synonym MGMT$ESA_SYS_PUB_PKG_REPORT;
drop public synonym MGMT$ESA_PUB_PRIV_REPORT;
drop public synonym MGMT$ESA_POWER_PRIV_REPORT;
drop public synonym MGMT$ESA_OH_PERMISSION_REPORT;
drop public synonym MGMT$ESA_OH_OWNERSHIP_REPORT;
drop public synonym MGMT$ESA_KEY_OBJECTS_REPORT;
drop public synonym MGMT$ESA_EXMPT_ACCESS_REPORT;
drop public synonym MGMT$ESA_DIRECT_PRIV_REPORT;
drop public synonym MGMT$ESA_DBA_ROLE_REPORT;
drop public synonym MGMT$ESA_DBA_GROUP_REPORT;
drop public synonym MGMT$ESA_CREATE_PRIV_REPORT;
drop public synonym MGMT$ESA_CONN_PRIV_REPORT;
drop public synonym MGMT$ESA_CATALOG_REPORT;
drop public synonym MGMT$ESA_BECOME_USER_REPORT;
drop public synonym MGMT$ESA_AUDIT_SYSTEM_REPORT;
drop public synonym MGMT$ESA_ANY_PRIV_REPORT;
drop public synonym MGMT$ESA_ANY_DICT_REPORT;
drop public synonym MGMT$ESA_ALL_PRIVS_REPORT;
drop public synonym MGMT$EM_HOMES_PLATFORM;
drop public synonym MGMT$ECM_VISIBLE_SNAPSHOTS;
drop public synonym MGMT$ECM_CURRENT_SNAPSHOTS;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY6;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY5;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY4;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY3;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY2;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY1;
drop public synonym MGMT$ECM_CONFIG_HISTORY;
drop public synonym MGMT$E2E_RAW;
drop public synonym MGMT$E2E_HOURLY;
drop public synonym MGMT$E2E_1DAY;
drop public synonym MGMT$DELTA_VIEW_DETAILS;
drop public synonym MGMT$DELTA_VIEW;
drop public synonym MGMT$DELTA_VENDOR_SW;
drop public synonym MGMT$DELTA_PATCHSET_DETAILS;
drop public synonym MGMT$DELTA_PATCHSETS;
drop public synonym MGMT$DELTA_OS_KERNEL_PARAMS;
drop public synonym MGMT$DELTA_OS_COMP_DETAILS;
drop public synonym MGMT$DELTA_OS_COMPONENTS;
drop public synonym MGMT$DELTA_ORACLE_HOME;
drop public synonym MGMT$DELTA_ONEOFF_PATCHES;
drop public synonym MGMT$DELTA_INIT;
drop public synonym MGMT$DELTA_HOST_CONFIG;
drop public synonym MGMT$DELTA_HARDWARE;
drop public synonym MGMT$DELTA_FS_MOUNT;
drop public synonym MGMT$DELTA_COMPONENT_DETAILS;
drop public synonym MGMT$DELTA_COMPONENTS;
drop public synonym MGMT$DB_TABLESPACES_ALL;
drop public synonym MGMT$DB_TABLESPACES;
drop public synonym MGMT$DB_SGA_ALL;
drop public synonym MGMT$DB_SGA;
drop public synonym MGMT$DB_ROLLBACK_SEGS_ALL;
drop public synonym MGMT$DB_ROLLBACK_SEGS;
drop public synonym MGMT$DB_REDOLOGS_ALL;
drop public synonym MGMT$DB_REDOLOGS;
drop public synonym MGMT$DB_OPTIONS_ALL;
drop public synonym MGMT$DB_OPTIONS;
drop public synonym MGMT$DB_LICENSE_ALL;
drop public synonym MGMT$DB_LICENSE;
drop public synonym MGMT$DB_INIT_PARAMS_ALL;
drop public synonym MGMT$DB_INIT_PARAMS;
drop public synonym MGMT$DB_FEATUREUSAGE;
drop public synonym MGMT$DB_DBNINSTANCEINFO_ALL;
drop public synonym MGMT$DB_DBNINSTANCEINFO;
drop public synonym MGMT$DB_DATAFILES_ALL;
drop public synonym MGMT$DB_DATAFILES;
drop public synonym MGMT$DB_CONTROLFILES_ALL;
drop public synonym MGMT$DB_CONTROLFILES;
drop public synonym MGMT$CS_EVAL_SUMMARY_STANDARD;
drop public synonym MGMT$CS_EVAL_SUMMARY_RULE;
drop public synonym MGMT$CS_CONFIG_STANDARDS;
drop public synonym MGMT$CSM_WATCHLIST;
drop public synonym MGMT$CSM_URL_HOURLY;
drop public synonym MGMT$CSM_URL_DIST_HOURLY;
drop public synonym MGMT$CSM_URL_DIST_DAILY;
drop public synonym MGMT$CSM_URL_DAILY;
drop public synonym MGMT$CSM_SUBNET_HOURLY;
drop public synonym MGMT$CSM_SUBNET_DIST_HOURLY;
drop public synonym MGMT$CSM_SUBNET_DIST_DAILY;
drop public synonym MGMT$CSM_SUBNET_DAILY;
drop public synonym MGMT$CSM_REGION_HOURLY;
drop public synonym MGMT$CSM_REGION_DIST_HOURLY;
drop public synonym MGMT$CSM_REGION_DIST_DAILY;
drop public synonym MGMT$CSM_REGION_DAILY;
drop public synonym MGMT$CSM_REGION;
drop public synonym MGMT$CSM_MT_URL_HOURLY;
drop public synonym MGMT$CSM_MT_URL_DIST_HOURLY;
drop public synonym MGMT$CSM_MT_URL_DIST_DAILY;
drop public synonym MGMT$CSM_MT_URL_DAILY;
drop public synonym MGMT$CSM_MT_METRIC_DETAILS;
drop public synonym MGMT$CSM_MT_IP_HOURLY;
drop public synonym MGMT$CSM_MT_IP_DIST_HOURLY;
drop public synonym MGMT$CSM_MT_IP_DIST_DAILY;
drop public synonym MGMT$CSM_MT_IP_DAILY;
drop public synonym MGMT$CSM_MT_DSR_HOURLY;
drop public synonym MGMT$CSM_MT_DSR_DIST_HOURLY;
drop public synonym MGMT$CSM_MT_DSR_DIST_DAILY;
drop public synonym MGMT$CSM_MT_DSR_DAILY;
drop public synonym MGMT$CSM_METRIC_DETAILS;
drop public synonym MGMT$CSM_IP_HOURLY;
drop public synonym MGMT$CSM_IP_DIST_HOURLY;
drop public synonym MGMT$CSM_IP_DIST_DAILY;
drop public synonym MGMT$CSM_IP_DAILY;
drop public synonym MGMT$CSM_DOMAIN_HOURLY;
drop public synonym MGMT$CSM_DOMAIN_DIST_HOURLY;
drop public synonym MGMT$CSM_DOMAIN_DIST_DAILY;
drop public synonym MGMT$CSM_DOMAIN_DAILY;
drop public synonym MGMT$CSA_HOST_SW;
drop public synonym MGMT$CSA_HOST_RULES;
drop public synonym MGMT$CSA_HOST_OS_PROPERTIES;
drop public synonym MGMT$CSA_HOST_OS_FILESYSTEMS;
drop public synonym MGMT$CSA_HOST_OS_COMPONENTS;
drop public synonym MGMT$CSA_HOST_NICS;
drop public synonym MGMT$CSA_HOST_IOCARDS;
drop public synonym MGMT$CSA_HOST_CUSTOM;
drop public synonym MGMT$CSA_HOST_CPUS;
drop public synonym MGMT$CSA_HOST_COOKIES;
drop public synonym MGMT$CSA_FAILED;
drop public synonym MGMT$CSA_COLLECTIONS;
drop public synonym MGMT$CSA_CLIENT_RULE_VIOLS;
drop public synonym MGMT$CSA_CLIENTS;
drop public synonym MGMT$CPF_PATCH_INFO;
drop public synonym MGMT$CPF_PATCH_DATA;
drop public synonym MGMT$CPF_HOMES_INFO;
drop public synonym MGMT$CPF_ADVISORY_INFO;
drop public synonym MGMT$CONNECTOR_TYPE;
drop public synonym MGMT$CONNECTOR;
drop public synonym MGMT$CLUSTER_INTERCONNECTS;
drop public synonym MGMT$BLACKOUT_HISTORY;
drop public synonym MGMT$BLACKOUTS;
drop public synonym MGMT$AVAIL_ALERT_HISTORY;
drop public synonym MGMT$AVAILABILITY_HISTORY;
drop public synonym MGMT$AVAILABILITY_CURRENT;
drop public synonym MGMT$AUDIT_LOG;
drop public synonym MGMT$APPL_PATCH_AND_PATCHSET;
drop public synonym MGMT$APPLIED_PATCHSETS;
drop public synonym MGMT$APPLIED_PATCHES;
drop public synonym MGMT$ALERT_NOTIF_LOG;
drop public synonym MGMT$ALERT_HISTORY;
drop public synonym MGMT$ALERT_CURRENT;
drop public synonym MGMT$ALERT_ANNOTATIONS;
drop public synonym EMD_MNTR;
drop public synonym ECM_UTIL;
drop synonym DBSNMP.MGMT_EMREP_OOB_MONITORING;

drop public synonym MGMT$ADR_INFO;
drop public synonym MGMT$ARU_FAMILY_PRODUCT_MAP;
drop public synonym MGMT$ARU_LANGUAGES;
drop public synonym MGMT$ARU_PATCH_RECOM;
drop public synonym MGMT$ARU_PATCH_RECOMMENDATIONS;
drop public synonym MGMT$ARU_PLATFORMS;
drop public synonym MGMT$ARU_PRODUCTS;
drop public synonym MGMT$ARU_PRODUCT_RELEASE_MAP;
drop public synonym MGMT$ARU_RELEASES;
drop public synonym MGMT$ARU_TARGETS;
drop public synonym MGMT$CCC_ALL_OBSERVATIONS;
drop public synonym MGMT$CCC_ALL_OBS_BUNDLES;
drop public synonym MGMT$CCC_DIAG_ANALYTICS;
drop public synonym MGMT$CCC_DIAG_QUEUEBACKLOG;
drop public synonym MGMT$CCS_DATA;
drop public synonym MGMT$CCS_DATA_SOURCE;
drop public synonym MGMT$CCS_DATA_SOURCE_VISIBLE;
drop public synonym MGMT$CCS_DATA_VISIBLE;
drop public synonym MGMT$CM_CHANGE_PLANS;
drop public synonym MGMT$CM_CP_SYNCH_CONFLICTS;
drop public synonym MGMT$CM_C_P_CHNG_ITEMS;
drop public synonym MGMT$COMPLIANCE_STANDARD;
drop public synonym MGMT$COMPLIANCE_STANDARD_GROUP;
drop public synonym MGMT$COMPLIANCE_STANDARD_RULE;
drop public synonym MGMT$COMPOSITE_CS_EVAL_SUMMARY;
drop public synonym MGMT$CONFIG_VERSION;
drop public synonym MGMT$CS_ASM_DISKGRP_SETTINGS;
drop public synonym MGMT$CS_DBM_CELL_GROUPS;
drop public synonym MGMT$CS_DBM_GRIDDISK_MISCONF;
drop public synonym MGMT$CS_DB_CONTROL_FILE_COUNT;
drop public synonym MGMT$CS_DB_INIT_PARAMS;
drop public synonym MGMT$CS_DB_RBS_IN_SYSTEM;
drop public synonym MGMT$CS_DB_REC_SEG_SETTINGS;
drop public synonym MGMT$CS_DB_REC_TS_SETTINGS;
drop public synonym MGMT$CS_DB_REC_USER_SETTINGS;
drop public synonym MGMT$CS_DB_REDO_LOGS;
drop public synonym MGMT$CS_DB_REDO_LOG_COUNT;
drop public synonym MGMT$CS_DB_TABLESPACES;
drop public synonym MGMT$CS_DB_TBSP_SEGSPACE_MGMT;
drop public synonym MGMT$CS_EVAL_SUMMARY;
drop public synonym MGMT$CS_FEATURE_USAGE;
drop public synonym MGMT$CS_GROUP_EVAL_SUMMARY;
drop public synonym CM$COMPOSITE_WIRES_CONFIG;
drop public synonym CM$COREID_ACCESS_CONFIG_INFO;
drop public synonym CM$COREID_ACS_PROFILECONFIG_IN;
drop public synonym CM$COREID_ACS_SERVERCONFIG_INF;
drop public synonym CM$COREID_IDENTITY_CONFIG_INFO;
drop public synonym CM$EM$ECM_CSA_CUSTOM;
drop public synonym CM$EM$ECM_HW_CPU;
drop public synonym CM$EM$ECM_HW_IOCARD;
drop public synonym CM$EM$ECM_HW_NIC;
drop public synonym CM$EMAS_COH_CACHE_CONFIG_ECM;
drop public synonym CM$EMAS_COH_CLUSTER_CONFIG_ECM;
drop public synonym CM$EMAS_COH_CMGR_CONFIG_ECM;
drop public synonym CM$EMAS_COH_CONN_CONFIG_ECM;
drop public synonym CM$EMAS_COH_GCAFTER_CONFIG_ECM;
drop public synonym CM$EMAS_COH_GCBEF_CONFIG_ECM;
drop public synonym CM$EMAS_COH_HTTP_SESSION_ECM;
drop public synonym CM$EMAS_COH_MEMORY_CONFIG_ECM;
drop public synonym CM$EMAS_COH_NODE_CONFIG_ECM;
drop public synonym CM$EMAS_COH_OS_CONFIG_ECM;
drop public synonym CM$EMAS_COH_RUNTIME_CONFIG_ECM;
drop public synonym CM$EMAS_COH_SERVICE_CONFIG_ECM;
drop public synonym CM$EMAS_COH_WKA_CONFIG_ECM;
drop public synonym CM$EMAS_TM_CONFIG_ECM;
drop public synonym CM$EM_CCS_DATA_SOURCE;
drop public synonym CM$EM_CCS_PARSED_DATA;
drop public synonym CM$EM_CELL_HCA_CONFIG;
drop public synonym CM$EM_CELL_HCA_PORT_CONFIG;
drop public synonym CM$EM_DBM_COMPUTE_NODES;
drop public synonym CM$EM_ESM_FILESYS;
drop public synonym CM$EM_ESM_PORTS;
drop public synonym CM$EM_ESM_SERVICE;
drop public synonym CM$EM_ESM_STACK;
drop public synonym CM$EM_EXADATA_CELL;
drop public synonym CM$EM_EXADATA_CELLDISK;
drop public synonym CM$EM_EXADATA_FCACHE;
drop public synonym CM$EM_EXADATA_FCACHE_CDISK;
drop public synonym CM$EM_EXADATA_GD_CLIENTS;
drop public synonym CM$EM_EXADATA_GRIDDISK;
drop public synonym CM$EM_EXADATA_IORM;
drop public synonym CM$EM_EXADATA_IORM_CATPLAN;
drop public synonym CM$EM_EXADATA_IORM_DBPLAN;
drop public synonym CM$EM_EXADATA_LUN;
drop public synonym CM$EM_EXADATA_LUN_PDISKS;
drop public synonym CM$EM_EXADATA_PDISK_LUNS;
drop public synonym CM$EM_EXADATA_PHYS_DISK;
drop public synonym CM$EM_HOST_HCA_CONFIG;
drop public synonym CM$EM_HOST_HCA_PORT_CONFIG;
drop public synonym CM$EM_IB_NETWORK_CONNECTIONS;
drop public synonym CM$EM_IB_SWITCH_CONFIG_SUMMARY;
drop public synonym CM$EM_IB_SWITCH_PORT_CONFIG;
drop public synonym CM$EM_IB_SWITCH_VERSION;
drop public synonym CM$EM_ILOM_SYS_INFO;
drop public synonym CM$EM_TPROPS_ECM_VIEW;
drop public synonym CM$ESM_COLLECTION;
drop public synonym CM$ESS_DISPATCHER_CONFIG;
drop public synonym CM$ESS_PROCESSOR_CONFIG;
drop public synonym CM$MGMT_ASM_CLUSTER_ECM;
drop public synonym CM$MGMT_ASM_DG_ATTR_ECM;
drop public synonym CM$MGMT_ASM_DISKGROUP_ECM;
drop public synonym CM$MGMT_ASM_DISK_ECM;
drop public synonym CM$MGMT_ASM_INIT_PARAMS_ECM;
drop public synonym CM$MGMT_ASM_INSTANCE_ECM;
drop public synonym CM$MGMT_BI_ANS_CONFIG;
drop public synonym CM$MGMT_BI_CC_CONFIG;
drop public synonym CM$MGMT_BI_DAC_CONFIG;
drop public synonym CM$MGMT_BI_DAC_ETL_CONFIG;
drop public synonym CM$MGMT_BI_PS_ALERTS_CONFIG;
drop public synonym CM$MGMT_BI_PS_CACHE_CONFIG;
drop public synonym CM$MGMT_BI_PS_CHARTS_CONFIG;
drop public synonym CM$MGMT_BI_PS_CLIENT_CONFIG;
drop public synonym CM$MGMT_BI_PS_CONFIG;
drop public synonym CM$MGMT_BI_PS_DISPLAY_CONFIG;
drop public synonym CM$MGMT_BI_PS_MARKETING_CONFIG;
drop public synonym CM$MGMT_BI_PS_OTHERS_CONFIG;
drop public synonym CM$MGMT_BI_PS_REP_CACHE_CONFIG;
drop public synonym CM$MGMT_BI_PS_STATE_POOL_CONFI;
drop public synonym CM$MGMT_BI_PS_THREADPOOL_CONFI;
drop public synonym CM$MGMT_BI_PS_XML_CACHEDEF_CON;
drop public synonym CM$MGMT_BI_SCH_IBOTS_CONFIG;
drop public synonym CM$MGMT_BI_SCH_MAIL_CONFIG;
drop public synonym CM$MGMT_BPELPROCESS_CONFIG;
drop public synonym CM$MGMT_BPEL_CLUSTER_CONFIG;
drop public synonym CM$MGMT_BPEL_CONFIG;
drop public synonym CM$MGMT_BPEL_CONFIGFILES;
drop public synonym CM$MGMT_BPEL_DOMAIN_CONFIG;
drop public synonym CM$MGMT_BPEL_DSTORE_CONFIG;
drop public synonym CM$MGMT_BPEL_GENERAL_CONFIG;
drop public synonym CM$MGMT_BPEL_PROCESS_CONFIGFIL;
drop public synonym CM$MGMT_BPMN_CONFIG;
drop public synonym CM$MGMT_CLUSTER_ACTV_SRVS_ECM;
drop public synonym CM$MGMT_CLUSTER_CONFIG;
drop public synonym CM$MGMT_CLUSTER_CSS_NODES_ECM;
drop public synonym CM$MGMT_CLUSTER_PSRVPOOLS_ECM;
drop public synonym CM$MGMT_CLUSTER_RESOURCES_ECM;
drop public synonym CM$MGMT_CLUSTER_SRVPOOLS_ECM;
drop public synonym CM$MGMT_COMPOSITE_CONFIG;
drop public synonym CM$MGMT_COMPOSITE_SENSOR_CONFI;
drop public synonym CM$MGMT_CONFIG_VERSION_ECM;
drop public synonym CM$MGMT_COREID_ACCESS_SYS_INFO;
drop public synonym CM$MGMT_COREID_IDENTITY_SYS_IN;
drop public synonym CM$MGMT_DB_ASM_DISK_ECM;
drop public synonym CM$MGMT_DB_AUTOTASK_CLIENT_ECM;
drop public synonym CM$MGMT_DB_COMPONENTS_ECM;
drop public synonym CM$MGMT_DB_CONTROLFILES_ECM;
drop public synonym CM$MGMT_DB_CPU_USAGE_ECM;
drop public synonym CM$MGMT_DB_DATAFILES_ECM;
drop public synonym CM$MGMT_DB_DBNINSTANCEINFO_ECM;
drop public synonym CM$MGMT_DB_HIGHWATERMARK_ECM;
drop public synonym CM$MGMT_DB_INIT_PARAMS_ECM;
drop public synonym CM$MGMT_DB_INST_ONLY_INFO_ECM;
drop public synonym CM$MGMT_DB_INVOBJS_ECM;
drop public synonym CM$MGMT_DB_INVOBJ_CNT_ECM;
drop public synonym CM$MGMT_DB_LICENSE_ECM;
drop public synonym CM$MGMT_DB_LSNR_CONFIG_ECM;
drop public synonym CM$MGMT_DB_OPTIONS_ECM;
drop public synonym CM$MGMT_DB_RECSEGMENTSETTINGS_;
drop public synonym CM$MGMT_DB_RECTSSETTINGS_ECM;
drop public synonym CM$MGMT_DB_RECUSERSETTINGS_ECM;
drop public synonym CM$MGMT_DB_REDOLOGS_ECM;
drop public synonym CM$MGMT_DB_ROLLBACK_SEGS_ECM;
drop public synonym CM$MGMT_DB_SCHEDULER_JOBS_ECM;
drop public synonym CM$MGMT_DB_SERVICES_ECM;
drop public synonym CM$MGMT_DB_SGA_ECM;
drop public synonym CM$MGMT_DB_TABLESPACES_ECM;
drop public synonym CM$MGMT_DB_USERS_ECM;
drop public synonym CM$MGMT_DB_VOTING_DISK;
drop public synonym CM$MGMT_ECM_ADR_INFO;
drop public synonym CM$MGMT_ECM_CSA;
drop public synonym CM$MGMT_ECM_CSA_GENERAL_INFO;
drop public synonym CM$MGMT_ECM_CSA_RULES;
drop public synonym CM$MGMT_ECM_EMD_ALL_PROPERTIES;
drop public synonym CM$MGMT_ECM_EMD_CONFIG_PARAMS;
drop public synonym CM$MGMT_ECM_EMD_JAVA_PARAMS;
drop public synonym CM$MGMT_ECM_EMD_TARGETS;
drop public synonym CM$MGMT_LDAP_LDAPSERVERDBINFOC;
drop public synonym CM$MGMT_LDAP_OIDREPLTOPOLOGY;
drop public synonym CM$MGMT_LISTENER_PORTS_ECM;
drop public synonym CM$MGMT_LISTENER_SERVICES_ECM;
drop public synonym CM$MGMT_LL_HOME_INFO;
drop public synonym CM$MGMT_LL_INV_CLONE_PROPS;
drop public synonym CM$MGMT_LL_INV_COMPONENT;
drop public synonym CM$MGMT_LL_INV_COMP_INST_TYPE;
drop public synonym CM$MGMT_LL_INV_CRS_NODES;
drop public synonym CM$MGMT_LL_INV_DEPENDENCY_RULE;
drop public synonym CM$MGMT_LL_INV_DEP_HOMES;
drop public synonym CM$MGMT_LL_INV_PATCHED_FILE;
drop public synonym CM$MGMT_LL_INV_PATCHES;
drop public synonym CM$MGMT_LL_INV_PATCHSET;
drop public synonym CM$MGMT_LL_INV_PATCH_BUGFIX;
drop public synonym CM$MGMT_LL_INV_PATCH_COMP;
drop public synonym CM$MGMT_LL_INV_SUMMARY;
drop public synonym CM$MGMT_LL_INV_VERSIONED_PATCH;
drop public synonym CM$MGMT_MEDIATOR_CONFIG;
drop public synonym CM$MGMT_OC4J_ADAPTER_CONFIGFIL;
drop public synonym CM$MGMT_OC4J_ADAPTER_CONFIGPAR;
drop public synonym CM$MGMT_OC4J_APPLICATIONINFO;
drop public synonym CM$MGMT_OC4J_CONFIGFILES;
drop public synonym CM$MGMT_OC4J_CONNECTIONPOOLS;
drop public synonym CM$MGMT_OC4J_DATASOURCES;
drop public synonym CM$MGMT_OC4J_DEPLOYEDAPPS;
drop public synonym CM$MGMT_OC4J_GLOBALWEBSETTINGS;
drop public synonym CM$MGMT_OC4J_MANAGEDDATASOURCE;
drop public synonym CM$MGMT_OC4J_MODULES;
drop public synonym CM$MGMT_OC4J_NATIVEDATASOURCES;
drop public synonym CM$MGMT_OC4J_PORTRANGES;
drop public synonym CM$MGMT_OC4J_RESOURCECONFIG;
drop public synonym CM$MGMT_OC4J_WEBMODULESETTINGS;
drop public synonym CM$MGMT_OC4J_WEBMODULEURLS;
drop public synonym CM$MGMT_OHS_CIPHERSUITES;
drop public synonym CM$MGMT_OHS_CONFIGFILES;
drop public synonym CM$MGMT_OHS_GENERAL;
drop public synonym CM$MGMT_OHS_LISTENADDRESSES;
drop public synonym CM$MGMT_OHS_PERFRELATED;
drop public synonym CM$MGMT_OHS_ROUTINGGENERAL;
drop public synonym CM$MGMT_OHS_ROUTINGLOCATIONS;
drop public synonym CM$MGMT_OHS_VIRTUALHOSTS;
drop public synonym CM$MGMT_OID_GENERAL_CONFIG;
drop public synonym CM$MGMT_OID_LOG_CONFIG;
drop public synonym CM$MGMT_OID_PERFORMANCE_CONFIG;
drop public synonym CM$MGMT_OID_SASL_CONFIG;
drop public synonym CM$MGMT_OID_STATS_CONFIG;
drop public synonym CM$MGMT_OIF_IDPSAML1X_ASSERTPR;
drop public synonym CM$MGMT_OIF_SPSAML1X_ASSERTPRO;
drop public synonym CM$MGMT_ORACLE_BI_SCH_CONFIG;
drop public synonym CM$MGMT_ORACLE_FED_SYS_INFO;
drop public synonym CM$MGMT_ORACLE_HAS_CONFIG;
drop public synonym CM$MGMT_ORACLE_HAS_IC_ECM;
drop public synonym CM$MGMT_ORACLE_IDM_SYSTEM_INFO;
drop public synonym CM$MGMT_OSB_BIZ_RESOURCE_CONFI;
drop public synonym CM$MGMT_OSB_BIZ_TRANSPORT_CONF;
drop public synonym CM$MGMT_OSB_FE_DETAIL_CONFIG;
drop public synonym CM$MGMT_OSB_GLOBAL_CONFIG;
drop public synonym CM$MGMT_OSB_JMSQ_CONFIG;
drop public synonym CM$MGMT_OSB_PROXY_RESOURCE_CON;
drop public synonym CM$MGMT_OSB_REPORTING_DBDETAIL;
drop public synonym CM$MGMT_OSM_DISK_GROUP_ECM;
drop public synonym CM$MGMT_RACDB_CONFIG_ECM;
drop public synonym CM$MGMT_RACDB_SRVPOOLS_ECM;
drop public synonym CM$MGMT_RAC_SERVICES;
drop public synonym CM$MGMT_SOACOMPONENT_CONFIG;
drop public synonym CM$MGMT_SOAINFRA_CONFIG;
drop public synonym CM$MGMT_SOAREFERENCE_CONFIG;
drop public synonym CM$MGMT_SOASERVICE_CONFIG;
drop public synonym CM$MGMT_SOA_ENGINE_CONFIG;
drop public synonym CM$MGMT_SSO_SSOSERVER_DB_INFOC;
drop public synonym CM$MGMT_SSO_SSOSERVER_LDAP_INF;
drop public synonym CM$MGMT_STATSPACK_CONFIG_ECM;
drop public synonym CM$MGMT_STORAGE_REPORT_ALIAS;
drop public synonym CM$MGMT_STORAGE_REPORT_DATA;
drop public synonym CM$MGMT_STORAGE_REPORT_ISSUES;
drop public synonym CM$MGMT_STORAGE_REPORT_KEYS;
drop public synonym CM$MGMT_SYSTEM_CHANGES;
drop public synonym CM$MGMT_WEBCACHE_CLUSTERINFO;
drop public synonym CM$MGMT_WEBCACHE_CLUSTERMEMBER;
drop public synonym CM$MGMT_WEBCACHE_CONFIGFILES;
drop public synonym CM$MGMT_WEBCACHE_LISTENPORTS;
drop public synonym CM$MGMT_WEBCACHE_OPERATIONPORT;
drop public synonym CM$MGMT_WEBCACHE_ORIGINSERVERS;
drop public synonym CM$MGMT_WEBCACHE_PERFRELATED;
drop public synonym CM$MGMT_WEBCACHE_SITEALIASES;
drop public synonym CM$MGMT_WEBCACHE_SITEMAPPINGS;
drop public synonym CM$MGMT_WEBSPHERE_APPLICATION;
drop public synonym CM$MGMT_WEBSPHERE_EJBCOMPONENT;
drop public synonym CM$MGMT_WEBSPHERE_JDBCDATASOUR;
drop public synonym CM$MGMT_WEBSPHERE_JDBCPROVIDER;
drop public synonym CM$MGMT_WEBSPHERE_PORTCONFIG;
drop public synonym CM$MGMT_WEBSPHERE_RESOURCECONF;
drop public synonym CM$MGMT_WEBSPHERE_WEBAPPCOMPON;
drop public synonym CM$MGMT_WORKFLOW_CONFIG;
drop public synonym CM$MGMT_WORKFLOW_DAF_CONFIG;
drop public synonym CM$MGMT_ECM_HW;
drop public synonym CM$MGMT_ECM_HW_CPU;
drop public synonym CM$MGMT_ECM_HW_IOCARD;
drop public synonym CM$MGMT_ECM_HW_NIC;
drop public synonym CM$MGMT_ECM_HW_NIC_BONDS;
drop public synonym CM$MGMT_ECM_NON_OUI_BUGS_FIXED;
drop public synonym CM$MGMT_ECM_OMS_CONFIG_PARAMS;
drop public synonym CM$MGMT_ECM_OS;
drop public synonym CM$MGMT_ECM_OS_COMPONENT;
drop public synonym CM$MGMT_ECM_OS_FILESYSTEM;
drop public synonym CM$MGMT_ECM_OS_INIT_SERVICES;
drop public synonym CM$MGMT_ECM_OS_MODULES;
drop public synonym CM$MGMT_ECM_OS_PROPERTY;
drop public synonym CM$MGMT_ECM_OS_REGISTERED_SW;
drop public synonym CM$MGMT_ECM_OS_ULIMITS;
drop public synonym CM$MGMT_ECM_SERVICETAG_INSTANC;
drop public synonym CM$MGMT_ECM_SERVICETAG_REGISTR;
drop public synonym CM$MGMT_EMREP_DBA_TAB_PRIVS;
drop public synonym CM$MGMT_EMREP_DB_INFO;
drop public synonym CM$MGMT_EMREP_OMS_NAME;
drop public synonym CM$MGMT_EMREP_OMS_SECURE_ECM;
drop public synonym CM$MGMT_ESA_REPORT;
drop public synonym CM$MGMT_FEATURE_USAGE_ECM;
drop public synonym CM$MGMT_GEN_APACHE_CIPHERSUITE;
drop public synonym CM$MGMT_GEN_APACHE_GENERAL;
drop public synonym CM$MGMT_GEN_APACHE_LISTENADDRE;
drop public synonym CM$MGMT_GEN_APACHE_PERFRELATED;
drop public synonym CM$MGMT_GEN_APACHE_ROUTINGINFO;
drop public synonym CM$MGMT_GEN_APACHE_VIRTUALHOST;
drop public synonym CM$MGMT_HAS_MANAGED_ASM_ECM;
drop public synonym CM$MGMT_HAS_MANAGED_DB_ECM;
drop public synonym CM$MGMT_HAS_MANAGED_LSNR_ECM;
drop public synonym CM$MGMT_HA_CLS_INTR_CONN;
drop public synonym CM$MGMT_HA_FILES_ECM;
drop public synonym CM$MGMT_HA_INFO_ECM;
drop public synonym CM$MGMT_HA_INIT_PARAMS_ECM;
drop public synonym CM$MGMT_HA_RAC_INTR_CONN;
drop public synonym CM$MGMT_HA_RMAN_CONFIG_ECM;
drop public synonym CM$MGMT_IAS_CONFIGFILES;
drop public synonym CM$MGMT_IAS_CONFIG_PROPS;
drop public synonym CM$MGMT_IAS_CONSOLECONFIG;
drop public synonym CM$MGMT_IAS_DCMCONFIG;
drop public synonym CM$MGMT_IAS_DEPLOYEDAPPS;
drop public synonym CM$MGMT_IAS_DIP_CONFIG;
drop public synonym CM$MGMT_IAS_GENERAL;
drop public synonym CM$MGMT_IAS_MEMBERTARGETS;
drop public synonym CM$MGMT_IAS_OIF_DATASTORE_CONF;
drop public synonym CM$MGMT_IAS_OIF_IDPSAML20_ASSE;
drop public synonym CM$MGMT_IAS_OIF_IDPSAML20_PROT;
drop public synonym CM$MGMT_IAS_OIF_IDP_CONFIG;
drop public synonym CM$MGMT_IAS_OIF_IDP_WSFED11PRO;
drop public synonym CM$MGMT_IAS_OIF_SERVER_CONFIG;
drop public synonym CM$MGMT_IAS_OIF_SPSAML20_ASSER;
drop public synonym CM$MGMT_IAS_OIF_SPSAML20_PROTO;
drop public synonym CM$MGMT_IAS_OIF_SP_CONFIG;
drop public synonym CM$MGMT_IAS_OIF_SP_WSFED11PROP;
drop public synonym CM$MGMT_IAS_OPMNCONFIG;
drop public synonym CM$MGMT_IAS_OVD_LSNR_CONFIG;
drop public synonym CM$MGMT_IAS_OVD_SCHEMA_LOC_CON;
drop public synonym CM$MGMT_IAS_OVD_SEARCH_CONFIG;
drop public synonym CM$MGMT_IAS_OVD_SERVER_CONFIG;
drop public synonym CM$MGMT_JBOSS_APPSCONFIG;
drop public synonym CM$MGMT_JBOSS_DSCONFIG;
drop public synonym CM$MGMT_JBOSS_GENERALCONFIG;
drop public synonym CM$MGMT_JBOSS_POOLCONFIG;
drop public synonym CM$MGMT_JBOSS_PROTOCONFIG;
drop public synonym CM$MGMT_JBOSS_RESOURCECONFIG;
drop public synonym CM$MGMT_JVM_CONFIG_ECM;
drop public synonym MGMT$WEBLOGIC_APPLICATIONS;
drop public synonym MGMT$WEBLOGIC_CLUSTER;
drop public synonym MGMT$WEBLOGIC_DOMAIN;
drop public synonym MGMT$WEBLOGIC_EJBCOMPONENT;
drop public synonym MGMT$WEBLOGIC_JDBCMULTIDS;
drop public synonym MGMT$WEBLOGIC_JMSCONNFACTORY;
drop public synonym MGMT$WEBLOGIC_JMSQUEUE;
drop public synonym MGMT$WEBLOGIC_JMSTOPIC;
drop public synonym MGMT$WEBLOGIC_JOLTCONNPOOL;
drop public synonym MGMT$WEBLOGIC_MACHINE;
drop public synonym MGMT$WEBLOGIC_NETWORK_CHANNELS;
drop public synonym MGMT$WEBLOGIC_NODEMANAGER;
drop public synonym MGMT$WEBLOGIC_OPSSSYSPROP;
drop public synonym MGMT$WEBLOGIC_RACONFIG;
drop public synonym MGMT$WEBLOGIC_RAOUTBOUNDCONFIG;
drop public synonym MGMT$WEBLOGIC_RESOURCECONFIG;
drop public synonym MGMT$WEBLOGIC_STARTSHUTCLASSES;
drop public synonym MGMT$WEBLOGIC_VIRTUALHOST;
drop public synonym MGMT$WEBLOGIC_WEBAPPCOMPONENT;
drop public synonym MGMT$WEBLOGIC_WORKMANAGER;
drop public synonym MGMT$WEBLOGIC_WSCONFIG;
drop public synonym MGMT$WEBLOGIC_WSPORTCONFIG;
drop public synonym MGMT$CS_HA_INFO;
drop public synonym MGMT$CS_RULE_EVAL_SUMMARY;
drop public synonym MGMT$CS_TARGET_ASSOC;
drop public synonym MGMT$DB_ASSOC_DATA;
drop public synonym MGMT$DB_AUTOTASK_CLIENT;
drop public synonym MGMT$DB_CPU_USAGE;
drop public synonym MGMT$DB_FEATURE_USAGE;
drop public synonym MGMT$DB_HA_BACKUP_REPORT;
drop public synonym MGMT$DB_HA_CONFIG;
drop public synonym MGMT$DB_HIGHWATERMARK;
drop public synonym MGMT$DB_INST_ONLY_INFO;
drop public synonym MGMT$DB_INVOBJ_CNT;
drop public synonym MGMT$DB_SCHEDULER_JOBS;
drop public synonym MGMT$DB_SERVICES_ECM;
drop public synonym MGMT$DB_USERS;
drop public synonym MGMT$DIAGNOSTIC_CHECK_ERRORS;
drop public synonym MGMT$DIAGNOSTIC_CHECK_ROWS;
drop public synonym MGMT$ESM_COLLECTION_LATEST;
drop public synonym MGMT$ESM_FILE_SYSTEM_LATEST;
drop public synonym MGMT$ESM_PORTS_LATEST;
drop public synonym MGMT$ESM_SERVICE_LATEST;
drop public synonym MGMT$ESM_STACK_LATEST;
drop public synonym MGMT$HA_DG_TARGET_SUMMARY;
drop public synonym MGMT$HW_CPU_DETAILS;
drop public synonym MGMT$HW_IO_DEVICES;
drop public synonym MGMT$HW_NIC_BONDS;
drop public synonym MGMT$J2EEAPP_EJBCOMPONENT;
drop public synonym MGMT$J2EEAPP_JRFWS;
drop public synonym MGMT$J2EEAPP_JRFWSOPER;
drop public synonym MGMT$J2EEAPP_JRFWSPOLICY;
drop public synonym MGMT$J2EEAPP_JRFWSPORT;
drop public synonym MGMT$J2EEAPP_WEBAPPCOMPONENT;
drop public synonym MGMT$J2EEAPP_WSCONFIG;
drop public synonym MGMT$J2EEAPP_WSPORTCONFIG;
drop public synonym MGMT$J2EE_APPLICATION;
drop public synonym MGMT$OH_CLONE_PROPERTIES;
drop public synonym MGMT$OH_COMPONENT;
drop public synonym MGMT$OH_COMP_DEP_RULE;
drop public synonym MGMT$OH_COMP_INST_TYPE;
drop public synonym MGMT$OH_CRS_NODES;
drop public synonym MGMT$OH_DEP_HOMES;
drop public synonym MGMT$OH_FILE;
drop public synonym MGMT$OH_HOME_INFO;
drop public synonym MGMT$OH_INSTALLED_TARGETS;
drop public synonym MGMT$OH_INV_SUMMARY;
drop public synonym MGMT$OH_PATCH;
drop public synonym MGMT$OH_PATCHED_COMPONENT;
drop public synonym MGMT$OH_PATCHED_FILE;
drop public synonym MGMT$OH_PATCHSET;
drop public synonym MGMT$OH_PATCH_FIXED_BUG;
drop public synonym MGMT$OH_VERSIONED_PATCH;
drop public synonym MGMT$OSB_ADMIN_CLIENT_DB;
drop public synonym MGMT$OS_INIT_SERVICES;
drop public synonym MGMT$OS_LIMITS;
drop public synonym MGMT$OS_MODULES;
drop public synonym MGMT$OS_PATCH_SUMMARY;
drop public synonym MGMT$PA_FINAL_PATCH_LIST;
drop public synonym MGMT$PA_TARGET_MAPPING;
drop public synonym MGMT$RAC_MEMBERSHIPS;
drop public synonym MGMT$RECOM_METRIC_SOURCE;
drop public synonym MGMT$SERVICETAG_INSTANCES;
drop public synonym MGMT$SERVICETAG_REGISTRY;
drop public synonym MGMT$STATSPACK_CONFIG;
drop public synonym MGMT$SWLIB_UPG_REPORT;
drop public synonym MGMT$UNPATCHABLE_DB_TARGETS;
drop public synonym MGMT$VIEW_MT_TC_REPORT;

drop tablespace mgmt_tablespace including contents and datafiles cascade constraints;
drop tablespace mgmt_ecm_depot_ts including contents and datafiles cascade constraints;
drop tablespace mgmt_ad4j_ts including contents and datafiles cascade constraints;

Review: Do more with SOA Integration

Wed, 2012-03-21 15:11

Publishing books related to Oracle SOA technology contains a broad spectrum of products, tools and technologies. Packt Publishing is trying to fill this spectrum with al kinds of books. But buying all these books is expensive, even if you buy only the e-book version.

One of the books the published is a Best-Of book. It takes the best chapters from the following books.
  1. BPEL cookbook
  2. SOA Approach to Integration
  3. Service Oriented Architecture: An Integration Blueprint
  4. Building SOA-Based Composite Applications Using NetBeans IDE 6
  5. Oracle SOA Suite Developer's Guide
  6. WS-BPEL 2.0 for SOA Composite Applications with Oracle SOA Suite 11g
  7. Oracle Modernization Solutions
  8. SOA Governance


You can view the book here.


So what do I think of the book? I think it is a good starter. It gives you an overview of the complete SOA spectrum.

What I like in this book is the theory on the concepts of SOA. A big part of the book is all about the concepts, patterns and models that can be used for various SOA Technologies (BPEL  / Service Bus / Governance). The theory is supported with best practices on the implementation (best-practise).

While this book is not full end-2-end walk in the park on SOA technology, it explains in detail the concepts on SOA. Only if you want to deep-dive into a part of the SOA technology, you should read that particular book.




One other thing I miss in this book, is the Oracle Service Bus. Pack published this year a book on this; Oracle Service Bus 11g Development Cookbook

My tips for Packt; Give this (e)book for free when you buy one of these other books. Based on this book, you will probably buy another one.

Major Memory en CPU improvement on OFM

Mon, 2012-02-27 13:34
The last few weeks we had some strange behaviour on our Oracle Fusion Middleware stack. This was first related to two different SOA 11g production clusters. One 2-node cluster and one 4-node cluster. Both environments run into a Java out-of-memory.

While he have running this production environments for a long time, we thought we have tuned this very well; on database as on application server. As I spoke earlier on Java Garbage collection on http://orasoa.blogspot.com/2011/09/soa-11g-improved-memory-and-garbage.html, and on tuning the SOA Suite 11g; http://orasoa.blogspot.com/2011/08/tuning-soa-11g-in-nutshell.html.

We first thought, it had to do the the applications we made; Composites, Custom Java Classes, Services. Is something changed in the meantime? We also thought it had to do with the amount of data we are processing, is there more data processed than normal? Something changed in the database? The network? The physical storage? All of them were not changed, looking in the program code; we did not find anything special.

We tried to analyse the a heap dump, digged into log files, Oracle Support Bug Database and many-many-other-things. I stared a long time to this

#
# A fatal error has been detected by the Java Runtime Environment:
#
# java.lang.OutOfMemoryError: requested 32756 bytes for ChunkPool::allocate. Out of swap space?
#

The I was triggered by a bug in the Oracle/Sun Java; http://bugs.sun.com/view_bug.do?bug_id=6973402 . For some reason I downloaded the latest Java 1.6 SDK and applied this on one managed server on one the SOA 11g Suite.

The result was amazing!
  • Less CPU
  • Less Heap usage
  • Normal garbage collections
We applied this on our SOA 11g Suite clusters and had no issues.

We see this difference also on de Oracle Service Bus (!).  My advise, roll out Java 1.6.0 build 30 (or later) on your existing production environments, SOA Suite, WebCenter, ServiceBus, etc!


Here are the results of our instance running without Java 1.6.0_b30 and at the bottom with Java 1.6.0_b30. And see the incredible difference. I did not show the CPU graphs with the garbage collections, but those are also different.


Java Heap Before applying Java 1.6.0 Build 30


Java Heap After applying Java 1.6.0 Build 30







Oracle Fusion Middleware PS5 is out

Wed, 2012-02-22 14:00
A short article, but Oracle Fusion Middleware patchset #5 is out! Now downloadble via:

Oracle Partner Event: Málaga 2012 Edition

Thu, 2012-02-09 13:07
In the first half of February 2012, I joined the Oracle Partner Event in Málaga, Spain. This event is organized by Oracle for all partners and special guests. The goal of this event is to learn from each other, between the participators as well with Oracle. We also get the latests information on the Oracle product strategy. The event is split into workshops and presentation sessions. The first two days is all about Oracle strategy, product updates and customers cases. While the last two days the workshops are being executed on SOA Suite, WebCenter and Weblogic.

My goal was to see and talk to my (ex)Oracle colleagues, Development and to get the latest info of the SOA Suite product stack and Weblogic Server. Apart from this networking is key during all these sessions, so I did a lot of chat with the participators to share experience, issues and any other business that comes along.

My focus is off-course Oracle Fusion Middleware and everything that is related to SOA/BPM. Here are some teasers.

Weblogic 12c
Weblogic 12c was announced at Oracle Open World in 2011, and can already be downloaded already. In this session we got in-depth information on all the new features that is currently available and what will come in the next releases.
  • Java EE 6
  • Simplified Deployment
  • Integrated Traffic Management (Exalogic)
  • Enhanced HA and Disaster Recovery
  • Higher Performance (that is default with new releases ;-) )
  • Transactions can also be stored in database
  • Seamless Upgrade (!)
  • Support for Exalogic
  • Support for Oracle Public Cloud

SOA Suite Strategy
Everybody in the SOA community was excited on the SOA and BPM sessions, new features of the upcoming releases where presented. We had sessions on the new PS5 patch set and what will come in the 12c edition, both for SOA and BPM.
  • Enterprise Manager is improved fault analysis
  • Testing BPEL processes from JDeveloper
  • Copy/Paste in JDeveloper of BPEL activities
  • Improved purging (see also purging document with PS5 enhancements)
  • DBAdapter supports coherence
  • Debugging of BPEL processes
  • Templating
  • All consoles integrated in EM (SOA / BPM / OSB)
  • Single IDE for all SOA products
  • ...many many more...
Overall
I am not able to give any details on which functionality comes in which release or even when Oracle will release it. That was the only disappointment of this event, they will not give any dates. I think this will not change in a next event ;-)



Oracle Social Network
This presentation and demo, is off course running in the Cloud, but in this 'product' Oracle integrates a messaging system, with artifacts. In this case Siebel CRM was integrated with Oracle Social Network in such way that everybody can join the conversation; documents can be added, shared, annotations can be made and approvals are send back to Siebel CRM. Everything via social media on any device. This demo shows that business can me made via social media. Except this social media is not run publicly to everybody but in your own organization.

Apart of all the workshops, the global and parallel sessions, there was also time to relax. Oracle organized a dinner with live Andalusian music. We went to a traditional Spanish bodega were we had tapas and drinks. Here is a video to taste the atmosphere.



Here are also some pictures that I have made during this event, this gives you a small impression.


 The Weblogic 12c session from Maciej Gruszka from Oracle Product Development.

 Simone Geib from SOA Product Development during her session on PS5 and 12c.

 Join the social networks of SOA Suite from Oracle Development.

 The old castle of Malaga.

At the central square in Malage, with colorful houses.



AQAdapter: Reset your datasource

Mon, 2012-01-30 09:14

Using the AQ Adapter in a cluster environment, can cost you a lot of temporary tablespace. When you use AQ for dequeuing events and process them further with OSB or SOA Suite, there is always a connection to the database.

This connection is waiting for messages to appear on the Queue (it is subscribed). From middleware perspective everything works fine, data is being dequeued and your proxy-service or composite is running.

But at database level, the session is consuming tablespace. This is the temporary tablespace, so far so good. But if you use this on heavy load for a long time, the temporary space will grow to hundreds of mega or even gigabytes.

To determine how much temp space your sessions are using, you can execute the following SQL:

SELECT 
u.tablespace
, ROUND(((u.blocks*p.value)/1024/1024),2)||'M' "SIZE"
, s.sid||','||s.serial# SID_SERIAL
, s.username
, s.program
, s.machine
, s.logon_time
, Q.NAME
, s.event
FROM
sys.v_$session s
, sys.v_$sort_usage u
, sys.v_$parameter p
, sys.dba_queues q
WHERE p.name = 'db_block_size'
AND a.saddr = b.session_addr
AND a.username = 'SCOTT'
AND a.p1text = 'queue id'
AND a.p1 = q.qid
ORDER BY
a.machine
, u.blocks;

I try to solve this by playing with the AQAdapter settings and de XA-datasource behind it. Non of them fixed the issue. The only way I solved it was by resetting the data-source. On the Internet I find a nice article from Edwin Biemond and refined his script into one I prefer. This is the result:

#
# Usage:
#
# $ORACLE_HOME/common/bin/wlst.sh resetdatasource.py
#
# based on:
# http://biemond.blogspot.com/2010/04/resetting-weblogic-datasources-with-ant.html
#

#
# Crontab:
# 10 1 * * 6 /bin/bash -x /opt/weblogic/Middleware/Oracle_OSB/common/bin/wlst.sh a.py weblogic t@ctwl4cc t3://l2-mslaccadm02:7201 MslDQXaDS >>/data/logs/resetdatasource.log 2>&1
#
import sys
import traceback
import time
import datetime

print 'Started at: ' + str(datetime.datetime.now())
n1 = datetime.datetime.now()

#
# Parse command line paramteres
#
adminUser = sys.argv[1]
adminPassword = sys.argv[2]
adminUrl = sys.argv[3]
datasourceNames = String(sys.argv[4]).split(",")

connect(adminUser, adminPassword, adminUrl)
domainRuntime()

drs = ObjectName("com.bea:Name=DomainRuntimeService,Type=weblogic.management.mbeanservers.domainruntime.DomainRuntimeServiceMBean");
domainconfig = mbs.getAttribute(drs, "DomainConfiguration");
servers = mbs.getAttribute(domainconfig, "Servers");

#
# Loop over servers
for server in servers:
serverName = mbs.getAttribute(server, 'Name')
if serverName == "AdminServer":
print 'Server: ' + serverName + ' skipped!'
else:
print 'Server: ' + serverName
dsBean = ObjectName('com.bea:ServerRuntime=' + serverName + ',Name=' + serverName + ',Location=' + serverName + ',Type=JDBCServiceRuntime')
if dsBean is None:
print 'not found'
else:
datasourceObjects = mbs.getAttribute(dsBean, 'JDBCDataSourceRuntimeMBeans')
#
# Loop over datasources
for datasourceObject in datasourceObjects:
if datasourceObject is None:
print 'datasource not found'
else:
dsName = mbs.getAttribute(datasourceObject,'Name')

#
# Loop over datasource to be reset
for datasourceName in datasourceNames:
if dsName == datasourceName:
print ' Reset: ' + dsName
try:
mbs.invoke(datasourceObject, 'reset', None, None)
except Exception, err:
print 'print_exc():'
traceback.print_exc(file=sys.stdout)
print
print 'print_exc(1):'
traceback.print_exc(limit=1, file=sys.stdout)
else:
print ' Skipped: ' + dsName

n2 = datetime.datetime.now()
print 'Duration: ' + str(n2 - n1)
print 'Finished at: ' + str(datetime.datetime.now())

The script can be scheduled via the crontab on the admin server. The following example starts the script every sunday at 01:10 AM.

10 1 * * 6 /bin/bash -x 
/opt/weblogic/Middleware/Oracle_OSB/common/bin/wlst.sh
/data/scripts/resetdatasource.py weblogic welcome1
t3://myadminserver:7001 MyDQXaDS
>>/data/logs/resetdatasource.log 2>&1

Oracle Service Bus Cookbook

Wed, 2012-01-25 05:37
Former Oracle collegueus and business parnerts wrote a nice cok book on the usages of Oracle Service Bus. The book is full of examples and guide you through the working and usage of the Oracle Service Bus. The is very technical of useful for developers who just ant to start the OSB. Experienced developers will use this book for the complete examples on the different technologies using OSB, such as JMS, EJB.

When you use this book, it is expected that you understand the concepts of XML, XLST, WSDL, WebServices, JMS and SOAP and basic knowledge of SQL. This is not explained in the book. Which is a advantage! Refer to the w3schools for such things.



You can obtain it via Packt Publishing.

Some subjects I miss in the book; best practice on execption handing, throtteling, deployment.

The examples in the book are based Oracle Service Bus patch set #3, but can also be used on top of patch set #4. This release is already available since august 2010. Why didn't' the authors use this version? I expect that the examples in the book can also be applied on the upcoming patch set release #5.


Meet me @ Oracle Partner Event Partner Community Forum – February 7th & 8th 2012, Malaga Spain

Tue, 2012-01-10 07:34
I will join the OPN Forum in Malaga Spain, on February 7th & 8th 2012. If you want to join just click on the link:



In this event you will meet other fellows on related stuff on Weblogic 12c, BPM, SOA, ADF and Webcenter.


  • learn how to sell the value of Fusion Middleware by combining SOA, BPM, WebCenter and WebLogic solutions
  • meet with Oracle SOA, BPM, WebCenter and WebLogic Product Management
  • exchange knowledge and have access to competitive intelligence
  • learn from successful SOA, BPM, WebCenter and WebLogic implementations
  • learn about WebCenter Sites and WebLogic12c
  • network within the Oracle SOA & BPM Partner Community, the Oracle WebCenter Partner Community and the Oracle WebLogic Partner Community

OWSM: Loading private and public certifcates

Mon, 2011-12-12 08:30
As written in my blog article on SSL, handling certificates is not easy. One of the goals I had was to load a public and private certificate into a JKS key-store. With tools such as keytool and openssl, this is not possible. After struggeling a few hours, I managed to fix this. This is how I did it.

You have two files, one public key and one private key; vijfhuizen_pub.pem, vijfhuizen_prv.pem. Based on these files, you can load the keystore as follows:
  • Convert the keys into DER format.
  • Load the DER files into a new keystore via Java.
Example:
openssl x509 -in vijfhuizen-pub.pem -inform PEM -out vijfhuizen-pub.crt -outform DER

openssl pkcs8 -topk8 -nocrypt -in vijfhuizen-prv.pem -inform PEM -out vijfhuizen-prv.crt -outform DER

java ImportKey -prikey vijfhuizen-prv.crt -signed vijfhuizen-pub.crt -alias vijfhuizen -keypass changeit -store vijfhuizen.jks

De Java Class has the following options:
java ImportKey
Usage

java ImportKey -alias alias -prikey file.der -signed cert.der -keypass pas1 -storepass pas2
java ImportKey -alias alias -prikey file.der -signed cert.der -keypass pas1 -store file.jks -storepass pas2

Description

Store DER key and signed certificate into user's home key store, or into the key
store file specified by the STORE parameter.

The Java  code can be download here.

OSB: Deployment issues with DBAdapter

Wed, 2011-11-16 02:05
In normal circumstances changing the configuration of the DBAdapter should work. You create a JDBC datasource and create in the outbound connections of the DbAdpater a new JNDI entry. After saving your settings you should update the DBAdapter application and apply the changes. Normally you see:





Here is the issue I was struggeling with. I created a new JNDI entry in the DBAdapter, applied the changes, deployed the Plan.xml files, updated the DBAdapter. I saw that the managed servers did not picked up the new change or even the old entries.

After a while I fixed the issue. This was related due to the fact the DbAdapter was also targed to the AdminServer. So here are the steps to update or add new JNDI entries in the DbAdapter application or any other, AqAdapter or FileAdapter.
  1. Update/Add JNDI entry in your outbound connections of the Adapter.
  2. Save the changes.
  3. Bring down the Managed Servers.
  4. Update the Adapter application.
  5. Bring down the Admin Server.
  6. Copy the Plan.xml file of the Adapter to the managed servers.
  7. Start the AdminServer.
  8. Start the managed servers.
This solution is strange, because you expect that Weblogic should do this while the AdminServer and Managed Servers are running. But in my case this was a working solution.

To create and deploy your own Adapters can be found @Edwin Biemond's Blog.





OSB: AdminServer spinning 100% CPU

Sat, 2011-10-15 13:37
Sometimes for no reason, or I did not find a reason..., the AdminServer is spinning into 100% CPU. Communication is impossible; deployment is failing or take a long time (hours...), Console will not start, etc.

The log files of the AdminServer will not give you a hint on this behavior. It will tell you that memory is reaching 100%:

AdminServer.log: reaching out of memory
Kill the AdminServer process and starting the AdminServer again, will not solve the issue. After a time the AdminServer is at 100% and communication is not possible.

A solution that worked for a short time was:
kill AdminServer process
delete all files and directories from the AdminServer:

cd $WLS_DOMAIN/servers/
cp -rv AdminServer/security .
rm -rf AdminServer/*
mv security AdminServer

Start the AdminServerThis solution resulted taht teh AdminServer was up and running, I could connect to the Service Bus console and the normal console. But when I started a deployment of new services, the AdminServer spinned into 100%.

After searching the log files and investigating why this suddenly happened, it did not occur on other environments, I did something radical. I removed all the OSB artifacts that were installed on the the AdminServer.

stop AdminServer
stop all the managed servers
cd $WLS_DOMAIN/osb
rm -rf * start AdminServerNow the AdminServer is up and running very quickly. Due to the fact there are now services deployed.
Start a deployment of services to the AdminSerer
After deployment, start all the managed services.This workarround works! The AdminServer is not spinning anymore, reacts fast on the consoles.




SOA 11g: Improved Memory and Garbage Consumption

Tue, 2011-09-13 09:43
There is a huge difference in memory consumption when you run SOA11g (PS4 in my case). The screens are based on a full-production clustered environment. One node is running with sub-optimal settings, while the other node is running optimal settings. A load-balancer is equally spreading the requests to the nodes.

Running SOA 11g on VMWare, 1 CPU and 3GB memory, with the options:

-Xms1280m
-Xmx1280m
-XX:MaxPermSize=512m
-XX:+UseParallelGC



Running SOA 11g on VMWare, 1 CPU and 3GB memory, with the options:

-Xms1280m
-Xmx1280m
-XX:MaxPermSize=512m
-Xss256k
-XX:+UseConcMarkSweepGC
-XX:+UseParNewGC
-XX:+CMSIncrementalMode
-XX:+CMSIncrementalPacing



The last XX options shows that the memory consumption is dramaticlly lower and garbage collection is lower but frequenter.

Purging OSB Report data

Mon, 2011-09-12 04:18
Deleting report data generated by Oracle Service Bus (OSB) can be done via the Service Bus console.

Make sure you have deployed the " Message Reporting Purger " application. By default the application is set to new, so it is not active. Inititially start this application for requests.



Purging can done be done via the Console.

If you want to purge the data directly in the database, execute the following SQL.

delete from wli_qs_report_data rd
where exists
(
  select 'x'
  from wli_qs_report_attribute ra
  where ra.msg_guid = rd.msg_guid
  and ra.db_timestamp &lt; trunc(sysdate) - 7
);

delete from wli_qs_report_attribute ra
where ra.db_timestamp &lt; trunc(sysdate) - 7;

alter table wli_qs_report_data deallocate unused;
alter table wli_qs_report_data enable row movement;
alter table wli_qs_report_data shrink space compact;

alter table wli_qs_report_attribute deallocate unused;
alter table wli_qs_report_attribute enable row movement;
alter table wli_qs_report_attribute shrink space compact;

Tuning SOA 11g in a nutshell

Sun, 2011-08-21 09:19

Tuning SOA 11g can be done in a few quick steps, this will tackle most common performance issues at infrastructure level. On the other hand, most performance issues are in the application (composite) self. If you design a bad application, the application will not perform well.

I did my tuning on the following subjects:
  • JVM Memory
  • JVM Garbage Collection
  • Datasources
  • Threads
  • EJB
  • Database

JVM Memory
Make sure you have set the minimal and maximal heap size the same size. The size should be at least 1024MB.
Make sure the maxpermsize parameter is set to at least 512MB. In most cases requests in the SOA world are relative small, this means you could shrink the size of the stack for one Java thread.

Example:

-server -Xms1280m -Xmx1280m -XX:MaxPermSize=512m -Xss128k


JVM Garbage Collection
Running your application server with one CPU, you would not expect enhanchments by setting garbage collection to parallel. On VMWare we saw some significant improvement when we set this option even the virtual machine has one CPU. I think it has to do with the hyper-visor and the ESX Server. Somehow the virtual machine benefits from the ESX environment.

Example:

-XX:-UseParallelGC -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+CMSIncrementalMode -XX:+CMSIncrementalPacing  

JMX
Setting some JMX options will not improve the performance, but it gives you insight information on the Java VM. If you not using JROckit your could set the following options and use VisualVM to view the Java engine.

-Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=7004 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false 

http://orasoa.blogspot.com/2010/04/monitoring-your-soa-jvm.html



Otherwise your JRockit Mission Control to get more information out of your Java VM.

Data-sources
Using the correct settings for all the connections to your database is essential. The SOA Suite is using  a lot of data-sources, while the OSB is using one data-source for the reports. Measure your connections to the database while running a load test on your environment. Based on these measurements you can predict the correct configuration.

The following table shows an example of the settings your should tune. Note that the values are based on my measurements on a particular system. These settings should be applied via the Weblogic Console or through Weblogic scripting.


   

DatasourcesEDNDataSourceEDNLocalTxDataSourcemds-owsmmds-soaOraSDPMDataSourceSOADataSourceSOALocalTxDataSource
Hostdb-hostdb-hostdb-hostdb-hostdb-hostdb-hostdb-host
Port1521152115211521152115211521
SIDorclorclorclorclorclorclorcl
TypeXAnon-XAnon-XAnon-XAnon-XAXAnon-XA
Initial Capacity:1111122
Maximum Capacity:10101010102020
Capacity Increment:2222222
Statement Cache Size:10101010101010
Test Connections On ReserveTRUETRUETRUETRUETRUETRUETRUE
Test Frequency:180180180180180180180
Seconds to Trust an Idle Pool Connection:30303030303030
Shrink Frequency:300300300300300300300
Connection Creation Retry Frequency:30303030303030
Inactive Connection Timeout:30303030303030
Maximum Waiting for Connection:2147483647214748364721474836472147483647214748364721474836472147483647
Connection Reserve Timeout: 30303030303030
Statement Timeout:-1-1-1-1-1-1-1
Enviroment
oracle.net.CONNECT_TIMEOUT100000100000100000100000100000100000100000
Set XA Transaction Timeout:TRUETRUE
XA Transaction Timeout:00
XA Retry Duration:300300
XA Retry Interval:6060

Threads
Do not touch the default threading model of Weblogic, unless you known what your are doing. Weblogic is using an automated mechanism for tuning his own work. WebLogic Server prioritizes work and allocates threads based on an execution model that takes into the managed servers parameters and actual run-time statistics (performance and throughput).

Within the SOA Suite 11g, you can still tune the threads of the BPEL engine itself. Keep in meind that these thread will use a database connection from the pool. It is not said that the total number of BPEL threads results in the same amount of connection to the database. You can set these values via Oracle Enterprise manager

 	

dspInvokeThread10
dspEngineThreads15
dspSystemThreads2


synMaxWaitTime150

EJB
The  soa-infra application contains all the EJB objects that are responsible for SOA11g (BPEL, Workflow, BPM, Sensors, Mediators, etc..). Each of these EJB objects has his own time out. By default it is 300 seconds. When you have long running process, also known as not optimal designed and implemented SOA Composites ;-) , you could run into time-out errors that could slow down the whole SOA environment. Therefore your should design and implement efficicient and optimal composites.

To change the time-out of the EJB's, execute the following steps.
  1. Stop all the managed servers
  2. Apply the EJB time-out changes
  3. Start the managed servers
or
  1. Stop all the managed servers
  2. Undeploy the soa-infra application
  3. Activate changes
  4. Deploy the soa-infra application from $ORACLE_HOME/soa/applications/soa-infra-wls.ear, as 'soa-infra' and copy application to all servers in the cluster
  5. Activate changes
  6. Redeploy soa-infra application with configuration file (Plan.xml) with all the new EJB time-ou settings.
  7. Activate changes
  8. Start soa-infra applicatio to server all requests.
Here is the configuration file for the soa-infra application, Plan.xml file:
Plan.xml:

<?xml version='1.0' encoding='UTF-8'?>
<deployment-plan xmlns="http://xmlns.oracle.com/weblogic/deployment-plan" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/weblogic/deployment-plan http://xmlns.oracle.com/weblogic/deployment-plan/1.0/deployment-plan.xsd">
<application-name>applications</application-name>
<variable-definition>
<variable>
<name>TransactionDescriptor_transTimeoutSeconds_BPELEngineBean</name>
<value>1800</value>
</variable>
<variable>
<name>TransactionDescriptor_transTimeoutSeconds_BPELDeliveryBean</name>
<value>1800</value>
</variable>
<variable>
<name>TransactionDescriptor_transTimeoutSeconds_BPELActivityManagerBean</name>
<value>1800</value>
</variable>
<variable>
<name>TransactionDescriptor_transTimeoutSeconds_BPELServerManagerBean</name>
<value>1800</value>
</variable>
<variable>
<name>TransactionDescriptor_transTimeoutSeconds_BPELProcessManagerBean</name>
<value>1800</value>
</variable>
<variable>
<name>TransactionDescriptor_transTimeoutSeconds_BPELInstanceManagerBean</name>
<value>1800</value>
</variable>
<variable>
<name>TransactionDescriptor_transTimeoutSeconds_BPELFinderBean</name>
<value>1800</value>
</variable>
<variable>
<name>TransactionDescriptor_transTimeoutSeconds_BPELDispatcherBean</name>
<value>1800</value>
</variable>
<variable>
<name>TransactionDescriptor_transTimeoutSeconds_BPELSensorValuesBean</name>
<value>1800</value>
</variable>
</variable-definition>
<module-override>
<module-name>soa-infra-wls.ear</module-name>
<module-type>ear</module-type>
<module-descriptor external="false">
<root-element>weblogic-application</root-element>
<uri>META-INF/weblogic-application.xml</uri>
</module-descriptor>
<module-descriptor external="false">
<root-element>application</root-element>
<uri>META-INF/application.xml</uri>
</module-descriptor>
<module-descriptor external="true">
<root-element>wldf-resource</root-element>
<uri>META-INF/weblogic-diagnostics.xml</uri>
</module-descriptor>
<module-descriptor external="true">
<root-element>persistence-configuration</root-element>
<uri>bpel_persistence_weblogic.jar!/META-INF/persistence-configuration.xml</uri>
</module-descriptor>
<module-descriptor external="false">
<root-element>persistence</root-element>
<uri>bpel_persistence_weblogic.jar!/META-INF/persistence.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>ejb_ob_engine_wls.jar</module-name>
<module-type>ejb</module-type>
<module-descriptor external="false">
<root-element>weblogic-ejb-jar</root-element>
<uri>META-INF/weblogic-ejb-jar.xml</uri>
<variable-assignment>
<name>TransactionDescriptor_transTimeoutSeconds_BPELEngineBean</name>
<xpath>/weblogic-ejb-jar/weblogic-enterprise-bean/[ejb-name="BPELEngineBean"]/transaction-descriptor/trans-timeout-seconds</xpath>
</variable-assignment>
<variable-assignment>
<name>TransactionDescriptor_transTimeoutSeconds_BPELDeliveryBean</name>
<xpath>/weblogic-ejb-jar/weblogic-enterprise-bean/[ejb-name="BPELDeliveryBean"]/transaction-descriptor/trans-timeout-seconds</xpath>
</variable-assignment>
<variable-assignment>
<name>TransactionDescriptor_transTimeoutSeconds_BPELActivityManagerBean</name>
<xpath>/weblogic-ejb-jar/weblogic-enterprise-bean/[ejb-name="BPELActivityManagerBean"]/transaction-descriptor/trans-timeout-seconds</xpath>
</variable-assignment>
<variable-assignment>
<name>TransactionDescriptor_transTimeoutSeconds_BPELServerManagerBean</name>
<xpath>/weblogic-ejb-jar/weblogic-enterprise-bean/[ejb-name="BPELServerManagerBean"]/transaction-descriptor/trans-timeout-seconds</xpath>
</variable-assignment>
<variable-assignment>
<name>TransactionDescriptor_transTimeoutSeconds_BPELProcessManagerBean</name>
<xpath>/weblogic-ejb-jar/weblogic-enterprise-bean/[ejb-name="BPELProcessManagerBean"]/transaction-descriptor/trans-timeout-seconds</xpath>
</variable-assignment>
<variable-assignment>
<name>TransactionDescriptor_transTimeoutSeconds_BPELInstanceManagerBean</name>
<xpath>/weblogic-ejb-jar/weblogic-enterprise-bean/[ejb-name="BPELInstanceManagerBean"]/transaction-descriptor/trans-timeout-seconds</xpath>
</variable-assignment>
<variable-assignment>
<name>TransactionDescriptor_transTimeoutSeconds_BPELFinderBean</name>
<xpath>/weblogic-ejb-jar/weblogic-enterprise-bean/[ejb-name="BPELFinderBean"]/transaction-descriptor/trans-timeout-seconds</xpath>
</variable-assignment>
<variable-assignment>
<name>TransactionDescriptor_transTimeoutSeconds_BPELDispatcherBean</name>
<xpath>/weblogic-ejb-jar/weblogic-enterprise-bean/[ejb-name="BPELDispatcherBean"]/transaction-descriptor/trans-timeout-seconds</xpath>
</variable-assignment>
<variable-assignment>
<name>TransactionDescriptor_transTimeoutSeconds_BPELSensorValuesBean</name>
<xpath>/weblogic-ejb-jar/weblogic-enterprise-bean/[ejb-name="BPELSensorValuesBean"]/transaction-descriptor/trans-timeout-seconds</xpath>
</variable-assignment>
</module-descriptor>
<module-descriptor external="false">
<root-element>ejb-jar</root-element>
<uri>META-INF/ejb-jar.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>fabric-ejb.jar</module-name>
<module-type>ejb</module-type>
<module-descriptor external="false">
<root-element>weblogic-ejb-jar</root-element>
<uri>META-INF/weblogic-ejb-jar.xml</uri>
</module-descriptor>
<module-descriptor external="false">
<root-element>ejb-jar</root-element>
<uri>META-INF/ejb-jar.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>hw_services_wls_ejb.jar</module-name>
<module-type>ejb</module-type>
<module-descriptor external="false">
<root-element>weblogic-ejb-jar</root-element>
<uri>META-INF/weblogic-ejb-jar.xml</uri>
</module-descriptor>
<module-descriptor external="false">
<root-element>ejb-jar</root-element>
<uri>META-INF/ejb-jar.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>sdpmessagingclient-ejb.jar</module-name>
<module-type>ejb</module-type>
<module-descriptor external="false">
<root-element>weblogic-ejb-jar</root-element>
<uri>META-INF/weblogic-ejb-jar.xml</uri>
</module-descriptor>
<module-descriptor external="false">
<root-element>ejb-jar</root-element>
<uri>META-INF/ejb-jar.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>b2b_engine_wls.jar</module-name>
<module-type>ejb</module-type>
<module-descriptor external="false">
<root-element>weblogic-ejb-jar</root-element>
<uri>META-INF/weblogic-ejb-jar.xml</uri>
</module-descriptor>
<module-descriptor external="false">
<root-element>ejb-jar</root-element>
<uri>META-INF/ejb-jar.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>fabric.war</module-name>
<module-type>war</module-type>
<module-descriptor external="false">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>hw_services.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170529</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>taskservice.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170530</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>taskmetadataservice.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170531</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>taskqueryservice.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170532</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>taskreportservice.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170533</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>IdentityService.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170533</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>usermetadataservice.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170528</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>runtimeconfigservice.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170527</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>taskevidenceservice.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170526</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>compositemetadataservice.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170525</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>b2bws.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170524</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
<module-descriptor external="false">
<root-element>weblogic-webservices</root-element>
<uri>WEB-INF/weblogic-webservices.xml</uri>
</module-descriptor>
<module-descriptor external="false">
<root-element>webservices</root-element>
<uri>WEB-INF/webservices.xml</uri>
</module-descriptor>
<module-descriptor external="true">
<root-element>webservice-policy-ref</root-element>
<uri>WEB-INF/weblogic-webservices-policy.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>b2b_starter_wls.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170509</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>agmetadataservice.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170508</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>agqueryservice.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170499</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<module-override>
<module-name>agadminservice.war</module-name>
<module-type>war</module-type>
<module-descriptor external="true">
<root-element>weblogic-web-app</root-element>
<uri>WEB-INF/weblogic.xml</uri>
<hash-code>1278926170497</hash-code>
</module-descriptor>
<module-descriptor external="false">
<root-element>web-app</root-element>
<uri>WEB-INF/web.xml</uri>
</module-descriptor>
</module-override>
<config-root>/opt/weblogic/Oracle/Middleware/KIM_SOA/soa/applications/plan</config-root>
</deployment-plan>

Set the following time-out of the EJB's:

	 	

BPEL/EJB properties Timeout
BPELActivityManagerBean 1800
BPELDeliveryBean 1800
BPELDispatcherBean 1800
BPELEngineBean 1800
BPELFinderBean 1800
BPELInstanceManagerBean 1800
BPELProcessManagerBean 1800
BPELSensorValuesBean 1800
BPELServerManagerBean 1800

Verify the the global transaction time out on all the managed servers is larger then the time out of the EJB. Set the global transaxtion time-out, JTA, to 3600.

Database 
To tune the dabatase, make sure that you follow the requirements of the SOA Suite 11g, make sure you can create enough process and session to the database. The database must be tuned, so the it has enough memory for caching, PGA, SGA memory should be adequate.

Make sure your have the purging scripts place. And verify if you have added an index to the SOA dehydration tables.

References



Pages