Oracle SOA Suite 12c: Invoking a BPEL process via Enterprise Manager (EM)

After you logged in via http://yourhost:7001/em navigate to "soa-infra":
 Then choose "Deployed Composites":
 There you have to click on your composite (here: "Project1"):
 Choose "Test":
 Go to the bottom of the page and expand the payload:
 There you have  fill in your test string:
 
 And after a click on "Test Web Service"
The response is shown incl. the response time.

To list the audit trails goto "Home-> Flow instances

And choose "search" on the right side:


Check 12.1.0.2 Alert Log For HugePages Usage

What! Another post on hugepages – seriously?

+ grep 'Dump of system resources acquired for SHARED GLOBAL AREA' -B1 -A22 database alert log
+ tail -25
2018-04-13T09:40:23.908633-07:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 

2018-04-13T09:40:23.916573-07:00
 Per process system memlock (soft) limit = UNLIMITED
2018-04-13T09:40:23.920591-07:00
 Expected per process system memlock (soft) limit to lock
 SHARED GLOBAL AREA (SGA) into memory: 2996M
2018-04-13T09:40:23.928517-07:00
 Available system pagesizes:
  4K, 2048K 
2018-04-13T09:40:23.936717-07:00
  (more...)

Answer: Anything Wrong With Query Performance? (Red Right Hand)

I of course attract a highly clever readership :). As some have commented, for a single table to require 1000+ consistent gets to retrieve 1000 rows implies that each row needs to be accessed from a different block. This in turn implies the Clustering Factor for this index to be relatively bad and the associated […]

exp catch

No-one should be using exp/imp to export and import data any more, they should be using the datapump equivalents expdp/impdp – but if you’re on an older (pre-12c) version of Oracle and still using exp/imp to do things like moving tables with their production statistics over to test systems then be careful that you don’t fall into an obsolescence trap when you finally upgrade to 12c (or Oracle 18).

exp/imp will mess up some of (more...)

Playing with Oracle Database Cloud – Migrating to Cloud using an Oracle Cloud Backup

The idea for this scenario is to learn how to migrate an Oracle Database from on-premises to Oracle Cloud DBaaS by using a previously done backup using Oracle Cloud Backup Services. First, we will create an Oracle Database Cloud Services database

Playing with Oracle Database Cloud Backup Service

This article will show you how easy is to make use of Oracle Cloud to securely store all our on-premises Oracle Database Backups. Note that backups stored in Oracle Cloud can also be used to create new Oracle Database Instances

Oracle 12c SOA Suite: Administration via Enterprise Manager

After

i want to present some screenshots of the web console of the SOA Suite:
http://localhost:7001/em
But first the servers have to be started:
cd /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/bin
nohup ./startNodeManager.sh &
nohup ./startWeblogic.sh &
Now the login is available:

 But there the soa_server1 is still down:


 So let's start this one:
nohup . (more...)

Oracle SOA Suite 12c: Tokens – To avoid substituting values: define global token variables

