Feed aggregator

Top 5 Infrastructure (IaaS) announcements by Oracle at Oracle OpenWorld 2017

Amis Blog - Sun, 2017-10-08 12:26

From Thomas Kurian’s keynote during Oracle OpenWorld 2017 – see https://youtu.be/cef7C2uiDTM – a quick recap of the five most important announcements regarding IaaS:

1.image

2.

image

3.

image

4.

image

5.

image

World record benchmarks

image

image

image

The post Top 5 Infrastructure (IaaS) announcements by Oracle at Oracle OpenWorld 2017 appeared first on AMIS Oracle and Java Blog.

Autonomous Database

Yann Neuhaus - Sun, 2017-10-08 12:09

Larry Ellison has announced Oracle 18c to be the Autonomous Database, the no-human labor, and self-driven, database. Here is a quick recap of what it is behind the marketing words. My opinion only.

Autonomous

Since Oracle decided to be a public cloud PaaS provider, they announced ‘unmanaged’ and ‘managed’ services. The managed service for DBaaS is where you are not the Database Administrator. Autonomous Database 017-10-04 15.51.53 You have full administration right to deploy and develop your application, but the system administration is done by Oracle: provisioning, patching, upgrade, system tuning, availability. The first managed service was announced last year at OOW16: the Oracle Exadata Express Cloud Service, for developers. And the second managed service is the Oracle Data Warehouse Cloud Service, for data warehousing. It is planned for December 2017 and will be based on new version: Oracle 18c.
And let’s be clear, the ‘autonomous’ label came at the last minute, as the marketing message for Open World, to show that the managed service is fully automated, because Cloud is about automation.

So, is that only marketing? I don’t think so. There are real features behind it. And some of them exist for a long time, and had just to be enhanced further in 18c.

Availability

The features are there for a long time for full automation. RAC protects from instance or server crash and Data Guard protects from all other failures. Both are fully automated with no-human intervention: service relocation in RAC, Fast-Start FailOver in Data Guard. And both can failover transparently with Application Continuity. Oracle also recently introduced Sharding, to link data availability to different datacenter. And this technique will also be used for RAC instance affinity in Oracle 18c.

Patch and Upgrade

You can apply patches in a rolling manner with RAC. The problem was OJVM, but this will be also rolling in 18c. You can do rolling upgrade with Data Guard. And 18c will have automated and faster upgrade at PDB plug-in. From a system point of view, all is fully automated. However, we will still need human intervention for testing, and planning it at the right time, and of course for troubleshooting when something goes wrong. The autonomous database is not incompatible with that. With logical replication (Golden Gate, Transient logical standby) or versioning (Edition Based Redefinition, Workspace Manager) Oracle has the tools to automatically provide the environment to test the upgrade before it is opened in production.

We can also imagine that other features may help to avoid regression. For example, SQL Plan Management can prevent execution plan regressions on common use-cases, and let the (human) user accept evolved plans later. This can also be done automatically (but humans still have to define the capture). Of course, we all know the limits of the advisors and automatic implementation. But there are also some applications where it can be fine. This ‘autonomous’ Cloud Service is a possibility, not a universal solution.

Tuning

Again, we all know that the database cannot be optimized without the knowledge of the data and the design of the application. But Oracle has also a lot of features to automate some common practices. Automatic Data Optimization, Segment Advisor, SQL Access Advisor, Auto DOP, automatic choice of buffered or direct reads,… We have seen a lot of drawbacks with SQL Plan Directives, but that was mainly in OLTP. This new managed service is for DWH where dynamic sampling is not a bad idea.

The idea is to ‘load data and run’ and Oracle takes care of index, partitioning, etc. You create the table and declare Primary keys and Foreign key (RELY DISABLE NOVALIDATE see a previous blog post about that). Then I suppose that Oracle can guess which are the dimension tables and the fact tables. And then do some common things to do on that: partition on the date dimension (if there is only one – maybe it has to detect some load/query patterns), create bitmap indexes on all fact foreign key. Online statistics gathering will be extended in 18c to incrementally maintain statistics on bulk-insert, and this may include histograms.

I’m very skeptical on that point, because I’ve seen lot of datawarehouse databases where, even on big hardware, there is always a need for optimization. But my point of view may be biased. I’m a consultant, and then I see only the databases where people think they need human analysis and troubleshooting. There may be some non-critical datawarehouse databases where nobody is doing any optimisation, and then implementing some default optimization may be sufficient to make it a bit more efficient. This autonomous elastic cloud service may be a good start for some projects, when it is difficult to plan the hardware and human resources that will be needed. But I’m quite sure that after a while, designing an efficient and scalable infrastructure and data model will still require our DBA skills and human intelligence.

Load

This service is provisioned as a PDB where what we can do is limited by the multitenant lockdown profiles. We can connect easily (with a credentials .zip) from SQL Developer, and we can load data from an object store using the DBMS_CLOUD package to define the credentials (Swift) and load text files. Once again, it is an evolution of existing features like external tables and preprocessors.

Scalability

This service is Elastic: it can scale the CPU resource up and down without stopping the service. Again this can use existing features: OVM for the host, and Resource Manager for the CDB and PDB.

So what?

Some will say that it is only marketing with nothing behind, and the same announcement that was made by each previous version. Others will say that it is really autonomous, self-driving, self-securing, self-repairing. This ‘self-driven’ idea is an analogy with Tesla (Elon Musk is a big friend of Larry Ellison), but for the moment, there’s still a human inside a Tesla. Autonomous is a vision for the future, not the present. The present is a new managed service, more online operations, and easier upgrades.

What I really like is the integration of existing features to serve a new marketing trend. Do you remember when the flashback features came out? Flashback query existed internally since the invention of rollback segments (and maybe even before with the Before Image). It was exposed in 9i with a dbms package, and 10g in the SQL ‘as of’. All was already there to bring a feature that no other RDBMSs are capable of. The existing features support the marketing message at the right time, and this marketing message encourages to develop new features again, like new online operations. And those do not benefit only to the managed cloud services as they go to the main branch of Oracle Database.

The other thing I like is the idea to have a configuration dedicated to specific needs. In the OOW17 hands-on lab, there was even a “_cloud_service_type” parameter set to DWCS. Here this service is for DWH, and there will be one dedicated to OLTP mid-2018. This is something I would like to see in future versions. For example, there was a lot of discussion about 12.1 enabling adaptive statistics by default, and 12.2 disabling them. This kind of default settings could be set depending on the database type: more conservative for OLTP upgrades, more adaptive for new datawarehouse projects.

 

Cet article Autonomous Database est apparu en premier sur Blog dbi services.

Oracle Enterprise Repository for Fusion Applications

Richard Byrom - Sun, 2017-10-08 11:35

A very useful resource I’ve been making good use of for Fusion implementations is the Oracle Enterprise Repository for Fusion Applications. Examples of content provided include: -

  • File-Based Data Import Templates
  • Report Listings
  • Roles
  • SOAP Web Services
  • Tables and Views
  • Business Process Models
  • Technology Audit
  • Flexfields
  • Lookups
  • Profile Options
  • Schedules Processes

All of this content is available across the following product areas: -

  • Sales
  • Global Human Resources
  • Financials
  • Procurement
  • Project Portfolio Management
  • Supply Chain Management

Oracle Enterprise Repository Fusion Applications

Furthermore the content provided spans various releases, namely Release 11, Release 12 and Release 13 (update 17b).

I hope you find this a useful resource for your Fusion projects.

Upgrade 12.2 Journey – Update Opatch

Michael Dinh - Sun, 2017-10-08 11:14
[oracle@db-asm-1 ~]$ ps -ef|grep pmon
oracle    1413     1  0 17:18 ?        00:00:00 ora_pmon_orclcdb
oracle   10752 10731  0 17:52 pts/1    00:00:00 grep pmon
oracle   24615     1  0 16:47 ?        00:00:00 asm_pmon_+ASM

[oracle@db-asm-1 ~]$ . oraenv <<< orclcdb 
ORACLE_SID = [oracle] ? The Oracle base has been set to /u01/app/oracle 

[oracle@db-asm-1 ~]$ echo $ORACLE_HOME 
/u01/app/oracle/11.2.0.4/db1 

[oracle@db-asm-1 ~]$ cd $ORACLE_HOME 
[oracle@db-asm-1 db1]$ mv -v OPatch OPatch.old 
'OPatch' -> 'OPatch.old'

[oracle@db-asm-1 db1]$ mkdir OPatch
[oracle@db-asm-1 db1]$ ls -ld OP*
drwxr-xr-x. 2 oracle oinstall 4096 Oct  8 17:53 OPatch
drwxr-xr-x. 8 oracle oinstall 4096 Oct  8 17:03 OPatch.old

[oracle@db-asm-1 db1]$ unzip -d $ORACLE_HOME -qo /media/swrepo/JUL2017PSU/p6880880_112000_Linux-x86-64.zip;echo $?
0
[oracle@db-asm-1 db1]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.16

OPatch succeeded.

[oracle@db-asm-1 db1]$ su -
Password:
[root@db-asm-1 ~]# . oraenv <<< +ASM 
ORACLE_SID = [root] ? The Oracle base has been set to /u01/app/oracle 

[root@db-asm-1 ~]# echo $ORACLE_HOME 
/u01/app/oracle/11.2.0.4/grid 
[root@db-asm-1 ~]# export GRID_HOME=$ORACLE_HOME 
[root@db-asm-1 ~]# cd $GRID_HOME 
[root@db-asm-1 grid]# ls -ld OP* 
drwxr-xr-x. 8 oracle oinstall 4096 Oct 8 16:41 OPatch 
[root@db-asm-1 grid]# mv -v OPatch OPatch.old 
'OPatch' -> 'OPatch.old'

[root@db-asm-1 grid]# mkdir OPatch
[root@db-asm-1 grid]# ls -ld OP*
drwxr-xr-x. 2 root   root     4096 Oct  8 17:56 OPatch
drwxr-xr-x. 8 oracle oinstall 4096 Oct  8 16:41 OPatch.old

[root@db-asm-1 grid]# chown oracle:oinstall OPatch
[root@db-asm-1 grid]# ls -ld OP*
drwxr-xr-x. 2 oracle oinstall 4096 Oct  8 17:56 OPatch
drwxr-xr-x. 8 oracle oinstall 4096 Oct  8 16:41 OPatch.old
[root@db-asm-1 grid]# logout

[oracle@db-asm-1 db1]$ . oraenv <<< +ASM
ORACLE_SID = [orclcdb] ? The Oracle base remains unchanged with value /u01/app/oracle

[oracle@db-asm-1 db1]$ echo $ORACLE_HOME
/u01/app/oracle/11.2.0.4/grid

[oracle@db-asm-1 db1]$ export GRID_HOME=$ORACLE_HOME
[oracle@db-asm-1 db1]$ unzip -d $GRID_HOME -qo /media/swrepo/JUL2017PSU/p6880880_112000_Linux-x86-64.zip;echo $?
0

[oracle@db-asm-1 db1]$ $GRID_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.16

OPatch succeeded.
[oracle@db-asm-1 db1]$

Upgrade 12.2 Journey – Build Virtual 11.2.0.4 Oracle Restart

Michael Dinh - Sun, 2017-10-08 10:53

I am using oravirt vagrant boxes.

https://github.com/oravirt/vagrantfile
https://github.com/oravirt/vagrant-vbox-si-asm
https://github.com/oravirt/vagrantfile#environment-variables-that-can-be-used-to-override-defaults

Starting the VM’s
vagrant up will build the VM’s to the specification in hosts.yml and run the base provisioner
If there are extra provisioners defined you need one of the following:
setup=true vagrant up (if VM’s are not created)
setup=true vagrant provision (if the VM’s are already up)

setup=true giver=11.2.0.4 dbver=11.2.0.4 cdb=false vagrant up
setup=true vagrant up
setup=true giver=11.2.0.4 dbver=11.2.0.4 cdb=false vagrant provision

Modifications made for shared folders.

vagrant-vbox-si-asmF:\Vagrant\vagrant-vbox-si-asm\hosts.yml
synced_folders:
#- {src: swrepo, dest: /media/swrepo}
- {src: "F:\\OracleSoftware", dest: /sf_OracleSoftware}
- {src: "C:\\dinh\\Dropbox\\working", dest: /sf_working}
- {src: "F:\\OracleSoftware\\11.2.0.4_PatchSet_Linux_x64", dest: /media/swrepo}

F:\Vagrant\vagrant-vbox-si-asm\extra-provision\ansible-oracle\group_vars\vbox-si-asm
oracle_stage_remote: /sf_OracleSoftware
oracle_stage_remote: /sf_working
oracle_stage_remote: /media/swrepo

Environment shared folders.

[vagrant@db-asm-1 ~]$ ps -ef|grep pmon
oracle    1413     1  0 17:18 ?        00:00:00 ora_pmon_orclcdb
vagrant   2435  2417  0 17:19 pts/0    00:00:00 grep pmon
oracle   24615     1  0 16:47 ?        00:00:00 asm_pmon_+ASM
[vagrant@db-asm-1 ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2              47G  2.3G   43G   6% /
tmpfs                 873M   83M  790M  10% /dev/shm
vagrant               3.7T  172G  3.5T   5% /vagrant
sf_working            420G  133G  287G  32% /sf_working
media_swrepo          3.7T  172G  3.5T   5% /media/swrepo
sf_OracleSoftware     3.7T  172G  3.5T   5% /sf_OracleSoftware
/dev/mapper/vgora-lvora
                       84G   12G   68G  16% /u01

[vagrant@db-asm-1 ~]$ cd /media/swrepo/
[vagrant@db-asm-1 swrepo]$ ls -l
total 4305238
drwxrwxrwx. 1 vagrant vagrant       4096 Jul 20  2016 client
drwxrwxrwx. 1 vagrant vagrant       4096 Jul 20  2016 database
drwxrwxrwx. 1 vagrant vagrant       4096 Jul 20  2016 grid
drwxrwxrwx. 1 vagrant vagrant       4096 Oct  7 15:46 JUL2017PSU
-rwxrwxrwx. 1 vagrant vagrant 1395582860 Feb 11  2014 p13390677_112040_Linux-x86-64_1of7.zip
-rwxrwxrwx. 1 vagrant vagrant 1151304589 Feb 11  2014 p13390677_112040_Linux-x86-64_2of7.zip
-rwxrwxrwx. 1 vagrant vagrant 1205251894 Apr 25  2016 p13390677_112040_Linux-x86-64_3of7.zip
-rwxrwxrwx. 1 vagrant vagrant  656026876 May 12  2014 p13390677_112040_Linux-x86-64_4of7.zip
-rwxrwxrwx. 1 vagrant vagrant     297405 Jul 17  2016 README for 13390677.pdf
-rwxrwxrwx. 1 vagrant vagrant      82385 Jul 17  2016 View Patch Digest.pdf
[vagrant@db-asm-1 swrepo]$

[vagrant@db-asm-1 swrepo]$ cd /sf_OracleSoftware/12.2.0.1_Linux_64
[vagrant@db-asm-1 12.2.0.1_Linux_64]$ ls -l
total 6297251
-rwxrwxrwx. 1 vagrant vagrant 3453696911 Apr 12 15:44 linuxx64_12201_database.zip
-rwxrwxrwx. 1 vagrant vagrant 2994687209 Apr 12 15:43 linuxx64_12201_grid_home.zip
[vagrant@db-asm-1 12.2.0.1_Linux_64]$

Install Log for vagrant-vbox-si-asm


Takeaways from OOW'17

Andrejus Baranovski - Sun, 2017-10-08 09:28
Let's summarise important points from OOW'17 conference. This year conference was a breakthrough for Oracle JET - most of Oracle Cloud UI's were implemented with Oracle JET. Oracle ADF is used for Oracle SaaS (Fusion Middleware) back office applications, same as before. There is often misunderstanding in JET vs. ADF comparison. Keep in mind - JET is only UI layer and it can be compared with ADF Faces only. While ADF is much more than UI - ADF BC Model, ADF Task Flows and ADF Bindings.

1. Use JET for front-end apps, with relatively simple complexity but strong requirement for performance and scalability. Back-end can be implemented with ADF BC REST. Typically it would take longer to implement JET UI comparing to ADF Faces (no drag and drop support, unless using Visual Cloud Builder Service for JET)

2. Use ADF Faces for complex and large back-office applications. Some degree of mix between ADF Faces and JET is possible. Back-end should be done in ADF BC

ADF is stable technology and Oracle is focusing to advertise new things on OOW. Recommended focus for ADF developers was around JCS, DevCS, JET and VBCS:


There was one session about how to move existing ADF app into the cloud with JCS. And session about ADF BC REST, no new features - mainly showing customer system implementation with current features.

JET open source contribution was announced, along with new JET offline support - persistence toolkit (will be available through NPM in next couple of weeks):


Oracle explained why handling offline use case in JET is important:


Persistence toolkit will run on JET hybrid, web and desktop apps (yes you can run JET as desktop app, with 3-rd party Electron plugin):


Here you can read more detail info about persistent toolkit design principles:


JET supports Fetch API (used by persistence toolkit):


Architecture explanation for JET persistence toolkit:


Another hot topic related to JET - Web components. Slots are supported, this allows to build advanced Web components with dedicated facets (ADF Faces terminology):


OOW'17 was packed with chatbot demos. Unfortunately there is no trial access for chatbot cloud yet. There was good session about chatbots from Lyudmil Pelov - he explained how Oracle chatbot service and language processing works:


I was impressed with Oracle Visual Cloud Builder Service progress this year. I really liked this service and I think it will become JET IDE development tool. Is not focused for business users only, but is targeted for JET developers too. It comes with embedded DB or you can call external services too. Next versions will allow direct JET code development, combined with drag and drop:


Develop JET in VBCS using drag and drop where possible and code additional logic in JS/HTML:


VBCS is not targeted for business users anymore, they target it for coders (us) too - thats news I like:



RDK UI is available now for ADF, JET and MAF. ADF RDK was updated to newer version. ADF and JET RDK UI look is identical.

New ADF RDK UI:


JET RDK UI:


Machine Learning was another big thing on OOW and JavaOne. Nice to hear things I was studying in university about neural networks are becoming hype now:


JVM garbage collection tuning. Is better to have objects to be dead young. This means in ADF is better to use Backing Bean Scope where possible, because short scope bean is destroyed after request and this allows VM to clean memory:

NetSuite Expands Middle East Operations

Oracle Press Releases - Sun, 2017-10-08 02:00
Press Release
NetSuite Expands Middle East Operations Cloud leader offers support for new VAT, adds dedicated sales team and strengthens partner ecosystem to meet growing demand for cloud ERP in region

Dubai, UAE and SAN MATEO, Calif.—Oct 8, 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 the expansion of operations in the Middle East to meet the increasing demand for cloud ERP in the market. With the support of Oracle’s global resources, NetSuite added a dedicated sales team with new leadership; new solution provider partners to strengthen its existing partner ecosystem; and increased customer adoption of NetSuite OneWorld. Additionally, NetSuite will offer support for the new Unified Value Added Tax (VAT) Agreement, set to take effect for Saudi Arabia and the United Arab Emirates (UAE) next year with more Gulf Cooperation Council (GCC) countries expected to follow.

“Local and global companies with regional headquarters in the area are already reaping the benefits of cloud ERP,” said Mark Woodhams, Oracle NetSuite Vice President, EMEA. “With today’s announcement, we’re signalling our ongoing commitment to the region and the success of our customers and partners here.”

NetSuite to Provide VAT Support, Enabling Businesses to Comply with New Tax Rules

With the Unified Value Added Tax (VAT) Agreement signed by the Gulf Cooperation Council (GCC) countries set to go into effect in the UAE and Saudi Arabia January 1, 2018, with other countries in the region expected to follow, NetSuite will build support for the new changes directly into the system. The VAT will impact every part of the business, including cash flow, pricing of products and services, financial reporting, tax accounting and reporting and, of course, technology. NetSuite already has a highly flexible in-house tax engine that supports over 110 countries for VAT, both rules and reporting, creating a solid foundation on which to build out functionality specific to the GCC VAT. Tax codes for the standard rate, zero rates, reverse charges, as well as VAT on imports, will all be part of NetSuite’s International Tax Reporting SuiteApp. Existing customers will enjoy full business systems compliance with new changes in the value-added tax (VAT) rate without having to lift a finger. NetSuite’s cloud computing model and the flexible, powerful NetSuite Tax Engine inside NetSuite’s financial software ensure that NetSuite customers immediately benefit from this update.

NetSuite Adds Direct Sales Team and Leadership

NetSuite is extending its focus on the Middle East and the surrounding region with a dedicated sales team, pre-sales, country manager, marketing and other support functions, all operating out of a new Dubai office, which will be the center of East, Central Europe, Middle East and Africa (ECEMEA) operations. The dedicated sales team has been established and trained to address the UAE and Saudi Arabian markets. NetSuite will also continue to recruit local implementation partners with experience in ERP to support continued growth in the region.

The dedicated sales office will be led by Khaled Ismail, Vice President, Oracle Digital Application Business, ECEMEA, who will manage sales and marketing strategy for the region. In this role, Ismail will manage an organization of 250 sales professionals with almost 20 managers and directors. He is also responsible for all the supporting functions for ECEMEA from pre-sales, sales development, marketing and customer success.

“The UAE has been a strong growth engine for NetSuite in recent years,” Ismail said. “Now, with the additional global resources of Oracle, we intend to continue that growth and expand not only our sales operations and partnership, but build out additional functionality specific to the region.”

NetSuite Strengthens Partner Presence in the Region

NetSuite already has a strong partner presence in the region with 16 partners serving customers in the region. In 2017 alone, NetSuite added the following seven businesses to its Solution Provider Program: Azdan Business Analytics; Trinamix Business Solutions; Wolfrayet Business Consulting; Masterkey Software; Foresee Solutions; UnitedofOQ; and Digital Trends. As part of its expansion in the region, NetSuite will actively be recruiting qualified partners to continue to provide local businesses with a leading cloud ERP solution.

NetSuite OneWorld, a Game-Changer for Middle Eastern Businesses

Businesses seeking to gain efficiency, grow revenues, expand globally and enter new markets often find themselves held back by software systems siloed by department, geography or legal entity structures, leaving them unable to deliver an optimal customer experience and gain insights into their operations. The agility, flexibility and scalability that NetSuite OneWorld provides is difficult to achieve by businesses running legacy on-premise software. Meanwhile, other available cloud financial software solutions only offer basic product functionality that cannot scale and support changing business needs, growth and international expansion.

NetSuite OneWorld provides a unified and cloud-based suite of software that is flexible enough to meet the needs of diverse business models, legal structures and geographies. NetSuite OneWorld supports 190 currencies, more than 20 languages, automated tax calculation and reporting in more than 100 countries, and customer transactions in more than 200 countries.

Further, to help today’s B2B and B2C businesses with omnichannel commerce, NetSuite OneWorld delivers commerce-ready capabilities that can help both B2B and B2C commerce businesses to move from siloed online, in-store and phone consumer shopping channels to an integrated commerce solution, connecting ecommerce and in-store POS to order management, inventory, merchandising, marketing, financials and customer service, while delivering a seamless brand experience and exceeding customer expectations.

NetSuite OneWorld Supports Growth for Local Businesses

M.R.S. Packaging (www.mrspackaging.com), a food and beverage distributor for the concession industry operating across nine countries in the region, has been a NetSuite customer since 2015. As the company grew, management determined it needed to replace its custom-built accounting software with a new, modern system to manage the business. M.R.S. selected NetSuite for its cloud-based architecture, intuitive user interface and comprehensive functionality. M.R.S. is now using NetSuite to manage financials, Customer Relationship Management (CRM) across sales and customer service, inventory management and human resources. The move to NetSuite enabled M.R.S. to avoid the costs and disruption associated with on-premise systems, while staying up to date on the latest version of the software thanks to regular upgrades that automatically carry customizations forward. M.R.S. is now adopting NetSuite OneWorld to manage subsidiaries in UAE and Bahrain.

“NetSuite has proven to be the most cost effective, user friendly system for a midsized company like ours,” said Manu Soni, Managing Director of M.R.S. “We expect to be a $100 million company in three years and we feel confident NetSuite can scale with us.”

Aigue Marine DMCC, the parent company for Gearbox (www.gearbox.ae) and Aquae Jewels (www.aquae-jewels.com), implemented NetSuite when it launched the Gearbox business, an ecommerce business that offers a rent, try and buy service for cameras, and camera and video equipment. John Massaut, the Managing Director for Aigue Marine DMCC, founded the business when he realized how difficult it was to find reasonably priced equipment for a photo shoot for the jewelry business. Aigue Marine DMCC had an existing KPI.com system, however it was difficult to integrate with the new website and didn’t provide the comprehensive visibility into the business he needed. Massaut selected NetSuite for its comprehensive functionality and inventory management capabilities. Aigue Marine implemented NetSuite in May 2017 and is now running both Gearbox and Aquae Jewels on a single instance of NetSuite, managing financials, customer relationship management (CRM) and inventory management.

Inventory management is especially critical for Aigue Marine DMCC. NetSuite OneWorld gives the Gearbox business full visibility into equipment availability and location to maximize profits. In addition, the flexibility and agility of NetSuite is also critical as Gearbox seeks to add fitness monitors to its rent, try & buy offerings, as well as making demographic data available to the companies that manufacture and market the products. Aquae Jewels is able to track 5,000 pieces of inventory across several locations automatically, improving delivery and customer satisfaction, while reducing manual workloads.

“NetSuite has done everything I hoped it would, managing inventory, financials and helping to put process and procedures in place to manage the business efficiently,” Massaut said. “It’s a comprehensive solution that can scale to accommodate our ambitious plans for growth.”

Contact Info
Gaurav Bhatnagar
Director, Corporate Communications – Middle East & Africa Oracle
+971 55 100 1407
gaurav.b.bhatnagar@oracle.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 www.oracle.com/netsuite.

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

Gaurav Bhatnagar

  • +971 55 100 1407

Playing with asmcmd

Michael Dinh - Sat, 2017-10-07 21:29

ASMCMD Disk Group Management Commands (11.2)

asmcmd -V
asmcmd version 11.2.0.4.0

asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  4194304     10236    10148                0           10148              0             N  CRS/
MOUNTED  EXTERN  N         512   4096  4194304     20472    18612                0           18612              0             N  DATA/
MOUNTED  EXTERN  N         512   4096  4194304     30708    30264                0           30264              0             N  FRA/

asmcmd lsdsk
Path
/dev/oracle/crs01
/dev/oracle/data01
/dev/oracle/data02
/dev/oracle/fra01
/dev/oracle/fra02
/dev/oracle/fra03

asmcmd lsattr -G DATA -l
Name                     Value
access_control.enabled   FALSE
access_control.umask     066
au_size                  4194304
cell.smart_scan_capable  FALSE
compatible.asm           11.2.0.4.0
compatible.rdbms         11.2.0.4.0
content.type             data
disk_repair_time         3.6h
idp.boundary             auto
idp.type                 dynamic
sector_size              512

asmcmd lsattr -G FRA -l
Name                     Value
access_control.enabled   FALSE
access_control.umask     066
au_size                  4194304
cell.smart_scan_capable  FALSE
compatible.asm           11.2.0.4.0
compatible.rdbms         11.2.0.4.0
content.type             data
disk_repair_time         3.6h
idp.boundary             auto
idp.type                 dynamic
sector_size              512

asmcmd setattr -G FRA compatible.asm 11.2.0.4
asmcmd setattr -G FRA compatible.rdbms 11.2.0.4

asmcmd spget
+CRS/asm/asmparameterfile/registry.253.956737501

asmcmd iostat -G DATA -t
Group_Name  Dsk_Name   Reads      Writes     Read_Time   Write_Time
DATA        DATA_0000  253212160  101387776  260.330309  13325.418821
DATA        DATA_0001  178841088  27744256   209.972386  152.957184

--io Displays information in number of I/Os, instead of bytes.
asmcmd iostat -G DATA -t --io
Group_Name  Dsk_Name   Reads  Writes  Read_Time   Write_Time
DATA        DATA_0000  16354  8570    260.792741  13331.596792
DATA        DATA_0001  11496  1650    209.973173  152.957184

asmcmd iostat -G DATA -t --io --region
Group_Name  Dsk_Name   Reads  Writes  Cold_Reads  Cold_Writes  Hot_Reads  Hot_Writes  Read_Time   Write_Time
DATA        DATA_0000  16357  8572    16315       5028         0          0           260.793019  13334.818434
DATA        DATA_0001  11497  1650    11436       1645         0          0           209.973268  152.957184

asmcmd lsof -G DATA
DB_Name  Instance_Name  Path
orclcdb  orclcdb        +data/orclcdb/controlfile/current.260.956739025
orclcdb  orclcdb        +data/orclcdb/datafile/sysaux.257.956738871
orclcdb  orclcdb        +data/orclcdb/datafile/system.256.956738871
orclcdb  orclcdb        +data/orclcdb/datafile/undotbs1.258.956738873
orclcdb  orclcdb        +data/orclcdb/datafile/users.259.956738873
orclcdb  orclcdb        +data/orclcdb/onlinelog/group_1.261.956739029
orclcdb  orclcdb        +data/orclcdb/onlinelog/group_2.262.956739055
orclcdb  orclcdb        +data/orclcdb/onlinelog/group_3.263.956739083
orclcdb  orclcdb        +data/orclcdb/tempfile/temp.264.956739127

oracle@db-asm-1:+ASM:/home/oracle
> ps -ef|grep pmon
oracle   15831     1  0 02:22 ?        00:00:00 asm_pmon_+ASM
oracle   16030     1  0 02:22 ?        00:00:00 ora_pmon_orclcdb
oracle   16330 11101  0 02:24 pts/3    00:00:00 grep pmon

oracle@db-asm-1:+ASM:/home/oracle
> . oraenv <<< orclcdb 
ORACLE_SID = [+ASM] ? The Oracle base remains unchanged with value /u01/app/oracle 

oracle@db-asm-1:orclcdb:/home/oracle 
> srvctl config database
orclcdb

oracle@db-asm-1:orclcdb:/home/oracle
> srvctl stop database -d orclcdb -o immediate

oracle@db-asm-1:orclcdb:/home/oracle
> ps -ef|grep pmon
oracle   15831     1  0 02:22 ?        00:00:00 asm_pmon_+ASM
oracle   16695 11101  0 02:25 pts/3    00:00:00 grep pmon

oracle@db-asm-1:orclcdb:/home/oracle
> . oraenv <<< +ASM
ORACLE_SID = [orclcdb] ? The Oracle base remains unchanged with value /u01/app/oracle

oracle@db-asm-1:+ASM:/home/oracle 
> asmcmd lsof -G DATA
DB_Name  Instance_Name  Path
oracle@db-asm-1:+ASM:/home/oracle
>

Oracle Fusion Business Process Models

Richard Byrom - Sat, 2017-10-07 17:20

At the inception of any enterprise software implementation one of the activities should be to determine what the new business processes will be. On a recent Oracle Fusion implementation I got the chance to become familiar with the process models that should be adopted. Fortunately, at the outset, Oracle provides standard business process models for the following areas

  • Enterprise Planning and Performance Management
  • Marketing
  • Sales
  • Order Fulfilment
  • Supply Chain Planning
  • Product Management
  • Production
  • Procurement
  • Materials Management and Logistics
  • Project Management
  • Financial Control and Reporting
  • Cash and Treasury Management
  • Asset Lifecycle Management
  • Enterprise Information Management
  • Workforce Deployment
  • Workforce Development
  • Compensation Management

Starting with a collection of standard business process models allows you to compare with existing processes and then determine what gaps there may be.

According to the Oracle Fusion Help

Business process modelling is one of the driving forces in the design of Oracle Fusion Applications. This modelling carries through to almost every aspect of Oracle Fusion Financials. The Business Process Models (BPMs) manage the deployment, upgrade, integration, and configuration of the product. Oracle Fusion documentation follows the process models very closely. Roles Based Access security is also tied closed to the BPM Model, so that tasks and activities are assigned appropriately. Messaging and online help are arranged along BPM lines. Field support uses the BPM models to organize their efforts to examine and resolve issues.

The Business Process Model has five levels:

  • Level zero (L0): A specific industry organized around raising capital, executing a business model, and reporting the resultant income to shareholders. For example, Automotive, Communications, Education, Healthcare, and Utilities, to name a few of the approximately thirty identified industries.
  • Level one (L1): A specific business process area.
  • Level two (L2): A specific business process
  • Level three (L3): A specific activity.
  • Level four (L4): Specific tasks involved in an activity.

Having business processes with varying levels means you can start with high level processes and then drill down to lower levels of detail as you require. Furthermore each level will relate back to the hierarchical employee levels in an organisation. An example of how the process levels might look is outlined in Figure 1.

Oracle Fusion Business Process Model Levels Example

Figure 1: An example of Oracle Fusion Business Process Model Levels

The process flows that Oracle provide can be downloaded at Oracle Support Doc ID 1542019.1. The diagrams are pitched at L3 and are typical swim lane Visio documents as illustrated in Figure 2.

Oracle Fusion Close Ledgers L3 Process

Figure 2: An example of an L3 Process Flow Diagram for Ledger Close

I’ve also prepared a process flow listing which you can also download.

Oracle Linux: How to change from uek to Red Hat compatible kernel

Dietrich Schroff - Sat, 2017-10-07 09:26
After a standard installation of Oracle Linux the uek kernel is bootet by default (unbreakable enterprise kernel).
# uname -a
Linux localhost.localdomain 4.1.12-94.3.9.el7uek.x86_64 #2 SMP Fri Jul 14 20:09:40 PDT 2017 x86_64 x86_64 x86_64 GNU/LinuxThis behaviour can be changed with these commands:
First you have to get the linenumber of your new target kernel:
# grep ^menuentry /etc/grub2.cfg  | xargs printf '%s\n' |grep Oracle
Oracle Linux Server (4.1.12-94.3.9.el7uek.x86_64 with Unbreakable Enterprise Kernel) 7.4
Oracle Linux Server (3.10.0-693.el7.x86_64 with Linux) 7.4
Oracle Linux Server (0-rescue-2071bdecbf9a49e4b17d57fb4df518e8 with Linux) 7.4
In my case it is number 2: (3.10.0-....). But the numbering starts with 0. So i have to configure 1:
[root@localhost oracle]# grub2-set-default 1[root@localhost oracle]# grub2-mkconfig -o /boot/grub2/grub.cfg
Generating grub configuration file ...
Found linux image: /boot/vmlinuz-4.1.12-94.3.9.el7uek.x86_64
Found initrd image: /boot/initramfs-4.1.12-94.3.9.el7uek.x86_64.img
Found linux image: /boot/vmlinuz-3.10.0-693.el7.x86_64
Found initrd image: /boot/initramfs-3.10.0-693.el7.x86_64.img
Found linux image: /boot/vmlinuz-0-rescue-2071bdecbf9a49e4b17d57fb4df518e8
Found initrd image: /boot/initramfs-0-rescue-2071bdecbf9a49e4b17d57fb4df518e8.img
done
And after a reboot you will get:
$ uname -a
Linux localhost.localdomain 3.10.0-693.el7.x86_64 #1 SMP Wed Aug 2 06:49:08 PDT 2017 x86_64 x86_64 x86_64 GNU/Linux

MS Windows 10 Creators Update

Frank van Bortel - Sat, 2017-10-07 06:30
It failed. Again. As it has done since august. It has not improved. It's defenitely back to the 1.0 version - no, not a typo. Seach the web for Win 10 upgrade 1703 failed, and will will be greeted with almost half a million hits. MS: get your act together! How about a course "Programming C for beginners"?!? There is NO NEED to reboot more than once (and not even that, actually), and once Frankhttp://www.blogger.com/profile/07830428804236732019noreply@blogger.com0

Watch Oracle OpenWorld 2017 Keynotes On Demand

Amis Blog - Sat, 2017-10-07 06:16

imageWatch Keynotes on YouTube using these links:

Larry Ellison (Sunday Oct 1st) – https://www.youtube.com/watch?v=HEupUSSSEBo

Dave Donatelli (Tuesday Oct 3rd) – https://www.youtube.com/watch?v=irvNYpCopA8 

imageThomas Kurian (Tuesday Oct 3rd) – https://www.youtube.com/watch?v=cef7C2uiDTM 

Larry Ellison (Tuesday Oct 3rd) – https://www.youtube.com/watch?v=faKWViY6zEk&t=6s 

SuiteConnect – Evan Goldberg (Wednesday Oct 4th) – https://www.youtube.com/watch?v=pURoDocJW1Y 


imageJavaOne Keynote (Monday Oct 2nd) – https://www.youtube.com/watch?v=UNg9lmk60sg

image

The post Watch Oracle OpenWorld 2017 Keynotes On Demand appeared first on AMIS Oracle and Java Blog.

Oracle Unified Method (OUM) for Cloud Application Services

Richard Byrom - Sat, 2017-10-07 05:27

Having used many of Oracle’s project management methodologies over the past two decades of implementing it I’m always interested to see what their latest offerings have in store. More recently I’ve been implementing their Fusion applications so have taken a natural interest in Release 6.4 of Oracle Unified Method which has evolved to include an approach for their Cloud Application Services (CAS).

Suzanne Armstrong highlights the key features on the OUM blog as follows

OUM release 6.4 provides support for Application Implementation, Cloud Application Services Implementation, and Software Upgrade projects as well as the complete range of technology projects including Business Intelligence (BI), Enterprise Security, WebCenter, Service-Oriented Architecture (SOA), Application Integration Architecture (AIA), Business Process Management (BPM), Enterprise Integration, and Custom Software. Detailed techniques and tool guidance are provided, including a supplemental guide related to Oracle Tutor and UPK.

This release features:

  • Cloud Home Page – Added to Highlight Cloud Support in OUM
  • CAS OUM (Cloud Application Services OUM) [previously OUM Cloud Application Services Implementation Approach] – Updated Task and Activity/Task Group Identifiers, Updated Terminology
  • Operate Focus Area – Added to Provide Visibility into Services Offered by Oracle Managed Cloud Services (OMCS)
  • Establish Governance Activity [previously Complete Project Management Plan] – Renamed and reframed to place greater emphasis on its main objective, which is to establish project governance by engaging in a dialogue to collaboratively define the processes which will be used to govern and control the project from start to finish. This approach recognizes that the delivery of documentation, while necessary and important, should be the by-product of rather than the driver for conversation.
  • Project Management Plan (PMP) template [previously Project Management Framework] – Developed to streamline the process for documenting project governance. The BT.070 task was renamed to Create Project Management Plan and the guidance was updated. All related tasks that contribute to the PMP were revised to refer to the new PMP template eliminating the prior individual templates. The PMP should be used to document the processes that govern the project.  Once defined, the PMP will remain relatively fixed and only require updates if there are material changes to the governance.
  • Acceptance Certificate [SM.040] Updated and Delivery Note [SM.040] Added - Clarified that acceptance, agreement, and acknowledgment should be secured using one of these templates.  Removed signature boxes / sign-off pages and project manager countersignature from all templates.
  • Risk Management Process, Tasks, and Templates – Streamlined Flow and Clarified Content

Bruce Dehner also has a really good overview presentation which talks about the Cloud Application Services Implementation Approach. It contains a pictorial view of the key activities at each implementation phase which also outlines who is responsible for doing what.

Oracle  OUM Cloud Application Services Approach

The Oracle OUM Partner Knowledge Zone has an abundance of further information and resources. Here you can download OUM collateral, obtain training and certification and view webcasts. Certainly I’m looking forward to making use of the templates and deliverables in my existing and forthcoming implementations.

The power of scripting

Oracle WTF - Sat, 2017-10-07 03:15

So your system has a neat automated archive and purge function for your rolling partitions, driven by the PART_RETENTION table which holds the table name, partition type ('DAILY', 'MONTHLY', 'QUARTERLY' or 'YEARLY') and how many of each to keep. As a general rule, you want 35 dailies, 13 month-ends, 5 quarter-ends and 2 year-ends for each table. Let's say you have ten tables. All you need is a handy script set that up. This is what someone actually came up with. (This is just an example. There were a lot more tables).

insert into part_retention (table_name, partition_type, retention ) values 'COUNTRIES', 'DAILY', 35);
insert into part_retention (table_name, partition_type, retention ) values 'DEPARTMENTS', 'DAILY', 35);
insert into part_retention (table_name, partition_type, retention ) values 'EMPLOYEES', 'DAILY', 35);
insert into part_retention (table_name, partition_type, retention ) values 'JOBS', 'DAILY', 35);
insert into part_retention (table_name, partition_type, retention ) values 'JOB_HISTORY', 'DAILY', 35);
insert into part_retention (table_name, partition_type, retention ) values 'LOCATIONS', 'DAILY', 35);
insert into part_retention (table_name, partition_type, retention ) values 'REGIONS', 'DAILY', 35);
insert into part_retention (table_name, partition_type, retention ) values 'SALES', 'DAILY', 35);
insert into part_retention (table_name, partition_type, retention ) values 'ORDERS', 'DAILY', 35);
insert into part_retention (table_name, partition_type, retention ) values 'ORDER_ITEMS', 'DAILY', 35);
insert into part_retention (table_name, partition_type, retention ) values 'CUSTOMERS', 'DAILY', 35);
insert into part_retention (table_name, partition_type, retention ) values 'COUNTRIES', 'MONTHLY', 13);
insert into part_retention (table_name, partition_type, retention ) values 'DEPARTMENTS', 'MONTHLY', 13);
insert into part_retention (table_name, partition_type, retention ) values 'EMPLOYEES', 'MONTHLY', 13);
insert into part_retention (table_name, partition_type, retention ) values 'JOBS', 'MONTHLY', 13);
insert into part_retention (table_name, partition_type, retention ) values 'JOB_HISTORY', 'MONTHLY', 13);
insert into part_retention (table_name, partition_type, retention ) values 'LOCATIONS', 'MONTHLY', 13);
insert into part_retention (table_name, partition_type, retention ) values 'REGIONS', 'MONTHLY', 13);
insert into part_retention (table_name, partition_type, retention ) values 'SALES', 'MONTHLY', 13);
insert into part_retention (table_name, partition_type, retention ) values 'ORDERS', 'MONTHLY', 13);
insert into part_retention (table_name, partition_type, retention ) values 'ORDER_ITEMS', 'MONTHLY', 13);
insert into part_retention (table_name, partition_type, retention ) values 'CUSTOMERS', 'MONTHLY', 13);
insert into part_retention (table_name, partition_type, retention ) values 'COUNTRIES', 'QUARTERLY', 5);
insert into part_retention (table_name, partition_type, retention ) values 'DEPARTMENTS', 'QUARTERLY', 5);
insert into part_retention (table_name, partition_type, retention ) values 'EMPLOYEES', 'QUARTERLY', 5);
insert into part_retention (table_name, partition_type, retention ) values 'JOBS', 'QUARTERLY', 5);
insert into part_retention (table_name, partition_type, retention ) values 'JOB_HISTORY', 'QUARTERLY', 5);
insert into part_retention (table_name, partition_type, retention ) values 'LOCATIONS', 'QUARTERLY', 5);
insert into part_retention (table_name, partition_type, retention ) values 'REGIONS', 'QUARTERLY', 5);
insert into part_retention (table_name, partition_type, retention ) values 'SALES', 'QUARTERLY', 5);
insert into part_retention (table_name, partition_type, retention ) values 'ORDERS', 'QUARTERLY', 5);
insert into part_retention (table_name, partition_type, retention ) values 'ORDER_ITEMS', 'QUARTERLY', 5);
insert into part_retention (table_name, partition_type, retention ) values 'CUSTOMERS', 'QUARTERLY', 5);
insert into part_retention (table_name, partition_type, retention ) values 'COUNTRIES', 'YEARLY', 2);
insert into part_retention (table_name, partition_type, retention ) values 'DEPARTMENTS', 'YEARLY', 2);
insert into part_retention (table_name, partition_type, retention ) values 'EMPLOYEES', 'YEARLY', 2);
insert into part_retention (table_name, partition_type, retention ) values 'JOBS', 'YEARLY', 2);
insert into part_retention (table_name, partition_type, retention ) values 'JOB_HISTORY', 'YEARLY', 2);
insert into part_retention (table_name, partition_type, retention ) values 'LOCATIONS', 'YEARLY', 2);
insert into part_retention (table_name, partition_type, retention ) values 'REGIONS', 'YEARLY', 2);
insert into part_retention (table_name, partition_type, retention ) values 'SALES', 'YEARLY', 2);
insert into part_retention (table_name, partition_type, retention ) values 'ORDERS', 'YEARLY', 2);
insert into part_retention (table_name, partition_type, retention ) values 'ORDER_ITEMS', 'YEARLY', 2);
insert into part_retention (table_name, partition_type, retention ) values 'CUSTOMERS', 'YEARLY', 2);

Submitted two abstracts to RMOUG Training Days 2018

Bobby Durrett's DBA Blog - Fri, 2017-10-06 18:05

I finally broke down and submitted my two talks to the RMOUG Training Days 2018. I’m not sure how likely I am to get my talks accepted but I learned a lot just through constructing my two abstracts. I have two talks that I have processed in my mind for a while:

  • Python for the Oracle DBA
  • Toastmasters for the Oracle DBA

These are just two things I’ve worked with and that I think have helped me in my job. Plus, they are two topics that interest me. Why talk about something boring just because you think other people want you to?

Anyway, it was fun to write the abstracts for two topics that I am passionate about. I have never been to RMOUG Training Days but I have heard a lot of good things. Hopefully I will get accepted and be able to get these talks out to the public.

I’m off next week so I don’t expect to blog until I get back to work. Maybe after I get back I can start to outline my Toastmasters talk in a few posts. I have given a couple of Toastmasters talks with similar material but this would be geared specifically for people who are more like me in the sense that they are Oracle DBAs.

Anyway, it was fun to get the abstracts turned in.

Bobby

Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator