test multicast with jboss

https://access.redhat.com/solutions/123073

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

solr and alfresco integration on jboss eap 6

When configuring solr with alfresco on jboss there is a lot of certificate bullshit. I was hitting the error:

ERROR | [ServerService Thread Pool -- 53] | 2014-11-10 12:41:30 | org.apache.catalina.core.StandardContext.java | JBWEB000287: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener: org.alfresco.error.AlfrescoRuntimeException: 10100000 Keystores are invalid

Caused by: org.alfresco.encryption.MissingKeyException: Key metadata is missing from keystore /usr/share/jbossas/modules/org/alfresco/configuration/main/alfresco/keystore/keystore

The problem is that alfresco looks for an keystore with the name keystore, and an alias metadata in the keystore. This keystore can be found in de alfresco.war file. Normally this keystore would be placed on the classpath by deployment but jboss works a little bit differt. So you need to extract the war and place the keystore on the classpath yourself.

After this, you can follow the manuals on the internet.

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

jboss EAP 6.2.0 Remote JMX monitoring in domain mode

In the domain.xml of the domain controller the profile of the server should contain the following:

           
               
               
               
           

On the host which runs the server a application user must be created with $JBOSS_HOME/bin/add_user.sh

The JMX port is defined in the socket-binding-group. For example if standard sockets is used than the jmx port is 4447. And with the port-offset it is possible to define differt ports for every server.

And now comes the trick. Install a jboss server on your machine with the same version. In the $JBOSS_HOME/bin there is an script jconsole.sh this script sets the right environment for jconsole (jars).

If jconsole is started the connection can be made:

service:jmx:remoting-jmx://ip_address:port

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

jboss EAP 6.2.0 Test datasource in the Jboss CLI

/host=[hostname]/server=[servername]/subsystem=datasources/data-source=jdbc\/[datasource_name]:test-connection-in-pool Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

ldapsearch OID 10.1.4 Find all groups an member belongs to

$ORACLE_HOME/bin/ldapsearch -h $ldapurl -p $ldapport -D "cn=orcladmin" -w $password -b "dc=acme,dc=nl" -s sub "(&(|(objectclass=orclgroup)(objectclass=orcladgroup))(uniquemember=cn={USER},cn=users,dc=acme,dc=nl))" displayname Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Create JBoss EAP 6.1 default profile with jboss-cli.sh

I made a shell function to create (copy) the default profile of JBoss EAP 6.1:

function create_profile
{
$JBOSS_HOME/bin/jboss-cli.sh -c --controller=${host}:${port} >> $LOG_FILE 2>&1 <"${2}_server.log","relative-to"=>"jboss.server.log.dir"},suffix=".yyyy-MM-dd",append=true)
/profile=${1}/subsystem=logging/logger="com.arjuna":add(level=WARN)
/profile=${1}/subsystem=logging/logger="org.apache.tomcat.util.modeler":add(level=WARN)
/profile=${1}/subsystem=logging/logger="org.jboss.as.config":add(level=DEBUG)
/profile=${1}/subsystem=logging/logger="sun.rmi":add(level=WARN)
/profile=${1}/subsystem=logging/logger="jacorb":add(level=WARN)
/profile=${1}/subsystem=logging/logger="jacorb.config":add(level=ERROR)

/profile=${1}/subsystem=logging/root-logger=ROOT:add
/profile=${1}/subsystem=logging/root-logger=ROOT:write-attribute(name="level", value="INFO")
/profile=${1}/subsystem=logging/root-logger=ROOT:root-logger-assign-handler(name="FILE")

/profile=${1}/subsystem=configadmin:add()

  # Create datasources subsystem
/profile=${1}/subsystem=datasources:add()
/profile=${1}/subsystem=datasources/jdbc-driver=OracleJDBCDriver/:add(driver-name="OracleJDBCDriver", driver-module-name="oracle.jdbc", driver-xa-datasource-class-name="oracle.jdbc.driver.OracleDriver")

  # Create ee subsystem:
/profile=${1}/subsystem=ee:add(spec-descriptor-property-replacement="false",jboss-descriptor-property-replacement="true")

