maandag 3 juni 2019

ORDS Remove entire schema info

Business Case

While deploying more and more ORDS based solutions, we need to be able to clean ORDS completely for a certain schema.

Solution

We created our own procedure for this cleanup.  While it works in our cases, maybe it is not complete for your environment.  Testing is always crucial.

Follow the following steps to create the procedure:

  1. Login with sys of your database or pluggable db
  2. Execute the following script:
create or replace procedure ords_metadata.remove_schema_entries
authid definer
is
    v_user constant varchar2(200) := SYS_CONTEXT('USERENV', 'SESSION_USER');
begin
    dbms_output.put_line('start remove schema entries for '||v_user);
    delete from ords_handlers where created_by = v_user;
    delete from ords_modules where created_by = v_user;
    delete from ords_objects where created_by = v_user;
    delete from ords_parameters where created_by = v_user;
    delete from ords_templates where created_by = v_user;
    delete from ords_url_mappings where created_by = v_user;
    delete from sec_authenticators where created_by = v_user;
    delete from sec_keys where created_by = v_user;
    delete from sec_origins_allowed_modules where created_by = v_user;
    delete from sec_privilege_auths where created_by = v_user;
    delete from sec_privilege_mappings where created_by = v_user;
    delete from sec_privilege_modules where created_by = v_user;
    delete from sec_privilege_roles where created_by = v_user;
    delete from sec_privileges where created_by = v_user;
    delete from sec_role_mappings where created_by = v_user;
    delete from sec_roles where created_by = v_user;
    delete from ords_schemas where created_by = v_user;
    commit;
    dbms_output.put_line('end remove schema entries');
end remove_schema_entries;
/
grant execute on ords_metadata.remove_schema_entries to public; 
create public synonym ords_remove_schema_entries for ords_metadata.remove_schema_entries;

To use this procedure, execute it with the following syntax:

set serveroutput on

begin
      ords_remove_schema_entries;
end;
/

This solution has been developed with ORDS 18.3. 

maandag 16 juli 2018

APEX 5.0 Cascading reports

Business case

You want to create a page with two or more reports that are connected with each other.  A kind of master-detail for reports.
In this example we show the list of departments and as a child report we show the employees of that department.

Solution

We start with building a blank page for our reports.  Add the different report regions on the page.  Whether you are using interactive reports or classic ones, it doesn't matter.  The solution works for both.


Once the reports are present and working independently, we can start making them connected.
The first report is called master and the second one is called the detail report.

Follow these steps to connect the reports:

  1. Create the necessary page items to hold the information to be passed on to the detail report.  In my case this is only the primary key.  So I create a page item called P7_DEPT_PK_ID.  These page items can be set to hidden, since they have no added value for the end-user.  But for testing purposes, we lease them visible so we can see what is being passed on.  You can make them hidden, once everything is working correctly.
  2. Now we need some javascript-code to pass the values of the current selected master record to these page items.  The easiest way is by using a link column on the master report.  As target for this link-column, we use an URL with the following destination:
    javascript:$s('P7_DEPT_PK_ID','#DEPARTMENT_ID#');
    You can see here that we are using a method called "$s", which can be used to put values in items.  As parameters we give the name of the destination parameter and the value, which in this case is the DEPARTMENT_ID from the currently selected master record.

    Some nice explanation on these javascript functions can be found in this blog: https://apex.oracle.com/pls/apex/germancommunities/apexcommunity/tipp/6341/index-en.html.
  3. Once the value of the PK is now in this page item, we still need to refresh the detail report.  This can be done through the use of a dynamic action.  In this dynamic action we indicate that whenever the page item P7_DEPT_PK_ID is changed, we need to refresh the detail report.
  4. The only remaining thing to do is to use the page item in the query of the detail report.
  5. Because we are using javascript to fill in the page item, we need to submit the page item to the server, when we are refreshing the detail report.  This is done through the property 'Page Items to Submit' on the detail report.
  6. Now you can run your solution




vrijdag 6 juli 2018

APEX 5.0 Example use of collections

This is my first attempt in using collections within Oracle APEX.
I just save this code for later use.

I used APEX 5.0 on the Oracle cloud.

I created 2 pages:

  • Overview Page
  • Edit Page
In the Overview page I load through a select-statement the data into a collection during the Pre-Rendering > Before Header > Processes > PL/SQL action, with the following code:
Declare
l_query varchar2(300) := 'select department_id, department_name, manager_id from departments';
l_coll_name varchar2(50) := 'DEPARTMENTS';
Begin
 APEX_DEBUG.ENABLE();
 APEX_DEBUG.INFO('Start fetchData');
    if not APEX_COLLECTION.COLLECTION_EXISTS(l_coll_name)
    then
    APEX_DEBUG.INFO('Collection ' ||l_coll_name||' does not exist, creating a new one');
      -- Create the collection from the query 
      APEX_COLLECTION.CREATE_COLLECTION_FROM_QUERY_B (
        p_collection_name => l_coll_name, 
        p_query => l_query);
    end if;
 APEX_DEBUG.INFO('End fetchData');
End;

I'm creating the collection only the first time that I'm entering the page.  So when changes are made on the second page, these changes are immediately shown on this page on returning.

To show the data in a report, you can use a classic report with a query which looks like this one:
select 
    c001,
    c002,
    c003,
    c004,
    c005
  from apex_collections
  where collection_name = 'DEPARTMENTS'
;

In this simple example, I just copy the values from the collections to the editable fields on the Edit Page through the link-functionality.
When showing the Edit page, I add a save button, which on submitting the page saves the changes in the collection and the db if needed.  These operations are performed in the Processing > Processes > PL/SQL code with the following code:

declare
  cursor c_get_seq
  is
  SELECT seq_id
   FROM APEX_collections
  WHERE collection_name = 'DEPARTMENTS'
    AND c001 = :P6_DEPTID
  ;
  r_seq c_get_seq%rowtype;
begin
   open c_get_seq;
   fetch c_get_seq into r_seq;
   if c_get_seq%found
   then
   APEX_DEBUG.INFO('Collection found, updating);
      APEX_COLLECTION.UPDATE_MEMBER (
        p_collection_name => 'DEPARTMENTS',
        p_seq => r_seq.seq_id,
        p_c001 => :P6_DEPTID,
        p_c002 => :P6_DEPTNAME,
        p_c003 => :P6_MANAGER);
        commit;
     -- update departments set department_name = :P6_DEPTNAME, manager_id = :P6_MANAGER where department_id = :P6_DEPTID;
   else
     APEX_DEBUG.ERROR('Collection not found!!');
   end if;
   close c_get_seq;
end;

After clicking on the save-button, the collection gets updated and the user returned to the previous page.

donderdag 8 december 2016

Finding jdbc/db connection leaks

Reason

Once I started creating my own application module instances, I got database connections not being released anymore.  And because we are all working in complex and big application, I didn't found the cause of the leak.
This blog will help you in finding the cause for the jdbc leak.
All my knowledge is based on the blog from Raul Castillo:JDBC Connection Leak

Finding that you have leaks

The first thing to do is finding whether you have leaks.  This can be done through the end-users stating that the application returns an error stating no connections are available anymore.
Now you can start investigating the cause of this issue.
You can use the Fusion Middleware console to investigate from which datasource the connections are not freed anymore.  It has a lot of helpfull statistics.
  1. Log in the Fusion Middleware Console : http(s)://<host>:<port>/em
  2. Go to your application on the left side under Farm and Application Deployments
  3. Click on the name of your application
  4. In the Application Deployment menu you can choose for Performance Summary.
  5. This will bring you to a new screen showing some default selected diagrams.  
  6. Click on the "Show Metric Palette" button to change the diagrams being showed.
    1. For this use case, you want to go to Related Targets > ServerName > Metrics > Datasource metrics > YourDataSourceName, domain level
    2. Here can select the following interessanting ones:
      1. Datasource - Available connections
      2. Datasource - Connection Leaks
      3. Datasource - Connection Pool size
      4. Datasource - Connections in use
These graphs are very handy when you want to see the evolution of the use of the connections of the datasource.  You can open multiple graphs from different datasource at the same time.  So  you can correctly define the datasource that is being leaking connections.

Once you have determined the datasource causing the leaks, you need to make sure WebLogic Server is cleaning them up after a while.  This can be configured in the WebLogic console:
  1. Login to WLS Console : http(s)://<host>:<port>/console
  2. Go to the datasources defined in the domain
  3. Select the datasource causing the leaks
  4. Go to Configuration > Connection Pool > Advanced 
  5. Make sure the parameter Inactive Connection Timeout is a positive number.  Put it to 5 for testing.  This parameter will cause WebLogic Server to cleanup stuck db connections  and causing a nice error message in the log files.
  6. You can find the logging in your <WLS managed server name>.log file.
  7. It is this error message that you need.  The Inactive Connection Timeout identifies after how many seconds he will try to cleanup the db connections.  When he finds db connections leaking, he will log a java stack trace indicating from where the leak is originating.  Here is an example:

    ####<Dec 8, 2016 8:12:07 AM CET> <Warning> <Common> <zcorinthe-1> <dev01-S1mc> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <1bf3554408c0f552:-3a194c43:158d428de6f:-8000-0000000000002b61> <1481181127371> <BEA-000620> <Forcibly releasing inactive resource "autoCommit=false,enabled=true,isXA=false,isJTS=false,vendorID=100,connUsed=false,doInit=false,'null',destroyed=true,poolname=MCPrintDev,appname=null,moduleName=null,connectTime=87,dirtyIsolationLevel=false,initialIsolationLevel=2,infected=false,lastSuccessfulConnectionUse=1481181100045,secondsToTrustAnIdlePoolConnection=10,currentUser=java.lang.Exception
      at weblogic.jdbc.common.internal.ConnectionEnv.setup(ConnectionEnv.java:366)
      at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:373)
      at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:339)
      at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:469)
      at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:363)
      at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:125)
      at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:158)
      at weblogic.jdbc.pool.Driver.connect(Driver.java:132)
      at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:658)
      at weblogic.jdbc.jts.Driver.connect(Driver.java:127)
      at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:548)
      at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:513)
      at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:506)
      at oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:1056)
      at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1237)
      at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6964)
      at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:304)
      at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:335)
      at oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:203)
      at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:620)
      at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:425)
      at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9518)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4529)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2459)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2269)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3168)
      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:592)
      at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:224)
      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:525)
      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:520)
      at oracle.jbo.client.Configuration.getApplicationModule(Configuration.java:1609)
      at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1514)
      at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1485)
      at be.contribute.demo.adf.DocumentManagement.createAMInstance(DocumentManagement.java:127)
      at be.contribute.demo.adf.DocumentManagement.<init>(DocumentManagement.java:110)
      at be.contribute.demo.adf.DocumentManagement.<init>(DocumentManagement.java:67)
      at be.contribute.demo.adf.SimpleDocumentGeneration.<init>(SimpleDocumentGeneration.java:83)
      at be.contribute.demo.adf.bipublisher.SimpleEnvelopeDocumentGeneration.<init>(SimpleEnvelopeDocumentGeneration.java:38)
      at be.contribute.demo.adf.bipublisher.AcknowledgmentRecieptGeneration.<init>(AcknowledgmentRecieptGeneration.java:23)
      at be.contribute.demo.adf.bipublisher.ReportDataControl.generateReportMotives(ReportDataControl.java:503)
      at sun.reflect.GeneratedMethodAccessor1991.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

     at java.lang.reflect.Method.invoke(Method.java:606)
      at oracle.adf.model.binding.DCInvokeMethod.invokeMethod(DCInvokeMethod.java:690)
      at oracle.adf.model.binding.DCDataControl.invokeMethod(DCDataControl.java:2181)
  8. Now you look for your classes in the stack trace and make sure that for every creation of an am instance, you also close it correctly.
