Feed aggregator

Updating records with many-to-1 linked table relationship

Tom Kyte - Thu, 2017-09-28 10:46
I have an MS_ACCESS Query to convert to Oracle SQL. Access Query <code>UPDATE target_table T INNER JOIN source_table S ON T.linkcolumn = S.linkColumn SET T.field1 = S.field1, T.field2 = S.field2, T.field3 = S.field3;</code> Note: T...
Categories: DBA Blogs

Native dynamic sql - Refcursor

Tom Kyte - Thu, 2017-09-28 10:46
Tom, Here is an example...that i want to change one function to avoid redundant information. create or replace package p_ref_cursor is type ret_ref_cursor is ref cursor; end p_ref_cursor; / drop table "tab1"; create table "tab1" ...
Categories: DBA Blogs

ORA-06502 with CHAR parameter. What am I missing?

Tom Kyte - Thu, 2017-09-28 10:46
Sorry to bother you with a ORA-06502 error. But I'm not understanding this behavior. As I saw, the length fits (see the dbms_output in result showing that the length is 16). The only thing i can think is that in the procedure proc, pl/sql is...
Categories: DBA Blogs

Windows and .NET sessions at Openworld

Christian Shay - Thu, 2017-09-28 09:25
Interested in Oracle Database on Windows performance and security, Active Directory, or .NET development topics? At Oracle Openworld SF next week there's a host of Windows and .NET sessions, hands on labs, and demogrounds for you to check out.

Here's the list of Windows sessions and demogrounds with times.
And here's the list of .NET development sessions, hands on lab, and demogrounds with times.

Use schedule builder to reserve your seats in any of those sessions before they fill up.

You can also visit us at our booth at the Moscone West "Exchange" (formerly known as "Demogrounds"). We'll have .NET experts as well as Oracle Database on Windows experts standing by to answer your questions or to give you a demo.

You can find us using this handy dandy map (we are on the left side of the exhibition hall with other Oracle application development booths) - click the image to enlarge:

See you at the show!!!


Announcing the dbi OpenDB Appliance

Yann Neuhaus - Thu, 2017-09-28 07:04

As already announced on Twitter and LinkedIn here is the blog post to describe our OpenDB appliance in more detail. I am sure you wonder what this is about so let me explain why we are doing this. What we do see day by day at our customers is that more and more databases get consolidated on to a VMWare deployment. This is not only true for the smaller ones of those but also for the critical, potentially much bigger ones. What makes it complicated, especially for smaller companies that do not necessarily have the knowhow for the specific database, is that you need to apply the best practices not only to the database deployment but also to the operating system and the VMWare deployment. But even if you have this already in place: Do you know how to deploy the PostgeSQL binaries, how to setup a PostgreSQL instance, how to monitor and how to backup and restore all that? Do you know how to do this with MySQL/MariaDB, MongoDB, Cassandra? If your answer to this is no but you need to have a PostgreSQL/MySQL/MariaDB/MongoDB/Cassandra instance ready quite fast then the dbi OpenDB Appliance might be the solution for you. Let’s dig into some details.

OpenDB-logo

A typical use case: You are forced to support an application which is running on a specific database. What do you do? Quickly setup a Linux VM, download the installer, clicking next, next, next and hopefully make the application connect to what you just installed and then cross your fingers and hope that never ever something goes wrong? You laugh? There are deployments out there which got setup in exactly this way. Another option would be to hire someone who is experienced in that area. This will not help you either as you’d at least need two people (because people tend to want to go to holidays from time to time). The next option would be to work together with external consultants which probably will work as long as you work with the right ones. Completely outsourcing the stuff is another option (or even going to the cloud), if you want to do that. With the dbi OpenDB Appliance you’ll get another option: We deliver a fully pre-configured VMWare based virtual machine image which you can easily plug into your existing VMWare landscape. Can that work? Let me explain what you would get:

As said just before you get an image which you can import into your VMWare ESX. I said this image is pre-configured, what does that mean? Well, when you start it up it boots into a CentOS 7.3 x64 Linux operating system. No magic, I know :) Additionally you’ll get four pre-configured disks:

/       15GB    The Linux operating system
/boot	1GB	The boot images (kernels)
/u01	50GB	All files belonging to the OpenDB itself
                All required DMK packages
                All source files (PostgreSQL, MariaDB, MongoDB, Cassandra)
                The Linux yum repositories
                The HOMEs of all product installations
                The admin directories for the initialized products
/u02	10GB	The data files belonging to the initialized products
/u03	10GB	The redo/wal files belonging to the initialized products
/u04	10GB	Backups

You are not supposed to touch the root, /boot and /u01 partitions but of course you will be able to resize /u02 to /u04. The 10GB provided initially are just meant as minimum setup. Resize your VMWare disk images (vmdks) and the dbi OpenDB command line utility offers you to resize the file systems as well with just a single call. At this point you probably wonder what the dbi OpenDB command line utility is about. In short this is a wrapper around our various DMK packages. Using one of the various DMK packages you can deploy and monitor databases even today. The command line utility makes use of that and wraps around the various DMKs. The interface is menu driven to make it as easy as possible for you and helps you with initializing the appliance (setting the hostname, network configuration and disk resizing). In addition you can install the products we support and create database instances on top of that without knowing the details. We take care of implementing the best practices in the background (kernel settings, file system layout, initialization parameters, …). But that is not all: We’ll go a step further and implement monitoring, alerting and backup procedures as well. The idea is that you really do not need to take care of such things: It just comes when you setup a product.

To give you an idea you’ll get something like this when you fire up the command line utility:

