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
Category: support
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
DITO
I never used Oracle Web Conference OWC, for security reason. Today I created one SR and read first time about Demo It To Oracle (DITO). This is basically a link CamStudio.org, which is a tool that records AVI file and converts AVI to flash SWF file. This is nice to have because you do need… Continue reading DITO
10.2.0.4 aix
I just noticed 10.2.0.4 is out. I started downloading 1,916,781 KB !
Software Configuration Manager
I just noticed today the Web 2.0 interface of metalink : The URL is http://csm.oracle.com, like Coftware Sonfiguration Manager (or maybe Configuration Software Manager). [edit: original name is: Configuration Support Manager] It seems nice, you can customize the portal with drag and drop, their is a blog too http://blogs.oracle.com/supportportal and a feedback button I am… Continue reading Software Configuration Manager
11g certification matrix
as of today, 24-AUG-2007, here is the certification matrix for Linux x86 OS Product Status SLES-10 11g Certified Red Hat Enterprise AS/ES 5 11g Certified Red Hat Enterprise AS/ES 4 11g Certified Oracle Enterprise Linux 5 11g Certified Oracle Enterprise Linux 4 11g Certified