What does Yathra mean?
Yathra is a Sanskrit word which means Journey. In the northern states of India Yathra is spelled as Yatra.
Why is this relevant?
Oracle Technology Network, and the Oracle ACE and ACE Director programs are sponsoring a 6 city OTN tour, or Yathra, in India this February.
- February 16 in Delhi
- February 18 in Mumbai
- February 20 in Pune
- February 22 in Bangalore
- February 25 in Hyderabad
- February 27 in Chennai
And I'm going! (Assuming my Visa application is approved.) Speaker's list is
Tom Kyte, in Moscone South Room 103, looking ahead to the new features that will come up with new version of DB (12c) when it gets released.
1) "With" clause can define PL/SQL functions
2) Improved defaults, including Default col to a sequence or "default if (on) null". Or always use a generated as an identity (with optional sequence def info). Or Metadata-only defaults (default on an added column).
3) Bigger varchar2, nvarchar2, raw -up to 32K. But follows rules like LOB, if over 4K will be out of line. (max_SQL_String_Size init param)
4) TopN and (more...)
Listening to Wim talking about the roadmap for Virtualization.
The whole idea of Cloud is transforming the IT needs. Data centers are becoming Service centers, the stack is much more integrated and customers are demanding much more scalability, availability, agility. Hypervisors need to be aware of each other, or at least be coordinated.
Future is *Application* driven Virtualization. Use templates, self provisioning. Create a RAC for the sake of creating a RAC is "so yesterday".
New world: "One throat to choke" becomes "One point of satisfaction" (my note: Not going to be easy, but that is the (more...)
Open World - Howard Street Tent, in the OTN lounge.
If you want to build a 2 node RAC on your laptop (which has 4GB RAM, Windows, 50GB disk) or you want to set one up on the Pythian laptops, come over.
I've been here this morning, helping out.
I'll be here from 10:15-11:30 tomorrow as well.
You can also install it on your own, with the core instructions from http://racattack.org
One of the highlights for the database crowd attending Oracle Open World is the unofficial geek conference called Oak Table World.
Tim Gorman just had a great presentation on fast database warehouse updates using transportable tablespaces and partition exchange. Well done.
Kellyn Pot'vin presenting on EM12c - full house!
Why monitor? To be proactive. Keep the users from becoming annoying, and keep management in the procurement cycle.
Challenges: White noise, wrong noise, late noise.
Manage incident manager. Create incident from alerts using rules. New visuals, new shift. This is a shock and a learning curve.
To use existing rule sets - don't mess with the existing ones. Instead disable and create-like. Several reasons: they work; they might get overwritten with patches.
Highlight: 220.127.116.11 - the metric thresholds are only set for Warning, not (more...)
Discussion around OracleVM, which has a no-Cost, no-Fee license. You can optionally purchase support, however the product itself is $0.
- consists of one or more VM Servers, managed by one VM Manager.
- 3.1.1 is in production
- 3.2 is in beta
As of 3.1, VM Manager can be installed as a VM inside the VM Server.
Is based on XEN, installs on bare metal (replaces an existing OS, just like to VMWare enterprise hypervisor), on install you have a Dom0 (Domain 'zero') which is a minimalist Linux used to provide core (more...)
For ACE Directors, OOW kicked off on Wednesday with Sofitel by Oracle HQ being a general collection point. On Thursday and Friday we had briefings on many topics, from many product groups as well as from Thomas Kurian of Oracle. Friday evening we shuttled to the Hilton San Francisco Union Square which we will call home for the next several days.
I'll be wandering around downtown San Francisco, attending events, talking, and generally having a great time. Although this year is bittersweet with some important people missing.
For those who want to chat with me, here are (more...)
Fellow ACE Director, Ken Graziano, has created a book "A Check List for Doing Data Model Design Reviews
" available for free this week.
Check out his blog at http://kentgraziano.com/ for more details.
Over the past few months I've been using VirtulBox on my new MacBook Pro. Absolutely love the combination!
Yesterday I finally upgraded the MacBook from 10.8.1 to 10.8.2 and immediately VirtualBox stopped working. Instead of opening my VMs, I was greeted by the message:
Failed to open a session for the virtual machine Windows XP.
VT-x is being used by another hypervisor. (VERR_VMX_IN_VMX_ROOT_MODE).
VirtualBox can't operate in VMX root mode. Please close all other virtualization programs. (VERR_VMX_IN_VMX_ROOT_MODE).
Turns out this is a new bug tracked at https://www.virtualbox.org/ticket/10965
It is fixed using HotFix package 4.2.1 for Virtualbox available at https://www.virtualbox.org/wiki/Downloads
Thanks to Hemant for noticing the following article in Oracle Support
Database Control To Be Desupported in DB Releases after 11.2 [ID 1484775.1]
I've been encouraging people to switch to Cloud Control for a while now.
We have finalized the session schedule for Oracle OpenWorld 2012.
We would like to inform you of your speaking schedule along with the location information. Since there will be multiple venues, we recommend that you make a note of your session location.
SESSION SCHEDULE INFORMATION
Session ID: CON5101
Session Title: Integrating Oracle Database Appliance with Sun ZFS Appliance to Achieve HA Security
Venue / Room: Moscone West - 3014
Date and Time: 10/3/12, 15:30 - 16:30
This post will likely be updated frequently over time.
It got started because I renewed Oracle Support online today. Oracle insists that my billing address must be in a certain format. However, about 2 months ago, I received a letter from Canada Post that I need to get mail addressed a certain way if I wish to continue to receive it - and that way is NOT the way Oracle insists is "the standard format". This will be the third time in 3 years I have had to fight with Oracle about the format of my corporate (more...)
The Oracle RDBMS Server has a GRANT command that permits assignment of privileges to a user or a role.
And it has a REVOKE command that removes privileges from a user or a role. That command simply removes the privilege from the list currently available to the user or role.
However, the Oracle database does not have a 'DENY' command that could be used to store a REVOKE in a role, allowing the removal of a privilege based on the addition of a role.
A lot of [new] DBAs believe that revoking a privilege from a role will remove (more...)
I'm teaching the Oracle Database 11gR2: Security course this week.
During the auditing module, students are asked to enable auditing, and then configure to send audits to syslogd. The steps are simple: tell the database to send audits to OS; tell the database to flag the audits as a specific syslog facililty and level. These two items are in the initialization parameter file, and you restart the DB after making the change.
The challenge: get the facility right OR ELSE!
If the syslog facility or the message level being requested is not valid, the database instance will NOT (more...)
Today is June 28. 6.28 ... 2-PI ... TAU! Happy TAU Day.
No, really, PI is wrong.
For more information, please go to http://tauday.com
That is all!
Last week I taught the Oracle University RAC class in Victoria, BC. On Thursday, I took my class on a field trip ...
The Victoria Oracle Users Group brought in Dan Morgan to chat about the Oracle Database Appliance. They lent him one to demonstrate during his presentation.
The ODA is about the same size and weight as my NetApp F810 Filer which has about 1 TB of disk.
However - the ODA has 4TB of active data disk triple mirrored (eg: 12TB with plenty of redundancy in case of disk failure). It includes 2 completely separate (more...)
Discussion yesterday: "OEM Grid Control / Cloud Control is expensive! You have to pay for the Packs to make it useful. You don't need to pay for the Diagnostics Pack in Database Control."
Sorry folks - that is totally incorrect.
The DB Diagnostics Pack and the SQL Tuning Pack (as well as other packs) are options added to the database. To use them, you need to pay for them.
These packs happen to collect information. Accessing that information (using the views) requires a license, and [in production] you (usually) need to pay for that (more...)