Showing posts with label 11g. Show all posts
Showing posts with label 11g. Show all posts

Jul 28, 2018

Oracle Weblogic 12c: Extracting the complete configuration via wlst.sh python script

If you want to get all information out of a weblogic server via wlst.sh than you can use the following script:
# written by Dietrich Schroff 2018
import sys


OutputFile='myfile.txt'
sys.stdout = open(OutputFile,'w')
connect('weblogic','mypasswd','t3://localhost:7001')
depth=0

def loopOverAllSubdirectories(goIntoThisDirectory,depth):
    depth=depth+1
    cd(goIntoThisDirectory)
    print depth," "*depth*2,goIntoThisDirectory
    try:
            completeInput=ls()
            inputArray=completeInput.split('\n')
        allParameters=[ x for x in inputArray if (not ("dr--" in x) or ("drw-" in x)) ]
        for Parameter in allParameters:
            if Parameter != "" :
                print depth," "*depth*2,Parameter
            allDirectoriesWrongFormat=[ x for x in inputArray if (("dr--" in x) or ("drw-" in x)) ]
            allDirectoriesWrongFormat2=[x.replace('dr--', '') for x in allDirectoriesWrongFormat]
            allDirectoriesToManyBlanks=[x.replace('drw-', '') for x in allDirectoriesWrongFormat2]
            allDirectories=[x.lstrip().rstrip() for x in allDirectoriesToManyBlanks]
        for Directory in allDirectories:
            if depth < 5 :
                loopOverAllSubdirectories(Directory,depth)
            cd('..')
    except:
        cd('..')

domainRuntime()
print "domainRuntime"
print "###############################################"
loopOverAllSubdirectories('/',0)
serverConfig()
print "ServerConfig"
print "###############################################"
loopOverAllSubdirectories('/',0)
This is a recursiv program which steps into all directories until a level of 5. On my weblogic server this scripts ran for more than two minutes:
# time ./wlst.sh myScript.py > /dev/null 

real    2m35.241s
user    0m29.405s
sys    0m4.259s
I tried unlimited depth, but then i had to stop at level 1500, because i think, that it will never stop ;-).

