support – Laurent Schneider

Download Oracle software with the command line

When downloading software to my database server, I used to first download locally and later copy to my Unix box… but wouldn’t be convenient to download it directly on the database server? Quite often, you get no X and no Browser and no Internet access on your datacenter. Therefore, we’ll use wget to the purpose.… Continue reading Download Oracle software with the command line

Unannouncement: Oracle 20c release date

Just reading the Doc 742060.1, the release 20c, which was due 2020, disappeared from the roadmap. Don’t wait anymore for 20c, there won’t be one. There was a preview release in the cloud, but Oracle failed to release one new release every year. While we are all used to wait 2-6 years for a new… Continue reading Unannouncement: Oracle 20c release date

12.1.0.2 on AIX

just released today http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html only in Enterprise Edition at the moment, and now available on HPUX, zLinux and AIX #oracle12c #db12102 is out for a bunch of platform #aix #os390 #hpux #zlinux — laurentsch (@laurentsch) November 17, 2014 This is the first and last patchset for 12cR1 #oracle 12.1.0.2 is the last patch set for… Continue reading 12.1.0.2 on AIX

to R1 or to R2

In the past, most of my customers skipped R1 releases. That is, 8.1.7 -> 9.2 -> 10.2 -> 11.2. SAP does the same. For the very first time SAP plans to go to 12.1.0.2 + some PSU in spring 2015. But only to avoid running out of support and without any fancy feature like Multitenant… Continue reading to R1 or to R2

12cR2

#db12cR2 release announced for 2016, Doc ID 742060.1 — laurentsch (@laurentsch) September 5, 2014

The new metalink interface

I just started using the New My Oracle Support User Interface It is a zero-flash interface with more capabilities than the “html” interface we used the previous years. It still provides about the same browser experience as the flash one. Have a try… according to Oracle : “it will eventually replace the Flash version” To… Continue reading The new metalink interface

11.2.0.3 on AIX / HPUX released

download patch 10404530

_optimizer_random_plan parameter

I was trying to find a workaround for a bug in 11.2.0.2 SELECT * FROM (SELECT 2 B FROM DUAL WHERE DUMMY = ‘Y’), (SELECT 3 C FROM DUAL WHERE DUMMY LIKE ‘%’) WHERE C = B(+); B C ———- ———- 2 3 ————————————————————————— | Id | Operation | Name | Rows | Bytes |… Continue reading _optimizer_random_plan parameter

Oracle 11.2.0.3

Just installed Oracle 11gR2 patchset 2 on Solaris Sparc 64bit, it works like a charm, waiting for the AIX patchset impatiently https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=10404530

my first ADR package

You got an internal error and want to create a zip of all relevant files. First, let’s generate an internal error. I found a quick way to generate an ora-600 or an ora-700 (which is a harmless ora-600 in 11g, read 737878.1) on oradeblog SQL> oradebug unit_test dbke_test dde_flow_kge_soft foo bar baz Statement processed. Now… Continue reading my first ADR package

11.2.0.2 for win32 and win64

patch 10098816 is available for download

11.2.0.2

I have read on Surachart Opun’s blog that 11.2.0.2 is available, but also that the patchset is now a full installation. In the past, if you wanted to have 9.2.0.8 or 10.2.0.5, you needed to install both the base version, 9.2.0.1 or 10.2.0.1 and the patchset, 9.2.0.8 or 10.2.0.5. Very often the patchset itself was… Continue reading 11.2.0.2

what’s up last weeks?

I just came back from diving, parasailing, safari and more fun in Egypt. On my blog I saw a comment from Nicolas regarding the availability of the terminal patchset for 10gR2 Note 161818.1: Oracle Database Releases Status Summary 10.2.0.5: Patchset 8202632

Happy New Year 2010

It is quite a while I have not posted anything of interest, I pretty apologize to my faithful readers… the reason for being offline are multiple, one of them, I cannot access my blog from my workplace yet. Ok, the last hint from my dba regarding Oracle Support : If flash really drives you nuts,… Continue reading Happy New Year 2010

dealing with support

It is quite a long time I did shot the pianist in my blog… probably patience and perseverance are better than aggressive behavior, but today I have been transfixed by an answer from metalink. Sometimes the issues I submit are a bit exotic but there it was a join with one view using one function… Continue reading dealing with support

future release dates of 11gR2

HPUX Itanium, Sun Sparc/x86_64, AIX –> october-december 2009 Windows, HPUX Risc –> april-june 2010 Ref: Release Schedule of Current Database Patch Sets Dates will change, keep an eye on the schedule, and do not base your business on expected dates ! Please be patient 🙂

Oracle on Mac

I just read a post from Barry Mc Gillin about apex on MacOsX. After having being using Vista for one year, I would really welcome a Mac as my next notebook. But what about Oracle Database on Mac OS X? According to otn, the latest release as of today is a deprecated 10gR1 for the… Continue reading Oracle on Mac

11g release 1 patchset 1

I just notice on Sven Blog that 11.1.0.7 is available. I have recently upgraded my connection at home so it took a bit less than half an hour to download this 1.5G patchset $ wget -O p6890831_111070_Linux-x86-64.zip http://oracle-updates.oracle… –10:17:40– http://oracle-updates.oracle.com/ARUConnect/p6890831_111070_Linux-x86-64.. Resolving oracle-updates.oracle.com… 87.248.199.23, 87.248.199.24 Connecting to oracle-updates.oracle.com|87.248.199.23|:80… connected. HTTP request sent, awaiting response… 200 OK… Continue reading 11g release 1 patchset 1