- I spent three weeks in California on a hybrid personal/business trip. I had a bunch of meetings, but not three weeks’ worth.
- The timing was awkward for most companies I wanted to see. No blame accrues to those who didn’t make themselves available.
- I came back with a nasty cough. Follow-up phone calls aren’t an option until next week.
- I’m impatient to start writing. Hence tonight’s posts. But it’s difficult for a man and his cough to be productive at the same time.
A running list of recent posts is:
- As a companion to this post, I’m publishing a very long one on vendor lock-in.
Subjects I’d like to add to that list include:
- Spark (it’s prospering).
- Databricks (ditto, appearances to the contrary notwithstanding).
- Flink (it’s interesting as the streaming technology it’s now positioned to be, rather than the overall Spark alternative it used to be positioned as but which the world didn’t need).
- DataStax, MemSQL, Zoomdata, and Neo Technology (also prospering).
- Cloudera (multiple topics, as usual).
- Analytic SQL engines (“traditional” analytic RDBMS aren’t doing well).
- Enterprises’ inconsistent views about vendor lock-in.
- Microsoft’s reinvention (it feels real).
- Metadata (it’s ever more of a thing).
- Machine learning (it’s going to be a big portion of my research going forward).
- Transitions to the cloud — this subject affects almost everything else.
I’ll edit these lists as appropriate when further posts go up.
Let’s cover some other subjects right here.
1. While Kafka is widely agreed to be the universal delivery mechanism for streams, the landscape for companion technologies is confused.
- Back in January I wrote that the leaders were mainly Spark Streaming, followed by Storm.
- I overlooked the fact that Storm creator Twitter was replacing Storm with something called Heron.*
- If there’s any buzz about Confluent’s replacement for distant-third-place contender Samza, I missed it.
- Opinions about Spark Streaming are mixed. Some folks want to get away from it; others like it just fine.
And of course Flink is hoping to blow everybody else in the space away.
*But that kind of thing is not necessarily a death knell. Cassandra inventor Facebook soon replaced Cassandra with HBase, yet Cassandra is doing just fine.
As for the “lambda architecture” — that has always felt like a kludge, and various outfits are trying to obsolete it in various ways. As just one example, Cloudera described that to me during my visit as one of the main points of Kudu.
2. The idea that NoSQL does away with DBAs (DataBase Administrators) is common. It also turns out to be wrong. DBAs basically do two things.
- Handle the database design part of application development. In NoSQL environments, this part of the job is indeed largely refactored away. More precisely, it is integrated into the general app developer/architect role.
- Manage production databases. This part of the DBA job is, if anything, a bigger deal in the NoSQL world than in more mature and automated relational environments. It’s likely to be called part of “devops” rather than “DBA”, but by whatever name it’s very much a thing.
I had a moment of clarity on this point while visiting my clients at DataStax, and discussing their goal — shared by numerous companies — of being properly appreciated for the management tools they provide. In the room with me were CEO Billy Bosworth and chief evangelist Patrick McFadin — both of whom are former DBAs themselves.
3. I visited ClearStory, and Sharmila Mulligan showed me her actual sales database, as well as telling me some things about funding. The details are all confidential, but ClearStory is clearly doing better than rumor might suggest.
4. Platfora insisted on meeting circumstances in which it was inconvenient for me to take notes. So I have no details to share. But they sounded happy.
5. Pneubotics — with a cool new video on its home page — has found its first excellent product/market fit. Traditional heavy metallic robots are great at painting and related tasks when they can remain stationary, or move on rigid metal rails. Neither of those options works well, however, for large curved or irregular surfaces as might be found in the aerospace industry. Customer success for the leading soft robot company has ensued.
This all seems pretty close to the inspection/maintenance/repair area that I previously suggested could be a good soft robotics fit.
How do you typically create database, using dbca or sqlplus?
I am still surprised with all the bloatware added for creating database using dbca.
Also, is there a reason to prefix PDB with pdb?
[14:54]oracle@arrow:cdb12c:/u01/app/oracle/product/184.108.40.206/db_1/dbs $ ll total 28 -rw-r--r--. 1 oracle oinstall 801 Jul 19 12:59 cr_cdb.sql -rw-rw----. 1 oracle oinstall 1544 Jul 19 13:06 hc_tmnt.dat -rw-r--r--. 1 oracle oinstall 216 Jul 19 12:48 inittmnt.ora -rw-r-----. 1 oracle oinstall 24 Jul 19 13:05 lkTMNT_A -rw-r-----. 1 oracle oinstall 5120 Jul 19 11:13 orapwtmnt -rw-r-----. 1 oracle oinstall 2560 Jul 19 13:36 spfiletmnt.ora [14:54]oracle@arrow:cdb12c:/u01/app/oracle/product/220.127.116.11/db_1/dbs $ cat /etc/oratab grid:/u01/app/18.104.22.168/grid tmnt:/u01/app/oracle/product/22.214.171.124/db_1 [14:54]oracle@arrow:cdb12c:/u01/app/oracle/product/126.96.36.199/db_1/dbs $ dbca -silent \ > -createDatabase -templateName General_Purpose.dbc -createAsContainerDatabase true \ > -gdbName cdb12c -sid cdb12c \ > -SysPassword oracle -SystemPassword oracle \ > -numberOfPdbs 2 -pdbName pdb \ > -pdbadminUsername pdba -pdbadminPassword oracle \ > -emConfiguration NONE \ > -redoLogFileSize 100 \ > -storageType FS -datafileDestination /oradata \ > -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 \ > -totalMemory 1024 -databaseType MULTIPURPOSE \ > -initparams audit_trail=NONE Registering database with Oracle Restart 4% complete Copying database files 5% complete 6% complete 12% complete 17% complete 22% complete 30% complete Creating and starting Oracle instance 32% complete 35% complete 36% complete 37% complete 41% complete 44% complete 45% complete 48% complete Completing Database Creation 50% complete 53% complete 55% complete 63% complete 71% complete 74% complete Creating Pluggable Databases 79% complete 84% complete 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cdb12c/cdb12c.log" for further details. [15:11]oracle@arrow:cdb12c:/u01/app/oracle/product/188.8.131.52/db_1/dbs $ ll total 48 -rw-r--r--. 1 oracle oinstall 801 Jul 19 12:59 cr_cdb.sql -rw-rw----. 1 oracle oinstall 1544 Jul 19 15:10 hc_cdb12c.dat -rw-rw----. 1 oracle oinstall 1544 Jul 19 13:06 hc_tmnt.dat -rw-r--r--. 1 oracle oinstall 216 Jul 19 12:48 inittmnt.ora -rw-r-----. 1 oracle oinstall 24 Jul 19 14:56 lkCDB12C -rw-r-----. 1 oracle oinstall 24 Jul 19 13:05 lkTMNT_A -rw-r-----. 1 oracle oinstall 7680 Jul 19 15:07 orapwcdb12c -rw-r-----. 1 oracle oinstall 5120 Jul 19 11:13 orapwtmnt -rw-r-----. 1 oracle oinstall 3584 Jul 19 15:11 spfilecdb12c.ora -rw-r-----. 1 oracle oinstall 2560 Jul 19 13:36 spfiletmnt.ora [15:12]oracle@arrow:cdb12c:/u01/app/oracle/product/184.108.40.206/db_1/dbs $ cat /etc/oratab #Backup file is /u01/app/220.127.116.11/grid/srvm/admin/oratab.bak.arrow line added by Agent grid:/u01/app/18.104.22.168/grid tmnt:/u01/app/oracle/product/22.214.171.124/db_1 cdb12c:/u01/app/oracle/product/126.96.36.199/db_1:N # line added by Agent [15:12]oracle@arrow:cdb12c:/u01/app/oracle/product/188.8.131.52/db_1/dbs $ sqlplus / as sysdba SQL*Plus: Release 184.108.40.206.0 Production on Tue Jul 19 15:12:33 2016 Copyright (c) 1982, 2014, 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> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 PDB2 READ WRITE NO SQL> @/media/sf_working/sql/dba_registry.sql NAME COMP_ID COMP_NAME VERSION STATUS --------- ------------ ---------------------------------------- ------------------------------ -------------------------------------------- CDB12C DV Oracle Database Vault 18.104.22.168.0 VALID CDB12C APEX Oracle Application Express 4.2.5.00.08 VALID CDB12C OLS Oracle Label Security 22.214.171.124.0 VALID CDB12C SDO Spatial 126.96.36.199.0 VALID CDB12C ORDIM Oracle Multimedia 188.8.131.52.0 VALID CDB12C CONTEXT Oracle Text 184.108.40.206.0 VALID CDB12C OWM Oracle Workspace Manager 220.127.116.11.0 VALID CDB12C XDB Oracle XML Database 18.104.22.168.0 VALID CDB12C CATALOG Oracle Database Catalog Views 22.214.171.124.0 VALID CDB12C CATPROC Oracle Database Packages and Types 126.96.36.199.0 VALID CDB12C JAVAVM JServer JAVA Virtual Machine 188.8.131.52.0 VALID CDB12C XML Oracle XDK 184.108.40.206.0 VALID CDB12C CATJAVA Oracle Database Java Packages 220.127.116.11.0 VALID CDB12C APS OLAP Analytic Workspace 18.104.22.168.0 VALID CDB12C XOQ Oracle OLAP API 22.214.171.124.0 VALID CDB12C RAC Oracle Real Application Clusters 126.96.36.199.0 OPTION OFF 16 rows selected. SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 188.8.131.52.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsManually created CDB.
[15:14]oracle@arrow:cdb12c:/u01/app/oracle/product/184.108.40.206/db_1/dbs $ . oraenv <<< tmnt ORACLE_SID = [cdb12c] ? The Oracle base remains unchanged with value /u01/app/oracle [15:14]oracle@arrow:tmnt:/u01/app/oracle/product/220.127.116.11/db_1/dbs $ sqlplus / as sysdba SQL*Plus: Release 18.104.22.168.0 Production on Tue Jul 19 15:14:10 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 APRIL MOUNTED SQL> @/media/sf_working/sql/dba_registry.sql NAME COMP_ID COMP_NAME VERSION STATUS --------- ------------ ---------------------------------------- ------------------------------ -------------------------------------------- TMNT XDB Oracle XML Database 126.96.36.199.0 VALID TMNT CATALOG Oracle Database Catalog Views 188.8.131.52.0 VALID TMNT CATPROC Oracle Database Packages and Types 184.108.40.206.0 VALID SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 220.127.116.11.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options [15:14]oracle@arrow:tmnt:/u01/app/oracle/product/18.104.22.168/db_1/dbs $
One of the focus area for us when developing the new Oracle Application Builder Cloud Service (ABCS) was to create a tool that would make it very simple to enrich Oracle SaaS applications.
This integration is a key part of Oracle's PaaS for SaaS offering - where we have unique capabilities in our Platform as a Service offering for our Software as a Service customers.
With ABCS it is very easy to pick up objects from Oracle SaaS (through the built in service catalog) and then design new web and mobile interfaces that show data from those.
In addition you can then add your own custom fields and related objects with additional data you want to track.
Once your application is complete - you can then either run it as a stand-alone app, or embed it into an Oracle SaaS interface.
I wrote two blogs and recorded two videos that show you the basics.
Embedding Oracle Application Builder Cloud Service Apps in Oracle Sales Cloud
These videos are part of the new Oracle Application Builder Cloud Service YouTube Channel
And the blogs are published on the Oracle Application Builder Cloud Service OTN Community
We have more tutorials there to help you go even further - so check them out!
Oracle today released the July 2016 Critical Patch Update.
This Critical Patch Update provides fixes for a wide range of product families including: Oracle Database Server, Oracle E-Business Suite, Oracle Industry Applications, Oracle Fusion Middleware, Oracle Sun Products, Oracle Java SE, and Oracle MySQL.
Oracle recommends this Critical Patch Update be applied as soon as possible. A summary and analysis of this Critical Patch Update has been published on My Oracle Support (MOS Note 2161607.1)
For More Information:
The Critical Patch Update Advisory is located at http://www.oracle.com/technetwork/security-advisory/cpujul2016-2881720.html
My Oracle Support Note 2161607.1 is located at https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2161607.1 (MOS account required).
The Critical Patch Update (CPU) for July 2016 was released on July 19, 2016. Oracle strongly recommends applying the patches as soon as possible.
The Critical Patch Update Advisory is the starting point for relevant information. It includes a list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities, and links to other important documents.
Supported products that are not listed in the "Supported Products and Components Affected" Section of the advisory do not require new patches to be applied.
The Critical Patch Update Advisory is available at the following location:
It is essential to review the Critical Patch Update supporting documentation referenced in the Advisory before applying patches.
The next four Critical Patch Update release dates are:
- October 18, 2016
- January 17, 2017
- April 18, 2017
- July 18, 2017
- Oracle E-Business Suite Release 12 Critical Patch Update Knowledge Document (April 2016) (Doc ID 2113110.1)
- Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (January 2016) (Doc ID 2072202.1)
- Secure Configuration Guide for Oracle E-Business Suite Release 12 (Doc ID 403537.1)
- Secure Configuration Guide for Oracle E-Business Suite Release 11i (Doc ID 189367.1)
- Oracle E-Business Suite Security Guide, Release 12.2 - Secure Configuration
- Critical Patch Update for April 2016 Now Available
- Critical Patch Update for January 2016 Now Available
We learned in previous articles that it takes more than just being a great technician to keep your customers happy. The theme of this series is that if you want to be viewed as a strategic resource in your organization, being a technical expert isn’t enough. Because of the trade you have chosen, the DBA position provides you with an excellent opportunity to play a more strategic role in your organization.
- Sponsored: 64% off Code Black Drone with HD Camera
Our #1 Best-Selling Drone--Meet the Dark Night of the Sky!
A Guest Post by Michael Richter, Director of Product Management, Oracle (pictured left)
Oracle Cloud apps shine on the big stage at Oracle OpenWorld 2016.
And none so brightly as Oracle Sales Cloud.
The CX Sales Track at OpenWorld 2016 is where sales professionals like you meet to learn, network, and experience everything there is to know about modern selling.
You can listen to success stories from customers, meet with partners that have implemented or extended sales applications, and engage with product experts in the exhibition center to see live demonstrations. What you will find in common is that modern selling is transforming the way sales is conducted across industries.
Industry Sessions for CX Leaders—Learn to stay ahead of the competition
How do you differentiate yourself beyond the products and services you sell? Pre-configured industry solutions accelerate the path to faster ROI and leverage Oracle’s extensive industry expertise. That combination lets you focus on your unique business components.
At Oracle OpenWorld, there will be a series of CX industry overview sessions, including High Tech and Manufacturing, Consumer Goods, Financial Services, Communications, Higher Education, Automotive, and Hospitality. There will be scheduled live demonstrations at the CX Sales Theater in the CX Central exhibition area on the 2nd floor at Moscone West.
Some featured sessions for industries include:
- GEN6944 Learn how to Differentiate Yourself with Industry-Tailored Customer Experiences
- CON6941 Redefining Automotive Industry Customer Experience for a Sharing, Digital World
- CON6934 Become a Disruptor—Lead with your Digital Experience (Communications)
- THT6954 Recruiting the Modern Student with Oracle CX (Higher Ed)
Learn from Customer Success Stories, Product Experts, and Live Demonstrations
There are many ways to interact with partners and Oracle product experts to gain deeper insights on modern selling. You'll find a number of conference sessions and live demonstrations focusing on Sales Cloud, Configure, Price, and Quote (CPQ) Cloud, Engagement Cloud topics, and more.
Oracle product managers will lead roadmap sessions to reveal the latest innovations to Sales Cloud. They’ll also share useful tools to speed migration and ways to streamline and get optimal value from integrations. Learn about the new Engagement Cloud through session presentations and live demonstrations.
We’re announcing Oracle Sales Cloud Release 12 at Oracle OpenWorld
- GEN6317 CX Sales General Session: A Modern Way to Sell
Sales Cloud session highlights:
- CON6319 Oracle Sales Cloud Roadmap
- CON6928 Oracle Cloud Marketplace: Drive Growth with Innovative Apps
- CON6929 Oracle Sales Cloud: Fast Deployments and Fast Results for Midsize Companies
- CON6933 Getting Value with an Oracles Sales Cloud & Marketing Cloud Integration
- HOL7492 & HOL7493—Hands on Labs (Introductory session and mobility session)
- THT6321 Oracle Sales Cloud Sales Force Automation Demonstration
- THT6940 Oracle Sales Cloud Partner Relationship Management Demonstration
- THT6939 Oracle Sales Cloud Sales Performance Management Demonstration
CPQ session highlights:
- CON6320 Oracle Configure, Price and Quote Roadmap
- CON6937 How Oracle Sales Cloud and CPQ Cloud Work Together for Maximum Results
- CON7076 What’s your CPQ Maturity? A CPQ Business Panel Discussion
- CON7078 Oracle CPQ Cloud and EBS Integration
- THT7082 Oracle Configure, Price and Quote Demonstration
- THT7083 Oracle Configure, Price and Quote and Oracle Commerce Cloud Demonstration
Engagement Cloud session highlights:
- CON6938 Introducing Engagement Cloud—A New Way to Engage your High Value Customers
- CON7120 Channel Surfing—Empowering Multi-channel Service Agents with Engagement Cloud
- CON7150 Delivering Knowledge-Driven Self-Service with Oracle’s Engagement Cloud
- CON6936 Optimizing Engagement to Develop Customer Loyalty (Financial Services)
- THT7121 Oracle Engagement Cloud Sneak Peak
CX Central Exhibition Center
- Visit the vast array of partner kiosks to learn from the experts, whether it's implementation best practices or new software developments to extend your brand and functionality.
The NEW CX Sales Theater
- Be sure to attend the sessions at the NEW CX Sales Theater in the exhibition area on 2/F at Moscone West. The prefix for these Theater sessions is “THT”, e.g. THT7121. Sales topics of interest include sales force automation, sales performance management, partner relationship management, customer data management, your preferred industry solution, sales analytics or the new Engagement Cloud. It’s all here for the taking.
A Unified and Seamless CX Approach—Oracle CX Cloud Suite
We encourage you to learn first hand about integrations, to become familiar with the tools and best practices to migrate from existing CRM systems to Sales Cloud, and to attend the multitude of valuable cross-experience sessions. These sessions will reveal how every experience with your brand matters and why it’s critical to strive for a unified and seamless CX approach.
Sessions will cover topics such as Industry Solutions, CX Platform, Oracle CX Cloud Suite and integrations, the Oracle CX Cloud Marketplace, social CRM, CX Cloud for Midsize, and Cloud user experience.
Attend a Fireside Chat with Oracle Sales Cloud and CPQ Cloud Product Management Team
- MTE6318 Hear from Oracle product experts from Sales and CPQ in an informal Fireside Chat format; this is a great way to wrap up the conference on Thursday afternoon.
The San Francisco Experience—Networking and Entertainment
San Francisco is the host city for Oracle OpenWorld. Top attractions include the Golden Gate Bridge, Alcatraz, the famous Cable Cars, California Academy of Sciences, and Fisherman’s Wharf.
Be sure to set aside some time with colleagues or new friends to experience this beautiful city.
See you in San Francisco!