The output file would look like this:
domainRuntime
###############################################
1    /
1    -r--   ActivationTime                               Fri Feb 23 13:03:05 EST 2018  
1    -r--   MigrationDataRuntimes                        null  
1    -r--   Name                                         ovm_domain  
1    -rw-   Parent                                       null  
1    -r--   ServiceMigrationDataRuntimes                 null  
1    -r--   Type                                         DomainRuntime  
1    -r-x   preDeregister                                Void :   
1    -r-x   restartSystemResource                        Void : WebLogicMBean(weblogic.management.configuration.SystemResourceMBean)  
2      AppRuntimeStateRuntime
2      drw-   AppRuntimeStateRuntime
3        AppRuntimeStateRuntime
3        -r--   ApplicationIds                               java.lang.String[oracle.sdp.client#2.0@12.1.3, oracle.pwdgen#2.0@12.1.3, owasp.esapi#2.0@12.1.3, oracle.wsm.seedpolicies#2.0@12.1.3, odl.clickhistory#1.0@12.1.3, odl.clickhistory.webapp#1.0@12.1.3, oracle.jrf.system.filter, oracle.jsp.next#12.1.3@12.1.3, oracle.dconfig-infra#2.0@12.1.3, orai18n-adf#11@11.1.1.1.0, oracle.adf.dconfigbeans#1.0@12.1.3.0.0, adf.oracle.domain#1.0@12.1.3.0.0, adf.oracle.businesseditor#1.0@12.1.3.0.0, oracle.adf.management#1.0@12.1.3.0.0, adf.oracle.domain.webapp#1.0@12.1.3.0.0, jsf#2.1@2.1.7-01-, jstl#1.2@1.2.0.1, UIX#11@12.1.3.0.0, ohw-rcf#5@12.1.3.0.0, ohw-uix#5@12.1.3.0.0, oracle.adf.desktopintegration.model#1.0@12.1.3.0.0, oracle.adf.desktopintegration#1.0@12.1.3.0.0, oracle.bi.jbips#11.1.1@0.1, oracle.bi.composer#11.1.1@0.1, oracle.bi.adf.model.slib#1.0@12.1.3.0.0, oracle.bi.adf.view.slib#1.0@12.1.3.0.0, oracle.bi.adf.webcenter.slib#1.0@12.1.3.0.0, state-management-provider-memory-rar-12.1.3, wsil-wls#12.1.3.0.0, DMS Application#12.1.3.0.0, coherence-transaction-rar, ovm_core, ovm_console, ovm_help]  
3        -r--   Name                                         AppRuntimeStateRuntime  
3        -r--   Type                                         AppRuntimeStateRuntime  
3        -r-x   getCurrentState                              String : String(appid),String(moduleid),String(subModuleId),String(target)  
3        -r-x   getCurrentState                              String : String(appid),String(moduleid),String(target)  
[.....]
4          JVMRuntime
4          drw-   AdminServer
5            AdminServer
5            -r--   HeapFreeCurrent                              447991664  
5            -r--   HeapFreePercent                              90  
5            -r--   HeapSizeCurrent                              841109504  
5            -r--   HeapSizeMax                                  4151836672  
5            -r--   JavaVMVendor                                 Oracle Corporation  
5            -r--   JavaVendor                                   Oracle Corporation  
5            -r--   JavaVersion                                  1.7.0_151  
5            -r--   Name                                         AdminServer  
5            -r--   OSName                                       Linux  
5            -r--   OSVersion                                    4.1.12-94.3.9.el7uek.x86_64  
5            -r--   Type                                         JVMRuntime  
5            -r--   Uptime                                       22612965  
5            -r-x   preDeregister                                Void :   
# wc -l myfile.txt 
19787 myfile.txt
Nearly 20.000 parameters... not bad...

Aug 30, 2012

Review at amazon: Oracle Database XE 11gR2 Jump Start Guide

This week i read Oracle Database XE 11gR2 Jump Start Guide:
After some postings about Oracle 11 XE like
about the features and installation, reading this book was the next step to see, what is special with XE in contrast to other Oracle editions.
Packtlib says at their overview:
  • Install and uninstall Oracle Database XE on Windows and Linux environment
  • Set up local and remote database connections and resize Oracle SGA
  • Install SQL Developer, access table data, modify table data,
    understand transaction control statements and most commonly used SQL
    functions
  • Create and manage database objects like tables, indexes, constraints, views, sequences, and synonyms
  • Develop PL/SQL stored subprograms
  • Create rich and responsive applications using Oracle Application Express
  • Understand Oracle logical and physical components such as SGA, PGA, Tablespaces, and Flash Recovery Area
  • Move data between different Oracle Database XE versions
  • Upgrade Oracle Database Express Edition to other Oracle Database Editions
  • Protect and recover your database
  • Tune the database for optimal performance
This topics are all covered in the book, but most of them just at beginners level. For readers which want to start with Oracle databases especially Express Edition this book is a rich source of SQL snippets and basic administration commands. Only the chapter, which describes the different editions, is helpful for database administrators.
So i gave 4 stars at my review at amazon, because for developers, which do not work each day with Oracle databases or want to start a program and need a free database, this book is an excellent jump start. Database administrators should stay with the official documentation (but they have to read much more than the 125 pages of this book ;-)

Oct 3, 2011

Review at amazon: Oracle 11g R1/R2 Real Application Clusters Essentials

Last week i read Oracle 11g R1/R2 Real Application Clusters Essentials.



Ok, the cover is really cool (does anybody know, if this is a real city?), but the content (500 pages) is missing any coolness. Only three of the twelve chapters do contain informations, you cannot easily google...
The description shows the problem:
Basic understanding of Oracle DBA is required. No experience of Oracle RAC is required.
Is it really possible to describe Oracle RAC within 500 pages for Newbies? All essentials? Perhaps RAC is so easy, that after introducing HA, RAC architecture and installation (100 pages) the rest is enough.
If you are interested, take a look at my review at amazon.de (like all my reviews: written in german ;-).

Sep 2, 2011

Oracle 11g Database Express Edition released

After the beta phase Oracle Database Express Edition 11g Release 2 was released:

Free to develop, deploy, and distribute

Oracle Database Express Edition 11g Release 2 (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 11g Release 2 code base.  It's free to develop, deploy, and distribute; fast to download; and simple to administer.
The installation is only for the following operating systems supported:
  • Oracle Enterprise Linux 4 Update 7
  • Oracle Enterprise Linux 5 Update 2
  • Red Hat Enterprise Linux 4 Update 7
  • Red Hat Enterprise Linux 5 Update 2
  • SUSE Linux Enterprise Server 10 SP2
  • SUSE Linux Enterprise Server 11
(only RPM-based 64 bit distributions).

Here some important license statements:
  • If Oracle Database XE is installed on a computer with more than one CPU
    (including dual-core CPUs), then it will consume, at most, processing
    resources equivalent to one CPU.
  • Only one installation of Oracle Database XE can be performed on a single computer.
  • The maximum amount of user data in an Oracle Database XE database cannot exceed 11 gigabytes.
  • The maximum amount of RAM that an Oracle Database XE database uses cannot exceed 1 gigabyte, even if more is available.
If you are interested in features which are not included with Oracle Database XE take a look here:
  • ...
  • Flashback Database
  • ...
  • Oracle Active Data Guard
  • Oracle Total Recall
  • ...
  • Oracle Real Application Clusters
  • In-Memory Database Cache
  • Oracle Diagnostic Pack
  • Oracle Partitioning
  • ...
  • Advanced Replication
  • ...

Apr 26, 2011

Oracle Database XE 11g beta

Last week Oracle announced database XE 11g beta:

The beta edition supports only two operating systems:

So what about using the Linux x64 edition?
But first: You should consider the following licensing restrictions (see here):
  • Only one CPU will be used.
  • Only one installation on a single computer allowed.
  • The maximum amount of user data in an Oracle Database XE database cannot exceed 11 gigabytes.
  • The maximum amount of RAM that an Oracle Database XE database uses cannot exceed 1 gigabyte
  • HTTPS is not supported natively.
The installation itself is straight forward:
  1. Log on to your computer with root permissions.
  2. Go to the following Web site:

    http://www.oracle.com/technology/products/database/xe


  3. Click Free Download and follow the instructions to select and download the Linux version of Oracle Database XE.
  4. Run the Oracle Database XE executable oracle-xe-11.2.0-0.4.x86_64.rpm to install Oracle Database XE.
    $ rpm -ivh downloads/oracle-xe-11.2.0-0.4.x86_64.rpm

    The installation displays a status of its progress.


  5. When prompted, run the following command:
    $ /etc/init.d/oracle-xe configure
  6. Enter the following configuration information:
    • A valid HTTP port for the Oracle APEX (the default is 8080)
    • A valid port for the Oracle database listener (the default is 1521)
    • A password for the SYS and SYSTEM administrative user accounts
    • Whether you want the database to start automatically when the computer starts
      If you enter Yes, then the database starts immediately

That's it.

Feb 10, 2011

SQLDeveloper Data Modeler 3.0 released

Two weeks ago SQLDeveloper 3.0 was released:



The list of new features can be found here. Some nice tutorials can be found on this page:

Documentation can be found at download.oracle.com/docs and it's free:

Dec 30, 2010

Review at amazon: Getting Started with Oracle BPM Suite 11gR1 – A Hands-On Tutorial

Last two weeks i read "Getting Started with Oracle BPM Suite 11gR1 – A Hands-On Tutorial" and played with the examples given in this book.

On the packtpub website the following can be found about this book:
What you will learn from this book :
  • Build a business process application
  • Model executable processes with Business Process Modeling Notation (BPMN) 2.0
  • Optimize your processes using process simulation
  • Analyze activity with Process Analytics and Business Activity Monitoring
  • Integrate business decisions with Business Rules
  • Design complex Human Task flows
  • Develop rich forms for BPM
  • Collaborate with Process Spaces (Social BPM)
  • Explore life-cycle management features


What they are not telling is, that this book contains many step by step examples with excellent screenshots. For this reason it is very easy to follow all the steps to set up a running BPM Suite (The installation process is described very detailed for windows) and get a process running.
On more than 500 pages you can find a short introduction in BPMN 2.0, Installation, BPM Studio, Roles, Simulation, ....
If you are interested, take a look at my review at amazon.de (like all my reviews: written in german ;-).

Sep 28, 2010

Oracle BPM: How to use start and end events

For modelling a process you have to configure your Jdeveloper 11g like shown in this posting. Then you can create easliy a process like this one:

[The behaviour of the tool palette is a little bit weird, because you can not use drag&drop. You have to click an item and then move the mouse inside the graph. Then the item is beneath the mouse cursor and you can place it with a second click.]

The start event can be changed via right mouse click:

[The start event with the envelope is called "message start event"]

Here an excerpt from the official documentation about the start events:
The none start event is used when no instance trigger is defined. Process analysts can use the none start event as a placeholder when the necessary start event of a process is unknown or is defined and implemented later by process developers. None start events are also used to specify the beginning of a process where the process instance is created by another flow object. Although the none start event does not trigger the creation of a process instance, it is required when triggering a process instance using the following flow objects:
  • Receive task. The receive task must have the Create Instance property set to true.
  • User task implemented with the initiator pattern
The message start event triggers a process instance when a message is received. This message can be sent from another BPMN or BPEL process or from a service. Messages are types of data used for of exchanging information between processes. Just as data objects are used to define the data used within a project, messages are used to define the data used between processes or between a process and a service.
You can exposed a BPMN process as service which enables other processes and applications to invoke the process. To expose a process as a service, your process must begin with a message start event.

The signal start event is similar to a message start event in that it is based on communication from another process or service. However, the message start event responds to a message sent to a specific process. In contrast, the signal start event is a response to a signal broadcast to multiple processes. Signals can be broadcast from a BPMN process using the signal throw event. Using a combination of signal throw and signal start events, you can invoke multiple processes simultaneously.

The timer start event triggers the creation of a process instance based on a specific time condition. You can configure the timer start event to trigger a process instance based on the following:
  • A specific date and time. For example, a process could be triggered on December 31, at 11:59 PM.
  • A recurring interval. For example, a process could be triggered every 10 hours, 5 minutes, 32 seconds.
The following end events can be used:
  • None end event
    like start event
  • Error end event
    Errors end events are normally used with the error boundary event. The error
    boundary event is used to alter the process flow based on a specific error. This flow usually ends using an error end event.
  • Message end event
    like start event
  • Terminate end event
    The terminate end event is used to immediately terminate a process. When a terminate end event is reached, the process ends immediately. There is no error handling or additional clean up performed.

Sep 12, 2010

BPM on Linux...

Running jdeveloper on Linux is not really a problem. Just unzip the tarball (<11g) or run the installer (11g +) and start with ./jdev.
Jdeveloper 11g starts on Linux but after installing the BPM functionality i got:
Sep 12, 2010 9:02:55 PM oracle.ideimpl.extension.WarnAboutDisabledExtensionsAddinlogDisabledExtensions
SEVERE: jar:/file:/home/data/opt/Oracle11.1.1.3.0/jdeveloper/jdev/extensions/oracle.bpm.modeler.jar!/META-INF/extension.xml:0: Not loaded: Missing dependencies: oracle.sca.modeler

Sep 12, 2010 9:02:55 PM oracle.ideimpl.extension.WarnAboutDisabledExtensionsAddinlogDisabledExtensions
SEVERE: jar:/file:/home/data/opt/Oracle11.1.1.3.0/jdeveloper/jdev/extensions/oracle.bpm.tests.jdev-test.jar!/META-INF/extension.xml:0: Not loaded: Missing dependencies: oracle.bpm.fusion.soa, oracle.bpm.workflow

Sep 12, 2010 9:02:55 PM oracle.ideimpl.extension.WarnAboutDisabledExtensionsAddinlogDisabledExtensions
SEVERE: jar:/file:/home/data/opt/Oracle11.1.1.3.0/jdeveloper/jdev/extensions/oracle.bpm.fusion.sca.jar!/META-INF/extension.xml:0: Not loaded: Missing dependencies: oracle.sca.modeler

Sep 12, 2010 9:02:56 PM oracle.ideimpl.extension.WarnAboutDisabledExtensionsAddinlogDisabledExtensions
SEVERE: jar:/file:/home/data/opt/Oracle11.1.1.3.0/jdeveloper/jdev/extensions/oracle.bpm.fusion.soa.jar!/META-INF/extension.xml:0: Not loaded: Missing dependencies: oracle.sca.modeler, oracle.sca.mediator, oracle.bpm.modeler, oracle.bpm.modeler.plugins, oracle.sca.modeler.plugins, oracle.bpm.mapper, oracle.bpm.rules, oracle.bpm.workflow

Sep 12, 2010 9:02:56 PM oracle.ideimpl.extension.WarnAboutDisabledExtensionsAddinlogDisabledExtensions
SEVERE: jar:/file:/home/data/opt/Oracle11.1.1.3.0/jdeveloper/jdev/extensions/oracle.bpm.fusion.internal.jar!/META-INF/extension.xml:0: Not loaded: Missing dependencies: oracle.bpm.rules, oracle.bpm.workflow
With this error messages the bpm.modeler does not work...
Does anybody know, how to get around this problem? (On Windows there are no problems -> BPM-modellers do not use Linux?!)


Sep 8, 2010

Oracle BPM Suite: Overview

In my last posting i provided some links to the documentation. After reading some pages, i will try to give a summary.

Here some explanations to these boxes:
  • BPM Studio = Jdeveloper 11g with BPM installed
  • Business Process Composer = a web-based application that enables business
    users to collaborate with process developers and designers
  • BAM = a complete solution for building interactive, real-time dashboards and proactive alerts for
    monitoring business processes and services
But how do this components fit into Oracle Fusion? Take a look at this picture:

Here you can see, that the BPMN and BPEL Service Engines share the same process core.
The Oracle BPM Engine provides a run-time environment for running business processes. It provides native support for both BPMN and BPEL processes. The Process Core
provides engine functionality that is shared by the BPMN and BPEL engines.
Some of the key functionality performed by the process core includes:
– Manage security
– Generate audit trails
– Invoke services
– Manage persistence
Ok. But why are there two ways for creating business processes? And hwo do they interact with each other?
Here two pictures with typical worksteps:






With knowing all this we are able to start our first project. Finally a screenshot of the business process composer:

Sep 5, 2010

Oracle BPM Suite: Documentation

After getting the BPM Suite ready (Installing BPM components into jdeveloper), here a collections of links to quick-starts, tutorials and the original documentation:
  • Oracle BPM and Oracle Service Bus Integration:
    About the global picture...
  • BPM 11g: For Oracle, It's All About Integration:
    Summarizing the steps to Oracle's BPM...
  • The official documentation library (11g Release 1)
    and inside this documentation you can find the following Guides:
  • Modelling and Implementation Guide
    This guide contains 447 pages and is for the following audience:
    This guide is intended for process developers who use the Business Process Studio application to create and implement business processes, and create and configure Oracle BPM projects used to created process-based applications using the Oracle Business Process Management Suite.
  • Administrator's Guide
    Targeted audience (618 pages):
    This document is intended for administrators managing applications on an SOA platform.
  • User's Guide
    With only 150 pages for:
    This document is intended for all users of both Oracle Business Process Management Workspace and Oracle Business Process Management Process Spaces.
  • User's Guide for Oracle Business Composer
    135 pages with the following intended audience:
    This guide is intended for process analysts who use the Business Process Composer application to create and edit the business processes and Oracle BPM projects used to created process-based applications using the Oracle Business Process Management Suite.
    This guide is also intended for process developers who must use Business Process Composer. See Section 1.2, "Oracle BPM User Personas" for more information on these user personas.
    This manual assumes that you have basic knowledge of business process design and are familiar with Business Process Management Notation (BPMN) 2.0.
  • Samples and Demos
Enjoy and Happy Reading!

Aug 31, 2010

Oracle BPM 11g: Missing BPM Studio Components in Jdeveloper 11g

Oracle announced Business Process Management Suite 11g on June 14th 2010:
  • A component of Oracle Fusion Middleware 11g, Oracle Business Process Management Suite 11g is the industry’s most complete, open and integrated Business Process Management (BPM) solution.
  • Oracle Business Process Management Suite 11g supports all types of processes with a new unified process foundation, user-centric design and social BPM capabilities.
  • Oracle Business Process Management Suite 11g includes a native implementation of BPMN 2.0.
So let's take a look at BPM homepage. There you can find a link "getting started". But on the "getting started" page there is a link "Get started with BPM Suite 10g".
Ok - you want 11g you should start with 10g and no quick link how to start the studio...

Next try: Start with the BPM download page. This sounds better:
  • JDeveloper: Download JDeveloper 11.1.1.3.0 (BPM Studio) from the FMW download page. Look for JDeveloper and Application Development Framework in the Required Addition Software section.
  • SOA and BPM Extension for JDeveloper: Install the SOA and BPM Extension using the JDeveloper Update Center. From the JDeveloper menu choose Help > Check for Updates. In the Update Wizard, select Search Update Centers and ensure Oracle Fusion Middleware Products is checked ( screenshot). Then ensure that Oracle SOA Composite Editor is checked ( screenshot, your version may not match the screenshot exactly). The SOA and BPM Extension is approximately 200 MB each.
But the screenshots are a redirects to the BPM Homepage....

To save your time, here a quick start, how to get the BPM Studio.

First download JDeveloper 11g (11.1.1.3.0), unzip it and run jdeveloper:

Then open "Check for Updates" inside the "help" menu.

After that follow the Update Wizard like shown in the next pictures:







At this step you have to provide your Oracle account credentials.



Finished!!!

Now you can choose "New Appliation"

and here we go:



That's all...

Jun 2, 2010

Oracle Fusion Demo



Download the zip-file from here.
Then create a appropriate directory:
mkdir fusiondemo
cd fusiondemo
unzip /tmp/FusionOrderDemo_R1PS2.zip
After that you will see:
schroff@hades:$ l
insgesamt 32
drwxr-xr-x  7 schroff schroff 4096  2. Jun 21:38 .
drwxr-xr-x 11 schroff schroff 4096  2. Jun 21:38 ..
drwxr-xr-x 13 schroff schroff 4096  2. Jun 21:38 CompositeServices
drwxr-xr-x  6 schroff schroff 4096  2. Jun 21:38 Infrastructure
drwxr-xr-x  6 schroff schroff 4096  2. Jun 21:38 MasterPriceList
-rw-r--r--  1 schroff schroff 3061 28. Mai 11:00 readme.txt
drwxr-xr-x  7 schroff schroff 4096  2. Jun 21:38 StandaloneExamples
drwxr-xr-x  7 schroff schroff 4096  2. Jun 21:38 StoreFrontModule
The readme.txt contains the following:

About the Oracle Fusion Order Demo Application

Fusion Order Demo (FOD) is an end-to-end application sample developed by Fusion Middleware Product Management. The purpose of the demo is to demostrate common use cases in Fusion Middleware applications, including the integration between different components of the Fusion technology stack, (ADF, BPEL, and WebCenter). The demo contains several applications that make up various parts of functionality.

Note that there are two versions of the demo: One which includes the ADF and SOA components (named FusionOrderDemo_R1PS2.zip), and one which includes these components, as well as WebCenter functionality. 
About the Applications included in the Demo (organized by extracted directory name)

CompositeServices - WebLogicFusionOrderDemo.jws is a sample SOA application based on Oracle Mediator, BPEL Process, Human Task, Business Rules, and Messaging Service. This application shows how to use Oracle SOA Suite to integrate a number of applications into one cohesive ordering system. The accompanying developer's guide for this module is Oracle<AE> Fusion Middleware Developer's Guide for Oracle SOA Suite 11g (http://www.oracle.com/pls/as111130/lookup?id=SOASE).

Infrastructure - Infrastructure.jws contains the database schema information for the sample application. All applications use the same schema, FOD. The accompanying Developer's Guide for this module is Oracle<AE> Fusion Middleware Fusion Developer's Guide for Oracle Application Development Framework 11g (http://www.oracle.com/pls/as111130/lookup?id=ADFFD).

MasterPriceList - MasterPriceList.jws is a sample application that integrates with Microsoft Excel to demonstrate the use of ADF Data Integration functionality. The accompanying Developer's Guide for this module is Oracle<AE> Fusion Middleware Desktop Integration Developer's Guide for Oracle Application Development Framework 11g  (http://www.oracle.com/pls/as111130/lookup?id=ADFDI).

StandaloneExamples - This module contains several workspaces that demonstrate various features of the ADF Framework that are not included in the Store Front scenario. The accompanying Developer's Guide for this module is Oracle<AE> Fusion Middleware Fusion Developer's Guide for Oracle Application Development Framework 11g  (http://www.oracle.com/pls/as111130/lookup?id=ADFFD).

StoreFrontModule - StoreFrontModule.jws is a sample web application based on Oracle ADF Business Components, ADF Model data bindings and ADF Faces. The application follows an online shopping scenario and contains hook points for integrating with the CompositeServices module. The accompanying Developer's Guide for this module is Oracle<AE> Fusion Middleware Fusion Developer's Guide for Oracle Application Development Framework 11g (http://www.oracle.com/pls/as111130/lookup?id=ADFFD).

The sample application is provided for informational purposes only.

Credits
Fusion Order Demo was created by:

Laura Akel
Duncan Mills
Lynn Munsinger
Juan Ruiz
Clemens Utschig
Kundan Vyas

Each directory contains another readme.txt for further instructions
(deployment, import to jdev).
Inside the CompositeServices you should open the jws-file with jdeveloper:

The follwing screenshot shows the applications with SOA content:

Here the composite.xml form the B2BX12OrderGateway:


This is a really small composite. If you want to see something larger, you should open the composite from the OrderBooking application. In one of the next posts i will try merge the screenshots to one picture (or does anybody know, how to create images from composites without doing screenshots?)...





Jan 23, 2010

Oracles SQL Developer 2.1...

On december 15th Oracle released a new version of its database tool SQL Developer:
Version 2.1.0.63.73

They jumped from version 1.5.5 to 2.1.0, so there should be some really new features built in. The release notes tell us:
  • Oracle SQL Developer Unit Testing provides a unit testing framework that allows you to build a set of sequential steps to create test cases for testing your PL/SQL code. These tests can optionally be collected into test suites, which can then be run and rerun to verify required functionality after any changes to your PL/SQL code. Command
    line access for executing, exporting, and importing suites or tests is provided for integration with your build and version control environment.
  • SQL Developer 2.1 incorporates a Data Modeler viewer, integrated into SQL Developer. The Data Modeler Viewer also supports visualizing tables, views and object types on read-only Data Modeler diagrams. The SQL Developer Data Modeler Viewer extension is a free extension to SQL Developer. For a updateable data model, download and review the Oracle SQL Developer Data Modeler, a stand alone product that supports logical,
    relational and conceptual modeling. The tool supports forward and reverse engineering and import and export from various sources. The Data Modeler supports an additional standalone model viewer, which allows users to open models built in the full Data Modeler.
  • The SQL Worksheet has been redesigned for SQL Developer 2.1 to support concurrent task processing for long running operations. Updates to the worksheet include the support of multiple data grids off the F9 (Run Statement) command and dockable OWA, DBMSOutput and SQL  History windows.
  • A detailed explanation is given here.
  • Let's focus on the second point: Data Modeler



  • I tried to work with that tool, but without the documentation or tutorial you are really lost. The official documentation does not explain anything useful about the data modeler...
    After searching a while i found some some nice links to start:
    After at least the first tutorial you will be able to maintain your ERD with SQL Developer 2.1...

    Sep 9, 2009

    Oracle SOA Suite 11g: How to start the soa instance...

    You tried to install Oracle's SOA Suite 11g?
    The installation completed successfully?
    You got the login screen like shown in this posting?

    Now you can login...

    The next screen shows this:

    After that there is this fancy gui with some flash components inside:

    Yippie! Everything is ok...
    Let's take a look at the SOA components:



    But stop! There are no SOA components. The manual shows this:

    ???
    How do i get this additional folder inside the SOA console?
    Ok, this is very easy:
    /opt/Oracle/Middleware/user_projects/domains/soa_domain/bin/
    startManagedWebLogic.sh soa_server1 http://localhost:7001
    And here we go:


    Just a last comment: Stopping this server can be done via command:
    ./stopManagedWebLogic.sh soa_server1 t3://hades:7001 weblogic oracle10

    Sep 8, 2009

    Oracle WLS: Installation errors

    Did you try to install an Oracle WLS and got some errors like:
    INST-07248
    INST-07292
    and you do not know what to do?
    The official pages are here. There you can find some explanations.
    For the errors abouve, the provided Middleware home was empty....


    Aug 21, 2009

    Oracle SOA Suite 11g: How to get a running test instance (on a laptop)?

    After migrating the first project, the next step is to deploy this bpel to a server. I started with only installing JDeveloper an let's see, if it possible to stay with that (without installing the real wls production server).

    I started with just with
    /opt/Oracle/Middleware/utils/quickstart/quickstart.sh

    So this looks like the wls server can be configured with Getting started with WebLogic Server 10.3.1:


    But after some clicks i ended with:

    Ok, there was only a very small chance, that a database is included inside the jdev-package. Like expected i installed Oracle's XE database. And after a short search i found a nice guide for setting up test instances inside wiki.oracle.com.

    Just to add the missing steps:
    dpkg -i oracle-xe-universal_10.2.0.1-1.0_i386.deb
    /etc/init.d/oracle-xe configure
    oracle@hades:~/app/oracle/product/10.2.0/server/bin$ ./createdb.sh
    lsnrctl start
    sqlplus system/passwd@XE
    and as written in the Oracle documentation - download the rcu and run it:
    ./rcu






    Ok, ignore this, but then:
    RCU-6107:Fehler bei der Prüfung auf Voraussetzungen von DB Init Param für: SHARED_POOL_SIZE
    Erforderlicher Wert = 147456 KB, Aktueller Wert = 0 KB, Vergleichsoperator: ">="
    RCU-6107:Fehler bei der Prüfung auf Voraussetzungen von DB Init Param für: SGA_MAX_SIZE
    Erforderlicher Wert = 147456 KB, Aktueller Wert = 143360 KB, Vergleichsoperator: ">="
    But this is fixable:

    SQL> alter system set sga_max_size=150M scope=spfile;
    System altered.
    SQL> alter system set sga_target=150M scope=spfile;
    System altered.
    and restart the DB:









    Once again:
    /opt/Oracle/Middleware/wlserver_10.3/common/bin/config.sh
    ...




    Then i tried via Jdeveloper -> Run -> Start Server Instance
    But the result was just many errors and no connectivity via http://localhost:7001.

    Then i tried
    cd /opt/Oracle/Middleware/user_projects/domains/DefaultDomain/
    ./startWebLogic.sh
    And after waiting 2 minutes, it worked: