OSB result Caching support in 11g with external coherence

OSB result Caching support in 11g with external coherence

OSB result Caching support in 11g

http://ift.tt/1AEYlV6

Created a simple SOA project with the simple helloworld that displays time+the input parameter you have passed.

for example

concat(xp20:current-dateTime(),bpws:getVariableData('inputVariable','payload','/client:process/client:input'))

Create a OSB project that calls this web service and enable the result cahcing for the business service.

Take this WSDL and import this to OSB and create a business service with this WSDL.

OSB Project 

Create a proxy service based on the business service.

Modify the file

\fmw11g\fmw1117\Middleware\user_projects\domains\soa_domain\config\osb\coherence\osb-coherence-override.xml

======================================================================================================================

<!DOCTYPE coherence SYSTEM "coherence.dtd">

<coherence>

    <cluster-config>

        <!--

            By specifying a well-known-address we disable the mutlicast listener.

            This ensures that the Coherence cluster for OSB will be isolated to this machine only.

        -->

        <unicast-listener>

            <well-known-addresses>

                <socket-address id="1">

                    <address system-property="OSB.coherence.wka1">xxx.xxx.oracle.com</address>

                    <port system-property="OSB.coherence.wka1.port">7890</port>

                </socket-address>

                <socket-address id="2">

                    <address system-property="OSB.coherence.wka2">xxx.xxx.oracle.com</address>

                    <port system-property="OSB.coherence.wka2.port">7898</port>

                </socket-address>

            </well-known-addresses>

            <address system-property="OSB.coherence.localhost">xxx.xxx.oracle.com</address>

            <port system-property="OSB.coherence.localport">7890</port>

        </unicast-listener>

        <multicast-listener>

            <time-to-live system-property="OSB.coherence.ttl">0</time-to-live>

        </multicast-listener>

    </cluster-config>

</coherence>

+++++++++++++

Where

 <socket-address id="1">

                    <address system-property="OSB.coherence.wka1">xxx.xxx.oracle.com</address>

                    <port system-property="OSB.coherence.wka1.port">7890</port>

                </socket-address>

Is for the stand alone Coherence server

<socket-address id="2">

                    <address system-property="OSB.coherence.wka2">xxx.xxx.oracle.com</address>

                    <port system-property="OSB.coherence.wka2.port">7898</port>

                </socket-address>

Is for the OSB Server

No need to change the file

\\soabde11\fmw11g\fmw1117\Middleware\user_projects\domains\soa_domain\config\osb\coherence\osb-coherence-cache-config.xml

Once it is done , open the setDomainEnv.sh file

EXTRA_JAVA_PROPERTIES="${EXTRA_JAVA_PROPERTIES} -Dsoa.archives.dir=${SOA_ORACLE_HOME}/soa -Dsoa.oracle.home=${SOA_ORACLE_HOME} -Dsoa.instance.home=${DOMAIN_HOME} -Dtangosol.coherence.distributed.localstorage=false -DOSB.coherence.localhost=xxx.xxx.oracle.com -DOSB.coherence.localport=7898 -Dtangosol.coherence.wka1=xxx.xxx.oracle.com -Dtangosol.coherence.wka2=xxx.xxx.oracle.com  -Dtangosol.coherence.wka1.port=7898 -Dtangosol.coherence.wka2.port=7890 -Dtangosol.coherence.log=jdk -Djavax.xml.soap.MessageFactory=oracle.j2ee.ws.saaj.soap.MessageFactoryImpl -Dweblogic.transaction.blocking.commit=true -Dweblogic.transaction.blocking.rollback=true -Djavax.net.ssl.trustStore=${WL_HOME}/server/lib/DemoTrust.jks"

The default entries are

#EXTRA_JAVA_PROPERTIES="${EXTRA_JAVA_PROPERTIES} -Dsoa.archives.dir=${SOA_ORACLE_HOME}/soa -Dsoa.oracle.home=${SOA_ORACLE_HOME} -Dsoa.instance.home=${DOMAIN_HOME} -Dtangosol.coherence.clusteraddress=227.7.7.9 -Dtangosol.coherence.clusterport=9778 -Dtangosol.coherence.log=jdk -Djavax.xml.soap.MessageFactory=oracle.j2ee.ws.saaj.soap.MessageFactoryImpl -Dweblogic.transaction.blocking.commit=true -Dweblogic.transaction.blocking.rollback=true -Djavax.net.ssl.trustStore=${WL_HOME}/server/lib/DemoTrust.jks"

basically you need to remove

-Dtangosol.coherence.clusteraddress=227.7.7.9 -Dtangosol.coherence.clusterport=9778

and replace this with

-Dtangosol.coherence.distributed.localstorage=false -DOSB.coherence.localhost=xxx.xxx.oracle.com -DOSB.coherence.localport=7898 -Dtangosol.coherence.wka1=xxx.xxx.oracle.com -Dtangosol.coherence.wka2=xxx.xxx.oracle.com  -Dtangosol.coherence.wka1.port=7898 -Dtangosol.coherence.wka2.port=7890

Create a shell script to start the Coherence server

+++++

#!/bin/sh

# Change below to appropriate location

JAVA_HOME="/home/oracle/jdk1.7.0_67"

WLS_HOME="/fmw11g/fmw1117/Middleware"

COHERENCE_HOME="${WLS_HOME}/coherence_3.7/"

OSB_ORACLE_HOME="${WLS_HOME}/Oracle_OSB1"

OSB_COHERENCE_CONFIG="${WLS_HOME}/user_projects/domains/soa_domain/config/osb/coherence"

NEW_SIZE=2048m

HEAP_SIZE=4096m

NODE_NAME="CacheServer"

