Infrastructure at your Service

Category Archives: Application integration & Middleware

Gérard Wisson

Oracle Middleware, administration and monitoring: a day at the DOAG SIG Middleware

By | Application integration & Middleware | No Comments

I am in the train back to Basel (Switzerland) and I will try to summarize the day spent on a SIG Oracle Middleware of the DOAG (German Oracle User Group) session related to Oracle Middleware administration and monitoring. The different topics I saw were: WebLogic 11g clustering and high availability Overiew of the Cloud Control 12c (monitoring, automatization, quality management, cloud management Real User Experience Insight (RUEI): End-to-End User Monitoring and Java Diagnostic Administration and…

 
Read More
Hervé Schweitzer

Adding new tables to an existing Oracle GoldenGate replication

By | Application integration & Middleware | 12 Comments

Once a replication environment is set up, it’s rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation. This posting should help you with this task. In the example below, tables from schema G001 will be added to an existing replication setup from the database PROD1 to REP1. CFG_ADV_COND CFG_NARRATIVE_TEMPLATE CFG_REG_REPORT_RULES CMN_LOOKUP CMN_USER_LOGIN   Stop the replication environment Connect to the source database PROD1 and…

 
Read More
Gérard Wisson

Connecting to the WebLogic Node Manager using WLST in a Production domain

By | Application integration & Middleware | No Comments

In a WebLogic server domain set as a Production domain, when we try to connect to the Node Manager with WLST we get the following error: Cannot connect to Node Manager. : Access to domain ‘testcluster’ for user ‘weblogic’ denied This blog gives the solution to solve the issue. First of all, we observe that the Node Manager is working fine because it is accessible with the WLS admin console and the managed servers can…

 
Read More
Yann Neuhaus

SQL Server: Attunity connectors for data transfer to Oracle

By | Application integration & Middleware | 2 Comments

Recently, at a customer site, I discovered the Attunity connector 1.1 for Oracle. The customer uses this connector to transfer data from Oracle to SQL Server using Integration Services (SSIS) and informed me that performances are greatly improved. So I decided to post a blog about this connector and perform a benchmark between Attunity connector and Microsoft OLE DB provider for Oracle.

 
Read More
Arnaud Berbier

Upgrading your Oracle Internet Application Server license

By | Application integration & Middleware | No Comments

With the appearance of WebLogic Server as Oracle application server and the emergence of the Oracle Fusion Middleware suite, some may wonder what will be the support of their Oracle Internet Application server license, e. g. Oracle Forms and Reports services, Business Intelligence Edition, etc. As a consultant, I am often dealing with these kinds of problems and aiming to improve license benefits. In this post, I want to focus on Oracle Internet Application server licenses.

 
Read More
Grégory Steulet

Oracle Application Express (APEX) 4.1: a migration guide

By | Application integration & Middleware | 5 Comments

 

Oracle Application Express – APEX 4.1 Introduces many new features such as :

  • Improved error handling and user-defined exception processing

  • Application Express now supports the use of ROWID for updates, inserts and deletes as an alternative to specifying primary keys

  • Developers can now easily add the capability for end-users to load spreadsheet data into existing tables within an application

  • The calendar wizards have been enhanced to include the ability to create an Edit page as part of creating the calendar

  • Building on their initial introduction in Release 4.0, the look and feel of Websheets in Release 4.1 has been substantially improved and the controls redesigned to make it more intuitive for users

A complete list of APEX new features can be found on: http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-41-new-features-459652.html

 
Read More
Arnaud Berbier

Oracle WebLogic Essentials : avantages du clustering

By | Application integration & Middleware | 4 Comments

J’ai eu le plaisir de suivre une formation chez Oracle University à Colombes (Paris). En tant que stagiaire, le cours s’intitulait Oracle Weblogic Administration Essential. Ce post traite de la notion de cluster Weblogic. J’y expose les avantages du clustering weblogic, les principaux éléments à connaître ainsi qu’un exemple de configuration via la console d’administration.

 
Read More