/profile=${1}/subsystem=ejb3:add(default-missing-method-permissions-deny-access=true,,default-security-domain=other)
/profile=${1}/subsystem=ejb3:write-attribute(name=default-slsb-instance-pool,value=slsb-strict-max-pool)
/profile=${1}/subsystem=ejb3:write-attribute(name=default-sfsb-cache,value=simple)
/profile=${1}/subsystem=ejb3:write-attribute(name=default-stateful-bean-access-timeout, value=5000)
/profile=${1}/subsystem=ejb3:write-attribute(name=default-singleton-bean-access-timeout, value=5000)
/profile=${1}/subsystem=ejb3/strict-max-bean-instance-pool=slsb-strict-max-pool:add(max-pool-size=20,timeout=5,timeout-unit=MINUTES)
/profile=${1}/subsystem=ejb3/strict-max-bean-instance-pool=mdb-strict-max-pool:add(max-pool-size=20,timeout=5,timeout-unit=MINUTES)
/profile=${1}/subsystem=ejb3/cache=simple:add(aliases=["NoPassivationCache"])
/profile=${1}/subsystem=ejb3/cache=passivating:add(passivation-store=file,aliases=["SimpleStatefulCache"])
/profile=${1}/subsystem=ejb3/file-passivation-store=file:add
/profile=${1}/subsystem=ejb3/service=async:add(thread-pool-name=default)
/profile=${1}/subsystem=ejb3/service=timer-service:add(thread-pool-name=default,path=timer-service-data,relative-to=jboss.server.data.dir)
/profile=${1}/subsystem=ejb3/service=remote:add(connector-ref=remoting-connector,thread-pool-name=default)
/profile=${1}/subsystem=ejb3/thread-pool=default:add(max-threads=10,keepalive-time={"time"=>"100","unit"=>"MILLISECONDS"})

# Create infinispan subsystem:
/profile=${1}/subsystem=infinispan:add
/profile=${1}/subsystem=infinispan/cache-container=web:add(aliases=["standard-session-cache"],default-cache="local-web",module="org.jboss.as.clustering.web.infinispan")
/profile=${1}/subsystem=infinispan/cache-container=web/local-cache=local-web:add(batching=true)
/profile=${1}/subsystem=infinispan/cache-container=web/local-cache=local-web/file-store=FILE_STORE:add(passivation=false,purge=false)

/profile=${1}/subsystem=infinispan/cache-container=hibernate:add(default-cache=local-query,module="org.jboss.as.jpa.hibernate:4")
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=entity:add
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=entity/transaction=TRANSACTION:add(mode=NON_XA)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=entity/eviction=EVICTION:add(strategy=LRU,max-entries=10000)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=entity/expiration=EXPIRATION:add(max-idle=100000)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=local-query:add
/profile=${1}/function create_profile
{
$JBOSS_HOME/bin/jboss-cli.sh -c --controller=${host}:${port} >> $LOG_FILE 2>&1 <"${2}_server.log","relative-to"=>"jboss.server.log.dir"},suffix=".yyyy-MM-dd",append=true)
/profile=${1}/subsystem=logging/logger="com.arjuna":add(level=WARN)
/profile=${1}/subsystem=logging/logger="org.apache.tomcat.util.modeler":add(level=WARN)
/profile=${1}/subsystem=logging/logger="org.jboss.as.config":add(level=DEBUG)
/profile=${1}/subsystem=logging/logger="sun.rmi":add(level=WARN)
/profile=${1}/subsystem=logging/logger="jacorb":add(level=WARN)
/profile=${1}/subsystem=logging/logger="jacorb.config":add(level=ERROR)

/profile=${1}/subsystem=logging/root-logger=ROOT:add
/profile=${1}/subsystem=logging/root-logger=ROOT:write-attribute(name="level", value="INFO")
/profile=${1}/subsystem=logging/root-logger=ROOT:root-logger-assign-handler(name="FILE")

/profile=${1}/subsystem=configadmin:add()

  # Create datasources subsystem
/profile=${1}/subsystem=datasources:add()
/profile=${1}/subsystem=datasources/jdbc-driver=OracleJDBCDriver/:add(driver-name="OracleJDBCDriver", driver-module-name="oracle.jdbc", driver-xa-datasource-class-name="oracle.jdbc.driver.OracleDriver")

  # Create ee subsystem:
/profile=${1}/subsystem=ee:add(spec-descriptor-property-replacement="false",jboss-descriptor-property-replacement="true")

/profile=${1}/subsystem=ejb3:add(default-missing-method-permissions-deny-access=true,,default-security-domain=other)
/profile=${1}/subsystem=ejb3:write-attribute(name=default-slsb-instance-pool,value=slsb-strict-max-pool)
/profile=${1}/subsystem=ejb3:write-attribute(name=default-sfsb-cache,value=simple)
/profile=${1}/subsystem=ejb3:write-attribute(name=default-stateful-bean-access-timeout, value=5000)
/profile=${1}/subsystem=ejb3:write-attribute(name=default-singleton-bean-access-timeout, value=5000)
/profile=${1}/subsystem=ejb3/strict-max-bean-instance-pool=slsb-strict-max-pool:add(max-pool-size=20,timeout=5,timeout-unit=MINUTES)
/profile=${1}/subsystem=ejb3/strict-max-bean-instance-pool=mdb-strict-max-pool:add(max-pool-size=20,timeout=5,timeout-unit=MINUTES)
/profile=${1}/subsystem=ejb3/cache=simple:add(aliases=["NoPassivationCache"])
/profile=${1}/subsystem=ejb3/cache=passivating:add(passivation-store=file,aliases=["SimpleStatefulCache"])
/profile=${1}/subsystem=ejb3/file-passivation-store=file:add
/profile=${1}/subsystem=ejb3/service=async:add(thread-pool-name=default)
/profile=${1}/subsystem=ejb3/service=timer-service:add(thread-pool-name=default,path=timer-service-data,relative-to=jboss.server.data.dir)
/profile=${1}/subsystem=ejb3/service=remote:add(connector-ref=remoting-connector,thread-pool-name=default)
/profile=${1}/subsystem=ejb3/thread-pool=default:add(max-threads=10,keepalive-time={"time"=>"100","unit"=>"MILLISECONDS"})

# Create infinispan subsystem:
/profile=${1}/subsystem=infinispan:add
/profile=${1}/subsystem=infinispan/cache-container=web:add(aliases=["standard-session-cache"],default-cache="local-web",module="org.jboss.as.clustering.web.infinispan")
/profile=${1}/subsystem=infinispan/cache-container=web/local-cache=local-web:add(batching=true)
/profile=${1}/subsystem=infinispan/cache-container=web/local-cache=local-web/file-store=FILE_STORE:add(passivation=false,purge=false)

/profile=${1}/subsystem=infinispan/cache-container=hibernate:add(default-cache=local-query,module="org.jboss.as.jpa.hibernate:4")
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=entity:add
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=entity/transaction=TRANSACTION:add(mode=NON_XA)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=entity/eviction=EVICTION:add(strategy=LRU,max-entries=10000)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=entity/expiration=EXPIRATION:add(max-idle=100000)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=local-query:add
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=local-query/transaction=TRANSACTION:add(mode=NONE)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=local-query/expiration=EXPIRATION:add(max-idle=100000)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=local-query/eviction=EVICTION:add(strategy=LRU,max-entries=10000)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=timestamps:add
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=timestamps/transaction=TRANSACTION:add(mode=NONE)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=timestamps/eviction=EVICTION:add(strategy=NONE)

# Create jaxrs subsystem:
/profile=${1}/subsystem=jaxrs:add()

# Create jca subsystem:
/profile=${1}/subsystem=jca:add()
/profile=${1}/subsystem=jca/archive-validation=archive-validation:add(enabled=true, fail-on-error=true, fail-on-warn=false)
/profile=${1}/subsystem=jca/bean-validation=bean-validation:add(enabled=true)
/profile=${1}/subsystem=jca/cached-connection-manager=cached-connection-manager:add(install=true)
/profile=${1}/subsystem=jca/workmanager=default:add(name=default)
/profile=${1}/subsystem=jca/workmanager=default/short-running-threads=default:add(core-threads=50,queue-length=50,max-threads=50,keepalive-time={"time"=>"10", "unit"=>"SECONDS"})
/profile=${1}/subsystem=jca/workmanager=default/long-running-threads=default:add(core-threads=50,queue-length=50,max-threads=50,keepalive-time={"time"=>"10", "unit"=>"SECONDS"})

/profile=${1}/subsystem=jdr:add
  
