public static String getThisServerThreadPoolHealth() throws Exception {
MBeanServerConnection connection = initConnection();
ObjectName runtimeService = new ObjectName("com.bea:Name=RuntimeService,Type=weblogic.management.mbeanservers.runtime.RuntimeServiceMBean");
String managedServerName = (String) connection.getAttribute(runtimeService, "ServerName");
ObjectName serverRT = new ObjectName("com.bea:Name=" + managedServerName + ",Type=ServerRuntime");
System.out.println("serverRT=" + serverRT);
ObjectName serverTP = (ObjectName)connection.getAttribute(serverRT, "ThreadPoolRuntime");
weblogic.health.HealthState tpHealthState = (weblogic.health.HealthState) connection.getAttribute(serverTP, "HealthState");
return healthStateToString(tpHealthState.getState());
}
import javax.management.MBeanServer;
....
InitialContext ctx = new InitialContext();
MBeanServer server = (MBeanServer)ctx.lookup("java:comp/env/jmx/runtime");
package tests.monitoring;
import javax.management.MBeanServer;
import javax.management.MBeanServerConnection;
import javax.management.MalformedObjectNameException;
import javax.management.ObjectName;
import javax.management.remote.JMXConnector;
import javax.naming.InitialContext;
import javax.naming.NamingException;
public class ServerHealthStateMonitorLocal {
private static MBeanServerConnection connection;
private static JMXConnector connector;
private static ObjectName service;
private static String combea = "com.bea:Name=";
private static String service1 = "DomainRuntimeService,Type=weblogic.management.mbeanservers.domainruntime.DomainRuntimeServiceMBean";
public static void initConnection() throws NamingException, MalformedObjectNameException, NullPointerException {
service = new ObjectName(combea + service1);
InitialContext ctx = new InitialContext();
MBeanServer server = (MBeanServer)ctx.lookup("java:comp/jmx/runtime");
connection = server;
System.out.println("connection = " + connection);
}
public static ObjectName[] getServerRuntimes() throws Exception {
if (connection == null) {
System.out.println("null connection");
}
return (ObjectName[]) connection.getAttribute(service, "ServerRuntimes");
}
public void printNameAndState() throws Exception {
ObjectName arr[] = getServerRuntimes();
for (ObjectName temp : arr)
System.out.println("\n\t servers: " + temp);
ObjectName domain = (ObjectName) connection.getAttribute(service, "DomainConfiguration");
System.out.println("Domain: " + domain.toString());
ObjectName[] servers = (ObjectName[]) connection.getAttribute(domain, "Servers");
for (ObjectName server : servers) {
String aName = (String) connection.getAttribute(server, "Name");
try {
ObjectName ser = new ObjectName("com.bea:Name=" + aName + ",Location=" + aName + ",Type=ServerRuntime");
String serverState = (String) connection.getAttribute(ser, "State");
System.out.println("\n\t Server: " + aName + "\t State: " + serverState);
weblogic.health.HealthState serverHealthState = (weblogic.health.HealthState) connection.getAttribute(ser, "HealthState");
int hState = serverHealthState.getState();
if (hState == weblogic.health.HealthState.HEALTH_OK)
System.out.println("\t Server: " + aName + "\t State Health: HEALTH_OK");
if (hState == weblogic.health.HealthState.HEALTH_WARN)
System.out.println("\t Server: " + aName + "\t State Health: HEALTH_WARN");
if (hState == weblogic.health.HealthState.HEALTH_CRITICAL)
System.out.println("\t Server: " + aName + "\t State Health: HEALTH_CRITICAL");
if (hState == weblogic.health.HealthState.HEALTH_FAILED)
System.out.println("\t Server: " + aName + "\t State Health: HEALTH_FAILED");
if (hState == weblogic.health.HealthState.HEALTH_OVERLOADED)
System.out.println("\t Server: " + aName + "\t State Health: HEALTH_OVERLOADED");
} catch (javax.management.InstanceNotFoundException e) {
System.out.println("\n\t Server: " + aName + "\t State: SHUTDOWN (or Not Reachable)");
}
}
}
public static void main(String[] args) throws Exception {
printHealthStatus();
}
public static void printHealthStatus() throws Exception {
ServerHealthStateMonitorLocal s = new ServerHealthStateMonitorLocal();
initConnection();
s.printNameAndState();
connector.close();
}
}
HEALTH_OK 0 HEALTH_WARN 1 HEALTH_CRITICAL 2 HEALTH_FAILED 3 HEALTH_OVERLOADED 4
package tests.monitoring;
import javax.management.MBeanServer;
import javax.management.MBeanServerConnection;
import javax.management.ObjectName;
import javax.naming.InitialContext;
public class ServerHealthStateMonitorLocal {
public static MBeanServerConnection initConnection() throws Exception {
MBeanServerConnection connection;
System.out.println("initConnection");
InitialContext ctx = new InitialContext();
System.out.println("ctx");
try {
connection = (MBeanServer) ctx.lookup("java:comp/env/jmx/runtime");
}
catch (Exception e) {
e.printStackTrace();
try {
connection = (MBeanServer) ctx.lookup("java:comp/jmx/runtime");
}
catch (Exception e2) {
e2.printStackTrace();
throw e2;
}
}
System.out.println("connection=" + connection);
return connection;
}
private static ObjectName getServerRuntime(MBeanServerConnection connection, String aName) throws Exception {
System.out.println("getServerRuntime");
ObjectName serverObjectName = new ObjectName("com.bea:Name=" + aName + ",Type=ServerRuntime");
return (ObjectName) connection.getAttribute(serverObjectName, "ServerRuntime");
}
public static String getHealthOfThisServer() throws Exception {
ServerHealthStateMonitorLocal s = new ServerHealthStateMonitorLocal();
MBeanServerConnection connection = initConnection();
String serverName = System.getProperty("weblogic.Name");
return s.getHealthOfServer(serverName);
}
private String getHealthOfServer(String aName) throws Exception {
String result = "NOT_FOUND";
MBeanServerConnection connection = initConnection();
ObjectName ser = getServerRuntime(connection, aName);
String serverState = (String) connection.getAttribute(ser, "State");
result = serverState;
weblogic.health.HealthState serverHealthState = (weblogic.health.HealthState) connection.getAttribute(ser, "HealthState");
int hState = serverHealthState.getState();
result = result + "_" + hState;
return result;
}
public static String getThisServerName() throws Exception {
ServerHealthStateMonitorLocal s = new ServerHealthStateMonitorLocal();
MBeanServerConnection connection = initConnection();
ObjectName runtimeService = new ObjectName("com.bea:Name=RuntimeService,Type=weblogic.management.mbeanservers.runtime.RuntimeServiceMBean");
String managedServerName = (String) connection.getAttribute(runtimeService, "ServerName");
return managedServerName;
/*
ObjectName msServerRuntime = new ObjectName("com.bea:Name="+ managedServerName + ",Type=ServerRuntime");
administrationURL = (String) mBeanServer.getAttribute(msServerRuntime, "AdminServerHost");
adminPort = (Integer) mBeanServer.getAttribute(msServerRuntime, "AdminServerListenPort");
System.out.println(administrationURL + adminPort);
*/
}
public static String getThisServerState() throws Exception {
MBeanServerConnection connection = initConnection();
ObjectName runtimeService = new ObjectName("com.bea:Name=RuntimeService,Type=weblogic.management.mbeanservers.runtime.RuntimeServiceMBean");
System.out.println("runtimeService=" + runtimeService);
ObjectName serverRT = (ObjectName) connection.getAttribute(runtimeService, "ServerRuntime");
System.out.println("serverRT=" + serverRT);
String serverState = (String) connection.getAttribute(serverRT, "State");
return serverState;
}
public static String getThisServerHealth() throws Exception {
MBeanServerConnection connection = initConnection();
ObjectName runtimeService = new ObjectName("com.bea:Name=RuntimeService,Type=weblogic.management.mbeanservers.runtime.RuntimeServiceMBean");
String managedServerName = (String) connection.getAttribute(runtimeService, "ServerName");
ObjectName serverRT = new ObjectName("com.bea:Name=" + managedServerName + ",Type=ServerRuntime");
System.out.println("serverRT=" + serverRT);
weblogic.health.HealthState serverHealthState = (weblogic.health.HealthState) connection.getAttribute(serverRT, "HealthState");
return healthStateToString(serverHealthState.getState());
}
private static String healthStateToString(int state) {
String result = "HEALTH_UNKNOWN";
switch (state) {
case 0:
result = "HEALTH_OK";
break;
case 1:
result = "HEALTH_WARN";
break;
case 2:
result = "HEALTH_CRITICAL";
break;
case 3:
result = "HEALTH_FAILED";
break;
case 4:
result = "HEALTH_OVERLOADED";
break;
default:
break;
}
return result;
}
}
<?xml version='1.0' encoding='UTF-8'?>
<jdbc-data-source xmlns="http://xmlns.oracle.com/weblogic/jdbc-data-source" xmlns:sec="http://xmlns.oracle.com/weblogic/security" xmlns:wls="http://xmlns.oracle.com/weblogic/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/weblogic/jdbc-data-source http://xmlns.oracle.com/weblogic/jdbc-data-source/1.0/jdbc-data-source.xsd">
<name>SOADataSource</name>
<jdbc-driver-params>
<url>jdbc:oracle:thin:@acme.com:1551:dosb01</url>
<driver-name>oracle.jdbc.OracleDriver</driver-name>
<properties>
<property>
<name>user</name>
<value>pl1_soainfra</value>
</property>
</properties>
<password-encrypted>{AES}hJ3eMa5bAzP8Oq1LbGMN+ZsUAWDCErZYuiBTfi2S2vg=</password-encrypted>
</jdbc-driver-params>
<jdbc-connection-pool-params>
<test-table-name>SQL SELECT 1 FROM DUAL</test-table-name>
</jdbc-connection-pool-params>
<jdbc-data-source-params>
<jndi-name>jdbc/SOALocalTxDataSource</jndi-name>
</jdbc-data-source-params>
</jdbc-data-source>
import getopt
env = None
password = None
list = None
opts, args = getopt.getopt(sys.argv[1:], "e:p:l:")
for opt, arg in opts:
print opt, arg
if opt in "-e":
env = arg
if opt in "-p":
password = arg
if opt in "-l":
list = arg
print "env", env
print "password", password
print "list", list
if password is None:
print "missing argument password"
. /opt/oracle/domains/osbpl2do/bin/setDomainEnv.sh
java weblogic.WLST
#Pierluigi is member of the group "Administrators"
connect('Pierluigi', 'weblogic1', 't3://acme.com:7101')
domainRuntime()
SessionMBean = findService("SessionManagement", "com.bea.wli.sb.management.configuration.SessionManagementMBean")
print SessionMBean
[MBeanServerInvocationHandler]com.bea:Name=SessionManagement,Type=com.bea.wli.sb.management.configuration.SessionManagementMBean
sessionName='pippo'
SessionMBean.createSession(sessionName)
SessionMBean.discardSession(sessionName)
#Praveen is member of no group
disconnect()
connect('Praveen', 'weblogic1', 't3://acme.com:7101')
domainRuntime()
SessionMBean = findService("SessionManagement", "com.bea.wli.sb.management.configuration.SessionManagementMBean")
print SessionMBean
[MBeanServerInvocationHandler]com.bea:Name=SessionManagement,Type=com.bea.wli.sb.management.configuration.SessionManagementMBean
sessionName='pippo3'
SessionMBean.createSession(sessionName)
Traceback (innermost last):
File "", line 1, in ?
at weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:234)
at weblogic.rmi.internal.BasicRemoteRef.invoke(BasicRemoteRef.java:223)
at javax.management.remote.rmi.RMIConnectionImpl_1035_WLStub.invoke(Unknown Source)
at weblogic.management.remote.common.RMIConnectionWrapper$16.run(ClientProviderBase.java:919)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
at weblogic.security.Security.runAs(Security.java:61)
at weblogic.management.remote.common.RMIConnectionWrapper.invoke(ClientProviderBase.java:917)
at javax.management.remote.rmi.RMIConnector$RemoteMBeanServerConnection.invoke(RMIConnector.java:993)
at weblogic.management.jmx.MBeanServerInvocationHandler.doInvoke(MBeanServerInvocationHandler.java:544)
at weblogic.management.jmx.MBeanServerInvocationHandler.invoke(MBeanServerInvocationHandler.java:380)
at $Proxy15.createSession(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
weblogic.management.NoAccessRuntimeException: weblogic.management.NoAccessRuntimeException: Access not allowed for subject: principals=[Praveen], on ResourceType: com.bea.wli.sb.management.configuration.SessionManagementMBean Action: execute, Target: createSession
package com.pierre.osb.doc;
import java.util.Hashtable;
import java.util.Set;
import javax.management.JMX;
import javax.management.MBeanServerConnection;
import javax.management.ObjectName;
import javax.management.remote.JMXConnector;
import javax.management.remote.JMXConnectorFactory;
import javax.management.remote.JMXServiceURL;
import javax.naming.Context;
import weblogic.management.mbeanservers.domainruntime.DomainRuntimeServiceMBean;
import com.bea.wli.config.Ref;
import com.bea.wli.sb.management.configuration.ALSBConfigurationMBean;
import com.bea.wli.sb.management.configuration.SessionManagementMBean;
public class ListProjects {
String hostname = "acme.com";
int port = 7001;
String username = "Pierluigi";
String password = "weblogic1";
public static void main(String[] args) throws Exception {
ListProjects listProjects = new ListProjects();
listProjects.display();
}
public void display() throws Exception {
JMXServiceURL serviceURL = new JMXServiceURL("t3", hostname, port, "/jndi/" + DomainRuntimeServiceMBean.MBEANSERVER_JNDI_NAME);
Hashtable<String, String> h = new Hashtable<String, String>();
h.put(Context.SECURITY_PRINCIPAL, username);
h.put(Context.SECURITY_CREDENTIALS, password);
h.put(JMXConnectorFactory.PROTOCOL_PROVIDER_PACKAGES, "weblogic.management.remote");
JMXConnector conn = JMXConnectorFactory.connect(serviceURL, h);
System.out.println("connected");
try {
System.out.println("Opened JMX connection to " + hostname + ":" + port + " as " + username);
// get mbean connection
MBeanServerConnection mbconn = conn.getMBeanServerConnection();
// Get SessionmanagementMBean
SessionManagementMBean sm =
JMX.newMBeanProxy(mbconn, ObjectName.getInstance(SessionManagementMBean.OBJECT_NAME), SessionManagementMBean.class);
// Create a session
String sessionName = "MySession";
sm.createSession(sessionName);
// Get the configuration MBean for the session, do stuff, and then discard the session.
try
{
System.out.println("Session exists? : " + sm.sessionExists(sessionName));
ALSBConfigurationMBean configMBean =
JMX.newMBeanProxy(
mbconn,
ObjectName.getInstance("com.bea:Name=" + ALSBConfigurationMBean.NAME + "." + sessionName + ",Type=" + ALSBConfigurationMBean.TYPE),
ALSBConfigurationMBean.class
);
System.out.println("Got the config MBean for session: " + configMBean.getSession());
Set<Ref> refs = configMBean.getRefs(Ref.DOMAIN);
System.out.println("found " + refs.size() + " refs<br>");
for (Ref ref : refs) {
System.out.println(ref.getFullName() + " isProjectRef= " + ref.isProjectRef() + "<br>");
}
}
finally
{
// use activateSession to commit session changes instead
sm.discardSession(sessionName);
}
} finally {
conn.close();
System.out.println("Closed JMX connection");
}
}
}
<%@page import="java.net.*" %>
<%@page import="java.io.*" %>
<%@page import="javax.xml.xpath.*" %>
<%@page import="org.xml.sax.*" %>
<%@page import="javax.xml.parsers.*" %>
<%@page import="org.w3c.dom.*" %>
<%
String urlToRead = "http://acme.com:8101/sbresource?SCHEMA/httptest/version";
URL url;
HttpURLConnection conn;
BufferedReader rd;
String line;
String xml = "";
String version = "N/A";
try {
url = new URL(urlToRead);
conn = (HttpURLConnection) url.openConnection();
conn.setRequestMethod("GET");
rd = new BufferedReader(new InputStreamReader(conn.getInputStream()));
while ((line = rd.readLine()) != null) {
xml += line;
}
rd.close();
} catch (Exception e) {
e.printStackTrace();
}
XPathFactory factory = XPathFactory.newInstance();
XPath xpath = factory.newXPath();
//String expression = "//xs:element[@name='version']/@id";
String expression = "//*";
DocumentBuilder builder = DocumentBuilderFactory.newInstance().newDocumentBuilder();
InputSource is = new InputSource(new StringReader(xml));
Document document = builder.parse(is);
out.write("parsed");
Node widgetNode = (Node) xpath.evaluate(expression, document, XPathConstants.NODE);
out.write("evaluated");
out.write(widgetNode.getTextContent());
out.write("widgetNode is null? " + (widgetNode == null));
%>
SET SERVEROUTPUT ON;
BEGIN
DBMS_OUTPUT.ENABLE;
DBMS_OUTPUT.PUT_LINE('Hello...');
DBMS_OUTPUT.PUT_LINE('Goodbye.');
END;
/
create or replace function datediff( p_what in varchar2,
p_d1 in date,
p_d2 in date ) return number
as
l_result number;
begin
select (p_d2-p_d1) *
decode( upper(p_what),
'SS', 24*60*60, 'MI', 24*60, 'HH', 24, NULL )
into l_result from dual;
return l_result;
end;
CREATE OR REPLACE FUNCTION SHOULDALERT
(
p_technicalmessageid IN VARCHAR2
) RETURN NUMBER IS
v_count integer;
BEGIN
select count(*) into v_count from nesoa2_alert_instances where technicalmessageid = p_technicalmessageid
and status in ('CREATED', 'PROCESSED') ;
return v_count;
END SHOULDALERT;
except Exception, inst:
print('unable to create JMSModule ' + jmsModule)
print inst
print sys.exc_info()[0]
linecount= testRunner.testCase.testSteps["Properties"].getPropertyValue( "linecount" )
linecountInt = linecount.toInteger() + 1
//increment property linecount by one
testRunner.testCase.testSteps["Properties"].setPropertyValue( "linecount", String.valueOf(linecountInt) )
def myhostnamesFile = new File("C:/pierre/workspace/SSS_AutomatedTests/SOAPUIArtifacts/hostnames.txt")
//find number of lines in hostnames file
hostnamesinthefile = 0;
myhostnamesFile.eachLine { hostnamesinthefile++ }
log.info( "hostnames in the file: " + hostnamesinthefile)
//divide modulo
theLineNumber = (linecountInt % hostnamesinthefile) + 1
log.info("theLineNumber to choose=" + theLineNumber)
theHostnameToChoose = ""
//scan all lines, line contains the text and lineNo the line number starting from 1
myhostnamesFile.eachLine() { line, lineNo ->
if ( lineNo == theLineNumber)
theHostnameToChoose = line
}
log.info( "theHostnameToChoose=" + theHostnameToChoose)
testRunner.testCase.testSteps["Properties"].setPropertyValue( "Hostname", theHostnameToChoose )
def deleteJMSModule(jmsModule):
myBean = getMBean('/SystemResources/' + jmsModule)
if myBean is not None:
edit()
startEdit()
try:
cmo.destroyJMSSystemResource(getMBean('/SystemResources/' + jmsModule))
print "deleted JMSModule " + jmsModule
validate()
save()
activate()
except:
print('unable to delete preexisting JMSModule ' + jmsModule)
dumpStack()
undo('true', 'y')
cancelEdit('y')
else:
print 'JMSModule ' + jmsModule + ' does not exist, I will not delete it'
select owner,constraint_name,constraint_type,table_name,r_owner,r_constraint_name
from all_constraints
where constraint_type='R'
and r_constraint_name in (select constraint_name
from all_constraints
where constraint_type in ('P','U')
and table_name='BLA');
@echo off
set SOAPUI_HOME=C:\pierre\SmartBear\soapUI-4.5.0\bin\
set JAVA=c:\pierre\jre32\bin\java
rem init classpath
set CLASSPATH=%SOAPUI_HOME%soapui-4.5.0.jar;%SOAPUI_HOME%..\lib\*;
rem JVM parameters, modify as appropriate
set JAVA_OPTS=-Xms128m -Xmx1024m -Dsoapui.properties=soapui.properties -Dsoapui.home=%SOAPUI_HOME%
if "%SOAPUI_HOME%" == "" goto START
set JAVA_OPTS=%JAVA_OPTS% -Dsoapui.ext.libraries="%SOAPUI_HOME%ext"
set JAVA_OPTS=%JAVA_OPTS% -Dsoapui.ext.listeners="%SOAPUI_HOME%listeners"
set JAVA_OPTS=%JAVA_OPTS% -Dsoapui.ext.actions="%SOAPUI_HOME%actions"
set JAVA_OPTS=%JAVA_OPTS% -Djava.library.path="%SOAPUI_HOME%\"
set JAVA_OPTS=%JAVA_OPTS% -Dwsi.dir="%SOAPUI_HOME%..\wsi-test-tools"
rem uncomment to disable browser component
rem set JAVA_OPTS=%JAVA_OPTS% -Dsoapui.jxbrowser.disable="true"
:START
rem ********* run soapui ***********
"%JAVA%" %JAVA_OPTS% com.eviware.soapui.SoapUI %*