# Change below to appropriate ip address and port

LOCAL_HOST="xxx.xxx.oracle.com"

LOCAL_PORT="9094"

JAVA_OPTS="-Xloggc:gc_${NODE_NAME}.log -server -XX:NewSize=${NEW_SIZE} -XX:MaxNewSize=${NEW_SIZE} -Xms${HEAP_SIZE} -Xmx${HEAP_SIZE} -XX:PermSize=128m -XX:MaxPermSize=128m -verbose:gc -XX:+PrintGCDateStamps -XX:+PrintGCDetails"

JMXPROPERTIES="-Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticate=false -Dtangosol.coherence.management=all -Dtangosol.coherence.management.remote=true "

COHERENCE_OPTS="-Dtangosol.coherence.distributed.localstorage=true -Dtangosol.coherence.override=${OSB_COHERENCE_CONFIG}/osb-coherence-override.xml -Dtangosol.coherence.cacheconfig=${OSB_COHERENCE_CONFIG}/osb-coherence-cache-config.xml -Dtangosol.coherence.log.level=9 -Dtangosol.coherence.cluster=OSB-cluster -Dtangosol.coherence.localhost=${LOCAL_HOST} -Dtangosol.coherence.localport=${LOCAL_PORT}"

CLASSPATH="$COHERENCE_HOME/lib/coherence.jar:$OSB_ORACLE_HOME/lib/osb-coherence-client.jar"

$JAVA_HOME/bin/java -server -showversion $JAVA_OPTS $COHERENCE_OPTS $JMXPROPERTIES -cp "$CLASSPATH" com.tangosol.net.DefaultCacheServer $1

+++++

First start the coherence server using the script

c1.sh

and after this start the OSB Server.

Tags: Publish
April 03, 2017 at 02:22PM
Open in Evernote

How to run a linux command from java code

How to run a linux command from java code

Download opensource java ssh client from 

http://ift.tt/2fVObXE

Use the following java docs , to review the API

http://ift.tt/2gR53TO

package client;

import java.io.BufferedReader;

import java.io.FileInputStream;

import java.io.InputStream;

import java.io.InputStreamReader;

import com.sshtools.net.SocketTransport;

import com.sshtools.ssh.PasswordAuthentication;

import com.sshtools.ssh.SshAuthentication;

import com.sshtools.ssh.SshClient;

import com.sshtools.ssh.SshConnector;

import com.sshtools.ssh.SshSession;

public class Class1 {

    public Class1() {

        super();

    }

    public static void main(String[] args) throws Exception {

        Class1 class1 = new Class1();

        SshConnector con = SshConnector.createInstance();

         SshClient ssh = con.connect(new SocketTransport("localhost", 22),

                        "root");

         PasswordAuthentication pwd = new PasswordAuthentication();

         pwd.setPassword("Welcome1");

         if (ssh.authenticate(pwd) == SshAuthentication.COMPLETE) {

                System.out.println("Authentication succeeded");

                SshSession sesison = ssh.openSessionChannel();

         } else {

                System.out.println("Authentication failed");

         }

        if (ssh.isAuthenticated()) {

                SshSession session = ssh.openSessionChannel();

               session.executeCommand("xm list");

            

               InputStream stdout =  session.getInputStream();

            BufferedReader br = new BufferedReader(new InputStreamReader(stdout));

                       System.out.println("the output of the command is");

                       while (true)

                       {

                           String line = br.readLine();

                           if (line == null)

                               break;

                           System.out.println(line);

                       }

                session.close();

                ssh.disconnect();

        }

    }

}

Tags: Publish
December 03, 2016 at 12:38PM
Open in Evernote

Unable to Play Flash Content on Windows 10

Unable to Play Flash Content on Windows 10

Right click on Flash Content you have

Click to Global Settings -> Advanced TAB

Click on Trusted Location Settings Butoon and and Add your directory where the flash content is there for all the files add say C:\ D:\ E:\ etc

Tags: Publish
November 26, 2016 at 10:17AM
Open in Evernote

PL/SQL Debugger Port Settings McaFee Firewall Disable

PL/SQL Debugger Port Settings McaFee Firewall Disable

Open Mcafee , Right Click and Click on Quick Settings -> Click on Firewall , this disables the firewall

Connecting to the database xxx-xxx

Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE

Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( 'xxxxx', '4000' )

ORA-30683: failure establishing connection to debugger

ORA-12535: TNS:operation timed out

ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68

ORA-06512: at line 1

Process exited.

Disconnecting from the database xxxx.

If you are using mcafee host intrusion prevention firewall , please follow this procedure to disable the firewall.

Firewall should be in the off status ,

Tags: Publish
November 18, 2016 at 11:07AM
Open in Evernote

WLST Script to Change SOAMaxThreadsConfig in 12c

WLST Script to Change SOAMaxThreadsConfig in 12c

import javax.management.openmbean.CompositeDataSupport;

if __name__ == '__main__':

    from wlstModule import *#@UnusedWildImport

print 'starting the script ....'

username = 'weblogic'

password = 'Welcome1'

url='t3://locahost:7001'

connect(username,password,url)

servers = cmo.getServers()

domainRuntime()

for server in servers:

    serverName = server.getName()

    print 'server: ' + server.getName()

    SoaInfraConfigobj = ObjectName('oracle.as.soainfra.config:Location=AdminServer,name=soa-infra,type=SoaInfraConfig,Application=soa-infra')

    print 'Common Properties for soa_server1'

   

    print  mbs.getAttribute(SoaInfraConfigobj, 'GlobalTxRetryInterval')

    props1 = mbs.getAttribute(SoaInfraConfigobj, 'SOAMaxThreadsConfig')

    print props1.get("incomingRequestsPercentage")

    print props1.get("internalBufferPercentage")

    print props1.get("internalProcessingPercentage")

   

    print props1

   

    javaMap = java.util.HashMap()

    javaMap.put("incomingRequestsPercentage", java.lang.Integer(20))

    javaMap.put("internalBufferPercentage", java.lang.Integer(40))

    javaMap.put("internalProcessingPercentage", java.lang.Integer(40))

    print javaMap

   

    mbs.setAttribute(SoaInfraConfigobj, Attribute('GlobalTxRetryInterval', 22))

    print  mbs.getAttribute(SoaInfraConfigobj, 'GlobalTxRetryInterval')

   

    new_rec_config_obj = javax.management.openmbean.CompositeDataSupport(props1.getCompositeType(),javaMap)

    print new_rec_config_obj

   

    mbs.setAttribute(SoaInfraConfigobj, Attribute('SOAMaxThreadsConfig', new_rec_config_obj))

   

   

    props1 = mbs.getAttribute(SoaInfraConfigobj, 'SOAMaxThreadsConfig')

    print props1.get("incomingRequestsPercentage")

    print props1.get("internalBufferPercentage")

    print props1.get("internalProcessingPercentage")

   

   

Tags: Publish
October 24, 2016 at 08:42AM
Open in Evernote

P6 Spy with a stand alone jdbc program

P6 Spy with a stand alone jdbc program

package mdsleak;

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class Class1 {

    public Class1() {

        super();

    }

    public static void main(String[] argv) {

                    System.out.println("-------- Oracle JDBC Connection Testing ------");

                    try {

                         //  Class.forName("oracle.jdbc.driver.OracleDriver");

                        Class.forName("com.p6spy.engine.spy.P6SpyDriver");

                    } catch (ClassNotFoundException e) {

                            System.out.println("Where is your Oracle JDBC Driver?");

                            e.printStackTrace();

                            return;

                    }

                    System.out.println("Oracle JDBC Driver Registered!");

                    Connection connection = null;

                    try {

                       //     connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott","tiger");

                       connection = DriverManager.getConnection("jdbc:p6spy:oracle:thin:@localhost :1521:orcl", "scott","tiger");

                        Statement stmt3 = connection.createStatement();

                        ResultSet rs3 = stmt3.executeQuery("SELECT COUNT(*) FROM EMP,EMP,EMP,EMP,EMP");

                            while(rs3.next()){

                            System.out.println(rs3.getInt(1));

                            }

                    } catch (SQLException e) {

                            System.out.println("Connection Failed! Check output console");

                            e.printStackTrace();

                            return;

                    }

                    if (connection != null) {

                            System.out.println("You made it, take control your database now!");

                    } else {

                            System.out.println("Failed to make connection!");

                    }

            }

}

Create a directory c:\temp\p6spy

Copy the file p6spy.jar to c:\temp\p6spy

Create a new file c:\temp\p6spy\spy.properties with the following

contents

++++++++++

realdatasourceclass=oracle.jdbc.driver.OracleDriver

autoflush=true

logfile=c:/temp/spy.log

append=false

+++++++++

Run the Java Program with the following arguments

C:\jdk1.7.0_79\bin\java.exe -classpath D:\myjdevwork\jdev1117\mywork\Application2\MDSLeak\classes;c:\temp\p6spy;c:\temp\p6spy\p6spy.jar;D:\sqldeveloper\jdbc\lib\ojdbc7.jar Class1

 you should see a file c:/temp/spy.log with the following

1477027846045|193|statement|connection 0|SELECT COUNT(*) FROM EMP,EMP,EMP,EMP,EMP|

Here 193 is the time it took in ms and 1477027846045 is the The Current Unix Timestamp

Import changes to the JDBC Program 

 //  Class.forName("oracle.jdbc.driver.OracleDriver");

  Class.forName("com.p6spy.engine.spy.P6SpyDriver");

   //     connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott","tiger");

         connection = DriverManager.getConnection("jdbc:p6spy:oracle:thin:@localhost :1521:orcl", "scott","tiger");

Tags: Publish
October 21, 2016 at 12:20PM
Open in Evernote

Enable JDBC Tracing with ODI (p6spy)

Enable JDBC Tracing with ODI (p6spy)

Create a directory c:\temp\p6spy

Copy the file p6spy.jar to c:\temp\p6spy

Create a new file c:\temp\p6spy\spy.properties with the following

contents

++++++++++

realdatasourceclass=oracle.jdbc.driver.OracleDriver

autoflush=true

logfile=c:/temp/spy.log

append=false

+++++++++

Open the file odi.conf file and add the following lines

after the line

AddJavaLibFile ../../../oracle_common/modules/features/com.oracle.db.jdbc7-dms.jar

+++

AddJavaLibFile c:/temp/p6spy/

AddJavaLibFile c:/temp/p6spy/p6spy.jar

+++

Invoke odi and edit the connection setting

For the JDBC driver name specify it as

com.p6spy.engine.spy.P6SpyDriver

and change the JDBC url to

jdbc:p6spy:oracle:thin:@localhost:1521:orcl

Perform some operations and you should see a file c:/temp/spy.log with the following

1477027846045|193|statement|connection 0|SELECT COUNT(*) FROM EMP,EMP,EMP,EMP,EMP|

Here 193 is the time it took in ms and 1477027846045 is the The Current Unix Timestamp

Tags: Publish
October 21, 2016 at 12:19PM
Open in Evernote

How to find out which jar file is loading the class I am looking for ??

How to find out which jar file is loading the class I am looking for ??

In SOA add the following java code to BPEL Java embeding activity 

++++
System.out.println("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx");
        try {


System.out.println(Class.forName("oracle.tip.adapter.ftp.SFTPClient").getProtectionDomain().getCodeSource().getLocation());

        }
        catch(Exception e1)
        {
         e1.printStackTrace();
        }

System.out.println("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ");

+++

Result :

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
file:/apps/erikad1/aerikad1/app_ECTH/ecthd0runtime/SOA/domain/ECTH_SOA_Domain/servers/ECTH_SOA1/stage/FtpAdapter1/FtpAdapter.rar

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

You can also add the flag 

export JAVA_OPTIONS="-verbose:class". This writes all the class loading

information to the standard out file.

This displays messages like

[Loaded oracle.tip.adapter.ftp.SFTPAgent from
file:/apps/erikad1/aerikad1/app_ECTH/ecthd0runtime/SOA/domain/ECTH_SOA_Domain/servers/ECTH_SOA1/stage/FtpAdapter1/FtpAdapter.rar]
[Loaded oracle.tip.adapter.ftp.SFTPClient from
file:/apps/erikad1/aerikad1/app_ECTH/ecthd0runtime/SOA/domain/ECTH_SOA_Domain/servers/ECTH_SOA1/stage/FtpAdapter1/FtpAdapter.rar]
[Loaded oracle.tip.adapter.file.outbound.FileLister from

file:/apps/erikad1/aerikad1/app_ECTH/ecthd0soa/fmw/SOA/soa/connectors/FileAdapter.rar]

Tags: Publish
March 29, 2016 at 09:08AM
Open in Evernote

Create WLST Project in Eclipse

Create WLST Project in Eclipse

File -> New -> Project and Select Faceted Project

Select Java -> 1.6 or 1.7

select Oracle WLST , Oracle Weblogic Utility Module Extensions , Utility Module

In the Runtime tab select Oracle Weblogic Server and click on Finish

and click on Finish 

File->New -> Select Another 

This creates test1.py with some sample code. Please change the password and the serverurl and run the project.

Tags: Publish
September 25, 2016 at 11:04AM
Open in Evernote

How to Automate Email Server setting's for Human WorkkFlow in SOA 11g and and 12c

How to Automate Email Server setting's for Human WorkkFlow in SOA 11g and and 12c

How to Automate Email Server setting's for Human WorkFlow in SOA 11g 

First run the program

c:\jdk1.7.0_79\jre\bin\java.exe -classpath D:\fmw1117\Middleware\Oracle_SOA1\soa\modules\oracle.soa.workflow_11.1.1\bpm-services.jar;D:\fmw1117\Middleware\wlserver_10.3\server\lib\wljmxclient.jar oracle.bpel.services.notification.util.ConfigureNotification

and then run with the getConfig option , this creates a blank notification.properties with all the properties if you have n't configured email previously

c:\jdk1.7.0_79\jre\bin\java.exe -classpath D:\fmw1117\Middleware\Oracle_SOA1\soa\modules\oracle.soa.workflow_11.1.1\bpm-services.jar;D:\fmw1117\Middleware\wlserver_10.3\server\lib\wljmxclient.jar oracle.bpel.services.notification.util.ConfigureNotification localhost 7001 weblogic Welcome1 WLS notification.properties getConfig

This writes the file notification.properties in the following format ,

+++

c:\jdk1.7.0_79\jre\bin\java.exe -classpath  D:\bpm12cqs\soa\soa\modules\oracle.soa.workflow_11.1.1\bpm-services.jar;D:\bpm12cqs\wlserver\server\lib\wljmxclient.jar oracle.bpel.services.notification.util.ConfigureNotification  iscsoavm21.idc.oracle.com 7001 weblogic Welcome1 WLS notification.properties getConfig

Hostname :[iscsoavm21.idc.oracle.com] Port :[7001] AdminUser :[weblogic] AppServer :[WLS] propertyfile :[notification.properties] flag :[getConfig]

Retrieving usermessagingdriver-email-driverconfig ....

OutgoingMailServer=

OutgoingMailServerPort=25

OutgoingMailServerSecurity=None

OutgoingEmailId=

OutgoingUsername=

OutgoingPassword=

MailAccessProtocol=IMAP

IncomingMailServer=

IncomingMailServerPort=

IncomingMailServerSSL=false

IncomingEMailId=

IncomingUsername=

IncomingPassword=

ImapAuthPlainDisable=false

RetryLimit=-1

MailDelFreq=600

AutoDelete=false

Debug=false

CheckMailFreq=30

ReceiveFolder=INBOX

ProcessingChunkSize=100

Retrieving worklfow-notification-config ....

HWFMailerNotificationMode=NONE

ASNSDriverEmailReplyAddress=no.reply@yourdomain.com

ASNSDriverEmailFromAddress=accountId@yourdomain.com

ASNSDriverEmailRespondAddress=respondToaccountId@yourdomain.com

Storing the config to the properties file....

Done.

+++

Now open the notification.properties and edit the values as shown below ,

# User Messaging Email Driver config

OutgoingMailServer=localhost

OutgoingMailServerPort=25

OutgoingMailServerSecurity=None

OutgoingEmailId=bpelsender@localhost

OutgoingUsername=bpelsender@localhost

OutgoingPassword=Welcome1

MailAccessProtocol=IMAP

IncomingMailServer=localhost

IncomingMailServerPort=143

IncomingMailServerSSL=false

IncomingEMailId=bpelreceiver@localhost

IncomingUsername=bpelreceiver@localhost

IncomingPassword=Welcome1

ImapAuthPlainDisable=false

RetryLimit=-1

MailDelFreq=600

AutoDelete=false

Debug=false

CheckMailFreq=30

ReceiveFolder=INBOX

ProcessingChunkSize=100

# HWF config

HWFMailerNotificationMode=EMAIL

ASNSDriverEmailReplyAddress=no.reply@yourdomain.com

ASNSDriverEmailFromAddress=bpelsender@localhost

ASNSDriverEmailRespondAddress=bpelreceiver@localhost

Now run the command

c:\jdk1.7.0_79\jre\bin\java.exe -classpath D:\fmw1117\Middleware\Oracle_SOA1\soa\modules\oracle.soa.workflow_11.1.1\bpm-services.jar;D:\fmw1117\Middleware\wlserver_10.3\server\lib\wljmxclient.jar oracle.bpel.services.notification.util.ConfigureNotification localhost 7001 weblogic Welcome1 wls notification.properties setConfig

This will set the required properties for the Email Server Configuration.

To cross check the values you have set run with the getConfig options agian

c:\jdk1.7.0_79\jre\bin\java.exe -classpath  D:\bpm12cqs\soa\soa\modules\oracle.soa.workflow_11.1.1\bpm-services.jar;D:\bpm12cqs\wlserver\server\lib\wljmxclient.jar oracle.bpel.services.notification.util.ConfigureNotification  localhost 14001 weblogic Welcome1 WLS notification.properties getConfig

Please note that this is not available with SOA 12c.

Tags: Publish
September 15, 2016 at 03:25PM
Open in Evernote

Stop DERBY Server in a SOA Quick start Install

Stop DERBY Server in a SOA Quick start Install

Open the file $DOMAIN_HOME/bin/setDomainEnv.sh

and set DERBY_FLAG="false" by default it is set to true.

# Set DERBY_FLAG, if derby is available.

if [ -f ${WL_HOME}/common/derby/lib/derby.jar ] ; then

        DERBY_FLAG="false"

        export DERBY_FLAG

fi

Tags: Publish
September 22, 2016 at 02:54PM
Open in Evernote

Create EMAIL Server Profile in 12c

Create EMAIL Server Profile in 12c

import javax.management.openmbean.CompositeDataSupport;

if __name__ == '__main__':

    from wlstModule import *#@UnusedWildImport

print 'starting the script ....'

username = 'weblogic'

password = 'Welcome1'

url='t3://localhost:14001'

profileName='testemail'

MailAccessProtocol = 'IMAP'

OutgoingMailServer = 'localhost'

OutgoingMailServerPort = '25'

OutgoingMailServerSecurity = 'None'

OutgoingDefaultFromAddr = 'bpelsender@localhost'

OutgoingUsername = 'bpelsender@localhost'

OutgoingPassword = 'Welcome1'

IncomingMailServer = 'localhost'

IncomingMailServerPort = '143'

IncomingMailIDs = 'bpelreceiver@localhost'

IncomingUserIDs = 'bpelreceiver@localhost'

IncomingUserPasswords = 'Welcome1'

ASNSDriverEmailFromAddress='bpelsender@localhost'

ASNSDriverEmailRespondAddress='bpelreceiver@localhost'

ASNSDriverEmailReplyAddress='no.reply@yourdomain.com'

HWFMailerNotificationMode='EMAIL'

connect(username,password,url)

servers = cmo.getServers()

domainRuntime()

for server in servers:

    serverName = server.getName()

    print 'server: ' + server.getName()

    EmailProfileConfigobj = ObjectName('oracle.ucs.messaging:type=UmsDomainConfig,name=UmsDomainConfiguration')

    print 'Common Properties for soa_server1'

   

    mbs.invoke(EmailProfileConfigobj,'removeDriverConfig',[profileName,'email'],['java.lang.String','java.lang.String'])

   

    mbs.invoke(EmailProfileConfigobj,'createDriverConfig',[profileName,'email'],['java.lang.String','java.lang.String'])

    print mbs.invoke(EmailProfileConfigobj,'getDriverConfig',[profileName,'email'],['java.lang.String','java.lang.String'])

   

    EmailDriverConfigobj = ObjectName('oracle.ucs.messaging:name='+profileName+',type=UmsDomainConfig.DriverConfig,driverType=email,UmsDomainConfig=UmsDomainConfiguration')

    mbs.invoke(EmailDriverConfigobj,'setProperty',['MailAccessProtocol',MailAccessProtocol],['java.lang.String','java.lang.String'])

    mbs.invoke(EmailDriverConfigobj,'setProperty',['OutgoingMailServer',OutgoingMailServer],['java.lang.String','java.lang.String'])

    mbs.invoke(EmailDriverConfigobj,'setProperty',['OutgoingMailServerPort',OutgoingMailServerPort],['java.lang.String','java.lang.String'])

    mbs.invoke(EmailDriverConfigobj,'setProperty',['OutgoingMailServerSecurity',OutgoingMailServerSecurity],['java.lang.String','java.lang.String'])

    mbs.invoke(EmailDriverConfigobj,'setProperty',['OutgoingDefaultFromAddr',OutgoingDefaultFromAddr],['java.lang.String','java.lang.String'])

    mbs.invoke(EmailDriverConfigobj,'setProperty',['OutgoingUsername',OutgoingUsername],['java.lang.String','java.lang.String'])

    mbs.invoke(EmailDriverConfigobj,'setProperty',['OutgoingPassword',OutgoingPassword],['java.lang.String','java.lang.String'])

    mbs.invoke(EmailDriverConfigobj,'setProperty',['IncomingMailServer',IncomingMailServer],['java.lang.String','java.lang.String'])

    mbs.invoke(EmailDriverConfigobj,'setProperty',['IncomingMailIDs',IncomingMailIDs],['java.lang.String','java.lang.String'])

    mbs.invoke(EmailDriverConfigobj,'setProperty',['IncomingUserIDs',IncomingUserIDs],['java.lang.String','java.lang.String'])

    mbs.invoke(EmailDriverConfigobj,'setProperty',['IncomingUserPasswords',IncomingUserPasswords],['java.lang.String','java.lang.String'])

    props1 = mbs.getAttribute(EmailDriverConfigobj, 'Properties')

   

    for props2 in props1:

            print str(props2.get('name')) +' = ' + str(props2.get('value'))

   

    WorkflowNotificationObj = ObjectName('oracle.as.soainfra.config:Location='+serverName +',name=human-workflow,type=HWFMailerConfig,Application=soa-infra')

    mbs.setAttribute(WorkflowNotificationObj, Attribute('ASNSDriverEmailFromAddress', ASNSDriverEmailFromAddress))

    mbs.setAttribute(WorkflowNotificationObj, Attribute('ASNSDriverEmailRespondAddress', ASNSDriverEmailRespondAddress))

    mbs.setAttribute(WorkflowNotificationObj, Attribute('ASNSDriverEmailReplyAddress', ASNSDriverEmailReplyAddress ))

    mbs.setAttribute(WorkflowNotificationObj, Attribute('HWFMailerNotificationMode', HWFMailerNotificationMode))

   

    print 'HWFMailerNotificationMode' +' = '+ mbs.getAttribute(WorkflowNotificationObj, 'ASNSDriverEmailReplyAddress')

    print 'ASNSDriverEmailFromAddress' +' = '+ mbs.getAttribute(WorkflowNotificationObj, 'ASNSDriverEmailFromAddress')

    print 'ASNSDriverEmailRespondAddress' +' = '+ mbs.getAttribute(WorkflowNotificationObj, 'ASNSDriverEmailRespondAddress')

    print 'HWFMailerNotificationMode' +' = '+ mbs.getAttribute(WorkflowNotificationObj, 'HWFMailerNotificationMode')

   

