Feed aggregator

SQL loader not loading if column value in multiple lines and value enclosed in double quotes.

Tom Kyte - Thu, 2017-03-02 11:06
hi , when I am loading data for one column value speeded in multiple columns and its failed. Here is the example and syntax for control file,record failing due to values in multiple lines for DESCRIPTION column "0","test0","123235","testitem0"...
Categories: DBA Blogs

In APEX, I am trying to write an output text file.

Tom Kyte - Thu, 2017-03-02 11:06
In APEX, I am trying to write an output text file. I keep getting ORA-29280 Invalid directory path even though I specify paths where I do have write access. *Maybe* I need to have a file browse to find the output directory. Is there a file browse ...
Categories: DBA Blogs

Connecting MS Access to Oracle

Tom Kyte - Thu, 2017-03-02 11:06
I have a Windows 8.1 machine with Access 2013. I am trying to connect to an Oracle database. I installed Oracle instant client When I create a data source using Microsoft ODBC for Oracle (driver: MSORCL32.dll), I get an ORA-01019 error. W...
Categories: DBA Blogs

spfile and pfile

Tom Kyte - Thu, 2017-03-02 11:06
Unfortunately during the testing of spfile and pfile, I have deleted the both files spfile and pfile, now database does not start ?? How to solve this issue, please help me
Categories: DBA Blogs


Tom Kyte - Thu, 2017-03-02 11:06
Hi TOM, Please go through the following and i have posted my question at the bottom : SQL> CREATE TABLESPACE ts01 DATAFILE 'd:\ts01.dbf' SIZE 2000k uniform size 40k autoextend on; SQL> SELECT initial_extent,next_extent,extent_management, a...
Categories: DBA Blogs

know if enabling row movement and shrink compact will be safe

Tom Kyte - Thu, 2017-03-02 11:06
Hello, I am reading about enabling row movement, in order to shrink space. One one thread, Tom answered this : ?Is there anything wrong on enabling row moevement? Only you can answer that, do you have any application that expects rowid to b...
Categories: DBA Blogs

12.2 is Available For Download For Linux And Solaris

Pete Finnigan - Thu, 2017-03-02 11:06
The Oracle database 12.2 has been available on the cloud for some time but it has not been available for download so that you can install it on your own servers or virtual Machines. You can download from OTN or....[Read More]

Posted by Pete On 02/03/17 At 09:10 AM

Categories: Security Blogs

Great Conversations at the PaaS Partner Community Forum #OAUX #PaaSForum

Usable Apps - Thu, 2017-03-02 06:00

Gift of the Gab* Hits Croatia

Chatbots and conversational UIs are HOT. So I am excited to share that Oracle Applications User Experience will be at the PaaS Partner Community Forum 2017 in Split, Croatia in March and showing off some chatbot and conversational UI PaaS4SaaS goodness as part of our user experience sizzle showcase.

Conversational UI at PaaS Community Forum

See how chatbots can provide a great user experience for SaaS users with our PaaS4SaaS guidance.

Accelerate into the Oracle Cloud

We'll also be showing off our latest UI accelerator kits (the Rapid Development Kits to you) that partners can use to design and deliver mobile cloud solutions using Oracle ADF, Oracle MAF, or Oracle JET. See you there for a chat about that, too!

We'd also love to talk to any partners and developers about typical conversational UI use cases, what they need to design great solutions, or indeed how we can enable the Oracle Partner ecosystem (that means startups too!) to easily design and build cloud solutions using PaaS4SaaS with a rocking UX that will win business.

Make a Date with OAUX 

Check out the session times on the agenda (or swing by our demo station any time):

The “Millennials Literally Prefer To...” User Experience Showcase (Monday, 27-MAR-2017)

Did you know that millennials would rather bank their money with a digital brand rather than a traditional financial institution? That chatbot messaging apps usage has overtaken social networks? That users demand a visual evolution of their user experience (UX) but yet UX doesn’t actually even need a visual UI? Come along to the Oracle Applications User Experience (OAUX) showcase and see how you can align with today’s user needs using Oracle technology and OAUX enablement for Oracle Partners. Millennials/Perennials welcome.

Right Tools for the Right Job: PaaS4SaaS User Experience Rapid Development Kits (Wednesday, 29-MAR-2017)

See how using the free UI accelerator kits from the Oracle Applications User Experience team enables you to design, build, and deploy winning mobile solutions in the Oracle Cloud using Oracle ADF and Oracle MAF. Hear how our Rapid Development Kits (RDKs) based on Oracle technology and OAUX Design Patterns have enabled Oracle SaaS and PaaS Partners to win business, and what's coming with Oracle JET and more.

* Oh, gift of the gab?

Definition: The ability to speak easily and confidently in a way that makes people want to listen to you and believe you.

As in: "She's got the gift of the gab - she should work in sales and marketing." (Source: Cambridge Dictionary)

An Irish specialty. 

More Information 

PaaS Community Forum Agenda Registration

Oracle Applications User Experience Rapid Development Kits

Runtime version of Node on Oracle Application Container Cloud (0.12 vs. 6.9.1) – easy single click upgrade

Amis Blog - Wed, 2017-03-01 23:32

Yesterday, I create a new application on Oracle Application Container Cloud. The application type is Node (fka Node.js), so the container type I had created was Node – rather than PHP or Java SE, the other two options currently available to me. I was a little dismayed to learn that the runtime Node version that my container was created with was (still) 0.12.17. I had assumed that by now ACCS would have moved to a more recent version of Node.

Today, after a little closer inspection, I realized that upgrading the runtime [version of Node]is actually very simple to do on ACCS. Go to the Administration tab in the application overview.


Two later versions for the Node runtime are listed – 4.6.1 and 6.9.1. Now we are talking! I can simply click on the Update button to have the runtime upgraded. I can then choose between the fast update, with some brief downtime, or the rolling upgrade that will not affect the service of my application – and take longer to complete.


I click on Restart. The UI informs me of the current action:


And I can track the in progress activity:


The overall upgrade took several minutes to complete – somewhat longer still than I had expected. However, it took me not more effort than clicking a button. And it did not impact my consumers. All in all, pretty smooth. And now I am on v6.9.1, which is pretty up to date.

I am not sure whether during the initial creation of the application I had the option to start out with this recent version of Node, rather than the fairly old v0.12 that was now provisioned initially. If so, I missed it completely. Then it should be made more obvious. If I did not get the choice, then I believe that a missed opportunity that Oracle may want to add to this cloud service.

The post Runtime version of Node on Oracle Application Container Cloud (0.12 vs. 6.9.1) – easy single click upgrade appeared first on AMIS Oracle and Java Blog.

DBMS_SCHEDULER Job only inserting rows once

