AIX commands

SFTP to a system:

sftp soauser@optaixdbexe01qa
sftp> put /utl/eaistaging/ebs/outbound/o2c/Oracle_EXE_I552_Orders/Orders53/MAULDIN_51.txt .
sftp> ls /home/soauser
sftp> exit

sftp username@hostname

put localpath remotePath

===================================
Find File System Disk space

df -k /
df -k /home/sdoddi

=====

Find Command:

find . -name '*.DAT'

this will find all the files ending with .DAT starting from  the current directory (the DOT (.) indicates the current directory)

If you don't want to do this recursively and search only the current folder,

find . -xdev -name '*.DAT'

For finding from root,

find / -name '*.DAT'

For finding from a specific directory,
find /utl/mdm/logs -name '*.DAT'

For size
find . -size +2  (1 block is 512 kb.. )

for files which got changed in the last 2 days,

find . -mtime -2

find . -name '*.DAT' -mmin -120

files which are not access for last 7 days and which end with .DAT

find . -name '*.DAT' -atime +7

Java useful links

http://howtodoinjava.com
http://java-success.blogspot.com

...will keep updating..

Passing two variables to Xquery Transformation

Using Xquery Transformation wizard in OEPE we can create a Xquery transformation with multiple input source variable types.  But sometimes when we want to add an extra parameter to the source to an existing Xquery transformation do the below:
suppose we have an existing xquery transformation as below: (Removed the mappings to be clear)

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

declare function xf:sample($orcl2FoodlinVendorOutputCollection1 as element(ns0:Orcl2FoodlinVendorOutputCollection))
    as element(ns1:VendorList) {
       
};
                             
declare variable $orcl2FoodlinVendorOutputCollection1 as element(ns0:Orcl2FoodlinVendorOutputCollection) external;


xf:sample($orcl2FoodlinVendorOutputCollection1)

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

And I would like to add another variable, "runId" which is a string as an input to the above Xquery Transformation:

declare function xf:sample($orcl2FoodlinVendorOutputCollection1 as element(ns0:Orcl2FoodlinVendorOutputCollection),$runId as xs:string)

    as element(ns1:VendorList) {

       

};

declare variable $orcl2FoodlinVendorOutputCollection1 as element(ns0:Orcl2FoodlinVendorOutputCollection) external;

declare variable $runId as xs:string external;

xf:sample($orcl2FoodlinVendorOutputCollection1, $runId)

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

The variable "runId" should be declared and assigned prior to this xquery transformation in the proxy service message flow (or in the split join flow)

Setting space as constant in Xquery Transformation

Add below to the prolog and set the space to the xml tag.

declare xmlspace preserve;

JAXB JAXBElement XJC @XmlRootElement

C:\orderXSDs>xjc -d  C:\src -p com.cswg.soa.ebs.otc.outbound.exe.orders.dcinfo F
ileTypeByDCInfo_table.xsd


FileTypeByDCInfo_table.xsd is located under orderXSDs directory.  The generated clases will be under C:\src directory

if you are getting the exception,
java.lang.ClassCastException: javax.xml.bind.JAXBElement cannot be cast
look @
http://weblogs.java.net/blog/kohsuke/archive/2006/03/why_does_jaxb_p.html

http://stackoverflow.com/questions/707084/class-cast-exception-when-trying-to-unmarshall-xml

call https service from osb...

The below is copied from: https://forums.oracle.com/forums/thread.jspa?threadID=1120159

