Feed aggregator

PL/SQL functions: Iterate and keys for associative arrays

XTended Oracle SQL - Sun, 2017-10-01 17:54

Unfortunately associative arrays still require more “coding”:
we still can’t use “indices of” or “values of” in simple FOR(though they are available for FORALL for a long time), don’t have convinient iterators and even function to get all keys…
That’s why I want to show my templates for such things like iterator and keys function. You can adopt these functions and create them on schema level.

declare 
   type numbers  is table of number;
   type anumbers is table of number index by pls_integer;
   a anumbers;
   i pls_integer;

   function iterate( idx in out nocopy pls_integer, arr in out nocopy anumbers) 
      return boolean
   as pragma inline;
   begin
      if idx is null 
         then idx:=arr.first; 
         else idx:=arr.next(idx);
      end if;
      return idx is not null;
   end;

  function keys(a in out nocopy anumbers) return numbers as
     res numbers:=numbers();
     idx number;
     pragma inline;
  begin
     while iterate(idx,a) loop
        res.extend;
        res(res.count):=idx;
     end loop;
     return res;
  end;

begin
   a(1):=10;
   a(3):=30;
   a(5):=50;
   a(8):=80;
   -- iterate:
   while iterate(i,a) loop
      dbms_output.put_line(a(i));
   end loop;

   -- keys:
   for i in 1..keys(a).count loop
      dbms_output.put_line(a(keys(a)(i)));
   end loop;

end;
Categories: Development

Oracle Announces Strong Cloud Momentum in Partner Program

Oracle Press Releases - Sun, 2017-10-01 15:01
Press Release
Oracle Announces Strong Cloud Momentum in Partner Program New Oracle PartnerNetwork Program and Enablement Resources Provide Easier Access to Oracle’s State-of-the-Art Cloud Platform

Oracle OpenWorld, San Francisco, Calif.—Oct 1, 2017

Oracle PartnerNetwork (OPN), today announced that the company continues to see strong cloud leadership and momentum across its 25,000-member strong partner program. Companies are increasingly looking to the cloud to stay competitive and enable business transformation. Since its launch in February 2016, more than 2,600 unique partners have joined the Oracle PartnerNetwork Cloud Program. Additionally, cloud resell revenue from partners increased 105 percent year over year.

Further helping customers and partners succeed in the cloud, OPN also today announced the Oracle Cloud Excellence Implementer Program. Please see the release here.

“Oracle continues to deliver the programs and enablement resources that help our partners to grow and thrive in the cloud,” said Dave Donatelli, executive vice president, Cloud Business Group, Oracle. “Through Oracle PartnerNetwork, we work in tandem with partners to provide customers with the solutions and services needed to take advantage of Oracle’s state-of-the-art cloud platform.”

With Oracle’s complete and integrated cloud, customers can choose their own personalized path for how they want to move to cloud and partners are a critical part of that journey. Nearly half of all partners in the OPN program today implement, develop and sell in the cloud with Oracle.

Providing ISVs a Platform for Success

For independent software vendors (ISVs), selecting the right cloud platform, and the right cloud partner, are critical decisions for their business. ISVs and application developers must balance the requirements of their current businesses and implementations with the need to invest in innovative new architectures, modern cloud capabilities, and flexible deployment models. With Oracle’s broad collection of available PaaS and IaaS services, we are delivering on the most comprehensive portfolio of cloud services and capabilities for developers, as well as programs, resources, and commercial models that meet both immediate business needs and longer-term growth objectives.

From startups to enterprise application providers, hundreds of partners worldwide are realizing the many benefits of migrating their applications and customers to Oracle Cloud Platform and Infrastructure, including 1Check, Manhattan Associates, Wexlog and many others.

“Oracle’s commitment to partners is clear—we both win when we work together,” said Jeff Cashman, senior vice president of business development, Manhattan Associates. “We are excited to collaborate with Oracle in bringing state-of-the-art cloud solutions to companies of all sizes.”

Oracle is investing in innovative new services and capabilities with Docker and Kubernetes, which has captured the attention of cloud application developers at Dial-Once, RECVUE, and SuiteBox among others.

Through the Oracle Cloud Marketplace, partners can expand the visibility of their applications to 425,000+ Oracle customers and partners. PS Technology, Stromasys and Symantec are a few of the 4,000+ cloud application providers leveraging Oracle programs and go to market resources to grow their business and expand into new markets.

New OPN Enablement Resources

Also launched today, the Cloud Excellence Implementer Program (CEI) helps customers make a smooth transition to the cloud through Oracle implementation partners. The new program recognizes and rewards those partners who have invested in building their Oracle Cloud expertise and demonstrate a proven track record for delivering high quality cloud implementation projects across Oracle’s customer base. With the CEI distinction, partners that work with Oracle to implement Oracle Cloud around the globe will be able to further differentiate themselves in the marketplace, and benefit from increased enablement and go-to-market support from Oracle. In tandem, customers will be able to more easily identify partners with the specific expertise and proven track record they need to successfully navigate their transition to the cloud.

The CEI program is available to OPN members now and will initially focus on implementations for Oracle’s SaaS Cloud services.

Driving Cloud Momentum for MSPs

Unveiled at OpenWorld 2016, the Oracle Cloud Managed Service Provider (MSP) program enables customers to speed up success in the cloud with support from the right partner and platform. The program is available to partners with the skills and infrastructure to build, deploy, run and manage both Oracle and non-Oracle workloads, enabling OPN members to offer a complete managed service solution for workloads running on Oracle Cloud.

The Oracle Cloud MSP Program most recently includes Fujitsu America Inc., which just announced a new MSP relationship to provide Oracle Cloud to its customers in the Americas.

“There is a breadth of opportunity for all partners—regardless of partner type—to expand your solution portfolios with Oracle Cloud,” said Penny Philpot, group vice president of worldwide channels and alliances, Oracle. “Our primary focus is working together with partners to transform our customers’ businesses and support their growth in the cloud.”

Oracle is one of the only cloud providers to deliver complete industry-leading product portfolios across Software-as-a-Service (SaaS), Platform-as-a-Service (PaaS), Infrastructure-as-a-Service (IaaS), and Data-as-a-Service (DaaS). Its SaaS portfolio features the broadest set of solutions in the marketplace, which can be extended, enriched and customized through Oracle PaaS and delivered on Oracle IaaS for high performance, security, scale and availability. In addition, Data as a Service (DaaS) complements our existing SaaS applications with one of the world’s largest third-party data sources with more than six billion anonymized profiles from online data, websites, and offline transactions for every major industry.

Contact Info
Scott Thornburg
Oracle
+1.415.816.8844
scott.thornburg@oracle.com
Kristin Reeves
Blanc & Otus PR for Oracle
+1.415.787.6744
kreeves@blancandotus.com
About Oracle

The Oracle Cloud delivers hundreds of SaaS applications and enterprise-class PaaS and IaaS services to customers in more than 195 countries and territories while processing 55 billion transactions a day. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

About Oracle PartnerNetwork

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

About Oracle OpenWorld

Oracle OpenWorld, the industry's most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,500 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

Trademarks

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

Safe Harbor

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

Statements in this article relating to Oracle’s future plans, expectations, beliefs, and intentions are “forward-looking statements” and are subject to material risks and uncertainties. Such statements are based on Oracle’s current expectations and assumptions, some of which are beyond Oracle’s control. All information in this article is current as of October 1, 2017 and Oracle undertakes no duty to update any statement in light of new information or future events. 

Talk to a Press Contact

Scott Thornburg

  • +1.415.816.8844

Kristin Reeves

  • +1.415.787.6744

New Oracle PartnerNetwork Program Drives Oracle Customer Success

Oracle Press Releases - Sun, 2017-10-01 15:00
Press Release
New Oracle PartnerNetwork Program Drives Oracle Customer Success Oracle Cloud Excellence Implementer Program Recognizes and Rewards Partners for Consistently Delivering Successful Oracle Cloud Implementations

Oracle OpenWorld, San Francisco, Calif.—Oct 1, 2017

To accelerate customers’ digital transformation in the cloud, Oracle PartnerNetwork (OPN) today launched the Oracle Cloud Excellence Implementer (CEI) program. The offering recognizes and rewards partners that continually demonstrate expertise, a successful track record, and superior customer satisfaction in delivering high-quality Oracle Software as a Service (SaaS) Cloud implementations to customers.

Oracle is committed to delivering spectacular customer experiences across the Oracle Cloud portfolio. This applies to the entire customer lifecycle, but the implementation phase—including investment in the support and services our customers need—is particularly critical to customer success and satisfaction.

The CEI program was developed to provide customers with a clear, objective and informative view of partner qualifications for implementing Oracle SaaS solutions. Through the OPN Solutions Catalog, customers are now able to easily identify and engage with partner firms that best align to their specific project needs. Access to this information helps customers minimize implementation risk, quickly adopt new cloud functionality, and continuously expand their Oracle Cloud footprint.

Partners may qualify for CEI status with individual Oracle cloud service module(s) within defined geographies, and must meet a rigorous set of entry and ongoing engagement criteria in order to remain in the program. Firms that achieve CEI status will be able to further differentiate themselves in the market and receive the highest level of benefits and deeper engagement with Oracle.

“The cloud continues to represent a tremendous opportunity not only for our customers, but also for our partner community,” said Camillo Speroni, Vice President of Worldwide Strategic Alliances, Oracle. “As such, we remain committed to providing the intelligence and resources both parties need to make this transition as smooth and successful as possible. The CEI program was designed to recognize and support those partners that not only offer a marked expertise in Oracle Cloud solutions, but also a commitment to excellence in ensuring successful customer experiences and outcomes throughout the entire implementation process.”

The CEI program officially launched at Oracle OpenWorld during the OPN Central Keynote, where Oracle executives outlined Oracle’s cloud direction and strategy. The partner application process opened on June 28, 2017. A full list of CEI partners can be found on the Oracle PartnerNetwork portal.

“As a regional partner with hubs in North America, Europe and ASEAN, the Oracle Cloud Excellence Implementer program is an opportunity for us to showcase our specific expertise in Oracle Cloud implementations, giving us the ability to compete with larger global organizations within the scope and geography we specialize in,” said Andy Bird, Founder and CEO, Inoapps. “We are thrilled that this new program recognizes implementation success and customer satisfaction—rather than focusing on only sales statistics—and allows us to set ourselves apart in the market as a proven leader in Oracle Cloud implementations.”

For more information about the CEI program, visit www.oracle.com/partners/goto/cei.

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

To find out more visit: http://www.oracle.com/partners.

Contact Info
Scott Thornburg
Oracle
+1.415.816.8844
scott.thornburg@oracle.com
Kristin Reeves
Blanc & Otus PR for Oracle
+1.415.787.6744
kreeves@blancandotus.com
About Oracle

The Oracle Cloud delivers hundreds of SaaS applications and enterprise-class PaaS and IaaS services to customers in more than 195 countries and territories while processing 55 billion transactions a day. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

About Oracle OpenWorld

Oracle OpenWorld, the industry's most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,500 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

Trademarks

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

Safe Harbor

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

Statements in this article relating to Oracle’s future plans, expectations, beliefs, and intentions are “forward-looking statements” and are subject to material risks and uncertainties. Such statements are based on Oracle’s current expectations and assumptions, some of which are beyond Oracle’s control. All information in this article is current as of October 1, 2017 and Oracle undertakes no duty to update any statement in light of new information or future events. 

Talk to a Press Contact

Scott Thornburg

  • +1.415.816.8844

Kristin Reeves

  • +1.415.787.6744

Virtualbox: How to use shared folders (aka gemeinsame Ordner)

Dietrich Schroff - Sun, 2017-10-01 14:23
If you want to use a directory inside a virtualbox vm without copying all files, you can use the shared folders.
Just choose a folder to share:

Then inside the vm type:
[root@localhost oracle]# mount -t vboxsf 12c /mntand that's it:
[root@localhost oracle]# df -h |grep 12c
12c                  180G    129G   52G   72% /mntor
[root@localhost oracle]# mount | grep 12c
12c on /mnt type vboxsf (rw,nodev,relatime)
When you are done just unmount the folder with
umount /mnt

Running Oracle Linux inside VirtualBox: Installation Virtualbox guest additions

Dietrich Schroff - Sun, 2017-10-01 12:36
First you have to insert the Virtualbox Guest Additions iso-image:
You can check this here:
 If this does not work, just add the iso into the IDE controller of virtualbox:

 As root you have to mount the image:


Before you can run the installer you have to get the following packages:

yum list kernel*Take the one with "devel" which version matches:
uname -aLinux 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/Linux
Something like
yum install kernel-uek-devel-XXXXXXThen install the follwing packages:
yum install dkms binutils gcc make patch libgomp glibc-headers glibc-devel bzip2Then export KERN_DIR:

Finally you can run the installer VBboxLinuxAdditions.run:

Then a reboot and everything should be fine.
The walkthrough the Oracle Linux installation process can be found here.
(Preconfiguration steps for virtualbox can be found here

Running Oracle Linux inside VirtualBox: Installation

Dietrich Schroff - Sun, 2017-10-01 12:33
After configuring the HDD, RAM, network, etc on VirtualBox (take a look here), i started the VM:

 
 Choose "Install Oracle Linux7.4":

Language settings:
 Overview (partitioning and network missing):
 Network interface:
 Partitioning:
 Start package installation:
 Configure passwords / users:
 
 Waiting for reboot:
(Installation of the virtualbox guest additions can be found here)
(Preconfiguration steps for virtualbox can be found here)

Running Oracle Linux inside Virtualbox: Preconfiguration of the virtualization engine

Dietrich Schroff - Sun, 2017-10-01 12:32
This is a walkthrough the VirtualBox GUI settings to install Oracle Linux. First you have to name your VM and choose Oracle Linux 64 bit:
RAM:
HDD:
HDD type:
HDD dynamic/static:
HDD size:
After these steps you have to mount the iso image:

And you should configure a network adapter. I chose the WLAN interface of my laptop:

I will post the walkthrough the installation process soon.
(Installation of the virtualbox guest additions can be found here)

New Game. New Name. Oracle Developer Community

OTN TechBlog - Sun, 2017-10-01 02:40

Technology has driven so much change that people have become nearly oblivious to all but the most dramatic innovations. But it’s important to remember that each wave of the innovation began with a single keystroke, one character in a line of code, then another, then another. It’s important to remember that the finger pressing down on that key is attached to a human being. A developer.

Developers drive change, and change, in turn, drives developers. It’s a perpetual evolutionary cycle that requires perpetual adaptation at both the individual and the organizational level.

There’s a major shift happening in technology — and at Oracle. This evolution is powered by a diverse population of software developers. In adapting to this evolution, the Oracle Technology Network has now become the Oracle Developer Community, and over the past year we’ve created programs to support people building modern, open, cloud-native applications.

Developer Champions

Developer Champions have expertise in modern software and cloud development, including microservices, containers, DevOps, continuous delivery, open source technologies, and SQL/NoSQL databases. These professionals are contributors to open source projects, authors on contemporary development approaches, and speakers at prominent Oracle (Oracle Code, JavaOne) and top industry conferences such as Devoxx, Developer Week, Velocity, and QCon. Meet the New Developer Champion Program.


Live for the Code!

Oracle Code Events

In this international series of free events developers learn about the latest technologies, practices, and trends from technical experts, industry leaders, and other developers in keynotes, sessions, and hands-on labs. And to make sure every developer  has access to these content, Oracle Code Online brings the same content and experts directly to your screen. More information...

Social Media and Content Aggregation

You can now connect with the Oracle Developer Community through a variety of social media channels:

Oracle Developers Portal

Pulling it all together is the Oracle Developers Portal. This inclusive space is for all of our language- and technology-specific communities, which we enthusiastically support. You’ll find a wide variety of content covering:

So play your part in driving innovation, and be a part of the Oracle Developer Community

SaveSave

CIDR for Dummies DBA in Cloud

Pakistan's First Oracle Blog - Sun, 2017-10-01 02:00
For DBAs of Cloud, its imperative to learn various networking concepts and CIDR is one of them. Without going into much detail, I will just post here quick note as what CIDR is and how to use it.



A CIDR looks something like this:

10.0.0.0/28

The 10.0.0.0/28 represents range of IP addresses, and no its NOT from 10.0.0.0 to 10.0.0.28. Here is what it is:

So in order to know how many IP address are in that IP range and from where it starts and where it ends, the formula is :

2 ^ (32 - )

So for the CIDR 10.0.0.0/28 :

2 ^ (32 - 28) = 2 ^ 4 = 2 * 2 * 2* 2 = 16

So in CIDR range 10.0.0.0/28 , we have 16 IP addresses in which

Start IP = 10.0.0.0
End IP  = 10.0.0.15



Also cloud providers normally reserve few IPs out of this CIDR range for different services like DNS, NAT etc. For example, AWS reserves first 4 and last IP of any CIDR range. So in our example , we would just have 10 IP addresses to work with in AWS.

So in case of AWS, we would have a region where we would have a VPC. CIDR is assigned to that VPC. In that VPC, for example we would have 2 subnets. We can distribute our 10 IPs from our CIDR 10.0.0.0/28 to our both subnets. Below I am giving 5 IPs to each subnet. A subnet is just a logical separate network.

For example we can give:

Subnet 1:

10.0.0.5 to 10.0.0.9

Subnet 2:

10.0.0.10 to 10.0.0.14 

Hope that helps.

PS. And oh CIDR stands for Classless Inter-Domain Routing (or Supernetting)
Categories: DBA Blogs

Oracle Container Registry mirrors in Oracle Cloud Infrastructure

Wim Coekaerts - Sat, 2017-09-30 19:56

Just in time for Oracle OpenWorld 2017!

For quite some time now, we have had a Container Registry available for users with an Oracle Single-Signon account. This registry contains a large number of Docker images to make it really easy to get started with Oracle Products such as the Oracle Database, MySQL, Oracle Linux, Java, Weblogic etc...No need to create or register a new account. Many of you already have an Oracle SSO account for use with OTN, My Oracle Support or Oracle Software Delivery Cloud.

The first time, you have to log in to the website hosted at http://container-registry.oracle.com (use your SSO account) and accept the licences for the products you want to download/pull with the Docker client. Once you have accepted the licenses, unless a license changes, or you want to access a product for which you have not yet accepted the license, you do not have to login to the website any more. From here on, you can use docker pull container-registry.oracle.com/<repository>/<product> to pull down the images you are interested in. 

Well, the above is not new, really but I wanted to give a very quick overview of what we have on our container registry.

What IS new:

Lots of our customers are using Oracle Cloud Infrastructure and there is a big interest in using Docker images for new projects. Since we want our customers/developers to have the best experience, we created / will create local mirrors of the central Container Registry in each OCI region. As of right now, the Ashburn and Phoenix OCI regions mirrors are online, Frankfurt will follow shortly. Why does this help? Well, first of all, performance. A few examples: timing a pull (and extract) of an Oracle Linux 7-slim image is just over 3 seconds. MySQL Community server 8 seconds, Oracle Database Standard or Enteprise Edition 3 minutes (full downloaded and extracted in your local OCI instance). And secondly, all network traffic stays within the Oracle Datacenters so you are not consuming Internet Traffic bandwidth.

The process remains the same: the main website to accept licenses is still http://container-registry.oracle.com. When you use docker on the command line in your instance, use either container-registry-phx.oracle.com or container-registry-ash.oracle.com. In the near future we will enable container-registry-fra.oracle.com. 

First you have to login on the command line:

 

# docker login container-registry-ash.oracle.com
Username: wim.coekaerts@oracle.com
Password: 
Login Succeeded

 

Next you can pull one of the many images:

 

# docker pull container-registry-ash.oracle.com/os/oraclelinux:7-slim
7-slim: Pulling from os/oraclelinux
d9ca67fed2e2: Pull complete 
Digest: sha256:2c4be3230da36933e1e9961909ed40c7fc3cc36107f86c2ed6c1775ea1c884fc
Status: Downloaded newer image for container-registry-ash.oracle.com/os/oraclelinux:7-slim

These registries are also accessible from outside of the OCI regions over the internet so if you experience slow access to container-registry.oracle.com, try one of these new ones.

We have a number of product categories available. You can find all the details on how to use them, which tags (versions of images such as 7.1 7.4, latest,...) on the registry website:

We are working on providing a mirror for http://yum.oracle.com inside OCI as well. Stay tuned for more Oracle Linux goodies in Oracle Cloud Infrastructure.

 

 

The day before OOW17; infra expectations

Amis Blog - Sat, 2017-09-30 19:01

Oracle Open World 2017 is starting tomorrow, and as a platinum partner of Oracle, we – AMIS Services – are obliged to keep us and our customers informed with the roadmap of Oracle products.

And of course translate this to added business-value for our customers.  In short: what to pick of all the coming announcements, new features, cloudiness and so on.  All the arrows are pointed towards the Oracle Cloud products of course, but first we’ll have to find the answer of the two questions:   ‘why should a customer go to the cloud’  and if yes ‘what role is Oracle Cloud playing in this’.

This week will be – as in the last years – full of announcements. It started early this year with the pre-announcement of Larry last week about the ‘autonomous database’, Bring Your Own Licence to the Cloud and Universal Credits.

As a reminder, hereby a wrap-up of the presentation of Larry Ellison:

– Lowest price for IaaS. That means the same price as Amazon, but faster, thus cheaper.

– Highest rate of automation in PaaS. That means the lowest TCO. Goal is to garantee a 50% lower TCO than Amazon

– The ‘autonomous database’ is available in December, based on Machine Learning. This should eliminate human Labor (DBA).

– Service Level Agreement of 99,995%, this is 30 minues of planned and unplanned downtime a year.

– Bring Your Own License for PaaS. 94% cheaper than the old price. This should lower the treshold to use the Oracle Cloud.

– It’s becoming possible to buy Universal Credits, no more linked to a Cloud product.

This wrap-up covers pretty much my agenda or, as you will, my focus of this Oracle Open World. Primarily focussed on TCO, (Cloud) platforms, databases, middleware , Engineered systems.

Oracle has taken some pretty smart moves, which will influence products like

– Engineered Systems. In general : is there still a business case in buying on-premisses hardware

– The role and feature of the DBA. DBAKevlar wrote a nice blog about this.

– Life Cycle Management of the platform. How to cope with the management of a hybrid environment, including this new autonomous databases, and containers.

– Databases. There will be a lot of new features in Oracle18.

Tomorrow it will be the start of an exhausting week and I’m not even presenting nor ACE or Developement Champion! Just a mortal visitor, attending a lot of presentations, key-notes, meetings with product-managment, network-events, appreciation-events, dinners with Oracle representatives.

Respect for my colleagues Lucas Jellema and Robert van Molken. Together they  are involved  with (or are presenting) 9 presentations.

My intention is also to write quite regurarly about the things that went on my journey this week.

Regardz

Resources:

Larry Ellison’s announcement: http://www.oracle.com/us/corporate/events/cloud-announcement/index.html

DBAkevlar’s blog : http://dbakevlar.com/2017/09/death-dba-long-live-dba/

Lucas Jellema en Robert van Möken presentations / involvements: https://events.rainfocus.com/catalog/oracle/oow17/catalogoow17?search=AMIS%20&showEnrolled=false

The post The day before OOW17; infra expectations appeared first on AMIS Oracle and Java Blog.

remove compress basic

Tom Kyte - Sat, 2017-09-30 17:46
What is the best way to remove compress basic from tables and partitions in production environment.
Categories: DBA Blogs

FILE_ID vs RELATIVE_FNO

Tom Kyte - Sat, 2017-09-30 17:46
Hi TOM, Trying to understand the difference between FILE_ID & RELATIVE_FNO in dba_data_files and dba_extents.
Categories: DBA Blogs

Is UTL_MAIL supported in 11g EE

Tom Kyte - Sat, 2017-09-30 17:46
Hi Team, Wanted to know wherher utl_mail is supported in 11g EE.I installed the version in my local windows machine.I am able to connect to it via SQL Developer. I can see utl_smtp and utl_tcp packages are installed. I tried to install the utlmail...
Categories: DBA Blogs

AVM Fritz: WLAN Mesh with Powerline Repeater does not work

Dietrich Schroff - Sat, 2017-09-30 06:40
Today i upgraded my FritzBox to FritzOS 6.90:

After the upgrade of the FritzBox i tried to upgrade my Powerline Adapter. But the 6.90 was not shown with inside the update mechanism via GUI.
(Be careful: you have to update your FritzBox first:
https://avm.de/nc/service/downloads/download/show/18332/:
ACHTUNG: Bitte nur installieren, wenn Sie eine FRITZ!Box mit FRITZ!OS >= 6.88 verwenden!)

So i downloaded the firmare image via this link and installed the new version:

Inside the FritzBox the WLAN mesh can be checked in "Heimnetz -> Heimnetzübersicht":

But no device behind the powerline adapter showed up.
I googled a bit around, but all AVM support pages where deleted. Inside Google cache i found the following:

So the mesh icon is missing at the powerline adapter. A reboot of the fritzbox and the powerline adapter did not change anything.

On AVM website there is an image how it should look like:

But it think, they have a problem with their mesh functionality and removed the 6.90 auto update for the wlan repeaters/powerline adapters and they even removed all support pages for the wlan mesh.

Let's wait for some bug fixes ;-)
(Still remember: These upgrades are just for free)

Ubuntu /etc/alternatives/java et.al.: Using java from external sources | update-alternatives | update-java-alternatives

Dietrich Schroff - Sat, 2017-09-30 02:21
After some problems with the jdk integrated in ubuntu 16.04 i installed the OpenJDK from http://jdk.java.net/9/.

The software is provided as tarball (tar.gz) and after
tar -xvf ~/Downloads/jdk-9+178_linux-x64_bin.tar.gz the binaries can be used with
jdk-9/bin/java
...But there are many links in /etc/alternatives still pointing to the ubuntu jdk:
lrwxrwxrwx 1 root root  41 Jul 11 21:02 /etc/alternatives/jar -> /usr/lib/jvm/java-9-openjdk-amd64/bin/jar
lrwxrwxrwx 1 root root  51 Jul 11 21:02 /etc/alternatives/jar.1.gz -> /usr/lib/jvm/java-9-openjdk-amd64/man/man1/jar.1.gz
lrwxrwxrwx 1 root root  47 Jul 11 21:02 /etc/alternatives/jarsigner -> /usr/lib/jvm/java-9-openjdk-amd64/bin/jarsigner
lrwxrwxrwx 1 root root  57 Jul 11 21:02 /etc/alternatives/jarsigner.1.gz -> /usr/lib/jvm/java-9-openjdk-amd64/man/man1/jarsigner.1.gz
lrwxrwxrwx 1 root root  42 Mai 31 21:09 /etc/alternatives/java -> /usr/lib/jvm/java-9-openjdk-amd64/bin/java
lrwxrwxrwx 1 root root  52 Mai 31 21:09 /etc/alternatives/java.1.gz -> /usr/lib/jvm/java-9-openjdk-amd64/man/man1/java.1.gz
lrwxrwxrwx 1 root root  43 Jul 11 21:02 /etc/alternatives/javac -> /usr/lib/jvm/java-9-openjdk-amd64/bin/javac
lrwxrwxrwx 1 root root  53 Jul 11 21:02 /etc/alternatives/javac.1.gz -> /usr/lib/jvm/java-9-openjdk-amd64/man/man1/javac.1.gz
lrwxrwxrwx 1 root root  45 Jul 11 21:02 /etc/alternatives/javadoc -> /usr/lib/jvm/java-9-openjdk-amd64/bin/javadoc
lrwxrwxrwx 1 root root  55 Jul 11 21:02 /etc/alternatives/javadoc.1.gz -> /usr/lib/jvm/java-9-openjdk-amd64/man/man1/javadoc.1.gz
lrwxrwxrwx 1 root root  43 Jul 11 21:02 /etc/alternatives/javah -> /usr/lib/jvm/java-9-openjdk-amd64/bin/javah
lrwxrwxrwx 1 root root  53 Jul 11 21:02 /etc/alternatives/javah.1.gz -> /usr/lib/jvm/java-9-openjdk-amd64/man/man1/javah.1.gz
lrwxrwxrwx 1 root root  43 Jul 11 21:02 /etc/alternatives/javap -> /usr/lib/jvm/java-9-openjdk-amd64/bin/javap
You can change them manually by deleting and creating new links but i think this is to much work.
Update-Alternatives works, but you have to issue the following command many times:
update-alternatives --quiet --install /usr/bin/jconsole jconsole /home/data/opt/jdk-9/bin/jconsole 1191Update-java-alternatives
update-java-alternatives.new -s java-jdk-9
update-java-alternatives.new: directory does not exist: /usr/lib/jvm/java-jdk-9
 does not work. But this can be fixed by creating your own jinfo file:
ls -la /usr/lib/jvm/.*jinfo
-rw-r--r-- 1 root root 2600 Mai  6 05:55 /usr/lib/jvm/.java-1.8.0-openjdk-amd64.jinfo
-rw-r--r-- 1 root root 2646 Apr 14  2016 /usr/lib/jvm/.java-1.9.0-openjdk-amd64.jinfo
-rw-r--r-- 1 root root 2058 Jul 14 22:05 /usr/lib/jvm/.java-jdk-9.jinfo
Just copy one of the existing files and change the paths to your JDK installation directory.
Then copy update-java-alternatives to update-java-alternatives and change the following lines:

inside the do_set function
#update-alternatives $uaopts --set $name $location
prio=$(awk -F= '/priority=/ {print $2}' $top/*$jname.jinfo)
update-alternatives $uaopts --install /usr/bin/${location##*\/} $name $location $prio
And then
update-java-alternatives.new -s java-jdk-9will change all links in /etc/alternatives, so that running java without path will use the your installed version...
$ java -version
java version "9"
Java(TM) SE Runtime Environment (build 9+178)
Java HotSpot(TM) 64-Bit Server VM (build 9+178, mixed mode)

What performs better NVL or DECODE for evaluating NULL values

Tom Kyte - Fri, 2017-09-29 23:26
Afternoon, Could anyone tell me which of the following statements would perform better? <code> SELECT 1 FROM DUAL WHERE NVL (NULL, '-1') = NVL (NULL, '-1') </code> OR <code> SELECT 1 FROM DUAL WHERE DECODE(NULL, NULL, '1', '0') = '...
Categories: DBA Blogs

Which Index is Better Global Or Local in Partitioned Table?

Tom Kyte - Fri, 2017-09-29 23:26
We have partitioned table based on date say startdate (Interval partition , For each day) We will use query that will generate report based on days (like report for previous 5 days) Also we use queries that will generate report based on hours (li...
Categories: DBA Blogs

SQL to find the ip address

Tom Kyte - Fri, 2017-09-29 23:26
Hi Tom, I want to capture the IP address of any client who has shutdown the db. Support currently in my db 5 clients are connected, one client shutdown the db, then I want to capture the IP address of client who has been shutdown the db. How to solv...
Categories: DBA Blogs

AWR

Tom Kyte - Fri, 2017-09-29 23:26
Hi Tom/Team, I am aware of the definition of terms used in AWR Report. but i want to know that - how to calculate and on what basis we need to calculate values listed for points in below 2 section of AWR report 1. Top 5 timed foreground event ...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator