tag:blogger.com,1999:blog-24475453830631319912024-03-17T08:42:05.259+01:00Arjan's Oracle knowledgeThis blog contains my knowledge about Oracle Database/Application Server/Linux/Shell scriptingArjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.comBlogger113125tag:blogger.com,1999:blog-2447545383063131991.post-48939207183923583452016-03-07T17:19:00.001+01:002016-03-07T17:19:52.235+01:00test multicast with jbosshttps://access.redhat.com/solutions/123073<br />
<br />
Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com18tag:blogger.com,1999:blog-2447545383063131991.post-19190266886126321152014-11-11T08:24:00.001+01:002014-11-11T08:24:16.689+01:00solr and alfresco integration on jboss eap 6When configuring solr with alfresco on jboss there is a lot of certificate bullshit. I was hitting the error:<br />
<br />
<span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">ERROR | [ServerService Thread Pool -- 53] | 2014-11-10 12:41:30 | org.apache.catalina.core.</span><wbr style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"></wbr><span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">StandardContext.java | JBWEB000287: Exception sending context initialized event to listener instance of class org.alfresco.web.app.</span><wbr style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"></wbr><span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">ContextListener: org.alfresco.error.</span><wbr style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"></wbr><span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">AlfrescoRuntimeException: 10100000 Keystores are invalid</span><br />
<span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><br /></span>
<span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">Caused by: org.alfresco.encryption.</span><wbr style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"></wbr><span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">MissingKeyException: Key metadata is missing from keystore /usr/share/jbossas/modules/</span><wbr style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"></wbr><span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">org/alfresco/configuration/</span><wbr style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"></wbr><span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">main/alfresco/keystore/</span><wbr style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"></wbr><span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">keystore</span><br />
<span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><br /></span>
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.<br />
<br />
After this, you can follow the manuals on the internet.<br />
<br />
Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com7tag:blogger.com,1999:blog-2447545383063131991.post-46512137639015828012014-01-22T14:16:00.001+01:002014-01-22T14:16:21.103+01:00jboss EAP 6.2.0 Remote JMX monitoring in domain modeIn the domain.xml of the domain controller the profile of the server should contain the following:<br />
<br />
<pre></pre>
<subsystem xmlns="urn:jboss:domain:jmx:1.3"><br /> <expose-resolved-model><br /> <expose-expression-model><br /> <remoting-connector use-management-endpoint="false"><br /> </remoting-connector></expose-expression-model></expose-resolved-model></subsystem><br />
<br />
On the host which runs the server a application user must be created with $JBOSS_HOME/bin/add_user.sh<br />
<br />
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.<br />
<br />
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).<br />
<br />
If jconsole is started the connection can be made:<br />
<br />
<div>
<strong>service:jmx:remoting-jmx://ip_address:port</strong></div>
<br />
<br />
Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com4tag:blogger.com,1999:blog-2447545383063131991.post-42905715703929206782013-12-17T21:26:00.000+01:002013-12-17T21:26:37.644+01:00jboss 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.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com0tag:blogger.com,1999:blog-2447545383063131991.post-32110880599152273572013-11-22T10:41:00.000+01:002013-11-22T10:41:10.114+01:00ldapsearch 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.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com1tag:blogger.com,1999:blog-2447545383063131991.post-86423466393726655592013-11-04T10:43:00.000+01:002013-11-04T10:43:04.862+01:00Create JBoss EAP 6.1 default profile with jboss-cli.shI made a shell function to create (copy) the default profile of JBoss EAP 6.1:
<pre>
function create_profile
{
$JBOSS_HOME/bin/jboss-cli.sh -c --controller=${host}:${port} >> $LOG_FILE 2>&1 <<EOF
batch
/profile=${1}:add()
/profile=${1}/subsystem=logging:add()
/profile=${1}/subsystem=logging/periodic-rotating-file-handler=FILE:add(autoflush=true,formatter="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%E%n",file={"path"=>"${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 <<EOF
batch
/profile=${1}:add()
/profile=${1}/subsystem=logging:add()
/profile=${1}/subsystem=logging/periodic-rotating-file-handler=FILE:add(autoflush=true,formatter="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%E%n",file={"path"=>"${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
}
</pre>
Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com3tag:blogger.com,1999:blog-2447545383063131991.post-22414643960858479122011-08-17T14:25:00.001+02:002011-08-17T14:25:38.093+02:00signing self signed certificatessites:
<br />
<br />http://www.g-loaded.eu/2005/11/10/be-your-own-ca/
<br />http://www.eclectica.ca/howto/ssl-cert-howto.php
<br />
<br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com1tag:blogger.com,1999:blog-2447545383063131991.post-89218794762014884052011-05-26T13:38:00.002+02:002011-12-23T08:34:41.455+01:00ubunut tips for myselfdisable firewall:<br /><br />ufw disable<br /><br />log on to another linux server it takes a very long time before the password question:<br /><br />change /etc/ssh/ssh_config<br /><br />uncomment:<br /><br />GSSAPIAuthentication no<br /><br />X forwarding<br /><br />ssh -XY user@machine<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com2tag:blogger.com,1999:blog-2447545383063131991.post-79737071563910354572011-03-31T12:33:00.001+02:002011-03-31T12:36:39.672+02:00Purge data ESB/WSMHow to purge ESB instance data? [ID 453357.1]<br />How To Delete / Purge Non-Operational Data from the OWSM Schema / Database ? [ID 815974.1]<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com0tag:blogger.com,1999:blog-2447545383063131991.post-23456089008469033192011-03-28T13:27:00.000+02:002011-03-28T13:28:08.941+02:00Query size rman backupsset linesize 200 heading off<br />set heading on pagesize 200<br /><br />column status format a10<br />column COMMAND_ID for a12<br />column time_taken_display format a10;<br />column input_bytes_display format a12;<br />column output_bytes_display format a12;<br />column output_bytes_per_sec_display format a10;<br />column ses_key format 9999999<br />column ses_recid format 9999999<br />column device_type format a10<br />column OutBytesPerSec for a13<br /><br />SELECT b.session_key ses_key,<br />b.session_recid ses_recid,<br />b.session_stamp,<br />b.command_id,<br />b.input_type,<br />b.status,<br />to_char(b.start_time,'DD-MM-YY HH24:MI') "Start Time",<br />b.time_taken_display,<br />b.output_device_type device_type,<br />b.input_bytes_display,<br />b.output_bytes_display,<br />b.output_bytes_per_sec_display "OutBytesPerSec"<br />FROM v$rman_backup_job_details b<br />WHERE b.start_time > (SYSDATE - &)<br />ORDER BY b.start_time desc;<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com12tag:blogger.com,1999:blog-2447545383063131991.post-49730193842737698872011-03-16T15:56:00.003+01:002011-03-16T15:59:28.977+01:00Oracle ESB: No WebService Provider is registered at this URLError when webservice is clicked in esb control<br /><br />No WebService Provider is registered at this URL<br /><br />During startup ESB:<br /><br />java.sql.SQLException: ORA-24067: exceeded maximum number of subscribers for queue<br />ORAESB.ESB_CONTROL<br /><br />solution:<br /><br />CREATE OR REPLACE PROCEDURE create_queue (qname VARCHAR2) <br />AS <br /> qtablename VARCHAR2(110) := qname; <br /><br />BEGIN <br /><br /> BEGIN <br /> dbms_aqadm.stop_queue (queue_name => qname); <br /> EXCEPTION <br /> WHEN OTHERS THEN <br /> null; <br /> END; <br /><br /> BEGIN <br /> dbms_aqadm.drop_queue (queue_name => qname); <br /> EXCEPTION <br /> WHEN OTHERS THEN <br /> null; <br /> END; <br /><br /> BEGIN <br /> dbms_aqadm.drop_queue_table (Queue_table => qtablename); <br /> EXCEPTION <br /> WHEN OTHERS THEN <br /> null; <br /> END; <br /><br /> dbms_aqadm.create_queue_table(Queue_table => qtablename, <br /> Queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE', <br /> multiple_consumers => true, <br /> compatible => '8.1'); <br /> dbms_aqadm.create_queue (Queue_name => qname, <br /> Queue_table => qtablename); <br /> dbms_aqadm.start_queue(qname); <br />END; <br />/ <br /><br />BEGIN <br /> create_queue('ESB_CONTROL'); <br />END; <br />/<br /><br /><br /><br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com1tag:blogger.com,1999:blog-2447545383063131991.post-63113078760292730032011-02-09T07:57:00.004+01:002011-02-25T08:41:07.073+01:00Deployment BPEL process fails with revision errorDuring automatic ant deployment this error is shown:<br /><br /><pre><code><br />Embedded error: The following error occurred while executing this line:<br />/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.<br />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.<br /></pre></code><br /><br />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.<br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com1tag:blogger.com,1999:blog-2447545383063131991.post-91018052462428965872011-01-05T13:53:00.000+01:002011-01-05T13:54:26.243+01:00All contexts in Oracle Application server with opmnctlopmnctl status -app -l | awk -F"|" '{ print $7 }'<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com0tag:blogger.com,1999:blog-2447545383063131991.post-24388913758268419492010-12-09T09:25:00.002+01:002010-12-09T09:32:32.723+01:00JMX monitoring OC4J JVMTo monitor the JVM with jconsole or an external profiler the opmn.xml settings of the container should be changed:<br /><br />This properties must be added:<br /><br />-Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=9900 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false"<br /><br />Restart the container and now you can connect on the url:<br /><br />service:jmx:rmi:///jndi/rmi://[HOSTNAME]:9900/jmxrmi<br /><br /><br /><br /><br /><br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com0tag:blogger.com,1999:blog-2447545383063131991.post-72830466452419635972010-11-26T07:21:00.002+01:002010-11-26T07:24:32.825+01:00Multiple java processes when using webgateIf you use an webgate version which needs the parameter <variable id="LD_ASSUME_KERNEL" value="2.4.19"/> 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.<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com0tag:blogger.com,1999:blog-2447545383063131991.post-90316572435818426992010-11-26T07:15:00.002+01:002010-11-26T07:21:00.103+01:00Invalid 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.<br /><br />- configureAccessGate (check the file ../AccessServerSDK/oblix/lib/ObAccessClient.xml) <br /><br />- cp AccessServerSDK/oblix/lib/jobaccess.jar to $ORACLE_HOME/j2ee/home/lib/ext<br /><br />- in the LD_LIBRARY_PATH in opmn.xml file, please remove the trailing slash "/" from the patch "/AccessServerSDK/oblix/lib/<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com0tag:blogger.com,1999:blog-2447545383063131991.post-45734486215263192922010-11-03T13:43:00.002+01:002010-11-03T13:50:03.901+01:00Determine OAS (10.1.3) version<pre><code><br />$ORACLE_HOME/OPatch/opatch lsinventory -detail<br /></pre></code><br /><br />Get version Oracle Containers for J2EE<br /><br /><pre><code><br />cd $ORACLE_HOME/j2ee/home<br />java -jar oc4j.jar -version<br /></pre></code><br /><br />Output:<br />Oracle Containers for J2EE 10g (10.1.3.5.0) (build 090727.2000.36696)<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com1tag:blogger.com,1999:blog-2447545383063131991.post-20644419130682689642010-09-15T11:21:00.001+02:002010-09-15T11:23:22.410+02:00SOA BPEL (10.1.3.x) Identity service: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Connection timed outThe reason for this error:<br />"java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Connection timed out:"<br />was that an proxy server was configured on the oc4j_soa container in opmn.xml<br /><br />BPEL Console gave this error:<br />The following exception occured while processing this request: <br /> Io exception: The Network Adapter could not establish the connection<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com0tag:blogger.com,1999:blog-2447545383063131991.post-48443982048459346302010-09-01T07:47:00.002+02:002010-09-01T07:52:10.341+02:00Delete of bpel domain on SOA 10.1.3.4 is not completeWhen a BPEL domain is delete from the BPELAdmin there are still records left in de dehydration database. These entries can be deleted:<br /><br />Logon on the dehydration store database as ORABPEL<br /><br />Check which domains are active:<br />select domain_ref from domain;<br /><br />Delete all other domains:<br /><br />delete suitcase_bin where domain_ref not in (select domain_ref from domain);<br />delete audit_details where domain_ref not in (select domain_ref from domain);<br />delete audit_trail where domain_ref not in (select domain_ref from domain);<br />delete cube_instance where domain_ref not in (select domain_ref from domain);<br />delete cube_scope where domain_ref not in (select domain_ref from domain);<br />delete dlv_message where domain_ref not in (select domain_ref from domain);<br />delete dlv_subscription where domain_ref not in (select domain_ref from domain);<br />delete document_ci_ref where domain_ref not in (select domain_ref from domain);<br />delete document_dlv_msg_ref where domain_ref not in (select domain_ref from domain);<br />delete domain_properties where domain_ref not in (select domain_ref from domain);<br />delete invoke_message where domain_ref not in (select domain_ref from domain);<br />delete process where domain_ref not in (select domain_ref from domain);<br />delete process_default where domain_ref not in (select domain_ref from domain);<br />delete process_descriptor where domain_ref not in (select domain_ref from domain);<br />delete process_log where domain_ref not in (select domain_ref from domain);<br />delete wi_fault where domain_ref not in (select domain_ref from domain);<br />delete work_item where domain_ref not in (select domain_ref from domain);<br />delete xml_document where domain_ref not in (select domain_ref from domain);<br />delete wftask where domainid='[NOT EXISTING DOMAINS]';<br />delete wftaskhistory where domainid='[NOT EXISTING DOMAINS]';<br />delete wftaskmetadata where domainid='[NOT EXISTING DOMAINS]';<br />delete wftask where domainid='[NOT EXISTING DOMAINS]';<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com1tag:blogger.com,1999:blog-2447545383063131991.post-35045944195900794162010-07-21T13:05:00.001+02:002010-07-21T13:06:34.491+02:00Oracle OMS agent: Rediscover targetsIn the AGENT_HOME execute agentca -d<br /><br />$ORACLE_HOME/bin/agentca -d<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com148tag:blogger.com,1999:blog-2447545383063131991.post-8727761828381990382010-07-15T10:08:00.003+02:002010-07-15T10:21:33.984+02:00A problem occured while connecting to server "hostname" using port "80": java.security.AccessControlException: access denied (com.collaxa.security.DomIn our environment the appications hw_services/orabpel and deploy_service in the oc4j_soa container are integrated with the OID. After change the password of oc4jadmin we got problems with the automatic deployment of BPEL Processes. See the stack trace below.<br /><br />We found out that the following line: <jazn provider="LDAP" jaas-mode="doAsPrivileged" /> was missing in the $ORACLE_HOME/j2ee/oc4j_soa/application_deployments/deploy_service/orion-application.xml.<br /><br /><pre><code><br />BUILD FAILED<br />/oracle/opleveringen/DDSAddressAdapter/1.2/1.1/DeploymentMijnLoket/build.xml:170: The following error occurred while executing this line:<br />/oracle/opleveringen/DDSAddressAdapter/1.2/1.1/DeploymentMijnLoket/build.xml:127: The following error occurred while executing this line:<br />/oracle/opleveringen/DDSAddressAdapter/1.2/1.1/DeploymentMijnLoket/build.xml:102: The following error occurred while executing this line:<br />/oracle/opleveringen/DDSAddressAdapter/1.2/1.1/JDeveloper/DDSAdapter/DDSAddressService/bpel/build.xml:89: A problem occured while connecting to server "hostname" using port "80": java.security.AccessControlException: access denied (com.collaxa.security.DomainPermission XXXX read)<br />at java.security.AccessControlContext.checkPermission(AccessControlContext.java:264)<br />at java.security.AccessController.checkPermission(AccessController.java:427)<br />at com.collaxa.security.OC4JSecurityService.checkAccess(OC4JSecurityService.java:16)<br />at com.collaxa.security.SecurityService.checkDomainAccess(SecurityService.java:26)<br />at com.collaxa.cube.fe.util.ServletUtils.getLocatorWithoutUrlRewrite(ServletUtils.java:77)<br />at _deployHttpClientProcess._jspService(_deployHttpClientProcess.java:332)<br />at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)<br />at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)<br />at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)<br />at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)<br />at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)<br />at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)<br />at oracle.security.jazn.oc4j.JAZNFilter$1.run(JAZNFilter.java:400)<br />at java.security.AccessController.doPrivileged(Native Method)<br />at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)<br />at oracle.security.jazn.oc4j.JAZNFilter.doFilter(JAZNFilter.java:414)<br />at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:644)<br />at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)<br />at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)<br />at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)<br />at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)<br />at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)<br />at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)<br />at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)<br />at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)<br />at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)<br />at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)<br />at java.lang.Thread.run(Thread.java:595)<br /></pre></code><br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com4tag:blogger.com,1999:blog-2447545383063131991.post-2304163689454403852010-07-08T13:13:00.002+02:002010-07-08T13:15:41.724+02:00Error during deployment war: Incompatible argument to functionAfter we changed the JDK of the OC4J container from 1.5 to 1.6 we had problems deploying applications.<br /><br /><pre><code><br />BUILD FAILED<br />build.xml:115: Deploy error: Operation failed with error:<br />(class: xx/xx/xxx , method: YyyyyY signature: (Ljava/util/Map;)RRR/rrr/RRR;) Incompatible argument to function<br /></pre></code><br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com1tag:blogger.com,1999:blog-2447545383063131991.post-50995797006326656562010-06-10T08:38:00.003+02:002010-06-10T08:39:44.346+02:00Apache Address already in use: make_sock: could not bind to port xxxxError in the Apache error.log<br /><br />Apache Address already in use: make_sock: could not bind to port xxxx<br /><br /><br />Find the process which is using the port:<br />netstat -tulpn| grep :xxxxx<br /><br />Kill the process:<br /><br />kill -9 httpd<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com4tag:blogger.com,1999:blog-2447545383063131991.post-13640824311944088792010-05-05T12:25:00.003+02:002010-05-05T12:50:43.371+02:00ESB Console: no systems. Error in log.xml: WSDL parsing failed : WSDL Parsing Failed: Connection timed outIn the metalink note: 467440.1 a possible solution is provided but in our case this was not working. We had a big application which was using Oracle BPEL en Oracle ESB. In the new release the Oracle ESB was replaced by another ESB (mule) but the old ESB systems were still deployed in the Oracle ESB. The ESB Console was not able to retrieve the ESB systems anymore, so everything was empty in the screen. The only error in log.xml in $ORACLE_HOME/j2ee/oc4j_soa/log/oc4j/.../log.xml was<br /><pre><code><br />WSDL parsing failed :WSDL Parsing Failed: Connection timed out<br /></pre></code><br /><br />We did an undeploy of the esb system with ant and this solved the problem.<br /><br />This is how we did the undeployment:<br /><br />build.xml:<br /><pre><code><br /><?xml version="1.0" encoding="windows-1252" ?><br /><project name="deploy" default="undeploy-esb"><br /><br /> <property file="build.properties"/><br /><br /> <import file="../etc/ESBMetadataMigrationTaskdefs.xml"/><br /> <target name="undeploy-esb"><br /><br /> <undeployESBEntities<br /> esbMetadataServerHostname="[HOSTNAME]"<br /> esbMetadataServerPort="[PORT]"<br /> userName="oc4jadmin"<br /> password="[PASSWORD]"><br /> <system guid="[ESBSYSTEM GUID]"/><br /> </undeployESBEntities><br /><br /> </target><br /><br /></project><br /></pre></code><br /><br />[ESBSYSTEM GUID] can be found in de dehydration store of the SOA suite: <br /><br />select name, guid from oraesb.wf_systems;<br /><br />You need some extra files to make ant work, these files can be found in $ORACLE_HOME/integration/esb/deployment there is an zip file: documentation.zip. In this zip file the files you need are there.<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com0tag:blogger.com,1999:blog-2447545383063131991.post-46270150222867545792010-04-21T20:07:00.004+02:002010-04-21T20:23:31.916+02:00Oracle Application Server 10.1.2.3: oidldapd process, high load on serverOn the production environment of the customer there was a problem that the servers sometimes did not respond on anything anymore. The oidldapd process was consuming 100% CPU and the load on the servers was very high (100+). The only thing we could do was an hard reboot of the server. <br /><br />We solved this issue bij tuning the OID. We replaced the default index by a bitmap index:<br /><br /><pre><code><br />To recreate the ei_attrstore index perform the following steps: <br /><br />a. Use sqlplus to connect to the OID database as user "ods" or connect as system and set the schema to ods, e.g. <br /><br />$ sqlplus system/<system password> <br />SQL> alter session set current_schema=ods; <br /><br />b. Drop the existing ei_attrstore index: <br /><br />SQL> drop index ei_attrstore; <br /><br />c. Recreate the ei_attrstore index: <br /><br />SQL> create bitmap index ei_attrstore on ds_attrstore(entryid, attrname) tablespace olts_attrstore nologging compute statistics; <br /><br />SQL> alter index ei_attrstore noparallel;<br /></pre></code><br /><br />And we changed the configset0<br /><br /><pre><code><br />$ORACLE_HOME/bin/ldapmodify -h [SERVERNAME] -p [PORT] -D cn=orcladmin -w [PASSWORD] -v <<EOF<br />dn: cn=configset0,cn=osdldapd,cn=subconfigsubentry<br />changetype: modify<br />replace: orclmaxcc<br />orclmaxcc: 10<br />-<br />replace: orclserverproces<br />orclserverprocs: 2<br />EOF<br /></pre></code><br /><br />After these changes the oidldapd did not have the strange behavior anymore.<br /><br />Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.Arjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.com2