Infrastructure at your Service

Gérard Wisson

WebLogic: Using a WLST script to find a specific word in an object

By | Application integration & Middleware | No Comments
 

 On a WebLogic Server, I had to write a WLST script to find the current number of consumers accessing a specific JMS Queue destination as this is not monitored by Oracle Grid Control 11g or Oracle Cloud Control 12c. Knowing only the short name of the queue, I uses a regular expression in my WLST script to find the needed information. To find the correct queue destination I had to search the Queue Destination Name….

Read More
Stéphane Haby

SQL Server 2012: CompoundCurve – a new geospatial feature

By | Database management | No Comments
 

  There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun and as an example, I will test CompoundCurve, a set of circular strings that may be combined with line strings, and store a “dbi” character set in a table.:-D What is CompoundCurve? It’s a set of circular strings, or circular strings combined with line strings, that form a desired curved shape. The end point of each…

Read More
Michael Schwalm

Processor licensing for Oracle database on VMware ESX

By | Hardware & Storage | 2 Comments
 

 In this post, I would like to share with you what I have learned about Oracle licensing particularities on a virtualization infrastructure (software partitioning) based on VMware ESX. Recently, I faced an Oracle licensing problem on a VMware ESX cluster on which I had to find a workaround in order to make the hardware comply with the customer’s licensing model. Without entering in details, the customer had a VMware cluster with three nodes and had…

Read More
Stéphane Savorgnano

Monitoring SQL Server with Oracle OEM Grid Control 11g

By | Database management | One Comment
 

 Recently, I had the chance to install the SQL Server Plug-in for Oracle Entreprise Management Grid Control 11g to monitor a SQL Server instance based on a windows host. Our client, who monitors these Oracle databases via OEM Grid Control 11g, wanted to use the same tool to also monitor SQL Server databases. In this blog posting, I will describe how to install the 11g agent on a Windows host and how to import as…

Read More
Michael Schwalm

Oracle RAC 11.2.0.2: A disturbing loop in a “ohasd” startup script

By | Operation systems | No Comments
 

 Last February, I performed an operating system rolling upgrade on a four-nodes RAC cluster (11.2.0.2). I then faced a strange problem when restarting the operating system… The first step of the procedure was to stop all Grid Infrastructure and Database services running on the first node as well as to disable Cluster and ASM autostart. The following command is supposed to prevent Oracle High Availability Service (OHAS) to be run at operating system startup: #…

Read More
Stephane Biehler

OpenERP release 7.0: Not just an update

By | Technology Survey | No Comments
 

  OpenERP release 7.0, which just came out, shows some real advantages in terms of accessibility. By refining the website, OpenERP wants to prove that the new release is not merely an update but a new product with a new mind-set. The new features Indeed, the ERP’s web interface is now purified and simplified to match the fashions. Today’s user interfaces are intended to be as simple and as designed as possible. The new web…

Read More
Middleware Team

Boot sequence for all Linux-based operating systems

By | Operation systems | No Comments
 

  In this bog posting, I will present a boot sequence that works for all Linux-based operating systems – from switching on the power to the login screen.   7 steps There are 7 steps for Linux startup: Power on Obviously, first of all, you have to switch on your computer, then: Each sub process will execute the following one It is the same process for all Linux distributions Close to BSD and Unix style…

Read More
Yann Neuhaus

Frankfurter Datenbanktage: Andrea Held im Gespräch mit Yann Neuhaus, dbi services

By | Technology Survey | No Comments
 

 Vor einigen Wochen hatte ich im Rahmen der Frankfurter Datenbanktage Gelegenheit zu einem Interview mit Andrea Held, der fachlichen Leiterin des Events und Geschäftsführerin der Firma Held Informatik. Das Ergebnis des Gesprächs ist dieses Video, in dem Sie mehr über dbi services, das schnelle Wachstum unserer jungen Firma und unser Dienstleistungsportfolio erfahren. Gucken Sie doch mal rein, falls Sie wissen wollen, wie dbi services “tickt” :roll:. Nochmals vielen Dank an Andrea Held für das interessante…

Read More
Michael Schwalm

Scripts to duplicate an Oracle database virtual machine: step two

By | Hardware & Storage | No Comments
 

 In January, I promised to show you the next step of a procedure to manage templates with Virtual Box. Don’t worry, I have not forgotten but I was very busy! This step, the final one, consists on customizing of a virtual machine configuration at the start. VMware does it with Templates on ESX, using for example Sysprep for MS Windows guests. I am going to show you how to do it with one simple text file….

Read More
Stéphane Savorgnano

SQL Server 2012: Create & replay a trace with Distributed Replay

By | Database management | One Comment
 

  My last blog was about installing and configuring Microsoft SQL Server 2012 Distributed Replay. This time, I will show you how you can create a trace and replay it with Distributed Replay Clients on a specific SQL Server target. This is my Distributed Replay configuration:   Creation of the trace I will use the two Distributed Replay clients to generate a workload against the target server with two PowerShell Windows which will execute diverse…

Read More
Stéphane Savorgnano

SQL Server 2012 SP 1: Third Cumulative Update (CU3) available

By | Technology Survey | No Comments
 

  Three weeks ago, Microsoft published the third Cumulative Update (CU3) for Microsoft SQL Server 2012 Service Pack one. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it. Which issues are covered by this CU3? It contains 38 Hotfixes: 27 for the Engine 8 for SSAS 3 for SSRS To have more details or information about these hotfixes, click here. Historic of SQL Server…

Read More
Michael Schwalm

Oracle Database Appliance: new ODA X3-2 architecture

By | Operation systems | No Comments
 

  A few weeks ago, I posted an article about Oracle Database Appliance, focusing on ODA version 2.5.0.0.0. However, a new update of ODA, version 2.5.5.0.0, was released by Oracle on 5 March. This posting will focus on the new ODA release, which leads to a new hardware architecture. So, what’s new with this new ODA version? According to the Release Notes, ODA now supports the new X3-2 architecture which allows additional hardware and storage capabilities….

Read More