==============================================================================================
=                                                                                            =
=                                                                                            =
=       _ _    _    ___                 ___  ___     _             _ _                       =
=    __| | |__(_)  / _ \ _ __  ___ _ _ |   \| _ )   /_\  _ __ _ __| (_)__ _ _ _  __ ___      =
=   / _  | '_ \ | | (_) | '_ \/ -_) ' \| |) | _ \  / _ \| '_ \ '_ \ | / _  | ' \/ _/ -_)     =
=   \__,_|_.__/_|  \___/| .__/\___|_||_|___/|___/ /_/ \_\ .__/ .__/_|_\__,_|_||_\__\___|     =
=                       |_|                             |_|  |_|                             =
=                                                                                            =
=                                                                                            =
=      Please make a selection from the menu below (type 'q' to exit):                       =
=                                                                                            =
=      1. Deploy a database home                                                             =
=      2. List the deployed database homes                                                   =
=      3. Setup a database instance                                                          =
=      4. List the deployed database instances                                               =
=                                                                                            =
=     10. Stop and remove a database instance                                                =
=     11. Remove a database home                                                             =
=                                                                                            =
=                                                                                            =
=     99. Initialize the appliance                                                           =
=                                                                                            =
=                                                                                            =
==============================================================================================
 
 Your input please: 

You would start by “Initialize the appliance” to set your preferred host name, to initialize the network and to provide the monitoring credentials. Once done you can go on and start deploying product homes (e.g. PostgreSQL) and instances on top of that. Of course you can deploy multiple instances on the same home and you can install several homes of the same product version.

What do we mean by a “product”? A product is what we support with a specific release of the appliance. Initially this probably will be:

  • PostgreSQL 9.6.5
  • PostgreSQL 9.5.9

So the menu would offer you something like this for deploying the binaries:

==============================================================================================
=                                                                                            =
=                                                                                            =
=       _ _    _    ___                 ___  ___     _             _ _                       =
=    __| | |__(_)  / _ \ _ __  ___ _ _ |   \| _ )   /_\  _ __ _ __| (_)__ _ _ _  __ ___      =
=   / _  | '_ \ | | (_) | '_ \/ -_) ' \| |) | _ \  / _ \| '_ \ '_ \ | / _  | ' \/ _/ -_)     =
=   \__,_|_.__/_|  \___/| .__/\___|_||_|___/|___/ /_/ \_\ .__/ .__/_|_\__,_|_||_\__\___|     =
=                       |_|                             |_|  |_|                             =
=                                                                                            =
=                                                                                            =
=      Please make a selection from the menu below (type 'q' to exit, 'b' to go back):       =
=                                                                                            =
=                                                                                            =
=     000 - PostgreSQL 9.6.5                                                                 =
=     001 - PostgreSQL 9.5.9                                                                 =
=                                                                                            =
=                                                                                            =
==============================================================================================
 
 Your input please: 

Once you have deployed the homes you require you can list them:

==============================================================================================
=                                                                                            =
=                                                                                            =
=       _ _    _    ___                 ___  ___     _             _ _                       =
=    __| | |__(_)  / _ \ _ __  ___ _ _ |   \| _ )   /_\  _ __ _ __| (_)__ _ _ _  __ ___      =
=   / _  | '_ \ | | (_) | '_ \/ -_) ' \| |) | _ \  / _ \| '_ \ '_ \ | / _  | ' \/ _/ -_)     =
=   \__,_|_.__/_|  \___/| .__/\___|_||_|___/|___/ /_/ \_\ .__/ .__/_|_\__,_|_||_\__\___|     =
=                       |_|                             |_|  |_|                             =
=                                                                                            =
=                                                                                            =
=      Please make a selection from the menu below (type 'q' to exit, 'b' to go back):       =
=                                                                                            =
=                                                                                            =
=     The following homes are available for deploying instances on:                          =
=                                                                                            =
=                                                                                            =
=     pg965:/u01/app/opendb/product/PG96/db_5/:dummy:9999:D                                  =
=     PG959:/u01/app/opendb/product/PG95/db_9/:dummy:9999:D                                  =
=     PG959_1:/u01/app/opendb/product/PG95/db_9_0:dummy:9999:D                               =
=     PG965_1:/u01/app/opendb/product/PG96/db_5_0:dummy:9999:D                               =
=                                                                                            =
=                                                                                            =
==============================================================================================
 
 Your input please: 

Here you can see that you can have multiple homes of the same release (two for PostgreSQL 9.6.5 and two for PostgreSQL 9.5.9 in this case). The path and naming for a home follow our best practices and are generated automatically. Having the homes you can start deploying you instances:

==============================================================================================
=                                                                                            =
=                                                                                            =
=       _ _    _    ___                 ___  ___     _             _ _                       =
=    __| | |__(_)  / _ \ _ __  ___ _ _ |   \| _ )   /_\  _ __ _ __| (_)__ _ _ _  __ ___      =
=   / _  | '_ \ | | (_) | '_ \/ -_) ' \| |) | _ \  / _ \| '_ \ '_ \ | / _  | ' \/ _/ -_)     =
=   \__,_|_.__/_|  \___/| .__/\___|_||_|___/|___/ /_/ \_\ .__/ .__/_|_\__,_|_||_\__\___|     =
=                       |_|                             |_|  |_|                             =
=                                                                                            =
=                                                                                            =
=      Please make a selection from the menu below (type 'q' to exit, 'b' to go back):       =
=                                                                                            =
=                                                                                            =
=     Please specify an alias for your new instance                                          =
=       The alias needs to be at least 4 characters                                          =
=       The alias needs to be at most  8 characters                                          =
=                                                                                            =
=                                                                                            =
=                                                                                            =
==============================================================================================
 
 Your input please: MYINST1 

What happens in the background then is that the PostgreSQL cluster is initialized, started and added to the auto start configuration (systemd) so that the instance will properly shutdown when the appliance is stopped and comes up when the appliance is started. Listing the deployed instances is possible, too, of course:

==============================================================================================
=                                                                                            =
=                                                                                            =
=       _ _    _    ___                 ___  ___     _             _ _                       =
=    __| | |__(_)  / _ \ _ __  ___ _ _ |   \| _ )   /_\  _ __ _ __| (_)__ _ _ _  __ ___      =
=   / _  | '_ \ | | (_) | '_ \/ -_) ' \| |) | _ \  / _ \| '_ \ '_ \ | / _  | ' \/ _/ -_)     =
=   \__,_|_.__/_|  \___/| .__/\___|_||_|___/|___/ /_/ \_\ .__/ .__/_|_\__,_|_||_\__\___|     =
=                       |_|                             |_|  |_|                             =
=                                                                                            =
=                                                                                            =
=      Please make a selection from the menu below (type 'q' to exit, 'b' to go back):       =
=                                                                                            =
=                                                                                            =
=     The following instances are currently deployed:                                        =
=                                                                                            =
=                                                                                            =
=     MYINST1:/u01/app/opendb/product/PG96/db_5/:/u02/opendb/pgdata/MYINST1:5432:Y           =
=                                                                                            =
=                                                                                            =
==============================================================================================
 
 Your input please: 

The cronjobs for monitoring, alerting and backup have been created as well:

[opendb@opendb ~]$ crontab -l
00 01 * * * /u01/app/opendb/local/dmk/dmk_postgres/bin/dmk-pg-dump.sh -s MYINST1 -t /u04/opendb/pgdata/MYINST1/dumps >/dev/null 2>&1
58 00 * * * /u01/app/opendb/local/dmk/dmk_postgres/bin/dmk-pg-badger-reports.sh -s MYINST1 >/dev/null 2>&1
*/10 * * * * /u01/app/opendb/local/dmk/dmk_postgres/bin/dmk-check-postgres.sh -s MYINST1 -m  >/dev/null 2>&1

With every new release/update of the appliance we plan to include more products such as MariaDB/MongoDB/Cassandra, provide patch sets for the existing ones and update the Linux operating system. Updates will be delivered as tarballs and the command line utility will take care of the rest, you do not need to worry about that. You can expect updates twice a year.

To visualize this:
OpenDB-big-picture

/u02 will hold all the files that contain your user data. /u03 is there for redo/wal/binlog where required and /u04 is for holding the backups. This is fixed and must not be changed. Independent of which product you choose to deploy you’ll get a combination of pcp (Performance Co-Pilot) and vector to do real time performance monitoring of the appliance (of course configured automatically).

Alerting will be done by a combination of third party (open source) projects and DMK. The tools we’ll use for PostgreSQL will be check_postgres and pgbadger, for example. For the other products we’ll announce what we will use when it will be included in a future release.

In addition to the VMWare template you can have the appliance also in the Hidora Cloud as a pay as you go service (although that is not fully ready).

If you have any questions just send as an email to: opendb[at]dbi-services[dot]com

 

Cet article Announcing the dbi OpenDB Appliance est apparu en premier sur Blog dbi services.

Commonwealth Edison, Baltimore Gas & Electric Awarded the 2017 Oracle Sustainability Innovation Awards

Oracle Press Releases - Thu, 2017-09-28 06:45
Press Release
Commonwealth Edison, Baltimore Gas & Electric Awarded the 2017 Oracle Sustainability Innovation Awards Leading Utility Companies Recognized for Energy Efficiency Programs

Redwood Shores, Calif.—Sep 28, 2017

Oracle today announced that Commonwealth Edison (ComEd) and Baltimore Gas and Electric (BGE) will be presented with the 2017 Oracle Sustainability Innovation Awards at Oracle OpenWorld. The awards recognize customers that are committed to making environmental issues a priority across the enterprise. ComEd and BGE showcased unique ways to advance energy efficiency through innovative green practices using Oracle technology. ComEd leadership was distinguished by earning the 2017 Oracle Chief Sustainability Office of the Year award among all nominations.

“We are inspired by the successes achieved by ComEd and BGE as part of their core commitments to a sustainable future. Both companies have implemented Oracle technologies in a way that improved eco-efficiencies, innovation and transparency,” said Rodger Smith, senior vice president and general manager, Oracle Utilities. “We’re honored to present them with the 2017 Oracle Sustainability Innovation Award during Oracle OpenWorld this year.”

Both companies have made significant impact by employing the Oracle Utilities Opower Energy Efficiency solution. The solution includes Home Energy Reports (HERs) and online web tools that provide customers with information about their energy consumption, thereby encouraging conservation. Since 2009, ComEd has generated over 1.1 TWh in energy savings; BGE has used the program since 2012 to save 420,000 MWh. The two organizations have also successfully implemented Peak Management programs, which encourage customers to reduce their energy consumption when electricity demand is high. Because of this BGE has reduced peak demand by 16 percent for participating customers, and ComEd has reduced Greenhouse gases by 10 percent.

“We’re delighted to be recognized for our commitment to sustainable practices,” said Mark Case, vice president of Regulatory Policy and Strategy for BGE who leads energy efficiency initiatives for Exelon’s utilities. “We’ve seen great success and look forward to continuing to work with Oracle to drive energy efficiency.”

“At ComEd, we believe that meeting the energy needs of today and tomorrow will depend heavily on our ability to collaborate with our customers,” Val Jensen, senior vice president, Customer Operations at ComEd. “Working with Oracle gives us more opportunities to leverage data-driven insights and engage with our customers to drive energy efficiency.”

Contact Info
Valerie Beaudett
Oracle
+1.650.400.7833
valerie.beaudett@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe, and Asia. For more information about Oracle, please visit us at www.oracle.com.

Trademarks

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

Talk to a Press Contact

Valerie Beaudett

  • +1.650.400.7833

Searching wikipedia from the command line

Yann Neuhaus - Thu, 2017-09-28 06:41

