I’ll be in San Francisco next week, presenting about Hadoop and Big Data at the biggest conference. If you want to say “hi”,
you can attend one of my sessions:
- Big Data Panel Discussion (Sunday, 8am at Moscone West room 3003)
- Data Wrangling with Oracle Big Data Connectors (Sunday 3:30 pm at Moscone West room 3003)
- Women in Technology roundtable (Monday 10 am at Oak Table World )
- ETL on Hadoop (Monday 11 am at Oak Table World – I presented the same content at Surge last week, you can peek at the slides).
- It’s a Solid-State World: How Oracle Exadata X3 Leverages Flash Storage (Wednesday 3:30 pm at Westin San Francisco, Metropolitan I – With Marc Fielding)
- Data Wrangling with Oracle Big Data Connectors (Thursday 2 pm at Moscone South room 300)
I also plan to attend few sessions by other people:
- Monday 12am - Oracle Database 12c for Data Warehousing and Big Data [CON8710]
- Monday 6:30pm - Oracle’s Big Data Solutions: NoSQL, Connectors, R, and Appliance Technologies [BOF11057]
- Tuesday 3:30pm - Big Data Deep Dive: Oracle Big Data Appliance [CON8646]
- Wednesday 10am - In-Database MapReduce for DBAs and Database Developers Using SQL or Hadoop [CON8601]
- Thursday 12:30 - Hadoop Your ETL: Using Big Data Technologies to Enhance ‘s Data Warehouses [CON8732]
And few social events: Oracle’s ACE dinner, Friends of Pythian dinner, Blogger meetup, OTN event and possibly few more.
You may also find me helping Oracle and Cloudera demonstrate the Big Data Appliance at the Engineered Systems demo booth.
See you there!
I got this question during my present course Oracle Grid Infrastructure 11g: Manage Clusterware and ASM while we discussed backup of the OCR. That backup is done by the OCR Master, which can be any node in the cluster. It is therefore recommended to configure the backup location to a shared folder that is accessible from all cluster nodes. But back to the question – here is how to find the OCR Master of the Oracle Cluster:
[grid@host01 ~]$ cat /u01/app/11.2.0/grid/log/host01/crsd/crsd.log | grep -i 'ocr master' 2013-09-17 07:49:44.237: [ OCRMAS]th_master:12: I AM THE NEW OCR MASTER at incar 1. Node Number 1 2013-09-17 07:53:00.305: [ OCRMAS]th_master:12: I AM THE NEW OCR MASTER at incar 1. Node Number 1 2013-09-17 12:19:21.414: [ OCRMAS]th_master: NEW OCR MASTER IS 2 [grid@host01 ~]$ olsnodes -n host01 1 host02 2 host03 3
(GRID_HOME and local hostname) The CRSD (Cluster Registry Service Demon) is the one who deals with the OCR, which is why I search through this log file.
The Master Node of the Cluster is the one who will become the only surviving node if the interconnect fails completely. It is also the node who will pass the time to the other nodes in the absence of NTP via CTSSD (Cluster Time Synchronization Service Demon). I suppose it is always the same as the OCR Master, but just to be on the safe side, you can check that this way:
[grid@host01 ~]$ cat /u01/app/11.2.0/grid/log/host01/cssd/ocssd.log | grep -i 'master node' 2013-09-17 07:48:53.541: [ CSSD]clssgmCMReconfig: reconfiguration successful, incarnation 274866533 with 1 nodes, local node number 1, master node number 1 2013-09-17 07:49:47.427: [ CSSD]clssgmCMReconfig: reconfiguration successful, incarnation 274866534 with 1 nodes, local node number 1, master node number 1 2013-09-17 07:52:27.595: [ CSSD]clssgmCMReconfig: reconfiguration successful, incarnation 274866536 with 1 nodes, local node number 1, master node number 1 2013-09-17 07:59:20.783: [ CSSD]clssgmCMReconfig: reconfiguration successful, incarnation 274866537 with 2 nodes, local node number 1, master node number 1 2013-09-17 11:34:59.157: [ CSSD]clssgmCMReconfig: reconfiguration successful, incarnation 274866538 with 3 nodes, local node number 1, master node number 1 2013-09-17 12:18:48.885: [ CSSD]clssgmCMReconfig: reconfiguration successful, incarnation 274866540 with 3 nodes, local node number 1, master node number 2 2013-09-17 12:22:52.660: [ CSSD]clssgmCMReconfig: reconfiguration successful, incarnation 274866541 with 2 nodes, local node number 1, master node number 2 2013-09-17 12:23:32.836: [ CSSD]clssgmCMReconfig: reconfiguration successful, incarnation 274866542 with 3 nodes, local node number 1, master node number 2 2013-09-17 12:26:29.474: [ CSSD]clssgmCMReconfig: reconfiguration successful, incarnation 274866543 with 3 nodes, local node number 1, master node number 2 2013-09-17 12:28:42.960: [ CSSD]clssgmCMReconfig: reconfiguration successful, incarnation 274866544 with 3 nodes, local node number 1, master node number 2
The CSSD (Cluster Synchronization Service Demon) is the one who deals with the Voting File that is used to determine which nodes must reboot and which nodes will survive in case of a problem with the Interconnect. Therefore, I search through its log file to determine the Master of the Cluster.
The question comes up quite often, so this little post will be handy to point to in the future. Hope you find it useful as well
Tagged: Grid Infrastructure, RAC
RAC Attack is a program initiated by Jeremy Schneider, Dan Norris and Parto Jalili at the IOUG Collaborate 2008 conference as a result of a classroom full of unattended PCs (long story, great ending)
Quoting from the RAC Attack web site at http://racattack.org :
"RAC Attack is a free curriculum and platform for hands-on learning labs related to Oracle RAC (cluster database). We believe that the best way to learn about RAC is with a lot of hands-on experience."
This year the RAC Attack team - we call ourselves RAC Attack Ninjas - will be hosting a campground in the OTN Lounge on Tuesday and Wednesday from 10-2.
People who have their own laptop can download the Oracle VirtualBox (http://virtualbox.org), Oracle Linux (https://edelivery.oracle.com/linux) and Oracle Database 12c for Linux (http://download.oracle.com) and we will help them install Oracle Database 12c and a 2-node RAC cluster.
This year, Exit Certified (Oracle University partner who provides a lot of RAC training) and DELL (Oracle partner who sells a lot of hardware used with RAC) have sponsored some equipment for people who want to attend, but don't want to use their own laptops.
If you are interested in learning more about RAC, maybe installing it on your laptop, then come along to the RAC Attack sessions during OOW. Get more details from the Facebook page for each of the two days.
If you are coming to install RAC, you might want to read through this.
My itinerary, generally speaking (as I usually allow a lot of flexibility):
1) I'm already in San Francisco - teaching the Oracle University course on OracleVM until Wednesday.
On Wednesday evening, I'll be heading to the Sofitel where many of the ACE Directors meet up before the ACED Briefing.
That's when we get to see Vikki and Lillian, the wonderful ladies who herd the cats known as Oracle ACEs.
2) ACE Director Briefing, Thursday and Friday
In the years since I was fortunate enough to be selected a ACE Director, I have tried to attend all the ACE Director Briefings - presentations by Oracle management and product management to let us know (under NDA) what is coming up. Of course, with the NDA, we are not allowed to talk about anything until Larry spills the beans, but at least we will have had a chance to mull things over before the beans do get spilled.
Since Tim Hall can not be at the briefing this year, a number of us ACEDs will be blogging extra, trying to keep him up to date without violating the NDA.
3) RAC Attack pre-meeting on Sunday, and possibly another on Saturday.
4) Kickoff on Sunday
Things officially start on Sunday with the various user group and specialty sessions, which inevitablyt have a great amount of info, followed by The Kickoff. If things hold true to previous years, Larry will throw the gauntlet and give us a glimpse of what new announcements will be made and why we should listen.
5) ACE Dinner on Sunday
One of the ACE highlights at OOW it the ACE Dinner on Sunday evening. I enjoy catching up with my fellow ACEs from around the world, and meeting the new faces who joined the ranks.
6) Monday-Thursday is going to be filled to the brim with all sorts of activities, traveling to and fro, and blogging about it.
7) RAC Attack
I'll be at RAC Attack both Tuesday and Wednesday. Facebook pages at
8) Enterprise Manager CAB on Friday
I've been very fortunate to be selected as a Customer Advisory Board attendee for the Oracle Enterprise Manager Cloud Control. This is an opportunity to provide feedback to the inner circle of the product team, as well as to learn about future directions of products.
Most products, and even major features, have CABs. I encourage all customers to consider getting involved.
It all starts on Sunday with a day long seminar. I'll be doing a series of "five things about" - in the areas of SQL, PL/SQL, Performance and more. You can check out and register for those sessions (and many others) here: http://www.oracle.com/openworld/oracle-university/index.html
Next, on Monday I'll be delivering:
Session ID: GEN8579
Session Title: General Session: What’s New in Oracle Database Application Development
Venue / Room: Marriott Marquis - Salon 8
Date and Time: 9/23/13, 12:15 - 13:15
I've done a session like this every year for the last 8 or so years, It'll cover what new Oracle Database Application development techniques have become available over the last year (and will include a few Oracle Database 12c repeats from last year where relevant).
Next, on Tuesday I'll be doing:
Session ID: CON8426
Session Title: The Five Best Things to Happen to SQL
Venue / Room: Moscone South - 103
Date and Time: 9/24/13, 10:30 - 11:30
This is not just the five best things to happen to SQL in Oracle Database 12c - but rather - five of the coolest things to happen to the SQL language over the years. You might be surprised at how many you did not know about....
And lastly - on Wednesday - the last slot before the appreciation event - I'll be presenting on:
Session ID: CON11637
Session Title: What’s New in Oracle Database 12c
Venue / Room: Moscone South - 103
Date and Time: 9/25/13, 17:00 - 18:00
This is not a repeat of last years "Top 12 Things about Oracle Database 12c", this is all new content - things discovered and found useful in the last year of using Oracle Database 12c. So, if you have seen my "12 things" talk - or videos - or read the articles in Oracle Magazine, this will be all new and different.
I hope to see you around - I'll be on site all week from Saturday evening until Wednesday night (flying back home on a redeye Wednesday).
Enjoy the show!
So that's good ... details are here https://www.neooug.org/DateSeminar/ChrisDate_SQL_and_relational_theory.htm
In Cleveland on Oct 22/23/23 2013 and cost is very very reasonable.
Not many spots left in this class it is going to sell out soon so act soon or ... well buy his book.
The journey is old, but the milestones are new. It’s the same old quest for excellence. Innovative questions are being asked and answered in the blogs across the Oracle, SQL Server and MySQL branches of technologies. This Log Buffer Edition relishes just that. Let’s start this Log Buffer with the exquisite blog post by Dana Pylayeva.
EMlight might not be as important now with Oracle 12c coming out and with Oracle’s EM Express, but EMlight is still pretty cool.
The maximum size for VARCHAR2, NVARCHAR and RAW columns has been extended to 32767 bytes with the Oracle 12c database.
Here’s a treat for the hard-core Oracle performance geeks out there. Tanel Poder is releasing a new tool.
Jonathan Lewis has a fairly strong preference for choosing simple solutions over complex solutions, and using Oracle-supplied packaged over writing custom code.
Connor is talking about 12c FETCH FIRST.
Valentino Vranken is telling a story about SQL Server-related contraptions.
Thomas LaRock is taking part in a webinar about Expert Database Design Tips for SQL Server and Azure.
The Certified Master and Architect community was collectively notified Friday, August 30, at 10PM PST that the Certified Master (MCM/MCSM) and Certified Architect (MCA) programs are dead.
The second incarnation of 2013 “SQL Relay” is bigger and better than ever, Richard Douglas has more.
Michael Swart is sharing three more tricky Tempdb lessons.
Jervin says that we all know that when troubleshooting MySQL crashes or any other processes in that regard, we simply enable core files to be dumped when the appropriate signal it triggered.
Want to prove your expertise with MySQL? Why not get certified.
There are multiple ways to backup a MySQL database. Some are more painful than others.
When Peter Gulutzan worked for MySQL he saw frequent complaints that the UNIQUE constraint didn’t stop users from inserting NULLs, multiple times.
Andrew Morgan was rooting through past blog entries and stumbled across a draft post on setting up multi-master (update anywhere) asynchronous replication for MySQL Cluster.
What you are you necessary to know about Oracle Database Concept, Architecture and Features. I mention a book about Oracle Database 12c - Oracle Essentials, 5th Edition Oracle Database 12c by Rick Greenwald, Robert Stackowiak, Jonathan Stern. Topics in a book covers:
- A complete overview of Oracle databases and data stores, and Fusion Middleware products and features
- Core concepts and structures in Oracle’s architecture, including pluggable databases
- Oracle objects and the various datatypes Oracle supports
- System and database management, including Oracle Enterprise Manager 12c
- Security options, basic auditing capabilities, and options for meeting compliance needs
- Performance characteristics of disk, memory, and CPU tuning
- Basic principles of multiuser concurrency
- Oracle’s online transaction processing (OLTP)
- Data warehouses, Big Data, and Oracle’s business intelligence tools
- Backup and recovery, and high availability and failover solutions
Chapter 1 Introducing Oracle
Chapter 2 Oracle Architecture
Chapter 3 Installing and Running Oracle
Chapter 4 Oracle Data Structures
Chapter 5 Managing Oracle
Chapter 6 Oracle Security, Auditing, and Compliance
Chapter 7 Oracle Performance
Chapter 8 Oracle Multiuser Concurrency
Chapter 9 Oracle and Transaction Processing
Chapter 10 Oracle Data Warehousing and Business Intelligence
Chapter 11 Oracle and High Availability
Chapter 12 Oracle and Hardware Architecture
Chapter 13 Oracle Distributed Databases and Distributed Data
Chapter 14 Oracle Extended Datatypes
Chapter 15 Oracle and the Cloud
After reviewing, I belief this book is a good for some people who are interested in Oracle Database (Maybe version 12c) and want to begin with Oracle Database product (It's very useful). A book gives much more details and explain about Oracle Database product (including version 12c), Concept, Architecture, How to install, Data structure, How to manage, Performance and some things what beginner should know. If readers are interested in Oracle Database 12c and want to know What’s new in this Book for Oracle Database 12c. Readers can check in APPENDIX A.
Anyway, DBA or Developer can use it as reference. Written By: Surachart Opun http://surachartopun.com
SQL> create user altdotoracle identified by altdotoracle;
SQL> grant create session, select any dictionary to altdotoracle;
SQL> conn altdotoracle/altdotoracle
SQL> select name, password from sys.user$ where password is not null;
NAME PASSWORD------------------------------ ------------------------------SYS AAJ125C9483Q017SYSTEM W45825DFFFD37SEOUTLN WW24Z1N6A8ED2E1ALTDOTORACLE 73NH15SG3Q2364W
Armed with these password hashes, password cracking tools can be used to compare these values to common dictionary passwords. When a match is found on a non-complex password, your password is cracked. (Don’t wear yourself out trying to crack the hashes above, I obfuscated them) SELECT ANY DICTIONARY no longer allows access to dictionary objects like USER$, ENC$ and DEFAULT_PWD$. Let’s try it.
Connected to:Oracle Database 12c Enterprise Edition Release 220.127.116.11.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> create user altdotoracle identified by altdotoracle;
SQL> grant create session, select any dictionary to altdotoracle;
SQL> conn altdotoracle/altdotoracleConnected.
SQL> select name, password from sys.user$ where password is not null;select name, password from sys.user$ where password is not null *ERROR at line 1:ORA-01031: insufficient privileges
SQL> select * from sys.enc$;select * from sys.enc$ *ERROR at line 1:ORA-01031: insufficient privileges
SQL> select * from sys.default_pwd$;select * from sys.default_pwd$ *ERROR at line 1:ORA-01031: insufficient privileges
So you end up with 4 oracle homes the old grid/old database the new grid/new database then you had to clobber/remove the old ones ( well or leave a real mess ).
Now if you read the older 11.2 ReadMe's and install guides yes it did "say" that yes you could do an in place upgrade but ... well it was a lie and ... well it did not work. So you were forced to do the out of place.
Looking at the latest ReadMe ( just a quick look ) is giving me a sense of deja vu ... this sure seems to read like the old stuff I remember that said yes you could do it.
Anyone have any real world testing done now with 18.104.22.168 to provide any feedback here before I wade on in?
This is how it reads now ... for 22.214.171.124 ...
This feature enables you to upgrade an existing installation of Oracle database to Oracle Database 11g Release 2 (126.96.36.199) into the same Oracle home directory by replacing the existing database files. The patch set application requires more downtime and is not recommended. This upgrade type requires less disk space.
Note:If you select In-place upgrade to upgrade Oracle database to the latest version, then you must:
- Review "Optionally Performing an In-Place Upgrade (Into the Same Oracle Home)" in Oracle Database Upgrade Guide.
- Take a complete backup of your Oracle home directory before you perform the upgrade.
This feature enables you to install Oracle Database 11g Release 2 (188.8.131.52) in a new, separate Oracle home directory. After the installation is complete, the data from the database in the old Oracle home directory is migrated to the database in the new Oracle home directory.
Out-of-place upgrade process is similar to Oracle database upgrade from one version to another and is the recommended type. The benefits of this upgrade type is that the patch set application requires much less downtime, and is safer when the patch set application must be aborted. This upgrade type requires more disk space to accommodate two Oracle home directories simultaneously.
So far in 2014 we ONLY have Steve F. and Tom K. to announce as keynoters ... ha! Yeah that Steve and that Tom ... plus Carlos S doing a workshop on SQLT ... yes that Carlos.
Still working to finalize a set of Monday workshops ... stay tuned over at the NEOOUG website and/or Oracle L for when we start accepting presentation abstracts ( probably October ).
A few days back, late Friday (30th August 2013) MS has made an announcement – that they are cancelling the MCM Certification, not so good news for MCM aspirants. This announcement has upset many in the SQL Community including myself.
I had my own reasons, and beliefs about not attending any of the certification exam until few month ago. In my 14+ years career not a single employer of asked me to go and get certified. I can say, I am lucky, but all I know is that I have worked hard – a lot. I have tried to learn a lot, from friends, from colleagues, from online web forums, books online, books and MS Evangelists, and still learning. And, that pays me well, I participate in community activities, speaks, blog and have been able to put my thoughts together to publish a book on SQL Server Cluster – this way I am surviving as a professional.
To be honest, during my career I have interviewed a lot of people and many of them are certified but they don’t have exposure and practical troubleshooting skills which was expected; apart from this, there are dumps available that can make it easy to clear an exam. Please understand, I am not criticizing those who has passed nor I am saying all who haven’t passed aren’t good as professional, but I am just trying to make a point why I haven’t attempted one. With this kind of experience it never interest me to pass the certification.
Then, MCM was introduced. I had heard a lot about Oracle exams which has lab test as well and MCM is a similar kind of exams. Brent Ozar ( Blog | Twitter ) blogged about What is MCM in 2010. I have followed all his posts about MCM and has developed an interest in attending MCM training followed by an exam. Event though the exam and training fees are way too high for me, I have made my mind that I will utilize the money my employer provide each of us for training + some from my pocket to get train and earn this title – but, sadly, it is gone now. Since MCITP is a pre-requisite for MCM, I have made my mind, attempted and failed. However, I am sure that I will clear it in next attempt. But, I am not sure, whether I will be taking an MCITP any more.
I will be more than happy, if this decision for MCM exam is reversed or some relevant / at par exam is introduced. In our country, it is said that “whatever happened has happened for the good, and whatever that is going to be happen in future will be for good”. I am hoping that this saying will hold true.
At the end, I would like to say, if you are believer and aspirant of this exam just like me please take some time and vote on the MS Connect site for reconsideration.
Cross Posted : SQL Server Citation
With organizations gearing up to the new round of technologies as the database vendors announce newer versions and features, the bloggers are busy covering all of those details with practical advice. This Log Buffer Edition brings you that advice.
Marco Vigelini has written one post regarding creation of a pluggable database PDB using the files of the seed PDB$SEED and his second post describes how to create a pluggable database by unplugging an existing PDB and plugging it into another container.
Oracle OEM 12c introduces a new feature that enables the creation of Oracle database thin clones by leveraging file system snapshot technologies from either Oracle ZFS Storage Appliance or Netapp.
Oracle OpenWorld 2013 is just few weeks away, and of course, Pythian is organizing the Annual Oracle Bloggers Meetup — one of your top favorite events of OpenWorld.
Here is how to install Fusion Middleware Infrastructure on Oracle DB 12c.
Here is how to break a large query into many small ones.
Oracle SQL Developer 4: A Tweak With Table Filter Recall
Kenneth Fisher has shared a T-SQL query to get current job activity.
Few days back, late Friday (30th August 2013) MS has made an announcement – that they are cancelling the MCM Certification, not so good news for MCM Aspirants.
Creating Logins and Users – Why I can’t connect
Be honest: have you ever waited too long to back up your SQL Server data?
Analysis Service connectivity error due to SQL Browser service
Morgan Tocker is migrating from PostgreSQL to MySQL.
TokuDB vs InnoDB in timeseries INSERT benchmark
Hot Backup allows users to create a backup of a running TokuMX primary or secondary server in a replica set, with no blocking of writes for clients.
So it’s all well and good having a nice MySQL cluster running on some tiny hardware, but what can you do with it?
Monitoring The Cluster Using the LCD Panel
Just a brief information for you out there who are about to create a Data Guard Configuration. You will want to have Standby Redo Logs (SRLs) on the Standby Database. Our (otherwise very good) Online Documentation says “RMAN automatically creates the standby redo log files on the standby database.” That is true, but only if you created them before on the Primary! That was already the case with 11g and it still is with 12c, which I have just tested. Here’s the outcome after the RMAN DUPLICATE without SRLs on the Primary, checking the alert log of the Standby:
Use the following SQL commands on the standby database to create standby redo logfiles that match the primary database: ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 104857600; ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 104857600; ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 104857600;
Confirmation with SQL*Plus:
[oracle@uhesse]$ sqlplus sys/oracle@physt as sysdba SQL*Plus: Release 184.108.40.206.0 Production on Fri Sep 6 09:06:08 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 220.127.116.11.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select * from v$standby_log; no rows selected
Conclusion: Don’t believe it (even if it is the Documentation), test it!”
Tagged: Data Guard