Hope this can help you in finding database leaks.

Have fun.

dinsdag 15 april 2014

ContributeGroep Sessions for OOW14 & JavaOne14

In the spirit of sharing the wonderful things our consultants do at customers, we entered a few of their efforts as proposals for Oracle Open World and JavaOne.

Here is the list of our entries:


ID Proposed Session Title Type Event
CON4630 Integration of Neo4j with Webcenter Content Conference Session OOW
Had enough of the linear searching into your documents?  Needing a dynamic search path in runtime?  Welcome to the world of graph databases.  Using a graph database to perform searches, allows you to add functionality from a totally different order.  Think about searches on relationships between documents or show recommendations of other users into your information model, just to name a few.  Basically, we add relationships between metadata, content, persons, applications, even if they didn’t exist before.  Graph databases allow for a dynamic search structure in runtime, providing more flexibility and agility to your portal.
CON3759 Securing web services - How to make a complex task look easy? Conference Session JavaOne
Not many developers like to implement or expose secured web services.  This is probably because securing web services is a complex matter.  Next to the complexity, the client/server architecture comes into play.  Both sides, client and server, will have their own implementation.  In an ideal world your backend code will not be impacted with the technologies in which it is build, nor which type of security you would choose. Since we are not living in a perfect world, those differences do have a big impact on your approach in bridging those 2 worlds. During this session we will explain how an enterprise service bus could help you out.  Not only in solving this predicament, also in adding clarity in your separation of concerns design.
CON3690 Single-click deployment in Application Express Conference Session OOW
Software development with Oracle Application Express is by no means affiliated with enterprise web development. Oracle itself positions APEX as a so-called rapid application development tool, but recommends other products as soon as projects get larger and more complex. I honestly believe, that APEX has the potential to cope with these large-scale projects. Needless to say, you need more than just plain APEX...

We have managed to incorporate a set of powerful tools in our day-to-day development process. These tools in combination with APEX allow teams to build high-quality database applications in a professional way. It takes no more than a single click on a button to fully deploy your application(s) to a target environment.
CON4662 Taskflows on Sale Conference Session OOW
Get ready for an alternative way of navigating between taskflows within ADF.  Instead of providing only the valid navigation route, we allow for a more flexible system avoiding dependency problems. This opens the way for a free form navigation keeping into account security and his history.  One of the possible implementations of this solution is the creation of a menu that is based on beans or configuration files. Introducing history to this system can overcome the use of the browser back button.
The pattern is already in use at a Belgian customer in providing web(ADF)-based solutions. This customer will be present to explain the business value and agility this brings to their application.

maandag 24 maart 2014

User Experience Event @AMIS

I had the pleasure to join the user experience event @AMIS in the Netherlands.  It was an event organised together with Oracle UX Team.
As a general impression: very well done.  Parking, event location, different themes and very good content are the main positive points that jumps into my mind.
Unfortunately were the sessions programmed without buffer time, so that when you followed one session you are certainly to be late for the next session in another room.  Luckily sessions were repeated, so I didn't have to miss anything and I was able to visit the different Oracle stands explaining the diversity of UX.

For a full list of the sessions, take a look at http://www.amis.nl/UxEvent/Lecture_details.html.
Here are some impressions I took from a couple of sessions:

UX Directions with HTML 5

This session was presented by a surprise act, in the sense that it was not Noel Portugal as presented on the site, instead it was a Belgian Oracle UX team member, namely Mark Vilrokx.  He showed us what they are working on.  It is very interesting to see how Oracle is investing into new technologies.  The things this guy showed us, was even new to our UX designer.  He focused on new possibilities with browser interactions in the mobile devices.  Knowing that a server can actually track your whereabouts, how bright it is in the room, whether you are using the application or not, is astonishing.  Not only passive information was gathered, also actions were triggered on the device.  Things like activating the vibrating functionality, playing a movie without user interaction.  This is a clear step forward for the browser in the war against native/hybrid applications.  Which made the off-line capability the only remaining drawback of the browser app in the mobile environment.

The architecture he used was a standard one: HTML5 -> Ajax calls -> REST Services.  To develop the mobile app, he used the Fuse Bootstrap, which is an adapted version of the Twitter Bootstrap.

Not presented in this session, but linked to the presenter is the Oracle Voice product.  It is a standalone product that will be released with the version 9 of HCM Cloud application.  It is an app that you can install on your phone or tablet, allowing you to speak to the application.  Not only in a question-response mode, where you answer to the question of the device, but also in entire sentences.
Example:  Create a new appointment Follow up meeting at Contribute next monday.  Not only will the solution interpret the sentence, it will also automatically fill in the fields of the new appointment.  For the missing information, extra questions will be asked.  When you have multiple opportunities for this account, a list of the possible opportunities for that account will be presented.
What is even more amazing is that the application does not need to learn.  You used to spend an hour saying/pronouncing bizarre and difficult words, this is not needed anymore.  Which indirectly means that you need to speak American English very well, preferably with a Californian accent :-).
A nice site note for my Belgian friends, this product uses Nuance for the Speech-to-Text and Text-to-Speech functionality.  Nuance bought the voice recognition software from our West-Vlaamse creatives L&H and is using their solution as one of the possible resolution software for the Speech-to-Text challenge.

Oracle's Strategy for Cloud User Experience

This session was presented by Jeremy Ashley, what a presenter.  It is not the content that struck me, instead his way of presenting and the feeling of clarity he gave us about this topic.   A must seen presenter!!
Back to the content.  The three main topics for Oracle UX are Simplicity, Mobility and Extensibility.
Simplicity is referring to the completeness of your solution.  It must be no too much, neither not too little, it must be exact for the job at hand.
Mobility is not about the mobile devices, instead it focusses on the way we work.  How we work differently now and in the future, then a couple of years ago.
The audience of these type of applications are people who will be using these not too often.  Hence the importance of keeping the distance between wanting to do something and doing it, must be a as small as possible.  The process that is the main driver, listens to the expression: Glass - Scan - Commit.  Resulting in an application giving the user an high level overview of the data, allowing him to drill down for more detail and then close his action.  This approach is very closely linked to the idea of 10-90-90, meaning that 10% of the tasks are performed by 90% of the users in 90% of the time.  These 10% are the main focus of these applications.  For full feature functionality, the user will be brought to the actual application.
Based on their experience with the Oracle Cloud solutions and fusion applications, the UX team delivers a set of patterns for you to use.  These can be found at http://www.oracle.com/ux.
While most of the development and testing is done through HTML5 and then pushed to the ADF team, APEX is gaining momentum here.  In the "near" future, the APEX team will also include these patterns, just like ADF does.

UX Today with ADF