Wouldn’t it be nice if you could search wikipedia from the command line? I often need to quickly look up a definition or want to know more about a specific topic when I am working on the command line. So here is how you can do it …

What you need is npm and wikit. On my debian based system I can install both with:

$ sudo apt-get install npm
$ sudo npm install wikit -g
$ sudo ln -s /usr/bin/nodejs /usr/bin/node

The link is to avoid the following issue:

$ wikit postgresql
/usr/bin/env: ‘node’: No such file or directory

For Fedora/RedHat/Centos you should use yum:

$ sudo yum install npm -y
$ sudo npm install wikit -g

Once you have that you can use wikit to query wikipedia (summary):

$ wikit postgresql
 PostgreSQL, often simply Postgres, is an object-relational database management system
 (ORDBMS) with an emphasis on extensibility and standards compliance. As a database
 server, its primary functions are to store data securely and return that data in
 response to requests from other software applications. It can handle workloads ranging
 from small single-machine applications to large Internet-facing applications (or
 for data warehousing) with many concurrent users; on macOS Server, PostgreSQL is
 the default database; and it is also available for Microsoft Windows and Linux (supplied
 in most distributions). PostgreSQL is ACID-compliant and transactional. PostgreSQL
 has updatable views and materialized views, triggers, foreign keys; supports functions
 and stored procedures, and other expandability. PostgreSQL is developed by the PostgreSQL
 Global Development Group, a diverse group of many companies and individual contributors.
 It is free and open-source, released under the terms of the PostgreSQL License,
 a permissive software license.

Cool. When you want to read the output in your default browser instead of the console you can do this as well by adding then “-b” flag:

$ wikit postgresql -b

When you want to open the “disambiguation” page in your browser:

$ wikit postgresql -d

Selection_013

Changing the language is possible as well with the “-lang” switch:

$ wikit --lang de postgresql 
 PostgreSQL (englisch [,pəʊstgɹɛs kjʊ'ɛl]), oft kurz Postgres genannt, ist ein freies,
 objektrelationales Datenbankmanagementsystem (ORDBMS). Seine Entwicklung begann
 in den 1980er Jahren, seit 1997 wird die Software von einer Open-Source-Community
 weiterentwickelt. PostgreSQL ist weitgehend konform mit dem SQL-Standard ANSI-SQL
 2008, d.h. der Großteil der Funktionen ist verfügbar und verhält sich wie definiert.
 PostgreSQL ist vollständig ACID-konform (inklusive der Data Definition Language),
 und unterstützt erweiterbare Datentypen, Operatoren, Funktionen und Aggregate. Obwohl
 sich die Entwicklergemeinde sehr eng an den SQL-Standard hält, gibt es dennoch eine
 Reihe von PostgreSQL-spezifischen Funktionalitäten, wobei in der Dokumentation bei
 jeder Eigenschaft ein Hinweis erfolgt, ob dies dem SQL-Standard entspricht, oder
 ob es sich um eine spezifische Erweiterung handelt. Darüber hinaus verfügt PostgreSQL
 über ein umfangreiches Angebot an Erweiterungen durch Dritthersteller, wie z.B.
 PostGIS zur Verwaltung von Geo-Daten. PostgreSQL ist in den meisten Linux-Distributionen
 enthalten. Apple liefert ab der Version Mac OS X Lion (10.7) PostgreSQL als Standarddatenbank

Quite helpful …

 

Cet article Searching wikipedia from the command line est apparu en premier sur Blog dbi services.

Oracle Applications Cloud User Experience Strategy Day– Directions for User Experience

Amis Blog - Wed, 2017-09-27 18:02

imageToday – Wednesday 27th of September – saw close to 50 people gathering for the OAUX (Oracle Applications User Experience) Strategy Day. Some attendees joined from remote locations on three continents, while most of us had assembled in the UX Spaces Lab at Oracle’s Redwood Shores HQ – equipped with some interesting video and audio equipment.

IMG_9972 Some important themes for this day:

  • The key message of Simplicity, Mobility and Extensibility is continued; simplicity means: a user experience that is to the point, only drawing a user’s attention to relevant items, only presenting meaningful data and allowing a task to be handled most efficiently.

    IMG_9974
    In order to achieve this simplicity, quite a bit of smartness is required: User context interpreted by smart apps lead to Simple UX, with Chat, Voice Input and Conversational UIs.and fully automated processes at the pinnacle. Machine learning is at the heart of this smartness – deriving information from the context, presenting relevant choices en defaults based on both context and historical patterns

    image
  • Enterprise Mobility is a key element in the user experience – with a consistent experience yet tailored to the device (one size does not fit all at all) and the ability to start tasks on one device and continue with them on different devices and a later point in time. The experience should be light on data. Only show the absolute essential information.

    image
  • The latest Oracle Cloud Applications Release – R13 – has some evolution in the UX and UI.

    IMG_9982
  • There is a move away from using icons to interact with the application for navigation – more towards search & notifications. The ability to tailor the look & feel (theming, logo, heading, integrate external UIs) has improved substantially.

    image

  • Conversational UI for the Enterprise is rapidly becoming relevant. Conversational UI for the enterprise complements and replaces current Web&Mobile UI – for quick, simple, mini transaction and smart capture. The OAUX team discerns four categories of interactions that conversational interfaces are initially most likely to be used for: Do (quick decisions, approvals, data submission), Lookup (get information), Go To (use conversation as starting point for a deeplink context rich navigation to a dedicated application component) and Decision Making (provide recommendations and guidance to users).

    Some examples of conversational UIs – low threshold user to system interaction for simple questions,requests, actions and submissions


    image

    Jeremy Ashley introduced the term JIT UI – just in time UI: widgets (buttons, selection lists) that are mixed in with the text based conversational UI (aka chat) to allow easy interaction when relevant; this could also include dynamically generated visualizations for more complex presentation of data.

    The OAUX makes an RDK (Rapid Development Kit) available for Conversational UI – or actually the first half of the RDK – the part that deals with designing the conversational UI. The part about the actual implementation will follow with the launch of the Oracle Intelligent Bot Cloud Service and associated technology and tooling.

    image

    This new RDK can be found at :  https://t.co/m7AuSBJw5J . It contains many guidelines on designing conversations – about how to address users, what information and interaction to provide.

  • Another brand new RDK is soon to be released for Oracle JET – aligned with JET 4.0, that is to be released next week at Oracle OpenWorld 2017. This RDK support development of Oracle JET rich client applications with the same look and feel as the R13 ADF based Oracle SaaS apps. Assuming that there will be a long  period of coexistence between ADF based frontends and Oracle JET powered user interfaces, it seems important to be able to develop an experience in JET that is very similar to the one users already are used to in the existing SaaS applications.


    image

    Additionally, the JET RDK will provide guidelines on how to developer JET applications. These guidelines were created in collaboration between the SaaS foundation and development teams, the JET product development team and the OAUX team. They are primarily targeted at Oracle’s own development teams that embrace JET for building SaaS App components and other developers creating extensions on top of Oracle SaaS. However, these guidelines are very useful for any development team that is using JET for developing any applications. The guidance provided by the RDK resources – as well as potentially the reusable components provided as part of the RDK – embodies best experiences and the intent of the JET team and provides a relevant headstart to teams that otherwise have to invent their own wheels.

    Here is a screenshot of the sample JET application (R13 style) provided with the RDK:

    image

  • Updates – aligned with Cloud Apps Release 13 – are released for MAF and ADF. Go to https://github.com/oracle/apps-cloud-ui-kit to find all resources

    Here is a screenshot of the ADF demo application provided with the ADF RDK:IMG_0013

Some other observations

Any data in a user interface has to be justified. Why should it be there? What will you use it for? What happens if it is not shown? Less is more (or at least: better)

Different generations of users prefer different styles of navigation & interaction; ideally the UX is personalized to cater for that.

An overview of all activities of the OAUX team during Oracle OpenWorld 2017:

image

The post Oracle Applications Cloud User Experience Strategy Day– Directions for User Experience appeared first on AMIS Oracle and Java Blog.

ORA-00060 : Deadlock detected while waiting for resource in Multi-threaded Java Batch process

Tom Kyte - Wed, 2017-09-27 16:26
Hi Tom I have a multi-threaded batch process running on Production that fails due to "ORA-00060 : Deadlock detected while waiting for resource". I am getting following error message: <code>02:25:25,899 [CobolThread 34] ERROR Error executing upd...
Categories: DBA Blogs

Materialized Views: Refresh Statistics History - How can I see data in user_mvref_stmt_stats

Tom Kyte - Wed, 2017-09-27 16:26
Hi Masters, sorry for another question :-) and again a big, big thank You for Your hard work and the answers to our questions!! Could You please have a look into my test case? Some of the statement fail, because I do not have all the privs in l...
Categories: DBA Blogs

Using JSON_TABLE with aggregate functions

Tom Kyte - Wed, 2017-09-27 16:26
Hi Team DB Version: 12.2.0.0.3 On a high level, on successful completion of the scripts (from LiveSQL) you would have: 1) Loaded 10k users data in JSON format in STAGE_USER table. 2) Loaded 500 roles data in JSON format in STAGE_ROLE table. ...
Categories: DBA Blogs

ORA-00937 for aggregate in scalar subquery

Tom Kyte - Wed, 2017-09-27 16:26
<code>HI CAN ANY BODY EXPLAIN IN 1ST QUERY WHY IT IS ERROR BUT IN 2ND QUERY IT GIVES RESULT ? SQL> SELECT SUM(SAL), 2 ( 3 SELECT SUM(SAL) FROM EMP 4 ) 5 FROM EMP; SELECT SUM(SAL) FROM EMP * ERROR at line 3: ORA-00937: n...
Categories: DBA Blogs

Benefits Of Transportation and Logistic Dashboards

Nilesh Jethwa - Wed, 2017-09-27 14:45

Transportation and Logistics Dashboard and KPI benefits

Currently, the industry of transportation and logistics is gaining momentum regarding the use of dashboards. Increasingly, non-technical companies involved in this sector are seeing the advantages of implementing data-driven platforms in their marketing goals.

The most particular change seen is the substantial potential as well as interest from small cities to “smart” cities. For instance, startups are co-creating valuable products with transportation and logistics dashboard providers through modern solutions like the TransportBuzz.

Dashboards for Transportation and Logistics

Dashboards or data-driven platforms are a modern way of simplifying how organizations control and manage their access to assets like services and data. Usually, that directs them to the following advantages:

  • More revenue channels.
  • Increased brand awareness and wider reach.
  • External sources that facilitates open innovation.
  • Better operational efficiency.

Read more at http://www.infocaptor.com/dashboard/

Where Can I Find EBS 12.2.7 Documentation?

Steven Chan - Wed, 2017-09-27 13:25

EBS 12.2.7 is the latest update to E-Business Suite 12.2. It be applied online -- you do not need to take your EBS environment down to apply this update.

Our online E-Business Suite Documentation Web Library always contains the latest versions of all of our guides, including our Installation Guides, Upgrade Guides, and Readme Notes:

The following Roadmap Note is also a critical reference, since it is a master index of all official Notes for advanced topics that complement our guides in the Documentation Library:

All EBS sysadmins should bookmark this Note.  The indexed Notes are essential for nearly all EBS installations.  Here are some examples:

  • Load-balancers and DMZs
  • Real Application Clusters for E-Business Suite
  • Upgrade Sizing and Best Practices
  • VM Templates
  • Customizing EBS 12.2
  • OA Framework Developer's Guide
  • Backup and Recovery with Online Patching 
  • Oracle Access Manager and Oracle Internet Directory integration
  • BPEL and SOA Suite 11g Integration
  • Workflow Mailer with Outlook and other cloud email servers
  • Recommended Browsers
  • JAR file signing
  • Upgrading the JDK for EBS servers
  • Encrypting the EBS database with Transparent Data Encryption (TDE)
  • Security Best Practices and FAQ

