Sunday, October 11, 2015

Copy and Paste

I bounced into a funny thing when I setup a Data Guard Physical Standby Database.

First I prepared some database init parameters in a document (actually I reused some old documentation I had done in a previous project).


The "alter system ..." command worked like a charm.

During the preparations I needed to restart the database instance. To my surprise I received an error that there was an issue with an init parameter.

ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed

Google did not really help me. So I decided to create a pfile from the spfile and had a look into it.

There it became evident what the error was. Somehow during the copy & paste the end-of-lines were copied as well - leaving my init parameter with some newlines in it.
Made one line from it in the pfile, started the db and created a new spfile. Now it worked like a charm.

Wednesday, May 20, 2015

Strange data in Fusion Middleware Console regarding OHS

I have an OHS cluster in my environment. Due to a change I needed to bounce the servers one by one.

As this is a production environment I wanted to make sure that everything is working - so I decided to restart them one after another.

I was then looking at the performance page of the OHS and saw the following:

However in the Home section of the OHS the processes came back after a couple of minutes:

Obviously everything was running o the first host. The access_log showed the typical requests.

So I decided to restart the second server as well (proceed - fingers crossed).

When I evr find out what caused this I will update this posting.

Friday, March 13, 2015

Oracle Streams Explorer

At the recent Oracle SOA Suite community forum in Budapest I had a hands-on experience with the Oracle Streams Explorer. Having worked with the Oracle Complex Event Processing and also some hands-on exercises with the new
Oracle Event Processing, the Oracle Streams Explorer is a very easy to handle and useful addition to the area of near-real-time data insight and analysis.

The user interface comes along in the new Oracle look-and-feel. You can select a number of areas like IOT, Risk and Fraud Management, Transportation and Logistics, Customer Experience and Analysis and Telecommunications.
Within that you get a number of predefined patterns and resources. Defining your own solution can therefore be based on an existing solution in your catalog or simply by combining input streams and defining filters on them.

Now plenty of examples can (and will) be named.

The essence for me - and this is a message that I will convey to customers - is the fact that by using Oracle Streams Explorer you can get a very tangible feeling of SOA environments.
A lot of data comes along, and you might want to be alerted when a certain event occurs. For example a RFID tag of a valuable item leaving the warehouse is something you want to know right away.
Put this into an HTTP Publisher or call a REST service that in effect sends out a notification to your smartphone will be a nice goodie for any logistics company. The beauty of the Oracle Streams Explorer
is the ease with which you can build such an application.

Now I need to find more time to build such an example and document it.

Friday, October 24, 2014

I should play more lotto

Just my luck: Friday afternoon and I hit an error in the Oracle VM.
OVMRU_001020E does not show on Google or inside Oracle Support ;-)

Am I really the first to hit that problem? Seems to be an issue with the network cards in my virtual machine. I guess I will do some more reading before I can continue installing my virtual machines.

Solved it. In the view I went to the Network Ports and selected additional ports, added them to the machine and off we go.

Wednesday, October 22, 2014

A call to flushChanges on the current MDSSession does not specify the correct transaction key

Interesting issue in a SOA/BPM today.
Redeployment of the application (SOA) and restart went through without an issue.

However the stresstest came back almost immediately. The AdminServer.out showed the error "A call to flushChanges on the current MDSSession does not specify the correct transaction key". Even more astonishing was the error TNS-12516 when trying to connect to the database.

After a little bit of searching we found that the database alert log said it could not extend the SOA_INFRA tablespace.

Adapted this and everything went back to normal.

Sunday, October 05, 2014

OVMAPI_4010e during server discovery

I bounced into the problem of getting the dreaded OVMAPI_4010e error when I was discovering the Oracle VM server in my network. Metalink (MyOracleSupport for the younger ones) told me that this was typically an issue with the password of the OVM Agent.

One obscure internet blog told me however that this was due to the difference in versions. Now - it beats me how the connection information and credentials are passed differently when a new version arrives, but eventually I placed the same version of the OVM Manager as the OVM Server on my Virualbox image and it works.