A presentation done by Sten Vesterli.  This session was really focused on ADF, like the title mention.  From the first moment it was clear that Sten was a guy with a lot of experience.  Here are some of his main points during the session:
From http://www.vesterli.com/2014/03/20/good-user-experience-at-low-cost/
  • A clear graph on the different types of applications you can build:
  • Use GUI mockup tools to create samples of your UI which don't have a high fidelity.  Reason: possible no feedback from end-users due to the hard work already done AND the possible feedback you get is that it could be finished tomorrow.  Conclusion: make sketches.  Possible tool: Balsamiq
  •  Another great point made by the presenter is the difference in type of application you can build between Forms,Apex and ADF.  While Forms and Apex applications have a 1-1 relationship with the underlying data model, ADF doesn't.  With ADF you have more a n-n relationship, allowing for a far greater UI experience.  Conclusion here: do not generate your UI screens.

Don't generate your user interface, design IT!

Session given by Lonneke Dikmans from Vennster, ACE Director in SOA & BPM.
The problem according to Lonneke is:
  • Using BPEL/BPM Human Tasks
    • too fine grained
    • too much data in process
      • need to adapt the process to changes in the UI
      • inflexible for use -> ex. no bulk operations possible
    • not enough data for the UI -> only task data is available
The solution for this is to take an alternative approach:
  • separate both solutions => BPEL/BPM and UX
  • take the following actions in your project
    • Define the different personas.  Who will be using the application, how often, from which type of devices, do they have knowledge of the app, ...
    • Define different scenario's for different type of personas
    • Design the interaction process
  • Ex: while the HR persons define the process, it should be the users themselves who define the UX/App
My question for Lonneke: how should we build BPM applications then?  From the BPM flow or build a separate application that calls on the BPM API's?
Answer from Lonneke: take the latter one.  This way the UI is really build for the end user and you have more flexibility.

Leveraging FMW for UX

Another session from Lonneke Dikmans.  This session was a simple overview of the main components of the FMW stack of Oracle.  Some points worth remembering:
  • How to test the experience:
    • Do Usability testing
    • Do SCA testing => use mock responses
    • Do Load testing
  • Tip: learning by doing : learn whether something works or not
    • ex: google class: 1st version done in 2 days
  • Monitoring

Oracle and Mobile: From Design to Device; The tools that make it happen

Session by Luc Bors.  Simple overview of ADF Mobile.
There seems to be a misunderstanding in the comparison between ADF mobile or hybrid solutions and native solutions.  According to Luc and Oracle(Oracle is saying this also, I know I did it also before), the effort in making a native app is a lot bigger and more difficult then making a hybrid solution for multiple platforms.  It is true that you need to make an app for each platform and that reuse at the level of the mobile app is almost zero.  Nevertheless, making these mobile apps is only a small part of the total project.  The major effort resides in building the back-end services, including security.
Take into account that the hybrid solution from Oracle only supports 2 platforms, while there are 4 in the market.  

According to me is Oracle ADF great at the data oriented apps, while building great looking apps are better done in native solutions.  One of our main references in this area is the Royal Belgian Football Association, who are really looking at their target audience and decide on the technology uses, like Oracle Forms, ADF, ADF Mobile and native mobile applications.

Conclusion

A great event with may thanks to AMIS and Oracle for organising this.  All speakers at this event where ACE Directors or Oracle employees, pushing the available knowledge at this event at a great height.  Looking forward for a next event like this.
At the following URL you can have a look at the presentations themselves: http://technology.amis.nl/2014/03/24/sharing-the-slides-of-the-ux-event-presentations/

vrijdag 3 januari 2014

ADF: Putting IE in a certain document mode

Problem

In our ADF application we used some javascript to put the focus on the first field of an af:query component.  This seems to work great when running directly from JDeveloper, but doesn't if the application is deployed on a separate WLS.

Solution

First we thought it is the javascript itself, but this was not possible since we do not change the code.
One of our JSF experts, Rudy De Busscher, figured out that the compatibility mode of IE changed between both deployments.  How or why, remains still a mystery.

So, now we need to force IE to keep his IE8 compatibility mode.  To do this, you need to put a meta tag in the header of your page.  This is easy enough to do in ADF, in the af:document tag, add a facet with this tag in, like this:

<af:document id="d1" title="Test Javascript">
   <f:facet name="metaContainer">
      <f:verbatim>
         <meta http-equiv="x-ua-compatible" content="IE=8"/>
      </f:verbatim>
   </f:facet>
....

The problem with this solution is that the meta-tag will be put after your stylesheet tags, which will result in the fact that this meta-tag is not taken into account.
To solve this problem, you need to perform a small operation.  Since this seems to be a hack, I'm not sure it will work in all ADF versions.  I tested it with ADF 11.1.1.3.0.
Make your code look like the following:

<f:view>
   <f:verbatim>
      <head><meta http-equiv=x-uq-compatible" content="IE=8"/></head>
   </f:verbatim>
   <af:document id="d1" title="Test Javascript">
   ...
To check whether IE is taken this into account, use the F12 key to open the Developer Tools, in the top menu you will find the Document Mode.  This will indicate in which mode you are operating.  Also have a look at the header of the document, the meta-tag of http-equiv should be after the title, but proceeding the stylesheet tags.

Have Fun.

F.

donderdag 2 januari 2014

ADF BC: Find out what is really happening in the database

Problem

While there are multiple ways (see previous blog) within ADF BC to see what is being generated and executed in the database, perhaps you are not satisfied with the information provided nor the overhead of the other loggings which are blocking your clear view on the matter.
Or perhaps you are missing information like how many times a query is executed, how long it took, how many fetches were used, ... 

Solution

Use the logging of the database to find the required information.  You can enable your sessions or even the entire database to activate logging that can be used to give you a clear overview on what is being asked from the database.
To activate this logging you need to perform the following actions:
  1. Activate the logging in your session
    Execute the following statement : alter session set sql_trace=true
    You can execute this command in your application module impl class by overriding the afterConnect() method.  I'm also using this method to set some optimizer hints for my queries, like optimizer_index_cost_adj and optimizer_index_caching.
    Example:
    • @Override
      protected void afterConnect() {
         super.afterConnect();
         executeCommand("alter session set sql_trace=true");
      }
  2. Perform the necessary actions in your application for which you want to have the trace.
  3. You can now stop the trace by executing the following statement: alter session set sql_trace=false
    or just perform action 4.
  4. At this point the database will have generated a very detailed, not easy to read and understand trace file.  This file can be found under the user dump directory, which is defined by the database parameter user_dump_dest (show parameter user). 
  5. Now we need to parse this file to a more readable file by executing the following statement:
    tkprof <sid>_ora_<pidid>.trc <result_file> sort=fchela
    Since it is very hard to know what process id you need, I just always took the last one :-)
    I added the sorting criteria to see the statements first with the biggest elapsed time.  Information on all parameters for tkprof can be found here.
    Example : tkprof orcl_ora_2463.trc test.txt sort=fchela 
  6. Now you have a file that is readable, namely test.txt.  This file will give an overview of all statements being executed by your sessions and at the end an overview.  Let's have a look at output for 1 statement.
  7. Only take the statements into account where the parsing user is not SYS.  The latter is used for database internal queries and do not adhere to the same tuning rules as your custom queries.
Here is an example output for a very simple query:
Let's have a look at the important bits of information:
  • As 3th part of information you see the query like it has been asked at the db.  Here you see whether correct bind variables are used.  The only drawback of this technique is that this query is not linked directly to a certain view object.  It is up to you to determine which view object has generated this query.
  • The count column of the Parse row, should be 1 or as low as possible.  This indicates how many times the db needed to parse this particular statement.  If you are not using bind variables, you will see that for each value a new statement overview is given and that the parse count will still be 1.
  • The count column of the Execute row, should represent the number of times this query should be executed.  If you would have expected a lower number then the one appearing here, then BC has executed this query more often.  To solve this problem, you will need to look at the page definition files to determine when and how often the query is executed or even in your custom code when you asked to execute query on an iterator.
  • Normally the cpu time of the execute row, should be very low.  If this is not the case, then it indicates that the query itself is very complex and has a lot of hierarchies of tables.  Or it could be because it is a DML-statement.
  • Now comes the most important row, the Fetch-row.  The fetch count number indicates how many times the application has fetched rows for this query.  If the execute count is 1 and the fetch count is 10, this means that ADF BC has executed the query once, but needed to go 10 times to the db to get all data.  To resolve this problem, just change the 'in Batches of'-tuning parameter of your view object.  Look at the following blog for some tuning guides.
These were for me the most important pieces of information to be able to tune my ADF application.

Have Fun.

F

ADF BC: Adapting the where-clause of a view criteria

Problem

You have build a working ADF BC application.  After some tuning tests, it seems that your application can use some tuning.  So you, or someone above you, decides to call an expert DBA or SQL tuning specialist.

Result : you need to change the way the where-clauses are created.
If you are lucky, it is just a where-clause you have written.
If you are less lucky, it is a where-clause created by a view criteria, in this case you can not change it.  You can only activate or deactivate some properties.

In our case this wasn't enough.  The ADF BC framework generated clauses like
UPPER(LAST_NAME) LIKE UPPER(:LastName_bvar || '%')


Solution

The first thing you need to do is to remove the upper-statement.  This can easily been done by deselecting the 'Ignore Case' property in the edit view criteria screen.

So now you are getting the following clause
LAST_NAME LIKE (:LastName_bvar || '%')

While this seems fine for you, your tuning specialist still isn't happy.  He wants to get rid of the wildcard.

