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.
The 28th edition of DOAG 2015 annual Conference + Exhibition was held November 17 – 20, 2015 in Nuremberg Conference Center. Participants had the opportunity to attend the exibition and daily lecture programs with more than 500 talks and international top speakers, plus a wide choice of workshops, and community activities.
Interseting key notes including one with Andrew Mendelsohn, Executive Senior Vice President at Oracle, who shared the information about new developments in Oracle database 12c.
This was a great opportunity for everyone to expand the knowledge and benefit from the know-how of the Oracle community.
Thanks for all the organizers and participants.
I was speaking there also with a database related topic called:
Official Abstract of my DOAG presentation:
How to design an Oracle database system to minimize planned interruptions? That depends on the requirements, goals, SLAs etc. The presentation will follow top-down approach. First we will describe major types of planned maintenance, prioritize those and then based on the system availability requirements find the best cost-effective technics to address those. A bit of planning, strategy and of course modern OS and database technics including latest Oracle 12c features will follow.
Timelines and location: Thursday, 2015-11-19, room Shanghai
The presentation consists of 3 major parts including Linux and SQL code examples:
– System downtimes and high availability basics
– Reducing planned downtime approach and methodology
– Technical part: system configurations, technics, new Oracle 12c features
See the slightly adjusted presentation material below:
– Presentation: Reduce planned database down time with Oracle technology
– Scripts: will follow
Please share your ideas, expririence or ask questions in the Comments to this post below.
You can also review my previouse DOAG 2014 presentation including live demo: Live adventure – From my PC to Oracle remote database
Some a few photos below… Read more »
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)
./runInstaller -silent -debug -force \ Read more »
I’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:
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
Oracle Database Server or sometimes called Oracle RDBMS or even simply Oracle is a world leading relational database management system produced by Oracle Corporation.
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).
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 »