X

Sorry about late approval of comments....

Just wanted to apologize about the late approval of a couple of comments. I thought I'd approved them but when I got on to do a blog entry I found that they had not been approved.  :)

Thursday, April 9, 2015 | Read More

It's out! Learn all about Oracle Database 12c Multitenant features. The book is called: Keeping Up With Oracle Database 12c Multitenant - Book One: CDBs, PDBs and the Multitenant World

My newest book effort is out! It's called Keeping Up With Oracle Database 12c Multitenant - Book One: CDBs, PDBs and the Multitenant World and you can find it here on Amazon.com. If you have not looked at Oracle Multitenant - now is the time! This is part one of what will be 3 or 4 books on Oracle Multitenant. You might look at this book and feel like it's not complete. Well, you are correct. This is part of a new series of books that I'm trying to get off the ground called the...

Thursday, April 9, 2015 | Read More

The Life and an INTP Part One - Ah, the good old days

This is somewhat of a personal post, but it's also related to Oracle. I've been involved in some discussions about 12c Multitenant and the fact that Oracle will be doing away with the 12c Non-Multitenant architecture someday. These discussions have made me a bit insightful, as have some related things. So, if you will allow me a moment to write a few personal thoughts - I'll then get back to Oracle stuff. I also wonder if you might relate to some of these thoughts.First I...

Wednesday, February 18, 2015 | Personal | Read More

Oracle Multitenant - Common Users

In a Multitenant database,you can create user accounts within the PDB's just like you normally would. For example this command: SQL> show con_name CON_NAME ------------------------------ TESTPDB SQL> create user dbargf identified by robert; Will create a user account called dbargf within the container named TESTPDB. The user will not be created in any other container. This is known as a local user account within the CDB architecture. It is local to a unique PDB.This isolation...

Wednesday, February 18, 2015 | Read More

Responses to You can't please all of the people... deprecation of the non-CDB architecture

I have received a few comments related to my posts on the deprecation of the non-CDB architecture. I must admit, I find some reactions to be a bit confusing. First, let me be clear - I am NOT an official voice for Oracle. This is MY blog, MY opinions and I am NOT directed by Oracle in any way with respect to what I do (or do not) write here.So, let's quash the notion that I'm acting as some kind of Oracle Shill when I suggest that there is a major over reaction to...

Wednesday, February 18, 2015 | Read More

You can't please all the people anytime - or - How people use anything to throw up FUD - or - Yes, the non-CDB architecture is deprecated in Oracle Database 12c - Part Four

Welcome to part three of my response to this blog entry on the deprecation notice of the Oracle non-CDB architecture. The previous blog entries are here for part one. Until now I've tackled these comments: What I want to talk about is Oracle’s attitude to its customers and what seems to me to be breathtaking arrogance. Personally I can think of three very good reasons why I might not want to use the single PDBwithin a CDB configuration which does not require a...

Thursday, February 12, 2015 | Read More

You can't please all the people anytime - or - How people use anything to throw up FUD - or - Yes, the non-CDB architecture is deprecated in Oracle Database 12c - Part Three

Welcome to part three of my response to this blog entry on the deprecation notice of the Oracle non-CDB architecture. The previous blog entries are here for part one. Until now I've tackled these comments: What I want to talk about is Oracle’s attitude to its customers and what seems to me to be breathtaking arrogance. Personally I can think of three very good reasons why I might not want to use the single PDBwithin a CDB configuration which does not require a...

Tuesday, February 10, 2015 | Read More

Managing your Exacheck...

I always run an Exacheck before patching an Exadata box. It's just a good practice. In many cases I'll ask the DBA at the customer to run it for me and send me the results. There is one consistent problem that I want to address in this blog and that's keeping your version of Exacheck current. First, Exacheck is updated quite regularly. When you run Exacheck it displays the version number for you at the top of the report. Before you trust any results of that Exacheck output,...