Below note gives the high level steps to be performed for implementing different security requirements with OSB OSB - Proxy Service HTTPS one way Configure Identity & Trust Keystore OSB - Proxy Service HTTPS 2 way Configure Identity Assertion Provider to support X509 Configure user mapper class for default identity assertion provider Change 2 way Client Cert behaviour from default ('Client Certificate Not requested”) to “Client Certificate requested but not enforced” OSB - Business Service HTTPS one way Add root & intermediate CA certificates of the server to the trust keystore *OSB - Business Service HTTPS 2 way * Add root & intermediate CA certificates of the server to the trust keystore Configure PKI Credential Provider containing the client certificate Configure a Service Key provider with SSL Client Authentication key Associate the service key provider to the proxy service which invokes the business service OSB - Proxy Service WS-Security User Name Token Configure Auth.xml or custom username token WS-Security Policy OSB - Proxy Service WS-Security X509 Token Configure Auth.xml and Sign.xml Policy Change UseX509ForIdentity attribute in domain → WS Security → Inbound Mbean Token handlers Page to true Ensure Certificate passed by client is present in certificate registry or the root CA in trust keystore depending upon weblogic certification path provider configuration Configure Identity Assertion Provider and Username mapper class. OSB - Business Service WS-Security User Name Token Configure Auth or custom username token WS-Security Policy Configure Service account for username provider OSB - Business Service WS-Security X509 Token Configure Sign.xml and Auth.xml policy ( or custom signing and username token policies) in the business service Configure a PKI credential provider and service key provider containing the certificate to be used for signing and authentication Associate the service key provider to the proxy service which invokes the business service. OSB - Proxy Service Digital Signature [ Request Only] Configure Sign.xml or a custom signing policy to the proxy service Ensure Certificate passed by client is present in certificate registry or the root CA in trust keystore depending upon weblogic certification path provider configuration OSB – Business Service Digital Signature [ Request Only] Configure Sign.xml policy ( or custom signing policy) in the business service Configure a PKI credential provider and service key provider containing the certificate to be used for signing Associate the service key provider to the proxy service which invokes the business service.

Oracle SOA Suite - Information Websites and Blogs

Here I will be sharing a lot of links which have a lot of useful information about Oracle SOA Suite.

SOA:
http://javaoraclesoa.blogspot.nl
http://erpschools.com
http://blog.ipnweb.com/p/index-of-articles.html
http://javaoraclesoa.blogspot.com/
http://moshe-soa.blogspot.com
http://georgie-soablog.blogspot.com
http://weblogic-wonders.com/weblogic/2009/10/12/configuring-two-way-ssl-between-client-and-weblogic-server-with-apache-proxying-the-request/
http://middlewaremagic.com/weblogic/?p=1938
http://albinoraclesoa.blogspot.com
http://abhishek-soablog.blogspot.com
http://neeraj-soa-tips.blogspot.com
http://abhishek-oracleaia-bpel-esb.blogspot.com
http://www.nagazuka.nl/
http://orasoa.blogspot.com
http://soa-java.blogspot.com
http://www.albinsblog.com
http://niallcblogs.blogspot.com
https://blogs.oracle.com/reynolds/entry/more_on_batch_processing_in_bp
http://cohfu.wordpress.com/2010/01/06/bulk-loading-a-coherence-cache-from-an-oracle-database/
https://blogs.oracle.com/knutvatsendvik/entry/throttling_in_osb
http://www.javamonamour.org
https://blogs.oracle.com/reynolds
http://georgie-soablog.blogspot.com
http://shrikworld.blogspot.com

http://www.oracle.com/technetwork/middleware/soasuite/learnmore/soascheduler-186798.pdf

SOA and OWSM:
http://soabpel.wordpress.com
http://tech-learnings.blogspot.com/2010/04/using-xsl-parameters-in-soa-11g.html
http://oraclefusionfacts.blogspot.com/

OSB:
http://blog.xebia.com
http://prabodh-mitra.blogspot.com/
https://svgonugu.wordpress.com/tag/service-callout/
http://victor-jan.blogspot.com
http://soawork.blogspot.in
OSB Routing Options in Proxy Service: http://blog.ipnweb.com/2012/05/true-dynamic-routing-with-osb-11g.html

Ant Script for deployment, uniqueMessageSeparator :
http://sharatverma.blogspot.com
http://puchaanirudh.blogspot.in/


Web Logic Patch Update: Smart Update Directory
http://docs.oracle.com/cd/E14759_01/doc.32/e14143.pdf

Oracle Application Server:
Oracle AS 10g: (10.1.3.5.1)
http://docs.oracle.com/cd/E14101_01/doc.1013/e15342/toc.htm


Will keep updating this post..