Feed aggregator

Notes from a long trip, July 19, 2016

DBMS2 - Tue, 2016-07-19 20:34

For starters:

  • 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.

Categories: Other

Create 12c CDB using dbca or sqlplus ???

Michael Dinh - Tue, 2016-07-19 17:27

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?

$ 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

$ cat /etc/oratab

$ 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.

$ 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

$ cat /etc/oratab
#Backup file is  /u01/app/ line added by Agent
cdb12c:/u01/app/oracle/product/          # line added by Agent

$ sqlplus / as sysdba
SQL*Plus: Release 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 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show con_name

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                               VALID
CDB12C    APEX         Oracle Application Express                         VALID
CDB12C    OLS          Oracle Label Security                               VALID
CDB12C    SDO          Spatial                                             VALID
CDB12C    ORDIM        Oracle Multimedia                                   VALID
CDB12C    CONTEXT      Oracle Text                                         VALID
CDB12C    OWM          Oracle Workspace Manager                            VALID
CDB12C    XDB          Oracle XML Database                                 VALID
CDB12C    CATALOG      Oracle Database Catalog Views                       VALID
CDB12C    CATPROC      Oracle Database Packages and Types                     VALID
CDB12C    JAVAVM       JServer JAVA Virtual Machine                        VALID
CDB12C    XML          Oracle XDK                                          VALID
CDB12C    CATJAVA      Oracle Database Java Packages                       VALID
CDB12C    APS          OLAP Analytic Workspace                             VALID
CDB12C    XOQ          Oracle OLAP API                                     VALID
CDB12C    RAC          Oracle Real Application Clusters                     OPTION OFF

16 rows selected.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Manually created CDB.
$ . oraenv <<< tmnt ORACLE_SID = [cdb12c] ? The Oracle base remains unchanged with value /u01/app/oracle 

$ sqlplus / as sysdba SQL*Plus: Release 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 - 64bit Production 
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> show con_name

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                                 VALID
TMNT      CATALOG      Oracle Database Catalog Views                       VALID
TMNT      CATPROC      Oracle Database Packages and Types                     VALID

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Extending Oracle SaaS with Oracle Application Builder Cloud Service - Simplified PaaS for SaaS

Shay Shmeltzer - Tue, 2016-07-19 16:18

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.

Creating Oracle ABCS application connected to Oracle SaaS

Embedding Oracle Application Builder Cloud Service Apps in Oracle Sales Cloud

<span id="XinhaEditingPostion"></span>

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! 

Categories: Development

July 2016 Critical Patch Update Released

Oracle Security Team - Tue, 2016-07-19 14:51

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).

Critical Patch Update for July 2016 Now Available

Steven Chan - Tue, 2016-07-19 14:45

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
References Related Articles

Categories: APPS Blogs

The DBA Best Practices Series Part 3- Reducing Organizational Risk

Chris Foot - Tue, 2016-07-19 13:55

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.

Mapping columns from two tables ,if match replace with another string

Tom Kyte - Tue, 2016-07-19 13:46
Hi Tom, I have a question?could you assist regarding this issue? 1. I have two tables are order table and product table. 2. order table containing two columns are order test and order app.the column data format is order test ...
Categories: DBA Blogs

SQL Injections

Tom Kyte - Tue, 2016-07-19 13:46
Hi Tom, 1)What is the sql injection,And how to solve sql injection problems with an example program tom?
Categories: DBA Blogs

Tom Kyte's books

Tom Kyte - Tue, 2016-07-19 13:46
Hi Tom, I have some of your fine Oracle books. Effective Oracle by design and Expert Oracle Database Architecture (latest version). I prefer reading on an ipad rather than carrying them around with me. Is there a PDF version of these books? Do ...
Categories: DBA Blogs

Converting Row to Column and Vice-versa

Tom Kyte - Tue, 2016-07-19 13:46
Hi Tom, I have a table Assigned_Task. ENAME JANUARY FEBRUARY MARCH APRIL ------ -------- -------- ------ ------ RASHMI 20 25 30 05 SOUMYA 11 21 09 15 BISWA 17 33 19 00 I want the output as below format: M...
Categories: DBA Blogs

Unique value in Oracle Collection variable

Tom Kyte - Tue, 2016-07-19 13:46
Hi team, I have one doubt on oracle collection while implementing on Scenario in my assignment. We need to have collection variable column (vARRAYS) inside a Table , Sample table structure looks like below id name list 1 ABC varra...
Categories: DBA Blogs

Alternatives for to_char(dt, 'DAY')

Tom Kyte - Tue, 2016-07-19 13:46
--->A simple SQL issue that I faced few days back. We normally perform some executions on weekends(SATURDAY or SUNDAY) like some sort of cleaning activity,stats gathering,partition creation etc. Please take caution If your are planning to achieve ...
Categories: DBA Blogs

Links for 2016-07-18 [del.icio.us]

Categories: DBA Blogs

The New Ask Tom

Tom Kyte - Mon, 2016-07-18 19:26
Why do parts of the new Ask Tom appear in another language? e.g. on the list of questions asked previously: Kedd Februar 18, 2003 (H. Feb 17, 2003, 0 days old) Thanks.
Categories: DBA Blogs

pivot data into named columns

Tom Kyte - Mon, 2016-07-18 19:26
Hi, I have a table that looks like the following PHOTOID PHOTO PRODUCT_ID 1 BLOB 123 2 BLOB 123 3 BLOB 123 4 BLOB 123 5 BLOB 123 6 BLOB 124 7 BLOB 124 8 BLOB 125 9 BLOB 126 10 BLOB 126 11 BLOB 126 12 BLOB 126 13 BLOB 126 each PRODUC...
Categories: DBA Blogs

Code enchancement

Tom Kyte - Mon, 2016-07-18 19:26
Hello Chris Saxon, I have a below table structure. CREATE TABLE "PEOPLE" ( "PERSON_ID" NUMBER, "GIVEN_NAME" VARCHAR2(100), "CATEGORY" number(50) ) INSERT INTO people VALUES(1,Connor,1001); / INSERT INTO people VALU...
Categories: DBA Blogs

difference between soft parse and hard parse

Tom Kyte - Mon, 2016-07-18 19:26
Hi Tom Can you explain briefly the difference between soft and hard parse? cheers
Categories: DBA Blogs

Time conversion

Tom Kyte - Mon, 2016-07-18 19:26
Hi Team, Please let me know how we can convert <b>14-JUL-2016 17:11:05 PM</b> into 1<b>7:11:05 or 05:11:05 PM only</b> in Oracle. Regards, Atin
Categories: DBA Blogs

Why it is difficult to scale oracle

Tom Kyte - Mon, 2016-07-18 19:26
Why it is difficult to scale oracle database. Thanks!!
Categories: DBA Blogs

CX Sales—It’s all about Modern Selling at Oracle OpenWorld 2016

Linda Fishman Hoyle - Mon, 2016-07-18 17:53

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. 

Next Steps

Registration is now open. Visit Oracle OpenWorld 2016 for information on CX Sales session and other details!

See what attendees are already saying about Oracle OpenWorld Sales Track and more by joining the conversation on social media: Twitter, #oow16, Facebook, LinkedIn, blog.

See you in San Francisco!


Subscribe to Oracle FAQ aggregator