Tags: Publish
September 19, 2016 at 03:45PM
Open in Evernote

How to find out which jar file is loading the class I am looking for ??

In SOA add the following java code to BPEL Java embeding activity 

++++
System.out.println("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx");
        try {


System.out.println(Class.forName("oracle.tip.adapter.ftp.SFTPClient").getProtectionDomain().getCodeSource().getLocation());

        }
        catch(Exception e1)
        {
         e1.printStackTrace();
        }

System.out.println("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ");

+++

Result :

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
file:/apps/erikad1/aerikad1/app_ECTH/ecthd0runtime/SOA/domain/ECTH_SOA_Domain/servers/ECTH_SOA1/stage/FtpAdapter1/FtpAdapter.rar

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

You can also add the flag 

export JAVA_OPTIONS="-verbose:class". This writes all the class loading

information to the standard out file.

This displays messages like

[Loaded oracle.tip.adapter.ftp.SFTPAgent from
file:/apps/erikad1/aerikad1/app_ECTH/ecthd0runtime/SOA/domain/ECTH_SOA_Domain/servers/ECTH_SOA1/stage/FtpAdapter1/FtpAdapter.rar]
[Loaded oracle.tip.adapter.ftp.SFTPClient from
file:/apps/erikad1/aerikad1/app_ECTH/ecthd0runtime/SOA/domain/ECTH_SOA_Domain/servers/ECTH_SOA1/stage/FtpAdapter1/FtpAdapter.rar]
[Loaded oracle.tip.adapter.file.outbound.FileLister from

file:/apps/erikad1/aerikad1/app_ECTH/ecthd0soa/fmw/SOA/soa/connectors/FileAdapter.rar]

Use different user directories for different Jdeveloper versions

In my system I have 4 jdev versions installed , jdev 11.1.1.7 , jdev 11.1.1.9 , jdev 12.1.3 and jdev 12.1.3

by default when i create a new application or project it is creating under the directory C:\JDeveloper\mywork

this is causing too much confusions for me in opening up the projects.

First create user environment variable's

JDEV1117_USER_HOME=d:\myjdevwork\jdev1117

JDEV1119_USER_HOME=d:\myjdevwork\jdev1119

JDEV1213_USER_HOME=d:\myjdevwork\jdev1213

JDEV1221_USER_HOME=d:\myjdevwork\jdev1221

Open the file D:\jdev1117\jdeveloper\jdev\bin\jdev.boot

and comment the variable ide.user.dir.var and add the following 

#ide.user.dir.var = JDEV_USER_HOME,JDEV_USER_DIR

ide.user.dir.var = JDEV1117_USER_HOME

Do the same for jdev 12.1.3 

D:\soa12cqs\jdeveloper\jdev\bin\jdev.boot

#ide.user.dir.var = JDEV_USER_HOME,JDEV_USER_DIR

ide.user.dir.var = JDEV1213_USER_HOME

How to get the username from BPEL code

I have an requirement where Composite-A (SAML1Call) call Calls Composite-B (SAML1)

I have created a new project , SAML1 with
oracle/wss11_saml_token_with_message_protection_service_policy
This is called from SAML1Call SOA composite

SAML1Call uses oracle/wss_username_token_service_policy for the inbound
and oracle/wss11_saml_token_with_message_protection_client_policy for calling
the SAML1 composite 
We would like to get the UserName from BPEL code 


Please check the enhancment request
Bug 21247695 - Need extract currently logged in security user name in BPEL
easily

How to get the security header parameters in a BPEL process (Doc ID
2021281.1)

You need to copy the file jps-api.jar to your bpel project SCA-INF\lib
directory

for example ,

