Marc Kelderman
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: 17 hours 42 min ago
Changing SOA properties via WLST
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.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
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:
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
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
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
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.
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
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
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
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.
"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
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;
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.
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
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
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.
Reference: Weblogic MBean Documentation
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
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
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.
- BPEL cookbook
- SOA Approach to Integration
- Service Oriented Architecture: An Integration Blueprint
- Building SOA-Based Composite Applications Using NetBeans IDE 6
- Oracle SOA Suite Developer's Guide
- WS-BPEL 2.0 for SOA Composite Applications with Oracle SOA Suite 11g
- Oracle Modernization Solutions
- SOA Governance
You can view the book here.