OVM's strange architecture

Obviously I do not run a major Oracle-based OVM data center. So for real-life large enterprises this is not an issue.

However image the following: you have a machine on which you want to run Oracle VM Server.
Installation of the OVM is straightforward and pretty easy.

Now you end up with a piece of equipment that does exactly NOTHING.

Nothing? Yup. Well you can start it and you get a Linux prompt, and that is pretty much it.

In comes the Oracle VM Manager. It dances, it talks, it does the wash and it walks the dog - and it can be yours for 99.99$ ;-)

Seriously, in order to get anything useful to be done with the OVM Server you need the manager. Now there is a small design flaw. Setting up the OVM Manager requires an extra machine. This can be a Virtualbox image, another machine in your network or even a guest on your Oracle VM Server.

Now the last seems to be appealing. Normally in such an environment I would like to have the controlling software on the box that I control (with the option to move it elsewhere when I grow and buy  a second box).

Unfortunately before you can place an image on the OVM Server you need to configure it - meaning you install the OVM Manager on a different platform.

Seem awkward. How about an installation option that would create the Dom0 on the (first) OVM Server and that would bring a OVM Manager with it? It is not there. Pity!

So I downloaded a Virtualbox template with the OVM Manager.

This did not work. The internet told me that this was due to a mismatch of the passwords of the OVM Agent. Changed the password - no success.

Now I am in the process to create my own Virtualbox image with OEL6 and install an OVM Manager 3.3.1.

Let's see how this works out.

UPDATE: It seems to work now (see also next post).

Saturday, October 04, 2014

A cable - a kingdom for a cable. Can you already see something?

Ok - when you do things the first time you make mistakes.

This was my first server I've ever build from scratch. I fiddled around with some equipment before, but buying a number of components and installing them was new for me.

Now the motherboard I have does have no video card as the folks who typically buy these extreme motherboards do bring their own video cards with them to render the monsters they are about to slay.
With me things were not so bright. Although I also bought a nice 24' screen I was still seeing nothing - basically because there was nothing to plug it in to the server.
Well - another trip to the store to buy a simple video card.

I did however initially bought a wireless card for the machine as I intend to place the machine in my study room. Historically this is where my DSL connection ended, so there was always a router with a cable present.

To my surprise I could not install the Oracle VM Server without a network. Obviously this makes sense when you are using this product in a data center which does not use WiFi a lot but all shades and colors of cable.

I investigated the issue and found that the machine was perfectly aware of its network sockets (two of them) and the WiFi card was detected as well. The issue at hand was the fact that the Oracle VM Server kernel was not equipped with the modules to support the ath9k which is the Linux wireless support for these kinds of cards.

Briefly I thought about baking my new Oracle VM kernel. I have done so in the past, so I knew what it would take to do so. I did some checks and found out that I would need to install a gazillion pieces of software to be able to build a new kernel.

I quickly abandoned the idea and now settled for the idea that I will have Ubuntu system running on the Oracle VM and use this as a stepping stone to connect to the WiFi.

Still not there. See the next post.

My endeavour with Oracle VM

So - I bought a decently sized system to have my own private cloud on it. The main motivation was the fact that currently it has become pretty difficult to run some Oracle software on your laptop.

Although a number of people do this you quickly realize that they just have a simple database installation on it or a plain WebLogic Server.

While this is satisfactory for a number of purposes it doesn't come near the things that I encounter in my day to day life. My customers typically have HA or even MAA environments, using RAC and some of the newest Fusion Middleware components.

When you simply want to re-enact an environment of that size your laptop will not be sufficient.

So - this journey is about the setup and "cloudy" ideas I have.

So what I have now is a system that offers me a good CPU, 64 GB of memory (probably the most expensive part nowadays) and 3 TB disk plus 512 SSD. All in all it cost me around 1800 Euro's. And as it was bought by my company the Dutch minister of finance is (hopefully) happily supporting my with this.

Let's see where this ends up.