Tom Kyte - Wed, 2017-03-01 16:46
I have created a job using dbms_scheduler. Following is my code to create the schedule, program & job : <code> begin dbms_scheduler.create_schedule ( Schedule_Name => 'test_schedule1', Repeat_interval => 'FREQ=MINUTELY; INTERVAL=2', Com...
Categories: DBA Blogs

Unable to open the database: ORA-01157: cannot identify/lock data file

Tom Kyte - Wed, 2017-03-01 16:46
first run the command startup nomount, done, then run the query, alter database mount, done, also open the control files, then run the query as: ALTER DATABASE OPEN, gives the following issue as: SQL> alter database open; alter database open * E...
Categories: DBA Blogs

Rolling sum for the past 12 months

Tom Kyte - Wed, 2017-03-01 16:46
Hi Sir - Trying to calculate the rolling sum or so. When create table tbl1 ( year number, month varchar2(3), col1 varchar2(10), col2 varchar2 (20), amount number) I need to list the values of col1, col2 along with the value as the below calculati...
Categories: DBA Blogs

extract DDL

Tom Kyte - Wed, 2017-03-01 16:46
I would like to extract DDL of indexes to store it outside the database. The purpose of this effort is to save the DDL to use it on fly when we need. I could use export/import tool but it requires editing when we want to run the text from SQL. I am p...
Categories: DBA Blogs

xmlquery to update more than 2426 nodes in XML

Tom Kyte - Wed, 2017-03-01 16:46
Hi, I have a scenario to update more than 2500 nodes in an XML. When i try to update more than 2426 nodes, I am getting an error as given below. ORA-19112: error raised during evaluation: XVM-00004: internal error "code buffer overflow". ...
Categories: DBA Blogs

Getting date time stamp difference in hours , minutes & seconds.

Tom Kyte - Wed, 2017-03-01 16:46
Hi Team, Could you please help me in understanding how we can find the difference between 2 date time stamp columns of a table to be returned in Hours , minutes & seconds ? Ex: I do have a table A with three columns in it with C1 as the pri...
Categories: DBA Blogs

The Workshop Integrates Collaboration and Business Intelligence in the Cloud to Boost Efficiency, Decision-Making, and Client Retention

WebCenter Team - Wed, 2017-03-01 12:17
        Oracle Customer Success 

The Workshop

The Workshop is a Spanish IT consulting firm that specializes in integrating business models, innovation, and technology to deliver business intelligence solutions that improve processes and operations. It services mainly operations- and efficiency-focused businesses in the retail, transportation, and manufacturing sectors.

  • Implement a cloud business intelligence platform that enables the IT company to make better business decisions in real time, and offer it to retail, transportation, and manufacturing clients to enable them to optimize their processes and operations
  • Improve the workflow, efficiency, and effectiveness of the company’s corporate communications and client interactions by implementing a collaborative platform to draft, review, approve, send, and track documents
  • Implemented and integrated Oracle Documents Cloud Service and Oracle Business Intelligence to deliver a user-friendly, powerful, and complete performance dashboard—combining company KPIs, stock levels, department performance, documents approval, to-do lists, and conversations—to retail, transportation, and manufacturing clients, transforming the company’s platform into an indispensable tool for clients and boosting retention
  • Provided real-time business intelligence to clients, enabling them to easily analyze data from multiple sources—including mobile devices, GPS providers, and databases—to make agile, informed business decisions, such as rerouting a bus away from a congested area to stay on schedule or moving stock from storage to store-front to meet demand
"We considered EMC, OpenText, Alfresco, and Google, but opted for Oracle Documents Cloud Service, integrating it with Business Intelligence because it best enables us to boost our company’s efficiency and to offer an indispensable added-value platform to our clients." — Eduard Romay, Accounts Director, The Workshop

Read the entire customer case study to learn more!

Oracle Java Cloud Upgrade to

Andrejus Baranovski - Wed, 2017-03-01 11:51
We finished upgrade of our production Oracle Java Cloud instance to This allows us to use new ADF BC REST features (16.5.2 What You May Need to Know About Versioning the ADF REST Framework).

Upgrade to newer version in Oracle Cloud is similar to on-premise upgrade. We need to create new service instance for software release and later re-deploy our app, re-configure data source and setup security mappings: instance is created in same way as it was before:

Instance is created in three simple steps, last step is just to review configuration:

Give it some 10 minutes to initialize:

And environment is initialized - very simple and much more easier than to configure it by yourself on premise:

We can verify in Cloud EM - JRF is installed, this means it includes full ADF support:

Are MicroServices the Death of BPM and Case Management?

Jan Kettenis - Wed, 2017-03-01 10:22
When reading about MicroServices you could get the impression that orchestrated business processes or even case management applications will soon become legacy. I seriously doubt that, considering the challenges you will face with creating a landscape of MicroServices that will be able to support some of the characteristics that gave birth to BPM and Case Management in the first place. Also, Martin Fowler's primary guideline concerning MicroServices is "don't even consider MicroServices unless you have a system that's too complex to manage as a monolith". In the following I discuss the issues you might face with Business Process and Case Management in a pure MicroServices architecture. My conclusion being that MicroServices will not be the death of BPMN or Case Management. On the contrary, it probably is going to help delivering on some of their promises we so far seem not always be able to deliver upon.

Business Processes and Cases Are Not MicroServicesLet's face it, BPM is about (stateful) orchestration. MicroServices are supposed to be stateless, and its business capability should not depend on others to complete its work, which makes it like the opposite. In BPMN the order in which activities are executed is prescribed or 'orchestrated' as we say, by 'flows' that go from one point to another. The de facto standard language to express a BPM processes is BPMN, which visualizes this explicitly. With each step the state of the complete flow can be persisted. Service calls should be synchronous when successful completion of the process is dependent on the response, and then errors are handled by the process. In contrast the MicroServices 'design for failure' principle makes them more about 'choreography' and as loosely coupled as possible. Rather than making the working of a MicroService dependent on a synchronous call to another service, communication preferably is based on events. By definition there is no such thing as persisting the 'state of a process', and no over-arching process to handle errors.

Unlike BPMN, Case Management is about choreography, but - much more than a number of interacting MicroServices - still predictable in that you know up-front which type activities may be involved, and the rules that determine this. Similar to BPMN, with CMMN you can visualize this to some extent. And similar to BPM also the state of a case is persisted, supporting that you can see what has been done by whom, what the current running activities are, and - based on the model and the rules - you can predict what might happen next. A successful completion of a case depends upon the completion of the individual activities. So in spite of its characteristic of choreography also Case Management contrasts MicroServices in more than one way.

MicroService ChallengesWhen thinking about the highly flexible, however for the observer often unpredictable flow of events in case of a MicroServices architecture, where the completion of an instance of one MicroService can trigger any number of instances of other MicroServices, you start to realize some of the challenges you will face with business processes that are only supported by MicroServices including - but not limited to - the following.
Process/Case IntrospectionAs stated before, one thing a business process and case management support is that you can introspect the state of the process or case. Where is it, what has already happened, and what will/might happen next? To achieve the same with MicroServices you will have to realize some central, coordinating MicroService or Aggregator that somehow has to be fed with the state of MicroService executions, can correlate them in some way, and present them in a context that can be understood by the user. For example, in case of a complex order handling business process (that can span hours our days) this implies that it is able to correlate MicroService executions using some common business indicator like an order id. This implies a dependency of this central MicroService on the other ones to publish the states of their execution with a reference to the order id. That introduces some interesting challenges regarding how to define the bounded context of such a central MicroService and how to implement the anti-corruption layer to make the entities of the individual MicroServices non-intrusive to that of the central one.

But let's ignore that for now. For this central MicroService to be able to present this state to the user so that he/she understands what happened when, why, by whom or what, and what might happen next, it must have some notion of a 'business process' (or case). It might be my lack of imagination, but I cannot picture how this can work as there is no central coordinator to rule them all. A concrete example from my practice is a Move Natural Person process in a bank. Next to a bank account this person might also have a credit card, a mortgage, and several insurances. Some of these product can be moved by just changing the address, but you cannot do that with a mortgage for example. For a bank moving a person or organization is one of the more complex processes, and whenever a customer calls to inquire what the status is, it is imperative for the bank employee to have this overall view. How to know that all relevant MicroServices have been initiated? Of course, I can picture some solution where all MicroServices have to publish events to some central "hub" and from there support some navigation to dashboards of the individual MicroServices, But I also start to see some sort of a dependency that you would try to avoid in a MicroServices architecture.
Process/Case OperationOperations will have a similar problem as the business has when they have to operate the process or case. If a process is stuck from a technical perspective, in which MicroService is that? Practically also this type of concern can only be addressed when to some extend there is a sort of common way to log errors, collect those and present them in a consolidated way. Also something that is in conflict with the principle of decentralization, as each MicroService is supposed to be operated independently.
Process/Case Modeling and TestingAnd what about modeling and testing a process or case? Capturing how a case may evolve over time in CMMN is already more difficult for the reader to understand than a BPMN process design. But how a process would unfold in a pure MicroServices environment you can only understand if you would model that in some similar way. But in a pure MicroServices architecture that does not seem to make any sense. And if you don't model it you surely will have difficulties testing it.
Authorization & AuthenticationAnother challenge I would like to point out is authorization and authentication. In BPMN there are swimlanes that correspond to roles that you can assign people to. By using a central repository of these roles you can implement a consistent way of authentication and authorization. In Case Management there are similar concepts (e.g. knowledge workers). How to implement this for a process only consisting of MicroServices when this implies a centralized authentication and authorization model?

Granted, MicroServices is relatively new, still in the hype phase, and over time some of these challenges will be addressed. This will result in new patterns, and frameworks and tools to support that. But I seriously doubt this will ever address all the requirements that are naturally addressed by BPM or Case Management. So over time I believe both will survive the MicroServices hype, although I see Case Management gaining ground over BPM.

MicroServices Values for BPM and Case ManagementHowever, all this does not mean there is no value in adapting at least some of the principles related to MicroServices to BPM and Case Management applications. I can see how it could address some of the issues I faced with processes that are almost too big to handle, and issues with reuse of services and the impact that had on agility. Since then I much more tend to:
  • Design and implement sub-processes as deployable units of their own.
  • Push more of the other logic to a deployable unit of its own than I already did.
  • Let data models be less intrusive to integrations (i.e. chose the Anti-Corruption pattern with small Bounded Contexts over the Conformist pattern), and address data mapping challenges in the (anti-corruption layer of the) individual services rather than in some integration layer (smart endpoints / dumb pipes).
  • Apply the Tolerant Reader pattern more that I already did
  • Copy and paste code if that prevents unnecessary impact of a change on some shared component.
And where useful and possible one can implement the services consumed by the business process or case as MicroServices and make the process and these services more loosely coupled. But that I already did. The mantra of 'do one thing and do it well' specifically appeals to me. I always try to prevent creating any service (of Java class for that matter) for which I have to use the word "and" to describe what it does.

New Performance Analytics Release

Rittman Mead Consulting - Wed, 2017-03-01 09:00

Poor performance is one of the most common complaints we hear upon arrival to customer sites, and often for good reason. When users have time to “make the rounds” before the system returns a result (if it returns a result at all), they have the right to be frustrated.

Unfortunately, tracking down the origins of performance issues can be extremely difficult, as the root cause could be one or more problems across several distinct systems. Without a comprehensive view of the complete technology stack, an administrator will effectively be guessing.

But we are all in the business of analytics. We should be taking an analytical approach to drive our decisions, and provide evidence to support them. Performance data should be collected, investigated, and then acted upon. But an analytical approach raises two distinct questions, “What data can we collect that will help us identify performance issues, and once found, what actions can we take”?

Enter Performance Analytics

Performance Analytics is an application that collects data from all layers of the stack in your environment, and makes it readily available for study and investigation. By collecting data from OBIEE Usage Tracking, operating system metrics, database sessions, and a myriad of other sources, our application provides administrators with an all-encompassing view of their system. It has never been easier to identify the causes of poor performance.

However, simply identifying a cause of poor performance isn’t all that’s required. In fact, it’s almost useless without knowing how to resolve the issue. Rittman Mead has expertise ranging from databases and data warehouses to front end browser applications, and everything in between. Our team will help you understand the problems discovered by Performance Analytics and show you how to fix them.

With the newest release of Performance Analytics, improving the performance of your BI ecosystem is easier than ever. No longer will your users sit around waiting for reports, no longer will you need to guess at configuration settings, and no longer will you be left with no leads to investigate when users desire a better experience.

New Features Simple and Lightweight Installation

Performance Analytics is now deployed using Docker, requiring absolutely no software installation on any machine other than the monitoring server.

Upgraded and enhanced software.

The open source technologies included in Performance Analytics have come a long way since its inception, and this release provides their latest and greatest versions, as well as our own improvements that increase performance and reliability.

Alerts and Notifications.

Receive notifications based on failed OBIEE system components, a violated performance threshold, or any other identifiable condition found in your data. Be made aware of adverse performance conditions the instant they occur.
And many more...

Learn More

We will be releasing more exciting news about Performance Analytics over the following weeks, so be sure to subscribe to our blog and newsletter to stay up to date!

Visit our Performance Analytics page here.
To request a demo or ask any questions about Performance Analytics, call or email us:

P (US): (888) 631-1410
E (US): info@rittmanmead.com
P (UK): +44 (0) 1273 911 268
E (UK): info@rittmanmead.com
Categories: BI & Warehousing

Oracle and Pluralsight Bring New Cloud Learning and Enablement Resources to Developers

Oracle Press Releases - Wed, 2017-03-01 07:00
Press Release
Oracle and Pluralsight Bring New Cloud Learning and Enablement Resources to Developers Pluralsight Developer Members to Gain Access to New Oracle Cloud Courses

Redwood Shores, Calif.—Mar 1, 2017

Oracle today announced a new collaboration with Pluralsight, a technology learning platform for software developers and Silver level member of Oracle PartnerNetwork.

Through the collaboration, developers will gain access to three new Oracle learning pathways on the Pluralsight platform including Oracle Cloud: Java Development, Oracle Cloud: Node.js Development and Oracle Cloud: IaaS Foundations. They will also be able to leverage two new Oracle Cloud courses including Oracle Cloud for Developers and Oracle Compute Cloud Service Foundations. The announcement was made at Oracle Code San Francisco, the first of a new global series of developer-focused events.

“Pluralsight has built a rich community and library of content that help developers take their skills to the next level,” said Damien Carey, Senior Vice President, Oracle University. “By expanding Pluralsight’s offering with new Oracle courses, we are providing increased opportunity for developers to learn valuable new skills and techniques to keep up with the latest and ever-changing demands of the software development world.”

Created by industry experts and curated by Pluralsight in collaboration with Oracle University, the Oracle learning pathways and new courses are available in English and will be delivered in all countries where Pluralsight is available. The new courses, designed to empower Oracle developers to advance their skillset, will be offered through Pluralsight’s existing subscription options.

“As the technology landscape evolves at a rapid pace, it’s critical for software developers to continually build their skillset to remain competitive and at the top of their game,” said Pluralsight co-founder and CEO, Aaron Skonnard. “We’re excited to team up with Oracle to activate their community of technology professionals with the tools they need to benchmark and master key skills and continue building next generation technology.”

Contact Info
Scott Thornburg
Kristin Reeves
Blanc & Otus
Mariangel Babbel
About Pluralsight

Pluralsight is an enterprise technology learning platform that delivers a unified, end-to-end learning experience for businesses across the globe. Through a subscription service, companies are empowered to move at the speed of technology, increasing proficiency, innovation and efficiency. Founded in 2004 and trusted by Fortune 500 companies, Pluralsight provides members with on-demand access to a digital ecosystem of learning tools, including adaptive skill tests, directed learning paths, expert-authored courses, interactive labs and live mentoring. For more information, visit www.pluralsight.com.

About Oracle Cloud

Oracle Cloud is the industry’s broadest and most integrated public cloud, offering a complete range of services across SaaS, PaaS, and IaaS. It supports new cloud environments, existing ones, and hybrid, and all workloads, developers, and data. The Oracle Cloud delivers nearly 1,000 SaaS applications and 50 enterprise-class PaaS and IaaS services to customers in more than 195 countries around the world and supports 55 billion transactions each day. For more information, please visit us at http://cloud.oracle.com.

* Performance comparison to AWS RDS db.m4.10xlarge using Provisioned IOPS storage.

About Oracle PartnerNetwork

Oracle PartnerNetwork (OPN) is Oracle's partner program that provides partners with a differentiated advantage to develop, sell and implement Oracle solutions. OPN offers resources to train and support specialized knowledge of Oracle’s products and solutions and has evolved to recognize Oracle’s growing product portfolio, partner base and business opportunity. Key to the latest enhancements to OPN is the ability for partners to be recognized and rewarded for their investment in Oracle Cloud. Partners engaging with Oracle will be able to differentiate their Oracle Cloud expertise and success with customers through the OPN Cloud program – an innovative program that complements existing OPN program levels with tiers of recognition and progressive benefits for partners working with Oracle Cloud. To find out more visit: http://www.oracle.com/partners.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Scott Thornburg

  • +1.415.816.8844

Kristin Reeves

  • +1.415.856.5145

Mariangel Babbel

  • +1.801.784.9150


Subscribe to Oracle FAQ aggregator