To accomplish this requirement you will need to get more creative.
Add the following code to your ViewImpl class or your base ViewImpl class:
    /**
     * Source : http://tompeez.wordpress.com/2011/08/21/extending-viewcriteria-to-use-sql-contains-4/
     * Adapting the creation of the where-clause to remove the '%' after the bind variables of the like statements
     * At the same time we add the '%' wildcart at the end of the variable value.
     * We will do this for all bind variables with custom property LIKE_CLAUSE=CUSTOM
     * This method gets called for all bind variables
     * @param viewCriteriaItem
     * @return
     * @author Filip Huysmans
     */
    @Override
    public String getCriteriaItemClause(ViewCriteriaItem viewCriteriaItem) {
        ArrayList<ViewCriteriaItemValue> lArrayList = viewCriteriaItem.getValues();
        if (lArrayList != null) {
            ViewCriteriaItemValue itemValue = (ViewCriteriaItemValue)lArrayList.get(0);
            if (itemValue.getIsBindVar()) {
                Variable lBindVariable = itemValue.getBindVariable();
                // check for the special LIKE_CLAUSE in the used bind variable
                Object obj2 = lBindVariable.getProperty("LIKE_CLAUSE");
                String likeClause = (obj2 != null ? obj2.toString() : "null");
                if (likeClause != null && !likeClause.isEmpty() &&
                    !"null".equals(likeClause)) {
                    if (viewCriteriaItem.getViewCriteria().getRootViewCriteria().isCriteriaForQuery()) {
                        // normal query execution
                        return getLikeClauseForDatabaseUse(viewCriteriaItem,
                                                           likeClause);
                    } else {
                        // for in memory we don't need to anything so just return '1=1'
                        return "1=1";
                    }
                } else {
                    // no special treatment for all other CriteriaItems
                    return super.getCriteriaItemClause(viewCriteriaItem);
                }
            }
        }
        // fallback call
        return super.getCriteriaItemClause(viewCriteriaItem);
    }
 
    protected String getLikeClauseForDatabaseUse(ViewCriteriaItem aVCI,
                                                 String typeLikeClause) {
        ArrayList<ViewCriteriaItemValue> lArrayList = aVCI.getValues();
        ViewCriteriaItemValue itemValue = (ViewCriteriaItemValue)lArrayList.get(0);
        String whereClause = "1=1";
        if (itemValue.getIsBindVar()) {
            Variable lBindVariable = itemValue.getBindVariable();
            Object objVarVal = ensureVariableManager().getVariableValue(lBindVariable.getName());
            String varVal = null;
            if (objVarVal != null) {
                // Adding the wildcard to the bind variable and putting the bind variable in upper-case
                varVal = (objVarVal.toString().toUpperCase() + "%");
                ensureVariableManager().setVariableValue(lBindVariable,
                                                         varVal);
            } else {
                // No value specified => return no where clause
                return null;
            }
 
            String bindVarName = lBindVariable.getName();
            if ("UPPER".equals(typeLikeClause))
                whereClause =
                        "UPPER(" + aVCI.getColumnName() + ") like :" + bindVarName +
                        " ";
            if ("CUSTOM".equals(typeLikeClause))
                whereClause =
                        aVCI.getColumnName() + " like :" + bindVarName + " ";
        }
        return whereClause;
    }
As mentioned in the java doc of this code block, you need to add a custom property to the bind variables for which you want this to take effect. Add a custom property with the name 'LIKE_CLAUSE' and a value of 'UPPER' or 'CUSTOM'.

From this situation you can add any functionality you want to make the where-clause exact what your tuning specialist is looking for.

Have Fun.

F

maandag 16 december 2013

ADF: annoying warnings

Fact

In the logging of your application server, you see often the following warning :

<SimpleSelectOneRenderer><_getSelectedIndex> Could not find selected item matching value "0" in RichSelectOneChoice[UIXEditableFacesBeanImpl, id=value70]

Problem

You are probably using a component which generates fields dynamically, like the query-component.  If you have defined a LOV for one of the fields this component needs to show and you have specified that it needs a "No Selection" item in the UI Hints of the LOV, then this warning will popup.

The warning you are getting is just saying that he tries to map a selected value "0" to the list he recieves, in which case he did not find it.  The id is pointing to the field in the query component in this case.  The fields are numberd from value00, value10, value20 to valueXX.

Solution

The solution is to remove the selection of the "No Selection"-item, but this will probably add another problem to your list.  To solve this problem you can do the following depending on the type of the view-component of your LOV.

  • View based on static values.
    In this case just add an empty row and put it on top.  The order for these kind of views is determined by the order in the list.

  • View based on a query.
    In this case just add an union-clause and add an empty row through the dual-table.  Also add an order by-clause to put the null-row first.

donderdag 3 oktober 2013

Simple tuning principles for ADF

Hello everyone,

Most of the time when people are talking about tuning, it starts to get quickly quite ugly technical.
I had the opportunity to do some tuning for a customer myself, I didn't pushed the pedal to the metal, but found some simple rules I could follow.


  • BC View Tuning
    • as-needed = iterator range size
    • fetch size batches = rows displayed + 1
    • max fetch size = -1
  • AM
    • jbo.ampool.initpoolsize=10% more then concurrent users
    • jbo.recycletreshold = nbr concurrent users
    • jbo.ampool.monitorsleepinterval= 14400000 = 4uur
    • jbo.dofailover=true
    • jbo.locking.mode=optimistic
    • jbo.doconnectionpooling=false
  • Pagedefinition
    • Iterator Rangesize = number of rows displayed
    • Iterator RowCountTreshold = -1
  • Taskflows
    • activation = defer
Everything else is common sense :-).

Hopes this gets you started.

F

Unconventional Overview of OOW13

Hello everyone,

Due to the huge amount of readers of my last year’s blogs on OOW, I restrict myself this year to the overall conclusion I made on OOW13.
The idea’s and opinions expressed in this blog are my own.  So if you want copy or use them, please send a donation to charity ☺.

@https://www.facebook.com/OracleOpenWorld
As aspected this year's Oracle Open World focused on Cloud, Big Data, Social, Customer Experience, M2M(IoT) and Mobile.
No surprises here, until you look further.  Until you start looking further then the sessions being given, further then buzzwords, even further then keynote speeches.

First major change, it is not about mobile, it is about mobile-first.  No longer the desktop browser is king in the land of the developer, according to Oracle, but the mobile devices are.  They control the development of frameworks, architectures and solutions.   They define how application will be made in the future and how they will look like.
We came from a couple of years of developing desktop web browser applications and making the mobile brothers alike for them, to making mobile applications and given their big brother applications the look&feel they need.
While this seems a small shift, it will totally change your view on application development.
Does this mean you need to throw all your current projects away and start over again, no.
Remember that it is Oracle's vision that is presented at Open World, giving you a year or two to react upon.

Another change is in the Cloud proposal, but this change we all expected: more, bigger and more social. The solutions presented covering the cloud offering of Oracle, were numerous.  I was impressed in the total package of Oracle, extra features on the existing offerings, new offerings in the IAAS, PAAS and SAAS area. While I'm not an Oracle applications guy, the list of offerings in the SAAS area overwhelmed me. Off course, their SAAS-cloud offering doesn't cover all the functionalities delivered by their mature sisters like PeopleSoft, Siebel, EBusiness Suite or JD Edwards.  Nor is that the purpose.  How many times did you hear that the cloud would change the way you do business?
When there wouldn't be any difference between those solutions, where would the change in doing business be?
But this isn't change this is evolution. The change lies in opening of their cloud offering.
How do you open a cloud offering you might ask?  It is not only Oracle's cloud that gives you your favorite products at your fingertips, also Microsoft's Azure-cloud solution will enable you to run your business in the cloud on Oracle software.
Who said that Oracle isn't a cloud company?
Small remark on the side: MS was putting a lot of focus on the fact that you could run the Oracle database, WebLogic Server and Java in their cloud.  While the first two make sense, the last one is a bit strange. Since it's slogan is "Develop once, run anywhere".

Finally, big data or should I say smart data. While last year big data was al about capturing, this year it is all about integrating and delivering solutions for the business.  The examples given during such a conference are breath taking.
Coming from a very small country myself, I was wondering what could mean big/smart data for the Belgium market. And in essence it is not about the absolute size of data that need to be handled, but the relative portion of that data that resides above the normal expected working parameters of your business. Since Oracle always looks at the big players in all market segments, the hardware solutions they put forward are equally big. So it is far more opportune to not look at the hardware side of things, but the architecture side of it.  Perhaps your business doesn't need the power of treating billions of rows of data a day, but it might well be that it is interested in the same insights.
Insights into your business, insights into your way of working, insights into your customers, insights into the business of your customers and perhaps the most business interruptive power of them all: social media.
Big/smart data is not about data; it is about thinking differently about building solutions based on data. Now it all comes together, network, hardware, software, maturity and social allowing for a new final frontier of analytics.

@https://www.facebook.com/OracleOpenWorld
Let’s not forget the new kid on the block, M2M.  It is hardly new; it was already presented the year before, but then only on JavaOne. While you need to go to J1 for the dirty technical details about it, you can now join OOW for the business side of things.  What M2M appeals to me is that it, like big data, let’s you rethink solutions for the business.  Now it is a lot easier to not only build a solution based on software, but also include a hardware portion.  We are not confined anymore to expense and unique in the market devices, probably vendor locked-in also, but we get now this breath taken possibilities of cheap and commodity hardware that we can shape to our needs.  The fact that this topic got his own keynote means that Oracle thinks that their customers are ready to embrace this technology, which probably result in a boost of projects being started.

@https://www.facebook.com/OracleOpenWorld
If you think I covered all the major topics by now, cloud/mobile/big data/m2m/social, you are in for a surprise.
At last year's conference, we had a couple of talks about the way Oracle tries to deliver applications that are end-user friendly.  They even had planned a short trip to HQ, to convince us about the effort they put into it.
Who could ever thought, that this topic would be the biggest one of them all the year after? I'm not counting the number of sessions nor the seats in the rooms of those sessions; instead I'm looking at impact of it on all previously discussed topics.
"Customer Experience", it seems so easy and logical. It is the reason why there are so many conventions around the world. It is the reason why companies invest in development, marketing and sales.  Frankly, it is probably the outcome of customer experience that drives companies or better-put "people".
Once you start talking about customer experience, you are dealing with a totally different set of KPI’s.  It is no longer about bits and bytes, no longer about how fast and well we can treat information, it is not about how much money we put into IT, what the hell it is not about IT.
It is about ... you, the customer, partner, employee and family and how we can make our business more suited for you.
Finally, once a department starts thinking about the service it can deliver, instead of the great wonderful technical things they can do, that's the day that it becomes the corner stone of a company.


Here are a few examples to illustrate the power of it.

@http://kentgraziano.com/
  • I already tweeted about it, so I'll start with the event itself. Not only was the event bigger in size, it was also bigger in the overall experience for the visitor. For me it is not so much about the big, too cold air-conditioned session rooms (they were there last year also ☺), it is about the fact that the company Oracle is more then just a supplier of hard- and software, it delivers now also entertainment, passion and vision outside of the IT-landscape.

    Walking around on the Oracle plaza, which was on Howard Street (between North and South Moscone), gave you a sense of the power of Oracle in the Bay area. This year there was no closed tent hiding Howard Street. This year it was an open, inviting and socially appealing place to linger. Coming out of a keynote, hearing fantastic music, feeling the sun warming your body and only seeing smiling people, pushes you into the only possible conclusion: Life @/with Oracle is great.  On top of that, add the suspense of the America's Cup, and you know there is more to live then IT even @Oracle.

    Short remark on the side concerning Larry Ellison ditching his cloud keynote in favor of the boat race, so what?  Larry has the fortune to have now 2 boats (metaphorically speaking). One is a very big one, with still a lot of potential but more importantly 5 great captains. This boat is not ready, nor willing, to lose. It has a great history of good and bad moments, but always came out strong. The other one is fairly new, has only 1 captain and a smaller crew. It has equally great potential, but still need guidance, hence their victory in the America's Cup.Larry didn't stand up 60.000 people, there would never be 60.000 people looking at the keynote. So many of them were also looking at the boat race or having lunch with customers or partners. Isn't it great to see that the team behind Larry is capable of standing by their captain?
  • Another example is the testimony of Lego. What a great inside into their company's marketing vision. How else can you do a campaign for 100$? Admitting that Lego already had a good brand name, so it can more easily make use of crowd sourcing, but nevertheless a good example how small and simple things can bring great results (trying to avoid saying big here).
    It is all about finding the social needs of your customers and using that to open new worlds for them and yourself.

  • Now for the last example, a more of a personal note. First a warning: all characters appearing in this story are fictitious. Any resemblance to real persons, living or dead, is purely coincidental.

    So I was wondering around finding my way to Moscone North for the keynote of JavaOne. Assuming a lot of people would take the direct route through the Moscone North entry, I took my changes via Moscone South. As a few of you know, there is a direct passage from South to North. Still standing in South and looking on to the passage of North, I see a sea of people waiting to go to the keynote. So a bit uneasy I put myself back in line ready for a long period of queuing.  Still not sure I'm really in the right lane, I ask a person next to me whether this is really the queue for the keynote.
    Naturally she could answer, "Off course, what else would all those people be queuing for?" and probably thinking "Again a foreigner, probably from a small country like Belgium where they've never seen such an interest in a keynote".
    Strangely enough she didn't, instead she said, "Yes, it is". A bit surprised by the calmness of her answer and given my capability of not stopping speaking, I asked a couple of more questions. Strangely enough, she didn't figure out that I was a foreigner right away and so she kept on answering my curiosity. Suddenly the roles got inverted. She was now starting to ask questions and I was more then willing to reply. After 10 minutes going back and forth like this, something changed.  We stopped with asking and started telling stories about things that happened or would be happening in the near future. We watched the keynote together and gave our very personal opinion on every topic. More often then not, we were thinking in the same direction. After the keynote, we exchanged numbers and fought our way through JavaOne for her and Open World for me.

    Now what has this to do with customer experience? Well read the story again and replace "me" with yourself, "she" with your partner, customer and the "keynote" with social media. Now tell me, is this not how you make the first contact with new customers/partners?


The final thoughts I want you to take with you are that all the fancy buzzwords like cloud, mobile, big data should be enablers for your business and not a goal in itself. When looking beyond IT and seeing the bigger picture, will allow you to do bigger and longer projects that stand the test of time and will be better appreciated and used by the business.

Hoped you enjoyed the reading.

F

dinsdag 28 mei 2013

ADF BC: JBO-25014: Another user has changed the row with primary key

Challenge

You receive the error mentioned in the title, but you are quite sure this is not the case and nothing has changed in the database due to triggers or pl/sql-code.

Context

Jdeveloper: 11gR1

Solution

There are already quite a few blogs on this error within ADF.  They all talk about the fact that something has changed in the database, without BC knowing about it.  This can be done through another user, a batch-script, a trigger or any other pl/sql-code.
But what if you are 100% sure this is not the case, then read on.

There is also another reason why this happen: the comparison of the different attributes didn't go well.  Although the documentation clearly state that the oracle.jbo.domain-classes should solve this issue, we still have found ourselves multiple times in this situation and mostly due to Date-attributes.
There are 2 ways to handle this:
  1. You can identify an attribute in your entity as a “Change Indicator”.  Once you have identified such an attribute in your entity, the BC-code will no longer compare all attributes, instead it will only compare those with the “Change Indicator” activated.

    To set this indicator on an attribute, just open the editor of the attribute to see the “Change Indicator” property.
  2. You can remove the attribute that is causing the problem from the comparison.  This is easier said than done, because you need to know which attribute is causing the problem.

    To find this out, just activate the JBO-diagnostic logging, you can do this by adding the following “-Djbo.debugoutput=console” to the Java-options of your run-configuration.
    Now run the application again and simulate the problem.  You should find something like this:
    <EntityImpl><compare> [508] Entity compare failed for attribute HireDate
    <EntityImpl><compare> [509] Original value :19-06-1987
    <EntityImpl><compare> [510] Target value :19-06-1987
    
    Now you know it is the HireDate-Attribute.  Now add the following code to the Impl-class of your entity:
    @Override
    protected boolean compare(SparseArray sparseArray) {
       // Removing the HIREDATE attribute from the array
       if (sparseArray != null && !sparseArray.isEmpty()) {
           for (int i=0; i<sparseArray.length(); i++) {
               Object value = sparseArray.get(i);
               if (value != null) {
                   if (i == HIREDATE) sparseArray.clear(i);
               }
           }
       }
       // Calling the standard compare method
       return super.compare(sparseArray);
    }
    
    You can do this for as many attributes as you need, just add them to the 3th if-statement.

dinsdag 7 mei 2013

JDeveloper 11.1.2.4 on Mac Lion


Challenge

Installing JDeveloper 11.1.2.4 on a MAC Lion

Context

Mac: 10.7.5
Jdeveloper: 11.1.2.4.0
Java: 1.7.0_17


Solution

