Oracle patch prerequisite check OPatch OEM MOS

January 19, 2016 by Leave a comment 

Oracle database patching is one of the most frequently executed maintenance activities that every DBA does in his life. The task is fairly simple and straight forward using the patch instructions from My Oracle Support (MOS). However in this article I’d like to highlight the importance of different Patch Prerequisite Checks that you have to perform before doing the patching itself. I think the entire success of patching exercise depends mostly on this step as seen on the below table that represents major PSU patching steps and approximate time lines. The rest of this draft document describes some best practices, tips and code examples for doing patch prerequisite checks using OEM Cloud Control, MOS and OPatch utility. Comments, adjustments, other tips and ideas are welcome and will be included in this post.

Oracle DB PSU patching steps

Oracle database PSU patching steps

Read more »

Oracle database client silent installation without response file

March 6, 2015 by 6 Comments 

I’m often asked questions on Oracle database or client software installation in Silent Mode with using response file. I used to do it in the past but not anymore. The silent software installation with Oracle response file is still available but I found another handy option in Oracle 11g/12c of doing the same. The same silent installation can be done directly from the command prompt without using an Oracle response file but it requires a minimum set of variables (from the response file) as arguments to the Oracle Universal Installer (OUI) (i.e “runInstaller or setup.exe”).

I give a few tested examples below to install Oracle software in Silent mode without a response file:

Oracle Database 11.2 on Linux silent installation (Enterprise Edition Software Only)

cd /opt/oracle/stage/database
./runInstaller -silent -debug -force \ Read more »

From my PC to Oracle remote database at DOAG 2014

November 17, 2014 by 1 Comment 

DOAG2014 Kirill Loifman is a conference speakerI’ll be speaking at German Oracle User Group (DOAG) Conference 2014 this week. The database related presentation with following title will be held in English:

Live adventure – from my PC to Oracle Remote Database

Official Abstract:
Best practices and live demo on remote database connection techniques including remote database connection setup, troubleshooting and undocumented tricks. Together with the audience we bypass a firewall, establish SSH RSA server authentication and receive DB access without an obvious user. Connect without passwords to any server this is our final goal!

Timelines and location: 19.11.2014 12:00, room Seoul

During my presentation in the interesting manner of a live demo I’ll try to explore how a trivial topic of Oracle database connection can have so many problematic areas in terms of  security, troubleshooting and user usability.

See the relevant documents below:
– Presentation: Live adventure – From my PC to Oracle remote database
– Demos: on DaDBMan YouTube channel

In case of questions please use comments below in this post.

Looking forward to seeing you all at CCN East, Nuremberg Trade Fair, 18th-20th November 2014!

..Oh yes, one more thing I forgot. In scope of the conference I was interviewed with a few questions by a DOAG representative. It was great to see myself with that interview in the DOAG Conference brochure together with the other big names of Oracle community. You can read it here in German: Die Datenbank hacken

What is Oracle database (RDBMS)?

October 10, 2014 by Leave a comment 

Oracle Database Server or sometimes called Oracle RDBMS or even simply Oracle is a world leading relational database management system produced by Oracle Corporation.

Oracle foundation

The company was founded in 1977 by Lawrence Ellison, Bob Miner and Ed Oates with initial capital of 1400 US Dollars. At the beginning the company was called Software Development Laboratories (SDL), later Relational Software, Inc. And only in 1983 the name was changed to Oracle Corporation in favour of its most successful product Oracle RDBMS (at that time there was already database version 3).

Why Oracle?

The name Oracle comes from the code name of a CIA project where Larry Ellison worked. After some time the project was stopped,  then Larry decided to start his own business using obviously similar name.

The origin of RDBMS idea

The idea about a relational database came to Ellison in 1972 from an article of Edgar Codd who worked in research laboratory of IBM at that time. The management of IBM did not realize a commercial benefit of such software at that time. In return, Oracle took an advantage of that idea and was the first company who presented the first commercially usable product on the market.

Roadmap of Oracle Database

First RDBMS version released in 1979 was called Oracle V2. Why not V1? Read more »

Roadmap of Oracle Database releases

September 12, 2014 by 6 Comments 

[Updated in October 2017]

Oracle was, is and will be probably the first in most of RDBMS innovations. Over the last 35 years Oracle went through successful database release schedule. To help planning the company IT projects I give the below road-map of the latest Oracle Database major releases 11.2 and beyond, showing planned release dates and the duration of their support lives. The release and timing of any platforms are subject to change at any time and at Oracle’s sole discretion. (see the latest status in MOS Doc ID 742060.1 or below as last updated on Oct-2017)

Oracle database roadmap

Oracle database roadmap [updated in October 2017]

Patching end dates for the latest release/patch levels

Release Patching Ends Notes and Exceptions*
12.1.0.2 31-Jul-2021 Extended Support fees waived through July 31, 2019
12.1.0.1 31-Aug-2016 Patching has ended for this release.
11.2.0.4 31-Dec-2020
Extended Support fees waived until Dec 31, 2018.

Oracle Major releases – Designated by the 2nd place in the version number (e.g. 11.2.0.x) and shown as the wider red bar in the Roadmap.

—> Starting from Oracle 12.2 Oracle uses a new patching concept based on RUs RURs patches.

—> Before Oracle release 12.2 following patching concept applies:

– Oracle Patch sets – Designated by the 4th place in the version number (e.g. 11.2.0.2), and shown by the narrower green bars below their associated major release. Patchsets are released on different platforms over time started usually from Linux.
– Patch Set Updates (PSU) and Critical Patch Updates (CPU) – (not listed separately on the Roadmap) they are released every quarter for supported patch sets and designated by the 5th place in the version number (e.g. 11.2.0.2.2).

Oracle historical release road map

2018: Oracle 18c expected to be released (based on OOW 2017 announcement)
– First fully autonomous database

2017: Oracle 12cR2 (12.2) 

2014 – 12.1.0.2

– Oracle Database In-Memory Read more »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email