Implementing ORAchk in Oracle Enterprise Manager 13c

By | February 3rd, 2016|Categories: Database, Meta-DBA|Tags: , |

Heard about it at Oracle OpenWorld 2015: A new feature in Oracle Enterprise Manager 13c is the possibility to incorporate ORAchk, the healthcheck tool for databases, RAC and Engineered Systems.

This post is about downloading (and importing), deploying and provisioning the ORAchk-plugin. Spoiler-alert: there’s downtime involved of the OMS.

There are two ways for downloading and deploying : offline-patching and on-line, which means whether OEM is connected to My Oracle Support or not. In this post I will describe both methods ( every method by the way with varying success). And of course you can choose between using the command-line EMCLI and the graphical user interface. It’s Enterprise Manager, so mainly using the gui, but sometimes  forced to use the command-line.

[…]

Oracle OpenWorld 2015 – a customer’s perspective

By | February 2nd, 2016|Categories: Architecture, Database|Tags: , , |

At the start of the each year, I always take the time to look back on the year we left behind. Last year, one of my most memorable experiences was Oracle OpenWorld in San Francisco. The event has always been an overwhelming experience, but this year it seemed even more so. I have never experienced such an amount of announcements and innovations, varying in importance and readiness, and all more or less related to the cloud.

A massive technology push to the cloud, a ‘cloud overload’. That could be the management summary of Oracle Open World 2015 (OOW15).

Oracle as software vendor is evolving to a cloud service provider. The force is strong….

[…]

Oracle licenses and the cloud

By | March 15th, 2015|Categories: Database, licensing|Tags: , , , , , |

Suppose the number of Oracle licenses you acquired in the past, is in line with the use. That is, you’re compliant with all the licensing rules Oracle come up with. The  license form you use is the so called ‘Full use’ license, this is the most common license form. Everybody happy. But will this change when moving servers, databases or middleware  to the public cloud?

Well , ‘It depends…’ :

1. Is the chosen cloud provider an ‘authorized cloud’ by Oracle

2. Are you going to use your own licenses (BYOL = ‘Bring Your Own License’) or is this included in the cloud solution

3. Is the use of the software the same as it ever was

I’ll try to explain this in chapters below.

[…]

My project with Dbvisit Standby – basics

By | March 31st, 2013|Categories: Database, Standby|Tags: , , , |

A while ago I made a promise to take a look at the product Dbvisit, found out this is not the product, but just the firm Dbvisit. The product I’m about to install is called officially ‘Dbvisit Standby‘. There’s also a product called ‘Dbvisit replicate’.
I didn’t really know about the product, not related to it, but it was buzzing around that it’s a cheap and a well working alternative for a high available environment with Oracle Standard Edition in stead of the Enterprise Edition with Data Guard.
So my first project (this post) is just to install a lab environment and get it working. The second project should be the real thing, testing the availability and the easiness of administration and monitoring.

What will I do for this part of the project (working from scratch with the latest versions – at the time of writing – of Oracle Linux and VirtualBox…):

1. Create two VM’s (VirtualBox with Oracle Linux 6)
2. Install Dbvisit Standby
3. Configure Dbvisit Standby
4. Get it going!

And not surprisingly, the preparation took most of the time:

[…]

ODA – a brief view on a virtualized platform

By | February 8th, 2013|Categories: Database|Tags: , , |

Received a pdf from Oracle with the new features of the Oracle Database Appliance (when you are using the OracleVM-option).

Among other things, the two last sheets about the licensing had my attention too. I’m just showing the slides, haven’t worked with it, so I can’t tell you in detail the experiences. But the slides may give you an idea how the Virtualized Platform will look like in the new ODA, and how it will be licensed.

 

ODA_how_VM

 

 

 

 

 

 

 

 

 

 

 

 

[…]

How many NUP’s you really need when using Oracle Database ?

By | December 14th, 2012|Categories: licensing|Tags: , |

Something about licensing. Boring for the most of us, but this may save you a lot of money…. The next is not completely new, but I never had it on writing, so found it worthfull to blog.  The following has by the way no legal status and I’m not held responsible for any claims Oracle might want to put on your company (that is, can’t afford a lawyer..)

Maybe you know the rule: When using Oracle Enterprise Edition database, and want to license by NUP’s – Named User Plus Licenses – you are bound to a minimum of 25 users per Oracle-defined processor. So using a server with one Intel-based quad-core processor (with a factor of 0,5), you have to pay for (4 * 0,5 =) 2 Oracle processors, which is equal to a minimum of 50 users.

This has  been defined in the Software Investment Guide (page 14):

Minimums for this metric may be discrete quantities, or they may be based on the number of processors in the machine on which the software will be installed and/or run. For example, the minimum for the Database Enterprise Edition, the iAS Standard Edition and the iAS Enterprise Edition is 25, 10 and 10 Named Users Plus per Processor, respectively

Let’s stick for a moment on the Enterprise Edition of the database, and the example above. When a second server (1 quad core) is added, also with an Enterprise Edition database on it you’ll have to pay for a total of 100 NUP’s.

But what if I only have got 60 users (non human operating device included) who are directly or indirectly authorized to use those two databases / nodes. Will I pay for 60 users or 100 ? To be sure I asked this question to my contact at LMS (License Management Service at Oracle).

[…]

Oracle and RHEL 6 certification

By | March 30th, 2012|Categories: Database|Tags: , , |

Waited for a long time now, but here it is, copied it from the official press release. It’s a bit pity of the 90 days in the second bullet, but in the meantime it is certified all the way and it is reflected in the certification […]

Param ‘_datafile_write_errors_crash_instance’ , TRUE or FALSE?

By | August 26th, 2011|Categories: Database, RAC|Tags: , , |

Since 11.2.0.2 there's a new parameter, "_datafile_write_errors_crash_instance" to prevent the intance to crash when a write error on a datafile occurs. But.. should I use this or not.

Restoring OCR on 11.2.0.2-cluster

By | May 15th, 2011|Categories: Database, RAC|Tags: , , |

As the documentation about restoring an OCR did not work as it should be, hereby a method to do this.

Just another RMAN backup-script for Windows

By | May 16th, 2010|Categories: Database, RMAN|Tags: , |

I was asked to deliver a backup-script for a windows-database. However I'm not a o.s.-scripting guru at all and certainly not on Windows, I came to the following script. It looks a lot like the one I use on Linux, just translated it into a .cmd-file. The challenge was to get it in one-command file.