# Create jmx subsystem:
/profile=${1}/subsystem=jmx:add(show-model=true)
/profile=${1}/subsystem=jmx/expose-model=resolved:add
/profile=${1}/subsystem=jmx/expose-model=expression:add

# Create jpa subsystem:
/profile=${1}/subsystem=jpa:add(default-datasource="", default-extended-persistence-inheritance="DEEP")
/profile=${1}/subsystem=jsf:add

/profile=${1}/subsystem=mail:add
/profile=${1}/subsystem=mail/mail-session="java:jboss/mail/Default":add(jndi-name=java:jboss/mail/Default,debug=false)
/profile=${1}/subsystem=mail/mail-session="java:jboss/mail/Default"/server=smtp:add(outbound-socket-binding-ref=mail-smtp)

/profile=${1}/subsystem=naming:add()
# remove this command if a 7.1.1 server is used
/profile=${1}/subsystem=naming/service=remote-naming:add
/profile=${1}/subsystem=pojo:add
/profile=${1}/subsystem=remoting:add
/profile=${1}/subsystem=remoting/connector=remoting-connector:add(socket-binding=remoting, security-realm=ApplicationRealm)

  
  # Create resource-adapters subsystem:
/profile=${1}/subsystem=resource-adapters:add()
/profile=${1}/subsystem=sar:add

/profile=${1}/subsystem=security:add
/profile=${1}/subsystem=security/security-domain=other:add(cache-type=default)
/profile=${1}/subsystem=security/security-domain=other/authentication=classic:add(login-modules=[{"code"=>"Remoting","flag"=>"optional","module-options"=>[("password-stacking"=>"useFirstPass")]},{"code"=>"RealmDirect","flag"=>"required","module-options"=>[("password-stacking"=>"useFirstPass")]}])
/profile=${1}/subsystem=security/security-domain=jboss-web-policy:add(cache-type=default)
/profile=${1}/subsystem=security/security-domain=jboss-web-policy/authorization=classic:add(policy-modules=[{"code"=>"Delegating","flag"=>"required"}])
/profile=${1}/subsystem=security/security-domain=jboss-ejb-policy:add(cache-type=default)
/profile=${1}/subsystem=security/security-domain=jboss-ejb-policy/authorization=classic:add(policy-modules=[{"code"=>"Delegating","flag"=>"required"}])

  # Create threads subsystem:
/profile=${1}/subsystem=threads:add()

/profile=${1}/subsystem=transactions/:add(socket-binding="txn-recovery-environment",status-socket-binding="txn-status-manager",process-id-uuid=true,default-timeout=300)
  
# Create web subsystem:
/profile=${1}/subsystem=web:add(default-virtual-server="default-host", native="false")
/profile=${1}/subsystem=web/connector=http:add(protocol="HTTP/1.1",socket-binding="http",scheme="http")
/profile=${1}/subsystem=web/virtual-server="default-host":add(alias=["localhost","example.com"])

/profile=${1}/subsystem=webservices:add(modify-wsdl-address=true,wsdl-host="\${jboss.bind.address:127.0.0.1}")
/profile=${1}/subsystem=webservices/endpoint-config=Standard-Endpoint-Config:add
/profile=${1}/subsystem=webservices/endpoint-config=Recording-Endpoint-Config:add
/profile=${1}/subsystem=webservices/endpoint-config=Recording-Endpoint-Config/pre-handler-chain=recording-handlers:add(protocol-bindings="##SOAP11_HTTP ##SOAP11_HTTP_MTOM ##SOAP12_HTTP ##SOAP12_HTTP_MTOM")



/profile=${1}/subsystem=webservices/endpoint-config=Recording-Endpoint-Config/pre-handler-chain=recording-handlers/handler=RecordingHandler:add(class="org.jboss.ws.common.invocation.RecordingServerHandler")
/profile=${1}/subsystem=webservices/client-config=Standard-Client-Config:add

/profile=${1}/subsystem=weld:add

run-batch 
EOF
}subsystem=infinispan/cache-container=hibernate/local-cache=local-query/transaction=TRANSACTION:add(mode=NONE)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=local-query/expiration=EXPIRATION:add(max-idle=100000)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=local-query/eviction=EVICTION:add(strategy=LRU,max-entries=10000)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=timestamps:add
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=timestamps/transaction=TRANSACTION:add(mode=NONE)
/profile=${1}/subsystem=infinispan/cache-container=hibernate/local-cache=timestamps/eviction=EVICTION:add(strategy=NONE)