Related Articles

Categories: APPS Blogs

Health and Beauty Companies Get Business Makeover with NetSuite

Oracle Press Releases - Wed, 2017-09-27 08:00
Press Release
Health and Beauty Companies Get Business Makeover with NetSuite C.O. Bigelow and Ovation Hair are among the fast-growing manufacturers groomed for success in the cloud

San Mateo, Calif.—Sep 27, 2017

Oracle NetSuite, one of the world’s leading providers of cloud-based financials/ERP, HR, Professional Services Automation (PSA) and omnichannel commerce software suites, today announced more and more health and beauty manufacturers and retailers are turning to the cloud to fuel growth and achieve customer-centric business agility. Innovative companies such as C.O. Bigelow, the oldest apothecary in the U.S., and Ovation Hair, a provider of high-end hair care products in southern California, are among the many health and beauty providers to graduate from disparate applications and labor-intensive manual data work to gain an edge in a highly competitive market.

Health and beauty is rapidly growing amid strong consumer demand for distinctive skin care, hair care, lip care, oral care and related products, as well as cosmetics, fragrances, deodorants, soaps, shower gels and more. Global sales of health and beauty products are expected to soar 73 percent from 2016 to 2024, from $432 billion to $750 billion, according to Inkwood Research, a Boston-based research firm.[1] This growth comes amid industry disruption as emerging and midmarket players develop, manufacture and market products with strong branding appeal as well as organic and eco-friendly attributes.

“Health and beauty companies are laser-focused on product innovation, brand-building and customer intimacy,” said Branden Jenkins, GM of Global Retail, Oracle NetSuite “They’re channeling the time and cost savings they realize with NetSuite into building the business, rather than wasting resources on manual work and outdated on-premise systems.”

Family-Run Business Stands the Test of Time and Adapts to Market Changes

C.O. Bigelow (www.bigelowchemists.com), the oldest apothecary in the U.S., has grown from its founding in 1838 in New York City to be a global omnichannel retailer of an eclectic, carefully curated array of more than 30,000 products. With an iconic brick-and-mortar store and traditional pharmacy occupying the same Greenwich Village space since 1902, the family-run business also operates an ecommerce website and sells to global hotels and airlines that offer Bigelow goods to customers across the globe. Its wholesale channel has grown 20 to 30 percent annually in recent years across more than 1,000 partner stores such as Sephora, Barney’s and Nordstrom. The owner, Ian Ginsberg, doesn’t view his company as disruptive. “We’re the ones who survived the disruption,” he says. “We’re a traditional business surviving in the modern world.” That takes a special kind of business agility, supported by Bigelow’s use of NetSuite. The manufacturer and retailer relies on NetSuite for core functions of financials, reporting, inventory and order management across all channels. Reporting on real-time data has been vital in delivering insights for Bigelow to strengthen its bottom line while gaining agility to compete with both upstart rivals and chain drug stores.

“We’re able to be faster and more nimble because of NetSuite,” said Ginsberg. “The real-time information available in NetSuite is just mind-blowing. Across all our functions, it just saves us so much time and money. We’re able to behave like a big guy in small guy clothes.”

Hair Care Leader Strengthens Hair, Business and Consumer Loyalty

Ovation Hair (www.ovationhair.com), based in Carlsbad, Calif., broke into the hair care market in 2007 with its flagship Cell Therapy product, helping customers grow thicker, stronger hair with a proprietary blend of proteins, vitamins, botanical extracts and amino acids. Since then, Ovation Hair has grown its lineup to more than 25 products, including shampoos and conditioners, all manufactured in southern California. Starting out by reaching consumers with radio ads after its founding in 2007, Ovation Hair today builds its brand and customer loyalty with email marketing and social media, while expanding its channels to include QVC TV spots, Amazon and distribution through 75 select salons in the U.S. Regular promotions, a loyalty program, subscription replenishment and refer-a-friend rewards have all been instrumental in driving double-digit revenue growth. Ovation Hair is better able to focus on innovation and marketing because NetSuite supplies a unified platform for the company to efficiently run financials, inventory, manufacturing and its ecommerce website. NetSuite serves as the repository for 500,000 contacts reached by email and social marketing, while NetSuite for manufacturing gives Ovation Hair important lot tracking capabilities for raw ingredients and shipped products.

“Having everything under one roof with NetSuite is very efficient and definitely an advantage in a competitive industry,” said Erika Sherwood, Ovation Hair Marketing Manager. “NetSuite has helped us improve our reaction time in updating the website and streamlining processes with our client database, marketing, product information, inventory levels and manufacturing.”

Key Technology Ingredients for Health and Beauty Companies to Grow and Thrive

New and more established health and beauty businesses such as C.O. Bigelow and Ovation Hair are turning to cloud business solutions as they compete with established multinationals such as Procter & Gamble, Unilever, L’Oreal, Estée Lauder and others. In many cases, product manufacturers are expanding into direct-to-consumer (D2C) sales, over websites and with partners such as Amazon and QVC. The features most important to leading health and beauty companies are focused on:

  • Customer centricity. Health and beauty product manufacturers and retailers need integrated processes and a 360-degree customer view to deliver a seamless omnichannel experience and personalized customer service.
  • Cloud-first scale and agility. Health and beauty companies need the ability to rapidly scale all operations, from entering new global markets to expanding channels, product offerings and subscription sales.
  • Integrated operational efficiency. End-to-end efficiency and visibility are essential for these companies to minimize operational costs and orchestrate processes to deliver an exceptional customer experience at every interaction.
  • Data-driven decision-making. Rather than relying on outdated, disparate data and guesswork, health and beauty companies running in the cloud can make informed decisions based on real-time information.

NetSuite provides an end-to-end view of business for health and beauty companies such as C.O. Bigelow and Ovation Hair across wholesale distribution and ecommerce channels, as well as company brick-and-mortar locations, to enable seamless, omnichannel experiences for customers. To learn more about NetSuite’s offering for health and beauty companies, please visit: http://www.netsuite.com/beauty

[1] Inkwood Resarch, “Global Beauty and Personal Care Products Market Forecast 2017-2024.”

Contact Info
Christine Allen
Oracle NetSuite
603-743-4534
PR@netsuite.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.com.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at oracle.com.

Trademarks

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

Talk to a Press Contact

Christine Allen

  • 603-743-4534

Carbon Scales Business Efficiencies with Oracle Cloud Applications

Oracle Press Releases - Wed, 2017-09-27 07:00
Press Release
Carbon Scales Business Efficiencies with Oracle Cloud Applications Oracle empowers Carbon to push the limits of what was previously “unmakeable”

Redwood Shores, Calif.—Sep 27, 2017

Carbon (Carbon, Inc.), the Silicon Valley-based additive manufacturing company, is leveraging Oracle Cloud Applications to support its hyper growth and international expansion. With Oracle Cloud Applications, Carbon has been able to take advantage of a complete and fully integrated suite of cloud applications to increase business agility and reduce IT complexity. In just six months, Oracle Cloud Applications have enabled Carbon to reduce its close cycle from 28 days to 7, and to improve processes in almost every function.

“The potential of our Digital Light Synthesis™ (DLS) technology is vast, but we knew we couldn’t successfully grow our business without a secure, scalable and connected suite of modern applications,” said Chris Hutton, director of business operations and international, at Carbon. “With Oracle, we have been able to future-proof our business operations and the results we have achieved in just six months have been really impressive.”

To support its rapid growth both domestically and globally, Carbon deployed Oracle Enterprise Resource Planning (ERP) Cloud, Oracle Human Capital Management (HCM) Cloud, Oracle Supply Chain Management (SCM) Cloud and Oracle Service Cloud. Oracle ERP Cloud has given Carbon a consolidated view of its global operations, utilizing standardized and streamlined business processes, and provided the financial platform needed to scale. Oracle HCM Cloud has helped Carbon find and retain the talent it needs to meet its growing business demands. Simultaneously, Oracle SCM Cloud has enabled Carbon to transform supply chain operations to gain greater insight into the distribution of parts and products. Finally, Oracle Service Cloud has enabled Carbon to streamline its customer service experience to quickly address urgent customer needs and optimize the customer experience.

“Carbon is one of the most innovative businesses in the world and its unique technology is helping deliver on the promise of 3D manufacturing,” said Steve Miranda, executive vice president, applications development at Oracle. “With Oracle Cloud Applications, Carbon has been able to streamline business processes across organizational development, manufacturing, finance, and services. As Carbon continues to partner with major brands and scale its business, we will be able to support its changing demands through the world’s largest and fastest-growing suite of cloud applications.”

Contact Info
Evelyn Tam
Oracle
+1.510.648.4756
evelyn.tam@oracle.com
About Carbon

Carbon, the Silicon Valley-based additive manufacturing company, was founded in 2013. Working at the intersection of hardware, software and molecular science, Carbon is delivering on the promise of additive manufacturing, allowing commercial partners to go beyond basic prototyping to start producing at scale. Carbon’s Digital Light Synthesis™ technology (DLS) was introduced simultaneously at TED 2015 and to the scientific community on the cover of Science Magazine (Science, March 2015). To date, Carbon has received $221 million in funding. Carbon’s investors include Autodesk, BMW, GE Ventures, GV, Nikon, Northgate Capital, Sequoia Capital and Silver Lake Partners. For more information, please visit Carbon3D.com or follow @Carbon on Twitter and Instagram.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at oracle.com.

Trademarks

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

Talk to a Press Contact

Evelyn Tam

  • +1.510.648.4756

check invalid directories

Laurent Schneider - Wed, 2017-09-27 05:29

To get the status of a directory, I wrote my own function, which uses DBMS_LOB.FILEEXISTS.


CREATE FUNCTION 
  status (DIRECTORY_NAME VARCHAR2)
  RETURN VARCHAR2
IS
BEGIN
  IF (DBMS_LOB.FILEEXISTS(
    BFILENAME (DIRECTORY_NAME, '.')) = 1)
  THEN
    RETURN 'VALID';
  ELSE
    RETURN 'INVALID';
  END IF;
EXCEPTION
  WHEN OTHERS
  THEN
    RETURN SQLERRM;
END;
/


SELECT
  directory_name NAME,
  directory_path PATH,
  status (directory_name) STATUS
FROM dba_directories;

NAME PATH STATUS   
---- ---- ---------
FOO  /foo INVALID  
TMP  /tmp VALID    
BAK  /u99 VALID    

check invalid database link for the DBA

Laurent Schneider - Wed, 2017-09-27 03:47

followup of check invalid database link
If you need to check db link in another schema, you need to create code that run with that schema.

base on the example from yesterday, here is an extended version for the dba


CREATE FUNCTION dba_status
  (owner VARCHAR2, db_link VARCHAR2)
  RETURN VARCHAR2
IS
  PRAGMA AUTONOMOUS_TRANSACTION;
  status   VARCHAR2 (4000);
BEGIN
  EXECUTE IMMEDIATE
