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).

log_archive_dest_1
location=use_db_recovery_file_dest
valid_for=(all_logfiles,all_roles)
db_unique_name=osbsoadb

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.