Inside the Enterprise Manager (URL: http://yourhost:7001/em) you can configure SOA Suite profiles:

Choose "Token Configurations"

 ???

To list the tokens click on "Modify Configuration file":

 To add a token click on the green plus:

 Do not forget to save your changes:


 
To use the bulk append you have to create a file like this one:




    2000
    weblogic
Choose your file "text.xml":
 and click on "Append":


Playing with CrashSimulator

Hi everyone,   Today I will show you how CrashSimulator (Shell Script – current version 1.04) works in detail. When unzipping the zip file you will find the following files within it: CrashSimulator.sh.x – For high-resolution ssh emulator screens, it

Keeping Intervals

I’ve recently been reminded of a blog post I wrote a couple of years ago that discussed the issue of running into the hard limit of 2^20 -1 as the number of segments for a (composite) partitioned table – a problem that could arise in a relatively short time if you used a large number of hash subpartitions in an interval/hash composite partitioned table (you get about 2 years and 10 months of daily partitions (more...)

Improve Data Clustering on Multiple Columns Concurrently (Two Suns in the Sunset)

I’ve had a couple of recent discussions around clustering and how if you attempt to improve the clustering of a table based on a column, you thereby ruin the current clustering that might exist for a different column. The common wisdom being you can only order the data one way and if you change the […]

Match_recognise – 2

In my previous post I presented a warning about the potential cost of sorting and the cost of failing to find a match after each pass of a long search. In a comment on that post Stew Ashton reminded me that the cost of repeatedly trying to find a match starting from “the next row down” could be less of a threat than the cost of “back-tracking” before moving to the next row down.

Taking (more...)

How Do You Create Data Guard Configuration?

I have taken for granted to create Data Guard Configuration the same way most of the time that I don’t know what goes wrong with done differently.

oracle@racnode-dc1-1:hawk1:/home/oracle
$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 19 23:41:49 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real  (more...)

12c DataGuard / Broker Pitfalls

In a broker configuration, you use the DGConnectIdentifer property to specify a connect identifier for each database.

The connect identifier for a database must:
Allow all other databases in the configuration to reach it.
Allow all instances of an Oracle RAC database to be reached.
Specify a service that all instances dynamically register with the listeners so that connect-time failover on an Oracle RAC database is possible.

The service should NOT be one that is (more...)

Linking Oracle GoldenGate Classic Architecture to Oracle GoldenGate Microservices Architecture

In my last post I covered how to connect the microservices architecture to the classic architecture (here). For this post, I want to show you how to connect the GoldenGate Classic Architecture to the new GoldenGate Microservices Architecture.

You many be asking yourself, why do I want to do this? The answer is quite simple. At the current moment and time, there is no upgrade path to move from Classic to Microservices. This (more...)

Oracle SOA Suite 12c: Configuring the SOA Suite Weblogic Server

After
 i had to run the
./config.sh
inside the home/oracle/Oracle/Middleware/Oracle_Home/oracle_common/common/bin

















And then after a
./startWeblogic.sh
inside /bin in the directory, which was configured in the first screenshot of the config.sh, i can open the console:


Oracle SOA Suite: Installing the Fusion Middleware SOA Suite

After the installation of the Fusion Middleware Infrastructur the next step is to install the SOA Suite software.

The software can be found here:



The first try failed with this error:

java -d64 -jar fmw_12.2.1.3.0_soa_quickstart.jar
Launcher-Logdatei ist /tmp/OraInstall2017-10-07_11-47-20PM/launcher2017-10-07_11-47-20PM.log.
Nicht genügend freier Speicherplatz in /tmp/orcl3797124329273264119.tmp, um das Installationsprogramm zu extrahieren. Aktuell 2796 MB. Erforderlich 3532 MB.
Ok. Some cleanups inside /tmp and then:









Next step: Run the config.sh to create a SOA Suite Server....

Blocking Prepared XA Transaction

There was an oracle-l thread last month about blocking sessions which could not be identified.

I replied back about a very niche scenario which I’d seen a few times before. And it’s just happened again so I thought it would be useful to just post some evidence on this.

Here are a couple of articles posted previously on XA transactions:

First, a reminder, from the posts (more...)

Oracle SOA Suite: Installating the Fusion Middleware Infrastructure

After setting up the database (installation, instance setup) and the SOA Suite repository (via rcu) the next step is to install the Oracle Weblogic Infrastructure.

The software can be downloaded here:

(You have to choose "Fusion Middleware Infrastructure Installer)

The unzip the downloaded zip:
 fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip
and run it: 
java -d64 -jar fmw_12.2.1.3.0_infrastructure.jar
Because the Oracle documentation does not contain pictures of the installer, here the screenshots:










Next step is to run the config.sh to configure the Application server domain.

Playing with Oracle Database Cloud Service – Virtual Image – How to use and create a database STEP by STEP

The Oracle Database Cloud Service (ODCS) Virtual Image option gives you some extra flexibility on how to deploy databases in the Oracle Cloud. When deploying an instance using the normal Oracle Database Cloud Service it will per default create an