OBIEE 11.1.1.7.0 Certified with Database 12c

Couple of updates in the world of Oracle, both related. The first is that the Oracle Database 12c is now generally available and can be downloaded from the Oracle Technology Network here (subject to the OTN Developer License Terms). Three platforms are supported - Linux x86-64, Solaris Sparc64, and (more...)

Oracle database 12c

So there is a new toy in the market for database geeks : Oracle has released database 12c. Every social platform is abuzz with the 12c activity. So thought that I should also complete the ritual Winking smile

In this post Aman has already summed up many important links.

Maria Colgan has (more...)

Required Reading

It's not often that I run across articles that really resonate with me. Last night was one of those rare occasions. What follows is a sampling of what I consider to be required reading for any IT professional with a slant towards database development.

Bad CaRMa

Oracle Database Gateways 11g R2 (11.2) Installation and Configuration for heterogeneous connection from Oracle to Microsoft SQL database

Installation

Install the Oracle Database Gateways 11g R2 (11.2). See the screen snapshots of the installation here.

Configuration

  • During the installation, the following default initialization parameter file is created:
[ORACLE_DG_HOME]\dg4msql\admin\initdg4msql.ora
dg4msql = Database gateway for Microsoft SQL Server. 
If you choose a different database option,  (more...)

When to consider sharding a MySQL database

Uncategorized
| Mar 13, 2013

When to consider sharding a MySQL database

 

Why should you not just design your applications from the start to account for data sharding? Sharding a database, that is horizontally partitioning tables among multiple databases, creates an added level of complexity that is not desirable in an application. However, there are times when sharding is required to maintain acceptable performance. So when is the right time to shard your database?

 

When to consider sharding a MySQL database   Why should you not just design your applications from the start to account for data sharding? Sharding a database, that is horizontally partitioning tables among multiple databases, creates an added level of complexity that is not desirable in an application. However, there are times when sharding is […]

-->

Schema and User 101

Uncategorized
| Jan 22, 2013

Schemas and users are frequently used interchangeably as if they were the same thing. For the most part, that's ok. In Oracle the concepts are so tightly coupled that thinking of them as the same thing is not really that far wrong. 


In reality, a user is a database account that is given a password and permissions. A schema is a container, or namespace, for containing schema objects. Schema objects are things like tables, views and indexes.


In Oracle, when a us

How long did Oracle materialized view refresh run?

The LAST_REFRESH_DATE column of the DBA_MVIEWS or the LAST_REFRESH column of the DBA_MVIEW_REFRESH_TIMES indicates the start refresh time. But what if we’d like to find out how long the refresh of the materialized view really takes. Well, we can query the DBA_MVIEW_ANALYSIS.

For Complete Refresh, the refresh duration will be in the FULLREFRESHTIM column of the DBA_MVIEW_ANALYSIS. For Fast Refresh duration, it will be in the INCREFRESHTIM column.

Both values are in seconds.

SELECT mview_name, last_refresh_date, fullrefreshtim, increfreshtim
FROM dba_mview_analysis
WHERE owner='JOHN';

MVIEW_NAME               LAST_REFRESH_DATE      FULLREFRESHTIM INCREFRESHTIM
------------------------ ---------------------- -------------- -------------
MV_CHANGE_HISTORY        07-JAN-13 04.36.58 PM               0             (more...)

Reinstalling an Oracle Database Appliance Part 3

An Oracle Database appliance is a set of standard hardware and software molded together to created a 2 node RAC cluster that is easy to deploy. In parts 1 & 2 i talked about what methods you can use to reformat or erase the Oracle Database Appliance and rebuild it. (more...)

Restoring a Database with Rman Controlfile Parameters

There are occasions when you recieve a complete backup of a database from a  place different then yours and have to do a restore. normally a restore is simple . put the files in a directory run rman catalog on them and you are done. but what if you have rman (more...)

Oracle Throws in the Towel on VMware Licensing – Reprise

Given the incredible number of comments I received on my last blog post, and the content of those comments, it is very obvious that folks are extremely confused by what I meant by that post, as well as the comments by Mr. Garsthagen (Oracle Director Level Employee), referenced in that post.

The confusion is typified by the following comment, the most recent I have received:

Oracle does not recognize either (Vmware/DRS Affinity) as a hard partition

First, to be completely clear, I have never stated, nor do I believe, that VMware (or any other software hypervisor for that matter) (more...)

Oracle Throws in the Towel on VMware Licensing

As all of my readers know, I have been a strong proponent of VMware virtualization of Oracle Database servers for license cost savings purposes. Predictably, Oracle has pushed back on this issue in the past. Well, they have now thrown in the towel.

In an online video, Richard Garsthagen, Director of Cloud Business Development EMEA for Oracle, has stated publicly that VMware host affinity rules (when combined with vMotion logging) work just fine, thank you very much, for purposes of establishing where Oracle software is "installed and/or running" for purposes of the Oracle Software License Agreement (OSLA).

Previously, (more...)

Oracle Database 12c – New Feature: Identity Columns


Well, Oracle Database 12c is not yet available but new features seems to be popping out in MOS. While troubleshooting Oracle Enterprise Manager Cloud Control 12c startup issues I came across Oracle Database 12c new feature called “Identity Columns”.

An Identity Columns is auto-incremented at the time of insertion just like in SQL Server. Going forward, I think you will not use Oracle Sequence anymore to generate unique values instead use Identity Columns.

For more information on this read:



Happy reading!!!

VMware: Maritz out, Gelsinger in. What does it mean for Oracle?

As many of you have heard by now, Paul Mauritz is out as CEO of VMware, and Pat Gelsinger (formerly COO of EMC, reporting directly to Joe Tucci) is replacing him.

The relevant question for those of us who care passionately about Oracle virtualization using VMware vSphere is:

What does this mean for VMware's BCA (Business Critical Applications: stuff like Oracle) strategy (which under Maritz was somewhat lacking)?

In my view, this is very, very good news indeed. The reason is simple: Paul Maritz was former Microsoft, and thus very Microsoft-centric. Under Maritz, VMware very successfully penetrated the Microsoft (more...)

Comments by Dave Welch of House of Brick on Oracle on VMware Licensing

I thought it worth republishing Dave Welch's (of House of Brick) comments to my discussion on the Everything Oracle at EMC online community on the subject of Oracle licensing costs on VMware vSphere configurations. Here are Dave's comments:

All,

Let me start by bringing all of you into the courtroom. There are three issues that you will observe me as counsel provide to the jury as part of my allowed instruction (I am not an attorney in real life).

I offer the definitions in this paragraph only to make this post as self-sufficient as possible and not with intent (more...)

VMware’s Official Support Statement Regarding Oracle Certification and Licensing

Stake in the Ground

VMware has put a stake in the ground with respect to Oracle licensing of VMware VMs running Oracle. The gist of this statement regarding certification, support, and licensing is that DRS host affinity rules, combined with vCenter audit trails showing where VMs have actually run, are sufficient for Oracle licensing purposes. The summary of the document states:

DRS Host Affinity rules can be used to run Oracle on a subset of the hosts within a cluster. In many cases, customers can use vSphere to achieve substantial licensing savings.

vCenter VMotion Logging

Concerning vCenter VMotion logging, the (more...)

NetApp’s ExaData Backup Play Reprise

I have received a fair number of responses to my previous post on this subject (some via comments and some via email). I thought the discussion worthwhile enough to punch it up a bit more here.

Backup

As I pointed out in the previous post, EMC can easily match NetApp's play to back up ExaData with the following:

EMCBackupSolution

As Geoff Rosser so correctly pointed out, this answer is incomplete. Yes, Data Domain is an awesome Oracle backup solution. Yes, it provides incredible deduplication rates for Oracle database environments. (Thanks, dynamox.) However, it is not the only viable solution from (more...)

NetApp’s ExaData Backup Play

There has been lots of material on the web recently concerning NetApp being able to backup ExaData. The purpose of this blog is to respond to that content, and state why NetApp's offering is rather lame, and actually offers nothing new.

The items on the web produced by NetApp are easy to find. I will not increase their Google hit rate by linking to them here. Suffice it to say, Neil Gerren's blog contains the principle content to which I will respond here. There is also NetApp technical report TR 4022, a 34 page tome, which I have read thoroughly. (more...)

Is ExaData an "Appliance"

My boss, Sam Lucido, raised the following question on the Everything Oracle at EMC website:

Appliances such as microwave ovens, refrigerators, iPods, iPads and TVs are excellent examples of the ease-of-use approach. Bringing the inherently complex world of Oracle databases together with the ease-of-use approach of appliances is challenging. By definition if Oracle Exadata is an appliance then its use should be simple, require relatively little maintenance and like a refrigerator do its job which in this case is run databases at extreme performance levels. If Oracle Exadata isn’t an appliance than what is it?

I found this question (more...)

Book Review: Oracle 11g R1/R2 Real Application Clusters Essentials by Ben Prusinski and Syed Jaffer Hussain (Packt Publishing)

Oracle 11g R1/R2 Real Application Clusters EssentialsOracle Real Application Cluster (RAC)  becomes the technology of choice for highly available and highly scalable deployment of enterprise Oracle database environment. With its innovative technology it comes with no surprise its complexity. The complexity is not only with the underlying database technology itself, but also how well you design and implement it to work with other components including operating system, storage subsystem, etc. In order to setup and maintain a successful RAC environment, it not only requires technical knowledge of database administrator (DBA), but also well collaboration and extended planning between all IT and business partners.

Few years (more...)

Oracle: Rename single/RAC Database

Method 1: Recreate control file with the new DB name, the old tried and tested method.
Method 2: Use new utility called NID
Steps to rename Databases using the new NID utility:
1.) Stop database

[oracle@testing1]~% srvctl status database -d test
Instance test1 is running on node testing1
Instance test2 is running on node testing2

srvctl stop database -d test


2.) startup mount the database:

[oracle@testing1]~% sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Thu Jul 21 00:50:44 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> (more...)