Urs Meier - Blog on IT

Service wlansvc failed to start

Urs Meier - Blog on IT — Fri, 03 Oct 2008 15:40:00 GMT

Trying to install my mobile card on a new Windows Server 2008 ended with the message "service wlansvc failed to start. Check if you have the privilege...". The point is, that the service was not installed. Solution: Administrative Tools >...(read more)

Using Oracle 11g client result_cache with ODP.NET

Urs Meier - Blog on IT — Thu, 24 Apr 2008 12:10:00 GMT

With Oracle 11g OCI clients can store result sets on the client. I was wondering how ODP.NET will use this feature and if there are any coding constraints. Required setup: The feature must be enabled server side by setting the init.ora parameter client_result_cache_size...(read more)

Oracle Query Notification revisited

Urs Meier - Blog on IT — Wed, 23 Apr 2008 09:27:00 GMT

A few month ago I compared the .NET query notification possibilites between SQL Server and Oracle. At that time Oracle could only dectect changes at table level; not at row level. With the new release of ODP.NET 11.1 and Oracle 11g Oracle enhances the...(read more)

HA Events vs. TAF with RAC and ODP.NET

Urs Meier - Blog on IT — Wed, 05 Dec 2007 18:31:00 GMT

Lately I had a question in this Blog about an ORA-25408. My first thought was, that TAF and HA events should not be mixed. In order to confirm this, I wrote a small application with 3 connection possibilites 1. Normal connection 2. TAF connection with...(read more)

Bulk Copy with SQL Server

Urs Meier - Blog on IT — Mon, 19 Nov 2007 11:26:00 GMT

SQL Server also offers an "array insert" possibility via .NET, which is called bulk copy . I wrote a similiar application as with the Oracle ODP.NET array insert. The point was not to compare Oracle vs. SQL Server, but to verify if the bulk...(read more)

Array Insert with ODP.NET

Urs Meier - Blog on IT — Sun, 18 Nov 2007 16:39:00 GMT

ODP.NET supports array insert in two ways: 1. Binding arrays using ArrayBindCount cmd.Parameters.Add("firstname", OracleDbType.Varchar2, firstNames, ParameterDirection.Input); where firstNames is string[] 2. Binding to PL/SQL associative Arrays...(read more)

Barrier free web design

Urs Meier - Blog on IT — Wed, 22 Aug 2007 16:21:00 GMT

Excellent presentation, but in German, about barrier free Web Design. Direct Google-Link Weiter lesen......(read more)

RAC FAN and FCF

Urs Meier - Blog on IT — Tue, 15 May 2007 17:59:00 GMT

After the successfull RLB tests with RAC FAN events we re-tested the FCF with both Java and ODP.NET Startup As soon as the DBA puts an additional instance into a RAC service the client receives a FAN / FCF event. Both Java and .NET use the additional...(read more)

More on RAC and RLB

Urs Meier - Blog on IT — Tue, 15 May 2007 17:32:00 GMT

My last RAC tests with runtime load balancing and .NET were not successful. ODP.NET always distributed the workload in a round robin manner. Now I know why: It is a AQ bug. I had more than one IP address defined (my real one and one for my vmWare). Since...(read more)

Linked Server Performance

Urs Meier - Blog on IT — Wed, 07 Mar 2007 15:23:00 GMT

Stefan Frutiger from Trivadis has extended my performance tests with linked server between SQL Server 2005 and Oracle 10g. First the hardware setup was enhanced: - 2 IBM laptops (T41 and T42) with W2003 and 1GB RAM - crossed cable as dedicated network...(read more)

Linked Server to Oracle

Urs Meier - Blog on IT — Sun, 24 Dec 2006 14:42:00 GMT

Because of some performance problems with Linked Severs between SQL Server and Oracle, I did some additional tests. I tested Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer...(read more)

Refactoring Databases

Urs Meier - Blog on IT — Sat, 21 Oct 2006 14:35:00 GMT

" Refactoring Databases" is a new book from Scott W. Ambler and Pramod J. Sadalage . They basically promote the agile development principles of software development into databases. The difficulty with databases is the fact, that we must manage...(read more)

citizendium

Urs Meier - Blog on IT — Wed, 18 Oct 2006 10:19:00 GMT

The "better" wikipedia starts under citizendium . I really admire and support people who are willing to put so much effort into public know-how or software, such as open source. But as as user of these open products, it is hard to understand...(read more)

Agile Software Development

Urs Meier - Blog on IT — Thu, 05 Oct 2006 16:41:00 GMT

Agile Development puts people over processes. In my opinion this is a good trend, even though not completely new. Lately I was reading a very interesting blog about Agile Software Development at Google . I agree with the comments of many readers: Steve...(read more)

CLB_GOAL LONG or SHORT?

Urs Meier - Blog on IT — Wed, 04 Oct 2006 07:39:00 GMT

With Oracle 10g R2 FAN and FCF we can load balance connections and requests over a "service". The service is defined to be run on one or more instances on the RAC. Services take a CLB_GOAL LONG or SHORT and are created with DBMS_SERVICE.CREATE_SERVICE...(read more)