# Create jaxrs subsystem:
/profile=${1}/subsystem=jaxrs:add()

# Create jca subsystem:
/profile=${1}/subsystem=jca:add()
/profile=${1}/subsystem=jca/archive-validation=archive-validation:add(enabled=true, fail-on-error=true, fail-on-warn=false)
/profile=${1}/subsystem=jca/bean-validation=bean-validation:add(enabled=true)
/profile=${1}/subsystem=jca/cached-connection-manager=cached-connection-manager:add(install=true)
/profile=${1}/subsystem=jca/workmanager=default:add(name=default)
/profile=${1}/subsystem=jca/workmanager=default/short-running-threads=default:add(core-threads=50,queue-length=50,max-threads=50,keepalive-time={"time"=>"10", "unit"=>"SECONDS"})
/profile=${1}/subsystem=jca/workmanager=default/long-running-threads=default:add(core-threads=50,queue-length=50,max-threads=50,keepalive-time={"time"=>"10", "unit"=>"SECONDS"})

/profile=${1}/subsystem=jdr:add
  
# Create jmx subsystem:
/profile=${1}/subsystem=jmx:add(show-model=true)
/profile=${1}/subsystem=jmx/expose-model=resolved:add
/profile=${1}/subsystem=jmx/expose-model=expression:add

# Create jpa subsystem:
/profile=${1}/subsystem=jpa:add(default-datasource="", default-extended-persistence-inheritance="DEEP")
/profile=${1}/subsystem=jsf:add

/profile=${1}/subsystem=mail:add
/profile=${1}/subsystem=mail/mail-session="java:jboss/mail/Default":add(jndi-name=java:jboss/mail/Default,debug=false)
/profile=${1}/subsystem=mail/mail-session="java:jboss/mail/Default"/server=smtp:add(outbound-socket-binding-ref=mail-smtp)

/profile=${1}/subsystem=naming:add()
# remove this command if a 7.1.1 server is used
/profile=${1}/subsystem=naming/service=remote-naming:add
/profile=${1}/subsystem=pojo:add
/profile=${1}/subsystem=remoting:add
/profile=${1}/subsystem=remoting/connector=remoting-connector:add(socket-binding=remoting, security-realm=ApplicationRealm)

  
  # Create resource-adapters subsystem:
/profile=${1}/subsystem=resource-adapters:add()
/profile=${1}/subsystem=sar:add

/profile=${1}/subsystem=security:add
/profile=${1}/subsystem=security/security-domain=other:add(cache-type=default)
/profile=${1}/subsystem=security/security-domain=other/authentication=classic:add(login-modules=[{"code"=>"Remoting","flag"=>"optional","module-options"=>[("password-stacking"=>"useFirstPass")]},{"code"=>"RealmDirect","flag"=>"required","module-options"=>[("password-stacking"=>"useFirstPass")]}])
/profile=${1}/subsystem=security/security-domain=jboss-web-policy:add(cache-type=default)
/profile=${1}/subsystem=security/security-domain=jboss-web-policy/authorization=classic:add(policy-modules=[{"code"=>"Delegating","flag"=>"required"}])
/profile=${1}/subsystem=security/security-domain=jboss-ejb-policy:add(cache-type=default)
/profile=${1}/subsystem=security/security-domain=jboss-ejb-policy/authorization=classic:add(policy-modules=[{"code"=>"Delegating","flag"=>"required"}])

  # Create threads subsystem:
/profile=${1}/subsystem=threads:add()

/profile=${1}/subsystem=transactions/:add(socket-binding="txn-recovery-environment",status-socket-binding="txn-status-manager",process-id-uuid=true,default-timeout=300)
  
# Create web subsystem:
/profile=${1}/subsystem=web:add(default-virtual-server="default-host", native="false")
/profile=${1}/subsystem=web/connector=http:add(protocol="HTTP/1.1",socket-binding="http",scheme="http")
/profile=${1}/subsystem=web/virtual-server="default-host":add(alias=["localhost","example.com"])