I encountered 2 problems during installation:

  1. In the Installation wizard, when you use Custom instead of Typical, you need to find the correct Java version yourself.  If you use Typical, the default Java is set per default.
  2. When trying to run the WebLogic Server for the first time, I receive the following output:
    [Waiting for the domain to finish building...]
    
    [03:54:51 PM] Creating Integrated Weblogic domain...
    
    [03:55:21 PM] Extending Integrated Weblogic domain...
    
    [03:55:29 PM] Integrated Weblogic domain processing completed successfully.
    
    *** Using HTTP port 7101 ***
    
    *** Using SSL port 7102 ***
    
    /Users/filiphuysmans/.jdeveloper/system11.1.2.4.39.64.36/DefaultDomain/bin/startWebLogic.sh
    
    [waiting for the server to complete its initialization...]
    .
    .
    JAVA Memory arguments: -Xms256m -Xmx512m
    .
    Unrecognized option: -jrockit
    
    Error: Could not create the Java Virtual Machine.
    
    Error: A fatal exception has occurred. Program will exit.
    
    WLS Start Mode=Development
    .
    
    CLASSPATH=/Users/filiphuysmans/programs/JDev111240/oracle_common/modules/oracle.jdbc_11.1.1/ojdbc6dms.jar:/Users/filiphuysmans/programs/JDev111240/patch_wls1035/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/Users/filiphuysmans/programs/JDev111240/patch_jdev1112/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/Library/Java/JavaVirtualMachines/jdk1.7.0_17.jdk/Contents/Home/lib/tools.jar:/Users/filiphuysmans/programs/JDev111240/wlserver_10.3/server/lib/weblogic_sp.jar:/Users/filiphuysmans/programs/JDev111240/wlserver_10.3/server/lib/weblogic.jar:/Users/filiphuysmans/programs/JDev111240/modules/features/weblogic.server.modules_10.3.5.0.jar:/Users/filiphuysmans/programs/JDev111240/wlserver_10.3/server/lib/webservices.jar:/Users/filiphuysmans/programs/JDev111240/modules/org.apache.ant_1.7.1/lib/ant-all.jar:/Users/filiphuysmans/programs/JDev111240/modules/net.sf.antcontrib_1.1.0.0_1-0b2/lib/ant-contrib.jar:/Users/filiphuysmans/programs/JDev111240/oracle_common/modules/oracle.jrf_11.1.1/jrf.jar:/Users/filiphuysmans/programs/JDev111240/wlserver_10.3/common/derby/lib/derbyclient.jar:/Users/filiphuysmans/programs/JDev111240/wlserver_10.3/server/lib/xqrl.jar
    .
    PATH=/Users/filiphuysmans/programs/JDev111240/wlserver_10.3/server/bin:/Users/filiphuysmans/programs/JDev111240/modules/org.apache.ant_1.7.1/bin:/Library/Java/JavaVirtualMachines/jdk1.7.0_17.jdk/Contents/Home/jre/bin:/Library/Java/JavaVirtualMachines/jdk1.7.0_17.jdk/Contents/Home/bin:/usr/bin:/bin:/usr/sbin:/sbin
    .
    ***************************************************
    *  To start WebLogic Server, use a username and   *
    *  password assigned to an admin-level user.  For *
    *  server administration, use the WebLogic Server *
    *  console at http://hostname:port/console        *
    ***************************************************
    starting weblogic with Java version:
    Starting WLS with line:
    /Library/Java/JavaVirtualMachines/jdk1.7.0_17.jdk/Contents/Home/bin/java -jrockit   -Xms256m -Xmx512m -Dweblogic.Name=DefaultServer -Djava.security.policy=/Users/filiphuysmans/programs/JDev111240/wlserver_10.3/server/lib/weblogic.policy -Djavax.net.ssl.trustStore=/var/tmp/trustStore875832875455889226.jks -Dhttp.proxyHost=proxy.iconos.be -Dhttp.proxyPort=8080 -Dhttp.nonProxyHosts=local|*.local|169.254/16|*.169.254/16|127.0.0.1|localhost|*.localhost|localhost.localdomain|::1|10.99.9.23|Filips-MacBook-Pro-2.local -Dhttps.proxyHost=proxy.iconos.be -Dhttps.proxyPort=8080 -Doracle.jdeveloper.adrs=true -Dweblogic.nodemanager.ServiceEnabled=true  -Xverify:none  -da -Dplatform.home=/Users/filiphuysmans/programs/JDev111240/wlserver_10.3 -Dwls.home=/Users/filiphuysmans/programs/JDev111240/wlserver_10.3/server -Dweblogic.home=/Users/filiphuysmans/programs/JDev111240/wlserver_10.3/server  -Djps.app.credential.overwrite.allowed=true -Dcommon.components.home=/Users/filiphuysmans/programs/JDev111240/oracle_common -Djrf.version=11.1.1 -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Ddomain.home=/Users/filiphuysmans/.jdeveloper/system11.1.2.4.39.64.36/DefaultDomain -Djrockit.optfile=/Users/filiphuysmans/programs/JDev111240/oracle_common/modules/oracle.jrf_11.1.1/jrocket_optfile.txt -Doracle.server.config.dir=/Users/filiphuysmans/.jdeveloper/system11.1.2.4.39.64.36/DefaultDomain/config/fmwconfig/servers/DefaultServer -Doracle.domain.config.dir=/Users/filiphuysmans/.jdeveloper/system11.1.2.4.39.64.36/DefaultDomain/config/fmwconfig  -Digf.arisidbeans.carmlloc=/Users/filiphuysmans/.jdeveloper/system11.1.2.4.39.64.36/DefaultDomain/config/fmwconfig/carml  -Digf.arisidstack.home=/Users/filiphuysmans/.jdeveloper/system11.1.2.4.39.64.36/DefaultDomain/config/fmwconfig/arisidprovider -Doracle.security.jps.config=/Users/filiphuysmans/.jdeveloper/system11.1.2.4.39.64.36/DefaultDomain/config/fmwconfig/jps-config.xml -Doracle.deployed.app.dir=/Users/filiphuysmans/.jdeveloper/system11.1.2.4.39.64.36/DefaultDomain/servers/DefaultServer/tmp/_WL_user -Doracle.deployed.app.ext=/- -Dweblogic.alternateTypesDirectory=/Users/filiphuysmans/programs/JDev111240/oracle_common/modules/oracle.ossoiap_11.1.1,/Users/filiphuysmans/programs/JDev111240/oracle_common/modules/oracle.oamprovider_11.1.1 -Djava.protocol.handler.pkgs=oracle.mds.net.protocol  -Dweblogic.jdbc.remoteEnabled=false -Dwsm.repository.path=/Users/filiphuysmans/.jdeveloper/system11.1.2.4.39.64.36/DefaultDomain/oracle/store/gmds   -Dweblogic.management.discover=true  -Dwlw.iterativeDev= -Dwlw.testConsole= -Dwlw.logErrorsToConsole= -Dweblogic.ext.dirs=/Users/filiphuysmans/programs/JDev111240/patch_wls1035/profiles/default/sysext_manifest_classpath:/Users/filiphuysmans/programs/JDev111240/patch_jdev1112/profiles/default/sysext_manifest_classpath  weblogic.Server
    
    Unrecognized option: -jrockit
    Error: Could not create the Java Virtual Machine.
    Error: A fatal exception has occurred. Program will exit.
    Process exited.
    
2 things go wrong here:
  • He tries to use the -jrockit VM-type.
  • There is no setting for the PermGenSpace
To solve this problem, perform the following steps:
  • Go to the domain directory to find the setDomainEnv.sh file.
    This file can be found in <your home directory>/.jdeveloper/system11.1.2.4.39.64.36/DefaultDomain/bin
  • Find the line with 'SUN_JAVA_HOME=""' and change/modify it to
      • SUN_JAVA_HOME=$BEA_JAVA_HOME
      • JAVA_VENDOR=Sun
      • export SUN_JAVA_HOME JAVA_VENDOR
  • Save the file and try to start the WLS Server

vrijdag 12 april 2013

Submitted Sessions for Oracle Open World and JavaOne 2013

It is again this time of year, were everyone is searching for their best English and write a small piece of text to convince a group of people.  Also we did the same exercise and handed over our papers for Oracle Open World and JavaOne.

Here is our, Contributes, list of papers for 2013:


 ID  Proposed Session Title  Type
TUT4879  Building your stock management solution for no more then $299  Tutorial
CON4907  Making Open-Source & Oracle security best friends. The Mazda story.  Conference Session
CON4872  No SOA without Service Orchestration  Conference Session
CON4901  Score with the right Oracle technology for the right audience. The RBFA story.  Conference Session
CON1846  Taking You from Forms to ADF Mobile: a Journey  User Group Forum (Sunday Only)


I would advice everyone else to do the same, but .... on different topics preferably ;-).

Thanks to everyone who helped building up this list and everyone who is going help to get some talks accepted.

Very much appreciated.

Filip

dinsdag 9 april 2013

Installing HTTP_Server with WebGate

Challenge

Installing an HTTP Server and configure it to be used as entry point for OAM.

Context

OAM 11.1.2 running on WLS 10.3.6.0

Solution

