LAKSHMI WEBLOGIC/SOA ADMIN

Setup Oracle sql plus client on AWS Ubuntu/Linux Dependencies : AWS Instance with Ubuntu/Linux Oracle Instant Client package Oracle SQL Plus package S teps to Install the Client :  1. First we need to install alien package sudo apt -get install alien 2. Install downloaded instant rpm package<client> sudo alien -i oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm  3. Install downloaded sql plus package sudo alien -i oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm  4. Install libaio1,libaio-dev packages if not already installed. Usually in vanilla ubuntu 14 l ibaio1, libaio-dev packages are not pre-installed.  5. Export oracle client lib directory path to LD_LIBRARY_PATH variable.  export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib/${LD_LIBRARY_PATH:+:$LD_LIBRARY_PATH} 6. Test the client now. Following sql prompt will appear by using credentials are correct. ubuntu@ip-272-300-...

Oracle Service Bus (OSB) uses the  Router Runtime Cache  to optimize message processing by  storing frequently accessed data (like XSLT, XQuery, WSDLs, and routing rules) in memory.  Proper tuning of this cache can significantly improve throughput and reduce latency. Key Aspects of Router Runtime Cache 1. Purpose Reduces Backend Calls : Caches external resources (WSDLs, XSDs, XQuery) to avoid repeated fetches. Improves Speed : Stores compiled transformations (XSLT, XQuery) to skip recompilation. Minimizes Overhead : Avoids repeated parsing of static routing rules. 2. Cache Types in OSB Cache Type Description Tuning Parameter Static Cache Caches immutable resources (WSDLs, XSDs). xpath-cache-size ,  wsdl-cache-size Dynamic Cache Stores runtime objects (XQuery, XSLT). transformation-cache-size Route Cache Caches routing decisions for repeated requests. route-cache-size Performance Tuning Parameters: 1. Cache Sizing (in  config.xml  or WLST) <server...

Overview of Purging in SOA: Purging removes obsolete data (completed/failed instances, audit trails, dehydration store entries) from SOA databases to Improve performance   (smaller tables = faster queries) Reduce storage costs Maintain compliance  (data retention policies) Partitioned Schemas in SOA Partitioning splits large tables (e.g.,  cube_instance ,  dlv_message ) into smaller, manageable chunks based on: Time ranges   (e.g., monthly partitions) Instance status   (completed vs. active) Component type  (BPEL, Mediator, etc.) Benefits of Partitioning: Faster purging (drop entire partitions instead of row-by-row) Improved query performance (partition pruning) Easier maintenance (archive old partitions) Purging Methods Manual Purging with  purge.sh  Script # Syntax (SOA 12c): $ORACLE_HOME/soa/bin/purge.sh \   -jdbcUrl "jdbc:oracle:thin:@//db_host:1521/ORCLPDB1" \   -dbUser soa_infra \   -dbPassword Welcome1 \   -o...