/profile=${1}/subsystem=webservices:add(modify-wsdl-address=true,wsdl-host="\${jboss.bind.address:127.0.0.1}")
/profile=${1}/subsystem=webservices/endpoint-config=Standard-Endpoint-Config:add
/profile=${1}/subsystem=webservices/endpoint-config=Recording-Endpoint-Config:add
/profile=${1}/subsystem=webservices/endpoint-config=Recording-Endpoint-Config/pre-handler-chain=recording-handlers:add(protocol-bindings="##SOAP11_HTTP ##SOAP11_HTTP_MTOM ##SOAP12_HTTP ##SOAP12_HTTP_MTOM")



/profile=${1}/subsystem=webservices/endpoint-config=Recording-Endpoint-Config/pre-handler-chain=recording-handlers/handler=RecordingHandler:add(class="org.jboss.ws.common.invocation.RecordingServerHandler")
/profile=${1}/subsystem=webservices/client-config=Standard-Client-Config:add

/profile=${1}/subsystem=weld:add

run-batch 
EOF
}

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

signing self signed certificates

sites:

http://www.g-loaded.eu/2005/11/10/be-your-own-ca/
http://www.eclectica.ca/howto/ssl-cert-howto.php

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

ubunut tips for myself

disable firewall:

ufw disable

log on to another linux server it takes a very long time before the password question:

change /etc/ssh/ssh_config

uncomment:

GSSAPIAuthentication no

X forwarding

ssh -XY user@machine

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Purge data ESB/WSM

How to purge ESB instance data? [ID 453357.1]
How To Delete / Purge Non-Operational Data from the OWSM Schema / Database ? [ID 815974.1]

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Query size rman backups

set linesize 200 heading off
set heading on pagesize 200

column status format a10
column COMMAND_ID for a12
column time_taken_display format a10;
column input_bytes_display format a12;
column output_bytes_display format a12;
column output_bytes_per_sec_display format a10;
column ses_key format 9999999
column ses_recid format 9999999
column device_type format a10
column OutBytesPerSec for a13

SELECT b.session_key ses_key,
b.session_recid ses_recid,
b.session_stamp,
b.command_id,
b.input_type,
b.status,
to_char(b.start_time,'DD-MM-YY HH24:MI') "Start Time",
b.time_taken_display,
b.output_device_type device_type,
b.input_bytes_display,
b.output_bytes_display,
b.output_bytes_per_sec_display "OutBytesPerSec"
FROM v$rman_backup_job_details b
WHERE b.start_time > (SYSDATE - &)
ORDER BY b.start_time desc;

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Oracle ESB: No WebService Provider is registered at this URL

Error when webservice is clicked in esb control

No WebService Provider is registered at this URL

During startup ESB:

java.sql.SQLException: ORA-24067: exceeded maximum number of subscribers for queue
ORAESB.ESB_CONTROL

solution:

CREATE OR REPLACE PROCEDURE create_queue (qname VARCHAR2)
AS
qtablename VARCHAR2(110) := qname;

BEGIN

BEGIN
dbms_aqadm.stop_queue (queue_name => qname);
EXCEPTION
WHEN OTHERS THEN
null;
END;

BEGIN
dbms_aqadm.drop_queue (queue_name => qname);
EXCEPTION
WHEN OTHERS THEN
null;
END;

BEGIN
dbms_aqadm.drop_queue_table (Queue_table => qtablename);
EXCEPTION
WHEN OTHERS THEN
null;
END;

dbms_aqadm.create_queue_table(Queue_table => qtablename,
Queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE',
multiple_consumers => true,
compatible => '8.1');
dbms_aqadm.create_queue (Queue_name => qname,
Queue_table => qtablename);
dbms_aqadm.start_queue(qname);
END;
/

BEGIN
create_queue('ESB_CONTROL');
END;
/




Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Deployment BPEL process fails with revision error

During automatic ant deployment this error is shown:

Embedded error: The following error occurred while executing this line:
/oracle/opleveringen/obm/1.1.0.0/code/opm-integration/scripts/ant/bpel/common-build.xml:82: A problem occured while connecting to server "soatier2.test.ta-twd.rotterdam.nl" using port "80": bpel_CancelBasket_1.0.0-SNAPSHOT.jar failed to deploy. Exception message is:  Error deploying BPEL suitcase.
An error occurred while attempting to deploy the BPEL suitcase file "/appl/oracle/soa_cl_10.1.3/bpel/domains/OnlineBetaalModule/tmp/bpel_10725323.tmp"; the exception reported is: Process bpel://localhost/OnlineBetaalModule/CancelBasket~1.0.0-SNAPSHOT/ is being re-deployed to a Production Server with same revision number.Please modify the revision for the process.