'create or replace function "'
|| owner
|| '".status(db_link varchar2) return varchar2 is '
|| 'x number;'
|| 'begin execute immediate ''select 1 from dual@"''
||DB_LINK||''"'' into x;'
|| 'return ''OK'';'
|| 'exception when others then return sqlerrm;'
|| 'end;';
  EXECUTE IMMEDIATE
    'begin :1 := "' || owner 
    ||'".status(''' || db_link || '''); end;'
    USING OUT status;
  EXECUTE IMMEDIATE 'drop function "' || owner || '".status';
  COMMIT;
  RETURN status;
END;
/


SELECT 
  owner, db_link, dba_status (owner, db_link) 
FROM dba_db_links;
OWNER DB_LINK DBA_STATUS(OWNER,DB_LINK)                                   
----- ------- --------------------------------
SCOTT L3.EXAM OK
SCOTT L2.EXAM ORA-12154: TNS:could not resolve
SCOTT L1.EXAM ORA-01017: invalid username/pass

What's on at Oracle OpenWorld for Developers using Python, Node.js, PHP, R, C and C++

Christopher Jones - Tue, 2017-09-26 18:08

Oracle Open World Conference Logo

The Oracle OpenWorld in San Francisco is approaching and it's time to plan your schedule.  The sessions that I'm tracking are all listed on the official schedule page Application Development with Node.js, Python, PHP, R, C and C++. Bookmark that link!

  Conference Sessions Hands-on Lab Session DevLive Interviews

Come and hear these informal chats at the DevLive Stage, Moscone West Level 1. The discussion is bound to be broad reaching and lively.

  • Node.js: JavaScript Application Development for Oracle Database
    Monday, Oct 02, 3:00 p.m. - 3:30 p.m. | Developer Lounge, Moscone West

  • Building Python Messaging Apps with Oracle DB12c
    Tuesday, Oct 03, 3:00 p.m. - 3:30 p.m. | Developer Lounge, Moscone West

When deterministic function is not

Yann Neuhaus - Tue, 2017-09-26 14:47

When you declare a function-based index, the function is deterministic, which means that calling it with same arguments will always return the same result. This is required because the indexed values, which are the result of the function, are stored in the index. But what happens if you declare a function deterministic when it is not?

I wanted to do this test after reading the following documents about Postgres HOT and WARM.

The relevant read is https://t.co/rCzqdz9RyJ and https://t.co/rFis1lqlFf

— Vladimir Sitnikov (@VladimirSitnikv) August 2, 2017

They say that they cannot vacuum one page at a time because index entries must be cleaned, and there’s a risk when trying to find an index entry from the table in case a user indexed a function which is not actually deterministic. This could lead to logical corruption. So, it seems that Postgres will always navigate from the index to the table and not the opposite. And that is possible in Postgres because they don’t implement DELETE and UPDATE physically. They only do an INSERT with the new version of the whole row and mark the old version as stale.

But Oracle is far more complex than that. Critical OLTP applications must be able to update in-place, without row movement, or the indexes maintenance would kill the performance and the redo generation would be orders of magnitude larger. An update is done in-place and the updated column must maintain the related index. And deletes will also delete all the index entries. Then, Oracle needs to navigate from the table to the index. This is done with a lookup onf the value in the index structure. The value is either a value stored in the table row, or derived with a deterministic function.

So what happens if I declare a function deterministic when it is not?

Here is a table:

SQL> create table DEMO (n not null) pctfree 99 as select rownum from xmltable('1 to 5');
 
Table created.

And here is a function which returns a rendom number. But I declare it deterministic:

SQL> create or replace function DEMO_FUNCTION(n number) return number deterministic as
2 begin
3 return dbms_random.value;
4 end;
5 /
 
Function created.

I declare an index on it:

SQL> create index DEMO_FUNCTION on DEMO(DEMO_FUNCTION(n));
 
Index created.

Oracle cannot verify if the function is deterministic or not, and trusts me.

A full table scan re-calculates the value each time, and do not raise any error.

SQL> select /*+ full(DEMO) */ DEMO_FUNCTION(n),rowid,n from DEMO where DEMO_FUNCTION(n) is not null;
 
DEMO_FUNCTION(N) ROWID N
---------------- ------------------ ----------
.743393494 AAAR5kAAMAAABXbAAA 1
.075404174 AAAR5kAAMAAABXbAAB 2
.601606733 AAAR5kAAMAAABXbAAC 3
.716335239 AAAR5kAAMAAABXbAAD 4
.253810651 AAAR5kAAMAAABXbAAE 5

If you run it several times, you will see different values.

An index acess will show always the same values because they come from the index:

SQL> select /*+ index(DEMO) */ DEMO_FUNCTION(n),rowid,n from DEMO where DEMO_FUNCTION(n) is not null;
 
DEMO_FUNCTION(N) ROWID N
---------------- ------------------ ----------
.135108581 AAAR5kAAMAAABXbAAE 5
.440540027 AAAR5kAAMAAABXbAAD 4
.480565266 AAAR5kAAMAAABXbAAA 1
.546056579 AAAR5kAAMAAABXbAAB 2
.713949559 AAAR5kAAMAAABXbAAC 3

Oracle could have run the function on the value from the table and compare it with the value from the index, and then raise an error. But that would be more expensive.

But then, what happens if I delete a row? Oracle will try to find the index entry by running the function, but then the value is not found in the index:

SQL> delete from DEMO where n=3 and DEMO_FUNCTION(n) is not null;
delete from DEMO where n=3 and DEMO_FUNCTION(n) is not null
*
ERROR at line 1:
ORA-08102: index key not found, obj# 73317, file 12, block 5603 (2)

This is a logical corruption caused by the bug in the function which was declared deterministic but is not. Verifying the deterministic truth would require running the function several times and even that would not detect values that change after days. It is the developer responsibility, to tell the truth. This was just a test. I you are in this case, make the index unusable and fix the function before re-building it.

 

Cet article When deterministic function is not est apparu en premier sur Blog dbi services.

Pages

Subscribe to Oracle FAQ aggregator