copy
D:\fmw1117\Middleware\oracle_common\modules\oracle.jps_11.1.1\jps-api.jar
C:\JDeveloper\mywork\test1\SAML1\SCA-INF\lib

define a bpel variable say CurrentLoggedInUser with XML type as string and
have the following java embeding activity

++
 javax.security.auth.Subject currentSubject =
oracle.security.jps.util.SubjectUtil.getCurrentSubject();
String   userName =
oracle.security.jps.util.SubjectUtil.getUserName(currentSubject);
System.out.println(" xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ");
System.out.println(" In the SAML1 Composite "+userName);
System.out.println(" xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ");
setVariableData("CurrentLoggedInUser",userName);
++

SOA 12c Install error Insufficient free space

 

While trying to install getting an error

 

java -jar fmw_12.1.3.0.0_soa_quickstart.jar
Launcher log file is /tmp/OraInstall2014-07-07_11-50-41AM/launcher2014-07-07_11-50-41AM.log.
Insufficient free space in /tmp/orcl965540478413729726.tmp to extract the installer.  Actual 153 MB.  Required 3053 MB.

As I do not have sufficent space in /tmp directory used the following workaround.

Create a directory /fmw11g/tmp

export _JAVA_OPTIONS="-Djava.io.tmpdir=/fmw11g/tmp"

Now when you start the installer you see the o/p as

java -jar fmw_12.1.3.0.0_soa_quickstart.jar
Picked up _JAVA_OPTIONS: -Djava.io.tmpdir=/fmw11g/tmp
Launcher log file is /fmw11g/tmp/OraInstall2014-07-07_11-56-55AM/launcher2014-07-07_11-56-55AM.log.

Opatch fails with the error java.lang.UnsatisfiedLinkError: Can't load library ../oui/lib/linux/liboraInstaller.so

 

OPatch giving an error on 64 bit linux with 64 bit JDK
java.lang.UnsatisfiedLinkError: Can't load library: /fmw11g/fmw1116/Middleware/oracle_common/oui/lib/linux/liboraInstaller.so
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1706)
        at java.lang.Runtime.load0(Runtime.java:770)
        at java.lang.System.load(System.java:1004)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.loadNativeLib(OiipuUnixOps.java:402)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.<clinit>(OiipuUnixOps.java:126)
        at oracle.sysman.oii.oiip.oiipg.OiipgEnvironment.ssgetUidux(OiipgEnvironment.java:528)
        at oracle.sysman.oii.oiix.OiixEnvironmentOps.ssgetUidux(OiixEnvironmentOps.java:159)
        at oracle.opatch.OUIReplacer.isRootAccess(OUIReplacer.java:741)
        at oracle.opatch.OPatch.main(OPatch.java:513)
Exception in thread "Main Thread" java.lang.UnsatisfiedLinkError: no oraInstaller in java.library.path
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1738)
        at java.lang.Runtime.loadLibrary0(Runtime.java:823)
        at java.lang.System.loadLibrary(System.java:1029)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.loadNativeLib(OiipuUnixOps.java:420)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.<clinit>(OiipuUnixOps.java:126)
        at oracle.sysman.oii.oiip.oiipg.OiipgEnvironment.ssgetUidux(OiipgEnvironment.java:528)
        at oracle.sysman.oii.oiix.OiixEnvironmentOps.ssgetUidux(OiixEnvironmentOps.java:159)
        at oracle.opatch.OUIReplacer.isRootAccess(OUIReplacer.java:741)
        at oracle.opatch.OPatch.main(OPatch.java:513)
Modify the file
/fmw11g/fmw1116/Middleware/wlserver_10.3/common/bin/commEnv.sh
and Change the
SUN_ARCH_DATA_MODEL="64"
JAVA_USE_64BIT=true
JAVA_HOME variable to /home/oracle/jdk1.6.0_45_64  and
JAVA_VENDOR variable to Sun.
for example ,
# Setup SUN_ARCH_DATA_MODEL
SUN_ARCH_DATA_MODEL="64"
#JAVA_USE_64BIT, true if JVM uses 64 bit operations
JAVA_USE_64BIT=true
# Reset JAVA_HOME, JAVA_VENDOR and PRODUCTION_MODE unless JAVA_HOME
# and JAVA_VENDOR are pre-defined.
if [ -z "${JAVA_HOME}" -o -z "${JAVA_VENDOR}" ]; then
  # Set up JAVA HOME
  JAVA_HOME="/home/oracle/jdk1.6.0_45_64"
  # Set up JAVA VENDOR, possible values are
  #Oracle, HP, IBM, Sun ...
  JAVA_VENDOR=Sun
  # PRODUCTION_MODE, default to the development mode
  PRODUCTION_MODE=""
fi

https://blogs.oracle.com/fmwinstallproactive/entry/which_jdk_is_my_fmw

How to print the XML data for a variable in BPEL

 

You can use the following java embedded  code 

try { 
  System.out.println("+++++++ Printing XML Variables ++++++++++ (Start) "+getInstanceId());  
    oracle.xml.parser.v2.XMLElement input = (oracle.xml.parser.v2.XMLElement) getVariableData("transactionDataArray");  
  System.out.println(" ++++ qname "+input.getQualifiedName() );  
javax.xml.transform.TransformerFactory tfactory = javax.xml.transform.TransformerFactory.newInstance();
javax.xml.transform.Transformer xform = tfactory.newTransformer();
javax.xml.transform.dom.DOMSource src = new  javax.xml.transform.dom.DOMSource(input);
java.io.StringWriter writer = new java.io.StringWriter();
javax.xml.transform.Result  result = new javax.xml.transform.stream.StreamResult(writer);
xform.transform(src, result);
System.out.println(writer.toString());
  System.out.println("+++++++ Printing XML Variables ++++++++++ (End) "+getInstanceId());
} catch (Exception e) {  
  System.out.println("exception "+e.getMessage());  
}

This will print the XML string for an variable.

Changing the Java Memory Settings for the WebLogic Server Based on Server Name

 

In Unix/Linux

Add these lines to $DOMAIN_HOME/bin/startWeblogic.sh file ,
 
+=+= Start +=+=
if [ "$SERVER_NAME" = "AdminServer"  ]
then
export MEM_ARGS="-Xms512m -Xmx1560m -XX:MaxPermSize=512m -XX:ReservedCodeCacheSize=64m"
fi

if [ "$SERVER_NAME" = "bam_server1"  ]
then
export MEM_ARGS="-Xms512m -Xmx756m -XX:MaxPermSize=512m -XX:ReservedCodeCacheSize=64m"
fi

echo "================================ Memory Arguments for " $SERVER_NAME " " $MEM_ARGS

+=+= End  +=+=

Add the above libes after the line ,

. ${DOMAIN_HOME}/bin/setDomainEnv.sh $*

 

In Windows

+=+= Start +=+=
if "%SERVER_NAME%"=="AdminServer" (
set MEM_ARGS=
set MEM_ARGS=-Xms512m -Xmx1586m -XX:PermSize=512m -XX:MaxPermSize=512m -XX:ReservedCodeCacheSize=64m
       
    )
   
if "%SERVER_NAME%"=="bam_server1" (
set MEM_ARGS=
set MEM_ARGS=-Xms212m -Xmx556m -XX:PermSize=212m -XX:MaxPermSize=312m -XX:ReservedCodeCacheSize=64m
       
    )
   
echo  ===================== Memory Arguments for  %SERVER_NAME%  %MEM_ARGS%   
+=+= End  +=+=

Add the above libes after the line

call "%DOMAIN_HOME%\bin\setDomainEnv.cmd" %*

Create SOA related Queues

 

-- Drop and create IP_IN_QUEUE related queue tables , queues etc
begin
dbms_aqadm.stop_queue (queue_name => 'IP_IN_QUEUE');
dbms_aqadm.drop_queue (queue_name => 'IP_IN_QUEUE');
dbms_aqadm.stop_queue (queue_name => 'IP_OUT_QUEUE');
dbms_aqadm.drop_queue (queue_name => 'IP_OUT_QUEUE');
dbms_aqadm.drop_queue_table (queue_table => 'IP_QTAB');
end;
 
BEGIN
   dbms_aqadm.create_queue_table (queue_table => 'IP_QTAB', queue_payload_type =>  'IP_MESSAGE_TYPE', multiple_consumers => TRUE);
   dbms_aqadm.create_queue (queue_name =>  'IP_IN_QUEUE', queue_table =>  'IP_QTAB');
   dbms_aqadm.create_queue (queue_name => 'IP_OUT_QUEUE', queue_table => 'IP_QTAB');
   dbms_aqadm.start_queue(queue_name => 'IP_IN_QUEUE', dequeue => TRUE, enqueue => TRUE);
   dbms_aqadm.start_queue(queue_name =>  'IP_OUT_QUEUE', dequeue => TRUE, enqueue => TRUE);
END;

-- Drop and create  edn_event_queue related related queue tables , queues etc and subscribers

begin
  DBMS_AQADM.stop_queue(queue_name=>'edn_event_queue');
  DBMS_AQADM.drop_queue(queue_name=>'edn_event_queue');
  DBMS_AQADM.drop_queue_table(queue_table=>'edn_event_queue_table');
end;

begin
  DBMS_AQADM.create_queue_table(
    queue_table         => 'edn_event_queue_table',
    queue_payload_type  => 'EDN_EVENT_DATA',
    multiple_consumers  => TRUE);
   
  DBMS_AQADM.create_queue(
    queue_name          => 'edn_event_queue',
    queue_table         => 'edn_event_queue_table');
  DBMS_AQADM.start_queue(queue_name=>'edn_event_queue');
end;

REM  Register Fabric subscriber
declare
  sub sys.aq$_agent;
begin
  sub := sys.aq$_agent('edn_java_subscriber', NULL, NULL);
  DBMS_AQADM.add_subscriber(queue_name=>'edn_event_queue', subscriber=>sub);
end;

REM  Register SQL subscriber
declare
  sub sys.aq$_agent;
begin
  sub := sys.aq$_agent('edn_sql_subscriber', NULL, NULL);
  DBMS_AQADM.add_subscriber(queue_name=>'edn_event_queue', subscriber=>sub);
end;

--  Drop and create  edn_oaoo_queue related related queue tables , queues etc and subscribers

begin
  DBMS_AQADM.stop_queue(queue_name=>'edn_oaoo_queue');
  DBMS_AQADM.drop_queue(queue_name=>'edn_oaoo_queue');
  DBMS_AQADM.drop_queue_table(queue_table=>'edn_oaoo_delivery_table');
end;
/

begin
  DBMS_AQADM.create_queue_table(
    queue_table         => 'edn_oaoo_delivery_table',
    queue_payload_type  => 'edn_oaoo_delivery',
    multiple_consumers  => TRUE);
  DBMS_AQADM.create_queue(
    queue_name          => 'edn_oaoo_queue',
    queue_table         => 'edn_oaoo_delivery_table');
  DBMS_AQADM.start_queue(queue_name=>'edn_oaoo_queue');
end;

declare
  sub sys.aq$_agent;
begin
  sub := sys.aq$_agent('edn_oaoo_subscriber', NULL, NULL);
  DBMS_AQADM.add_subscriber(queue_name=>'edn_oaoo_queue', subscriber=>sub);
end;