In the BPELAdmin tab server the field productionServer is true, when this is changed to false and the soa container is restarted the deployment succeeds. After the deployment change it to true again and restart again.
Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

All contexts in Oracle Application server with opmnctl

opmnctl status -app -l | awk -F"|" '{ print $7 }'

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

JMX monitoring OC4J JVM

To monitor the JVM with jconsole or an external profiler the opmn.xml settings of the container should be changed:

This properties must be added:

-Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=9900 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false"

Restart the container and now you can connect on the url:

service:jmx:rmi:///jndi/rmi://[HOSTNAME]:9900/jmxrmi






Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Multiple java processes when using webgate

If you use an webgate version which needs the parameter you will see 50 processes or more on linux for the JVM. When you change the webgate to a version which uses NTPD this problem is solved.

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Invalid Access SDK Path. -Djava.library.path must point to {SDK_HOME}/oblix/lib.

There are a couple of reasons for this error. You can try the following things to solve it.

- configureAccessGate (check the file ../AccessServerSDK/oblix/lib/ObAccessClient.xml)

- cp AccessServerSDK/oblix/lib/jobaccess.jar to $ORACLE_HOME/j2ee/home/lib/ext

- in the LD_LIBRARY_PATH in opmn.xml file, please remove the trailing slash "/" from the patch "/AccessServerSDK/oblix/lib/

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Determine OAS (10.1.3) version

$ORACLE_HOME/OPatch/opatch lsinventory -detail

Get version Oracle Containers for J2EE

cd $ORACLE_HOME/j2ee/home
java -jar oc4j.jar -version

Output:
Oracle Containers for J2EE 10g (10.1.3.5.0) (build 090727.2000.36696)

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

SOA BPEL (10.1.3.x) Identity service: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Connection timed out

The reason for this error:
"java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Connection timed out:"
was that an proxy server was configured on the oc4j_soa container in opmn.xml

BPEL Console gave this error:
The following exception occured while processing this request:
Io exception: The Network Adapter could not establish the connection

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Delete of bpel domain on SOA 10.1.3.4 is not complete

When a BPEL domain is delete from the BPELAdmin there are still records left in de dehydration database. These entries can be deleted:

Logon on the dehydration store database as ORABPEL

Check which domains are active:
select domain_ref from domain;

Delete all other domains:

delete suitcase_bin where domain_ref not in (select domain_ref from domain);
delete audit_details where domain_ref not in (select domain_ref from domain);
delete audit_trail where domain_ref not in (select domain_ref from domain);
delete cube_instance where domain_ref not in (select domain_ref from domain);
delete cube_scope where domain_ref not in (select domain_ref from domain);
delete dlv_message where domain_ref not in (select domain_ref from domain);
delete dlv_subscription where domain_ref not in (select domain_ref from domain);
delete document_ci_ref where domain_ref not in (select domain_ref from domain);
delete document_dlv_msg_ref where domain_ref not in (select domain_ref from domain);
delete domain_properties where domain_ref not in (select domain_ref from domain);
delete invoke_message where domain_ref not in (select domain_ref from domain);
delete process where domain_ref not in (select domain_ref from domain);
delete process_default where domain_ref not in (select domain_ref from domain);
delete process_descriptor where domain_ref not in (select domain_ref from domain);
delete process_log where domain_ref not in (select domain_ref from domain);
delete wi_fault where domain_ref not in (select domain_ref from domain);
delete work_item where domain_ref not in (select domain_ref from domain);
delete xml_document where domain_ref not in (select domain_ref from domain);
delete wftask where domainid='[NOT EXISTING DOMAINS]';
delete wftaskhistory where domainid='[NOT EXISTING DOMAINS]';
delete wftaskmetadata where domainid='[NOT EXISTING DOMAINS]';
delete wftask where domainid='[NOT EXISTING DOMAINS]';

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Oracle OMS agent: Rediscover targets

In the AGENT_HOME execute agentca -d

$ORACLE_HOME/bin/agentca -d

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.