Oracle Database 18.3.0 on premises available for download on Linux

Finally … it took a bit longer than expected and many people have mailed me in the past days. But Oracle Database 18.3.0 on premises available for download on Linux. Oracle Database 18.3.0 on premises available for download on Linux The other ports may follow soon after. I can’t give dates but you can download Oracle Database 18.3.0 on-prem for Linux now from OTN: Follow this link to access the download location: Oracle Database 18c 18.3.0 for Linux The download gets you the zip file but not the rpm. Those may take a couple of weeks for unknown reasons. And…

Minimum Supported Version for Database Upgrades

This question comes up very often: What is the minimum supported version for database upgrades? Or a question I received today: “I have an Oracle 10.2.0.4 database, can I upgrade directly to Oracle 11.2.0.4?” Usually I have to dig into my old slides from the past to give a definite answer. And of course, the Database Upgrade Guide of each version has the same information somewhere as well. Therefore I’d like to summarize the releases supported for direct database upgrades since Oracle 11.2.0.4 below. Upgrade? When I speak about database upgrades, I mean you’ll use either the command line upgrade…

Download Oracle Database 12.1.0.2 or older versions from the Oracle Software Cloud

I did blog a few weeks back about the download of older versions of the Oracle Database as OTN offers you only the most recent ones. In case you miss the downloads of Oracle Database 12.1.0.2 on OTN Looked pretty simply, huh? Well, here’s quick “how to” to access older Oracle Software downloads from eDelivery aka Oracle Software Cloud. Login to https://edelivery.oracle.com/, the Oracle Software Cloud Start typing “Oracle Database Enter” into the Search by field. It will display you the option below – mark it with a click: Then use the Select Platform drop down list to chose your…

In case you miss the downloads of Oracle Database 12.1.0.2 on OTN

Somebody asked me the other day why the download options for Oracle Database 12.1.0.2 for Linux and Solaris  disappeared from OTN? The same will happen with the other platforms as soon as Oracle Database 12.2.0.1 is available on-premises for them as well. You can always download Oracle Database 12.1.0.2 and previous releases from: Oracle Software Cloud (eDelivery) If you can’t locate the older release you are looking for please see this blog post I did in addition: Download Oracle Database 12.1.0.2 or older versions from the Oracle Software Cloud –Mike

Minor Upgrade? Going from 11.2.0.1 to 11.2.0.4?

My Belgium friend Phillipe Fierens raised a great question on Twitter last week and dropped me an email again after having a discussion with his client: For Phillipe and myself the answer is pretty clear and straight forward: There is no minor upgrade anymore since every (patch set) release is a full release and since new parameters, parameter values, features and whatever appears even in patch sets. But the following discussion on Twitter with comments from all sides made me think about why people would honestly declare going for instance from 11.2.0.1 to 11.2.0.3 as a minor upgrade whereas going…

Why you seriously can’t wait for the second release!

Premier Support for Oracle Database 11.2 has ended 4 weeks ago at 31-January-2015.  I think most Oracle DBAs are aware of it. And I have stressed the topic about the need to upgrade to Oracle Database 12.1.0.2 a lot in the past months via the blog, in workshops and in discussions and customer meetings. But there are still plenty of people out there you would like to wait for Oracle Database 12.2, the so called “second” release. From looking backwards I can understand this thinking. Neither Oracle 9.0 nor Oracle 10.1 were the best and most stable releases ever. If…

Oracle Database Documentation – From Past to Present

Yesterday one of my colleagues, well known Data Guard Guru Larry “Murphy” Carpenter, sent out an internal email with links to older and recent Oracle Database Documentation. Reason why you should use the below links: Some sites in the www have stored copies of the doc – but some may represent not the most recent state or may not be complete. So stay with the official Oracle docs only: Oracle 8.0.6 http://www.oracle.com/technetwork/documentation/oracle8-090636.html Oracle 8.1.7 http://www.oracle.com/pls/tahiti/homepage Oracle 9.0.1 http://www.oracle.com/pls/db901/homepage Oracle 9.2.0 http://www.oracle.com/pls/db92/homepage Oracle Database 10.1.0 http://docs.oracle.com/cd/B12037_01/index.htm Oracle Database 10.2.0 http://www.oracle.com/pls/db102/homepage Oracle Database 11.1.0 http://docs.oracle.com/cd/B28359_01/index.htm Oracle Database 11.2.0 http://docs.oracle.com/cd/E11882_01/index.htm Oracle Database 12.1.0…

Why cows can fly! Believe it or not …

A colleague of mine, Murilo from Oracle Brasil talked about our roles at Oracle (but this applies to any other software company in the market I’d guess). Do you believe in flying cows? Sales In Sales you’ll sell a customer that cows can fly Presales The presales consultant will have to do a presentation showing the ROI, TCO and KPIs of flying cows. She or he may have also a screenshot demo in Powerpoint showing flying cows. Consulting The consultant is the person to install the flying-cow piece of software at the customer site and embedd it into the customer’s…

Why people don’t patch and upgrade?!?

Please see the JAPANESE version of this blog post here!! Discussing the topic “Why Upgrade” or “Why not Upgrade” is not always fun. Actually the arguments repeat from customer to customer. Typically we hear things such as: A PSU or Patch Set introduces new bugs A new PSU or Patch Set introduces new features which lead to risk and require application verification Patching means risk Patching changes the execution plans Patching requires too much testing Patching is too much work for our DBAs Patching costs a lot of money and doesn’t pay out And to be very honest sometimes it’s…

Download Oracle Database 10.2 and 11.1 Software

In the past weeks several customers did either ask me in person or via email where to download Oracle Database 10.2 software, the base release. They need it for testing or to setup a system for an older application etc. And there are plenty of reasons for downloading “older” Oracle software. But it has been completely removed from our OTN page and from eDelivery/SoftwareCloud. There is a reason for doing that but it would be more informative if somebody at Oracle would have put out a message on OTN and eDelivery excusing for the inconvenience and asking you to open…

Excellent Source of Upgrade Information in Japanese

If you are a regular reader of this blog you will know that we have enjoyed our visits to Tokyo, Osaka, and Kyoto immensely. We work very closely with our colleagues in Japan, and I would like to highlight a website that will be extremely useful to anybody who can read Japanese. The site is oracledatabase.jp/upgrade. Here is a screenshot: With plenty of good information from web articles to white papers, this site is a terrific resource for our Japanese partners and customers!