Friday, February 6, 2015 | Read More

You can't please all the people anytime - or - How people use anything to throw up FUD - or - Yes, the non-CDB architecture is deprecated in Oracle Database 12c - Part Two

This is part two of my response to the deprecation of the non-CDB model at some point in the future and some of the responses that have been made in relation to this announcement. In Part One I addressed the initial comments that were made indicating that Oracle was being "arrogant" for daring to announce this deprecation of the 30+ year old architecture. In this and two more blog entries, I will address additional comments made in the blog as it tries to argue against the...

Friday, February 6, 2015 | Read More

You can't please all the people anytime - or - How people use anything to throw up FUD - or - Yes, the non-CDB architecture is deprecated in Oracle Database 12c - Part One

Oracle has announced the deprecation of the non-CDB architecture as seen in this blog entry here. Of course, the knee jerk, negative, FUD ridden comments are starting to come out. One of these kinds of responses can be seen in this blog. Edit: I wanted to point out that Mike Dietrich has some great information on the deprecation on non-CDB architecture here. In it Mike says clearly that the removal of the non-CDB architecture will not occur until after 12.2. This blog entry...

Wednesday, February 4, 2015 | Read More

Descriptive vs. Non-descriptive Naming

I was working on something today and started to muse on names. By names, I mean things like host names, service names, database names, PDB names, listener names and so on.  I started to mull over the question of the use of descriptive vs. non-descriptive naming and how this relates to security and vulnerability of Enterprise systems.  A lot of environments that I've been in name their database instance with fairly descriptive names. For example prod, prd, prdactg and so on. The...

Friday, January 9, 2015 | Read More

Oracle Multitenant - Should you move to a single CDB/PDB architecture?

Note: Something happened to this original copy of this post. I'm not sure what it was, but somehow it was like a draft copy ended up being posted and it lost almost half it's content. I have re-created the post. So, for those of you who saw the earlier edition - I have no idea what happened. It actually happened to me twice yesterday - and then this time - very frustrating. You are probably aware that there is a new feature in Oracle Database 12c called Multitenant....

Wednesday, January 7, 2015 | Read More

PDB Recovery - Your PDB won't open because a datafile is missing!

So, you start your CDB... SQL> startup ORACLE instance started. Total System Global Area 2566914048 bytes Fixed Size                  3048920 bytes Variable Size             671091240 bytes Database Buffers         1879048192 bytes Redo Buffers               13725696 bytes Database mounted. Database opened. So good, so far. Now, you try to open one of the PDB's called TPLUG with the alter pluggable database command and get the following error: SQL> alter pluggable database tplug...

Monday, December 29, 2014 | Read More

DBA ADD.... Am I the only one....?

So, I realized that I am doing it again. I've been doing some testing with advanced compression. In doing so, I built some scripts to run my tests and produce the results of those test and so on... Those scripts lead to me writing other scripts to build a test harness of sorts for this specific test, and on and on... Then, I realized - I was doing it again - I was letting my ADD get the best of me. Instead of focusing on the end game, which consisted of collecting compression...

Saturday, December 27, 2014 | Personal | Read More

About book writing

I get asked from time to time what it's like to write a book. Often, I've given those who have asked me that question an opportunity to contribute to one of my books in one way or another. I tend to look at the reviews that get posted about my books with a bit of trepidation. I know some authors who don't look at reviews at all. I like to look at them so I can get a taste and feel on what I've done write (pun intended) on the book and how I might improve next time. I got...

Tuesday, December 16, 2014 | Read More

The DBA post-it notes... what's weighing you down?

I once heard a story of a manager who had just taken over a department with a large number of employees and many managers. This department had been struggling, trying to meet goals and objectives. In a meeting with his managers, to put things in context, the new manager stood up a large figure of a man.  Then he took post-it notes and wrote the things that this person, a typical employee, was responsible for. When the manager was done, the stick figure was filled with post it...

Monday, November 24, 2014 | Read More

Just in case you needed something fun to look at today...

Have fun with this today.... My how the database has changed since long ago...

Friday, November 14, 2014 | Read More

Oh my... A cool post from CERN...

So... I just found this web page for the first time. Someone internally posted this link to an article on Oracle's In-memory Column Store. Besides the fact that it's a great article, showing the advantages of Oracle's In-memory Column Store - How COOL is it that it's testing involves test data from CERN? I mean, how many Oracle database blogs have the following in their content:"That big peak around INV_MASS=90. is caused by electron-positron pairs being produced by the...

Monday, October 20, 2014 | Read More

Questions that make you go Hmmmm..... #3 Why 3NF?

I was reading my various Oracle forums the other day. This question was posed: "I have a table columns like id,password,age,gender and interests. now I need to insert multiple interests to single user.please help me..thank you in advance. " I was sickened that the people who first answered the question were suggesting things like this: "My first thought would be to store the interests in comma-delimited format."There were several suggestions along this line (including...

Tuesday, October 14, 2014 | Read More

Urban "Best Practice" Myths....

I had a situation today where someone was insisting that "x" was a "best practice". I asked them to show me where Oracle had defined "x" to be a best practice, and after some searching there was no best practice "x" defined by Oracle. It really interesting how we have actual best practices and what I call cultural best practices and then there are the Urban best practices. In every case, the only true best practice is one that is defined by Oracle as a best practice. OFA is a...

Tuesday, September 30, 2014 | Read More

Build Your Own Exadata? Questions that make you go Hmmmm..... #2 (Part 3)

If you have read my previous posts on the topic of building your own Exadata then you have seen my arguments for the substantial costs of building your own both when developing the system and after it's gone operational. In this section, I discuss miscellaneous other costs - most of them reoccurring - that are associated with build your own... Notice that one thing I've done, for the most part, is avoid the discussion about specific features in Exadata. I think I mention them...

Monday, September 15, 2014 | Read More

Build Your Own Exadata? Questions that make you go Hmmmm..... #2 (Part 2)

This is part two in my post about designing your own "Exadata Killer" vs. Buying Exadata. In this post I postulate several operational related costs that are not considered when building out your own Exadata like infrastructure. This post is a copy of an discussion I had on this topic a few days ago and I thought it might be worth posting: Then there are the operational costs that are not being considered:a. Cost to patch and upgrade the entire infrastructure on a...

Friday, September 12, 2014 | Read More

Build Your Own Exadata? Questions that make you go Hmmmm..... #2 (Part 1)

So, I've been told on occasion "Hey, this Exadata stuff is expensive! I've just costed out my own Exadata Killer and it's like a quarter of the price. I'm just going to build my own!"Yeah - right. I had the ability to participate in a discussion about this and I postulated a lot of things that I don't think that people who throw out the "Build my own" argument ever consider. Let me share my thoughts with you about this. I'm going to chop this up into three parts over the next...

Wednesday, September 10, 2014 | Read More

Dr. Who!!

I confess, I'm a whovian... (or however it's spelled). Totally kick behind preview of the next Dr. Who. DrWhoPreview

Thursday, August 28, 2014 | Personal | Read More

To Oracle Database 12c or Not to Oracle Database 12c - Carts and Horses (A reoccurring series - Number two)

Oracle Database 11gR2 is moving from Premiere Support to Extended Support in January 2015. What does this mean to you? Here is the basic definition of the services provided by Premiere Support: * Major product and technology releases * Technical support * My Oracle Support * Updates, fixes, security alerts, data fixes, and critical patch updates * Tax, legal, and regulatory updates * Upgrade scripts * Certification with most new third party products/versions* Certification...

Wednesday, August 27, 2014 | Read More

New feature - You can have this blog emailed to you...

You will notice that there is now a subscribe by email link at the right of this page. If you click on that link, it will take you to FeedBurner. There you can put in your email and subscribe to this blog by email!! Enjoy! Robert

Tuesday, August 19, 2014 | Read More

Exadata support for ACFS (and thus, 10gR2) now available!

Really? Exadata, ACFS and 10gR2? If you work with Exadata you are probably aware that ACFS has not been supported - until now! ACFS is now supported on Exadata if you are running Grid Infrastructure version 12.1.0.2 or later. This new support is described in MOS note 1326938.1. Also Exadata support for ACFS is mentioned in MOS note 888828.1, which is the king of all Exadata notes on MOS. The upshot is that you can now run Oracle Database 10gR2 on Exadata using ACFS as the...

Sunday, August 17, 2014 | Read More

Questions that make you go Hmmmm..... #1

This seemed like a great blog series. I participate in a number of Oracle question boards here and there and sometimes I see questions that I just find funny.... I thought I'd post those I find particularly funny, obnoxious or that otherwise stand out. I will, of course, not name the poster or the website where these questions appeared...  So, today's gem is as follows: "Can any one explain about optimization with example how to optimize query.... Its needful for me ..." My...

Monday, August 11, 2014 | Read More

The Dangers of “Recipes”

The Story of the Would Be Baker There was once a man who loved to bake. He lived on the shore line. He would love to watch the ocean from his windows as he would bake his wares, steadfastly following his recipes. The recipes were ones that had been handed down from his mother and his mother’s mother, honed and crafted over generations of trial and error. The result of these recipes was the creation of amazing masterpieces of baking. Pies, cakes, rolls and other breadsthat he...

Friday, August 1, 2014 | Read More

Thoughts and Musings on Oracle Exacheck

If you deal with Oracle Exadata, then you are probably aware of Exacheck. Exacheck is a tool that is used to determine the health of the entire Exadata infrastructure. (Note that Exacheck is also available for Exalogic but for the purposes of this discussion we will be dealing with Exacheck and Exadata). The infrastructure checks on Exadata includes checking the database, the cell servers, the network and the other components of the Exadatamachine. When I do classes and talk...

Tuesday, July 29, 2014 | Read More

The Latest New Features Skinny – Part One

Oracle Database 12.1.0.2 has just been released here for Linux X86-64 and Solaris! I’m sure other OS releases are not far behind. The documentation is available here. Back in the old days, a dot release of the Oracle Database (i.e. 12.1.0.1 to 12.1.0.2) product didn’t have that many new features in and of itself. It was the big dot releases that contained the cool new features, and then the number change releases (11 to 12 for example) that really introduced major changes. Ho...

Saturday, July 26, 2014 | Read More

Carts and Horses (A reoccurring series)

Putting the Cart Before the Horse In my years of experience I’ve had the opportunity to engage so many different customers that I’ve lost count. In my professional life I have spent maybe 9 or 10 years total as a contractor. If you assume that I have engaged one new customer every 4 weeks as a contractor (which seems somewhat accurate in my head), then that would be about 12 customers a year. That addsup to some 120 customers in the 10 years – and to be honest that number...

Friday, July 25, 2014 | Read More

A proper introduction!

I thought I'd present a more formal introduction for my first real entry. Then, we are going to get into the meat of things. For those of you that don’t know me, my name is Robert Freeman. I live in Nevada and I work for Oracle in the Public Sector Engineered Systems Specialist group. Our group is at the forefront of the benefits, use and application of Engineered systems in all public sector spacesin the United States and Canada. From federal, state, provincial governments...

Thursday, July 24, 2014 | Read More

Welcome to my New Blog Site...

Welcome to my new blog site. It just made sense for me to move my blog over to the blogs.oracle.com  domain - and here I am. I'll be talking about a lot of things on this blog including everything from my thoughts on being a DBA, to Oracle Database, to Exadata, to what I'm doing right now and also about the books I'm writing and an occasional personal entry.  I hope you enjoy!

Wednesday, July 2, 2014 | Read More