Installing the HTTP_Server
  • Unzipping the HTTP_Server software
    • cd /opt/install/oam
    • mkdir patch6
    • unzip WebTier_11Patch6.zip -d patch6
    • cp patch6/Disk1/stage/Response/WebTierInstallAndConfigure.rsp ./WebTierInstallAndConfigurePatch6.rsp
    • cp patch6/Disk1/stage/Response/staticports.ini .
    • mv staticports.ini webtier_staticport.ini
    • Adapt the WebTierInstallAndConfigurePatch6.rsp
      [ENGINE]
      
      #DO NOT CHANGE THIS.
      Response File Version=1.0.0.0.0
      
      [GENERIC]
      
      #Set this to true if you wish to specify a directory where latest updates are downloaded. This option would use the software updates from the specified directory
      SPECIFY_DOWNLOAD_LOCATION=false
      
      #
      SKIP_SOFTWARE_UPDATES=true
      
      #If the Software updates are already downloaded and available on your local system, then specify the path to the directory where these patches are available and set SPECIFY_DOWNLOAD_LOCATION to true
      SOFTWARE_UPDATES_DOWNLOAD_LOCATION=
      
      #Set this to true if installation and configuration need to be done, all other required variables need to be provided. Variable "INSTALL AND CONFIGURE LATER TYPE" must be set to false if this is set to true as the variables are mutually exclusive
      INSTALL AND CONFIGURE TYPE=true
      
      #Set this to true if only Software only installation need to be done. If this is set to true then variable "INSTALL AND CONFIGURE TYPE" must be set to false, since the variables are mutually exclusive.
      INSTALL AND CONFIGURE LATER TYPE=false
      
      #Provide the Oracle Home location. The Oracle Home directory name may only contain alphanumeric , hyphen (-) , dot (.) and underscore (_) characters, and it must begin with an alphanumeric character. The total length has to be less than or equal to 128 characters. The location has to be an empty directory or a valid WebTier Oracle Home.
      ORACLE_HOME=/u01/app/oam/product/webtier/OHS
      
      #Provide existing Middleware Home location.
      MIDDLEWARE_HOME=/u01/app/oam/product/webtier
      
      #The name of the Oracle Instance. Instance name must begin with an alphabetic character, may only contain alphanumeric characters, or the underscore (_) or hyphen (-) characters and are 4 to 30 characters long.
      INSTANCE_HOME=/u01/app/oam/product/webtier/instances/instance1
      
      #Provide the Oracle Instance location. The Oracle Instance directory name may only contain alphanumeric , hyphen (-) , dot (.) and underscore (_) characters, and it must begin with an alphanumeric character. The total length has to be less than or equal to 128 characters. The location has to be an empty or non existing directory.
      INSTANCE_NAME=instance1
      
      #If set to true, installer will auto assign ports
      AUTOMATIC_PORT_DETECT=false
      
      #This is required if "AUTOMATIC_PORT_DETECT" variable is set to false, absolute path of a staticports file location need to be provided with values for ports.\nThe template for staticports.ini can be found from Disk1/staget/Response directory of the shiphome.
      STATICPORT INI FILE LOCATION=/opt/install/oam/webtier_staticport.ini
      
      #Provide the My Oracle Support Username. If you wish to ignore Oracle Configuration Manager configuration provide empty string for user name.
      MYORACLESUPPORT_USERNAME=
      
      #Provide the My Oracle Support Password
      MYORACLESUPPORT_PASSWORD=
      
      #Set this to true if you wish to decline the security updates. Setting this to true and providing empty string for My Oracle Support username will ignore the Oracle Configuration Manager configuration
      DECLINE_SECURITY_UPDATES=true
      
      #Set this to true if My Oracle Support Password is specified
      SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
      
      #Provide the Proxy Host
      PROXY_HOST=
      
      #Provide the Proxy Port
      PROXY_PORT=
      
      #Provide the Proxy Username
      PROXY_USER=
      
      #Provide the Proxy Password
      PROXY_PWD=
      
      
      [SYSTEM]
      
      #Set true to configure Oracle HTTP Server, else skip Oracle HTTP Server configuration
      CONFIGURE_OHS=true
      
      #Set true to configure Oracle Web Cache, else skip Oracle Web Cache configuration
      CONFIGURE_WEBCACHE=false
      
      #The Oracle HTTP Server (OHS) component name (required only if CONFIGURE_OHS is set to true). OHS component name must begin with an alphabetic character, may only contain alphanumeric characters, or the underscore (_) or hyphen (-) characters and are 4 to 30 characters long.
      OHS_COMPONENT_NAME=ohs1
      
      #The Web Cache component name (required only if CONFIGURE_WEBCACHE is set to true). Web Cache component name must begin with an alphabetic character, may only contain alphanumeric characters, or the underscore (_) or hyphen (-) characters and are 4 to 30 characters long.
      WEBCACHE_COMPONENT_NAME=
      
      #Valid passwords are 5 to 30 characters long, must begin with an alphabetic character, use only alphanumeric, underscore (_), dollar ($) or pound (#) characters and include at least one number.
      WEBCACHE_ADMINISTRATOR_PASSWORD=
      
      #The confirmation password for Web Cache administrator.
      WEBCACHE_ADMINISTRATOR_PASSWORD_CONFIRM=
      
      
      [APPLICATIONS]
      
      
      [RELATIONSHIPS]
      
      #If set to true, the instance and components will be registered with an existing weblogic server
      ASSOCIATE_WEBTIER_WITH_DOMAIN=false
      
      #Provide an existing domain host name. Required only if ASSOCIATE_WEBTIER_WITH_DOMAIN is set to true
      DOMAIN_HOST_NAME=
      
      #Provide the existing domain port number. Required only if ASSOCIATE_WEBTIER_WITH_DOMAIN is set to true
      DOMAIN_PORT_NO=
      
      #Provide the domain user name. Required only if ASSOCIATE_WEBTIER_WITH_DOMAIN is set to true
      DOMAIN_USER_NAME=
      
      #The domain user password. Required only if ASSOCIATE_WEBTIER_WITH_DOMAIN is set to true
      DOMAIN_USER_PASSWORD=
      
    • Adapt the webtier_staticport.ini file
      #######################################################################################
      #This file is a template file for staticports.ini
      #This file must be edited to provide the ports which required to be set
      #Those ports which are not provided explicitly in this file will be assigned automatically
      #The ports should be specified as a single port
      #Keep in mind to uncomment the port no
      #######################################################################################
      
      ########################Begin section for OPMN Port No################################
      ######################################################################################
      
      [OPMN]
      
      #This port indicates the OPMN Local Port
      OPMN Local Port = 6700
      
      #This port indicates the OPMN Local Port
      OPMN Remote Port = 6701
      
      ########################Begin section for ohs component################################
      #This port nos will be considered only if OHS is selected for configuration
      #######################################################################################
      
      [OHS]
      
      #The http_main port for ohs component
      OHS Port = 8888
      
      #This port indicates the OHS Proxy Port
      OHS Proxy Port = 8889
      
      #This port indicates the OHS SSL Port
      OHS SSL Port = 4443
      
      ########################Begin section for Web Cache component################################
      #This port nos will be considered only if Web Cache is selected for configuration
      #######################################################################################
      
      [WEBCACHE]
      
      #The port indicates the Web Cache Listen Port
      #Web Cache Listen Port = 7777
      
      #The port indicates the Web Cache Admin Port
      #Web Cache Admin Port = 7778
      
      #The port indicates the Web Cache Statistics Port
      #Web Cache Statistics Port = 7779
      
      #The port indicates the Web Cache Invalidation Port
      #Web Cache Invalidation Port = 7780
      
      #The port indicates the Web Cache SSL Port
      #Web Cache SSL Port = 7781
      
    I
  • Installing the HTTP_Server software
    • patch6/Disk1/runInstaller -silent -responseFile /opt/install/oam/WebTierInstallAndConfigurePatch6.rsp
    • Result:
      Starting Oracle Universal Installer...
      Checking Temp space: must be greater than 400 MB.   Actual 2380 MB    Passed
      Checking swap space: must be greater than 500 MB.   Actual 16383 MB    Passed
      Preparing  to launch Oracle Universal Installer from  /tmp/OraInstall2013-02-28_10-04-05AM. Please wait ...[oam@oamhost  oam]$ Log:  /u01/app/oracle/product/oraInventory/logs/install2013-02-28_10-04-05AM.log
      Copyright (c) 1999, 2011, Oracle and/or its affiliates. All rights reserved.
      Reading response file..
      Expected  result: One of  oracle-6,oracle-5.6,enterprise-5.4,enterprise-4,enterprise-5,redhat-5.4,redhat-4,redhat-5,SuSE-10,SuSE-11
      Actual Result: redhat-Red
      Check complete. The overall result of this check is: Failed <<<<
      Problem: This Oracle software is not certified on the current operating system.
      Recommendation: Make sure you are installing the software on the correct platform.
      Warning: Check:CertifiedVersions failed.
      Expected result: 1024MB
      Actual Result: 15948MB
      Check complete. The overall result of this check is: Passed
      TotalMemory Check: Success.
      Expected result: LD_ASSUME_KERNEL environment variable should not be set in the environment.
      Actual Result: Variable Not set.
      Check complete. The overall result of this check is: Passed
      Check Env Variable Check: Success.
      Verifying data......
      Copying Files...
      -----------20%----------40%----------60%----------80%--------100%
      [oam@oamhost oam]$ [CONFIG] Launching Config Actions....
      Started Configuration:Web Tier Configuration
      [CONFIG]:Create and Start AS Instance (instance1)
      [CONFIG] [Web Tier Configuration] [Create and Start AS Instance (instance1)]:Creating Oracle Instance directories...
      [CONFIG] [Web Tier Configuration] [Create and Start AS Instance (instance1)]:Recording OPMN ports reservations...
      [CONFIG] [Web Tier Configuration] [Create and Start AS Instance (instance1)]:Bootstrapping OPMN configuration files...
      [CONFIG] [Web Tier Configuration] [Create and Start AS Instance (instance1)]:Instantiating opmnctl for direct usage...
      [CONFIG] [Web Tier Configuration] [Create and Start AS Instance (instance1)]:Skipping instance registration
      [CONFIG] SUCCESS:Create and Start AS Instance (instance1)
      [CONFIG]:Create and Start OHS Component (ohs1)
      [CONFIG] [Web Tier Configuration] [Create and Start OHS Component (ohs1)]:Creating empty component directories...
      [CONFIG] [Web Tier Configuration] [Create and Start OHS Component (ohs1)]:Provisioning OHS files for ohs1
      [CONFIG]  [Web Tier Configuration] [Create and Start OHS Component  (ohs1)]:Copying OHS files from ORACLE_HOME to ORACLE_INSTANCE locations
      [CONFIG] [Web Tier Configuration] [Create and Start OHS Component (ohs1)]:Customizing httpd.conf
      [CONFIG] [Web Tier Configuration] [Create and Start OHS Component (ohs1)]:Adding component's process control to OPMN...
      [CONFIG] [Web Tier Configuration] [Create and Start OHS Component (ohs1)]:Skipping ohs1 component registration.
      [CONFIG] [Web Tier Configuration] [Create and Start OHS Component (ohs1)]:Invoking opmn reload...
      [CONFIG] SUCCESS:Create and Start OHS Component (ohs1)
      Configuration:Web Tier Configuration completed successfully
      The installation of Oracle AS Common Toplevel Component, Oracle WebTier and Utilities CD completed successfully.
      
  • Testing the installation: ok
  • Creating start/stop scripts in the /home/oam directory
