Marc Kelderman

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)

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:

• Weblogic http://docs.oracle.com/cd/E23943_01/relnotes.htm
• SOA Suite http://www.oracle.com/technetwork/middleware/docs/aiasoarelnotesps6-1866030.html
•  Service Bus http://www.oracle.com/technetwork/middleware/docs/aiasoarelnotesps6-1866030.html
• AIA http://www.oracle.com/technetwork/middleware/docs/aiasoarelnotesps6-1866030.html
• JDeveloper: http://www.oracle.com/technetwork/developer-tools/jdev/default-1399172.html

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

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

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.

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.

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

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;

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.