Installing the WebGate component
  • unzipping software
    • cd /opt/install/oam
    • mkdir webgates
    • unzip AccessManagerWebGates_111200.zip -d webgates
    • cd webgates/Disk1/stage/Response
    • cp WebgateSampleResponse.rsp ../../../../Webgate.rsp
    • Adapt Webgate.rsp
      [ENGINE]
      
      #DO NOT CHANGE THIS.
      Response File Version=1.0.0.0.0
      
      [GENERIC]
      
      #Provide the Oracle Home location. The location has to be the immediate child under the specified Middleware Home location. The Oracle Home directory name may only contain alphanumeric , hyphen (-) , dot (.) and underscore (_) characters, and it must begin with an alphanumeric character. The total length has to be less than or equal to 128 characters.
      ORACLE_HOME=/u01/app/oam/product/webtier/WebGate
      
      #Provide existing Middleware Home location.
      MIDDLEWARE_HOME=/u01/app/oam/product/webtier
      
      #Provide Location of GCC Library.
      GCC_LIBRARY_LOCATION=/usr/lib
      
      [SYSTEM]
      
      
      [APPLICATIONS]
      
      
      [RELATIONSHIPS]
  • Installing the webgate
    • webgates/Disk1/runInstaller -silent -responseFile /opt/install/oam/Webgate.rsp -jreLoc /u01/app/oam/product/jdk1.6.0_39/jre
    • Result
      Starting Oracle Universal Installer...
      Checking if CPU speed is above 300 MHz.    Actual 2933 MHz    Passed
      Checking Temp space: must be greater than 150 MB.   Actual 2380 MB    Passed
      Checking swap space: must be greater than 512 MB.   Actual 16383 MB    Passed
      Preparing  to launch Oracle Universal Installer from  /tmp/OraInstall2013-02-28_10-45-08AM. Please wait ...[oam@oamhost  oam]$ Log:  /u01/app/oracle/product/oraInventory/logs/install2013-02-28_10-45-08AM.log
      Copyright (c) 1999, 2012, Oracle and/or its affiliates. All rights reserved.
      Reading response file..
      Expected  result: One of  oracle-6,oracle-5.6,enterprise-5.4,enterprise-4,enterprise-5,redhat-6.1,redhat-6,redhat-5.4,redhat-4,redhat-5,SuSE-10,SuSE-11
      Actual Result: redhat-Red
      Check complete. The overall result of this check is: Failed <<<<
      Problem: This Oracle software is not certified on the current operating system.
      Recommendation: Make sure you are installing the software on the correct platform.
      Warning: Check:CertifiedVersions failed.
      Expected result: 1024MB
      Actual Result: 15948MB
      Check complete. The overall result of this check is: Passed
      TotalMemory Check: Success.
      Verifying data......
      Copying Files...
      -----------20%----------40%----------60%----------80%--------100%
      The installation of oracle.as.webgate.top completed successfully.
      
  • Performing post installation tasks
    • cd /u01/app/oam/product/webtier/WebGate/webgate/ohs/tools/deployWebGate/
    • ./deployWebGateInstance.sh -w /u01/app/oam/product/webtier/instances/instance1/config/OHS/ohs1 -oh /u01/app/oam/product/webtier/WebGate
      Copying files from WebGate Oracle Home to WebGate Instancedir
    • export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u01/app/oam/product/webtier/OHS/lib:/u01/app/oam/product/webtier/WebGate/webgate/ohs/lib
    • pwd
      /u01/app/oam/product/webtier/WebGate/webgate/ohs/tools/deployWebGate
    • cd ../setup/InstallTools/
    • ./EditHttpConf -w /u01/app/oam/product/webtier/instances/instance1/config/OHS/ohs1 -oh /u01/app/oam/product/webtier/WebGate -o webgate.conf
      The web server configuration file was successfully updated
      /u01/app/oam/product/webtier/instances/instance1/config/OHS/ohs1/httpd.conf has been backed up as /u01/app/oam/product/webtier/instances/instance1/config/OHS/ohs1/httpd.conf.ORIG
  • Registering the new webgate agent
    • Setting up the rreg tool
      • cd /u01/app/oam/product/middleware_home/OAM/oam/server/rreg/client
      • gunzip RREG.tar.gz
      • tar -xvf RREG.tar
      • cd rreg/bin
      • vi oamreg.sh   => setting the java_home directly
    • Updating the /u01/app/oam/product/middleware_home/OAM/oam/server/rreg/client/rreg/input/OAM11gRequest.xml File
      
      
      
      
      
      
          http://oamhost.contribute.be:7001
          RREG_HostId11G
          TestWebTier_WebGateAgent
          http://oamhost.contribute.be:8888
          false
          RREG_OAM11G
          false
          100000
          1800
          3600
          1
          24
          1
          -1
          60
          false
          open
          1
          false
          false
          false
          false
          no-cache
          no-cache
          0
          
             10.11.11.11
             10.11.11.12
             10.11.11.13
          
          
              /logout1.html
              /logout2.html
          
          /oam_logout_success
          end_url
          
      	/**
          
          
              /public/index.html
          
          
              /excluded/index.html
          
          
          
              
                  TestName
                  testValue1
                  testValue2
                  testValue3
              
          	
                  MaxPostDataLength
                  750000
              
          	
                  maxSessionTimeUnits
                  hours
              
              
                  RetainDownstreamPostData
                  false
              
              
                  useIISBuiltinAuthentication
                  false
                  
              
                  URLInUTF8Format
                  true
              
              
                  inactiveReconfigPeriod
                  10
              
              
                  WaitForFailover
                  -1
              
              
                  proxySSLHeaderVar
                  IS_SSL
              
              
                  client_request_retry_attempts
                  1
              
              
                  ContentLengthFor401Response
                  0
               
              
                  SUN61HttpProtocolVersion
                  1.0
               
              
                  impersonationCredentials
                  cred
              
              
                  UseWebGateExtForPassthrough
                  false
               
              
                  syncOperationMode
                  false
              
              
                  filterOAMAuthnCookie
                  true
                                              
          
      
      
      
      
    • ./oamreg.sh inband /u01/app/oam/product/middleware_home/OAM/oam/server/rreg/client/rreg/input/OAM11GRequest.xml
    • Result:
      JAVA_HOME=/u01/app/oam/product/jdk1.6.0_39
      CLASSPATH=./../lib/rreg.jar:./../lib:./../lib/RequestResponse.jar:./../lib/commons-codec-1.3.jar:./../lib/commons-httpclient-3.1.jar:./../lib/commons-logging-1.1.1.jar:./../lib/ojmisc.jar:./../lib/jps-api.jar:./../lib/jps-internal.jar:./../lib/jps-common.jar:./../lib/identitystore.jar:./../lib/identityutils.jar:./../lib/ldapjclnt11.jar:./../lib/dms.jar:./../lib/fmw_audit.jar:./../lib/ojdl.jar:./../lib/oraclepki.jar:./../lib/osdt_cert.jar:./../lib/osdt_core.jar:./../lib/osdt_jce.jar:./../lib/osdt_saml.jar:./../lib/osdt_xmlsec.jar:./../lib/xmlparserv2.jar:./../lib/jps-unsupported-api.jar:./../lib/nap-api.jar:./../lib/utilities.jar:./../lib/jps-ee.jar:.
      OAM_REG_HOME=./..
      ------------------------------------------------
      Welcome to OAM Remote Registration Tool!
      Parameters passed to the registration tool are: 
      Mode: inband
      Filename: /u01/app/oam/product/middleware_home/OAM/oam/server/rreg/client/rreg/input/OAM11GRequest.xml
      Enter admin username:weblogic
      Username: weblogic
      Enter admin password:         
      Do you want to enter a Webgate password?(y/n):
      y
      Enter webgate password:         
      Enter webgate password again:         
      Password accepted. Proceeding to register..
      Feb 28, 2013 1:56:35 PM oracle.security.am.engines.rreg.client.handlers.request.OAM11GRequestHandler getWebgatePassword
      INFO: Passwords matched and accepted.
      
      ----------------------------------------
      Request summary:
      OAM11G Agent Name:TestWebTier_WebGateAgent
      Base URL:http://oamhost.contribute.be:8888
      URL String:RREG_HostId11G
      Registering in Mode:inband
      Your registration request is being sent to the Admin server at:http://oamhost.contribute.be:7001
      ----------------------------------------
      
      Feb 28, 2013 1:56:39 PM oracle.security.jps.util.JpsUtil disableAudit
      INFO: JpsUtil: isAuditDisabled set to true
      Inband registration process completed successfully! Output artifacts are created in the output folder.
      
    • Copying the result to the instance directory of the webgate
      • cd /u01/app/oam/product/middleware_home/OAM/oam/server/rreg/client/rreg/output/TestWebTier_WebGateAgent
      • cp * /u01/app/oam/product/webtier/instances/instance1/config/OHS/ohs1/webgate/config/.
    • Starting the oam_server1
    • Restarting the webtier