Oracle out of place patching reduces database downtime

February 12, 2016 by 2 Comments 

To minimize downtime during patching of NON-RAC databases Out of Place Patching can be used. You can apply this approach to any Oracle patch starting from Oracle database 11g (11.2.0.2.0+) using OPatch utility. In this case time spent installing the software can be saved from the total database downtime required. However, some downtime is required for switching database services to the new Oracle database home and applying a post-upgrade script. A basic overview of the steps is below:

– Clone the existing database home online
– Apply required patch to the cloned database home using OPatch
– Switch the database services to the cloned database home
– Complete the post installation tasks for the patch applied

Notes:
– Oracle database 11g and 12c documentation describe DB_HOME cloning only in OFFLINE mode (when DB is down)
http://docs.oracle.com/cd/E11882_01/em.112/e12255/oui6_cloning.htm#OUICG298
http://docs.oracle.com/database/121/LADBI/app_cloning.htm#LADBI7853

– However, there should be no requirement to shutdown any databases, listeners, agents etc. that are running from the source home while cloning the Oracle Home directory because any processes that load the static binaries or libraries into memory should not hold a write lock.

– Oracle Out of Place patching is supported by SAP

– Out of Place patching is a recommended patching method that is used in out of the box deployment procedure of Oracle Enterprise Manager (OEM) Cloud Control 12c+ version

Oracle 12c database Out of Place patching reduce downtime

Oracle database Out of Place patching

Below we will use a combination of Oracle documentation, a few MOS Notes and a little bit of experience to manually conduct Out of Place patching of Oracle database 12c
Read more »

Oracle database client silent installation without response file

March 6, 2015 by 4 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 »

How to install Oracle 11gR2 64-bit client on Windows 7

March 22, 2013 by 10 Comments 

Installation of Oracle 11gR2 64-bit client on Windows 7 is even trickier compared to Oracle 32-bit client installation. In fact after some series of installations, I do recommend installing Oracle client 32-bit on Windows 7 64-bit version, unless you have solid technical restrictions of that. This will avoid various installation issues as well as some client software incompatibility issues. I give however below a short installation plan for Oracle 11gR2 64-bit client with possible issues you can encounter during and after it. Read also my other article for some more tips on that: Oracle 11gR2 client installation on Windows 7 troubleshooting.
Read more »

Oracle 12c Pluggable Database (PDB) – SQL code examples

March 15, 2013 by 4 Comments 

Oracle database 12c is still not there and last time I predicted it will be released in March. Let’s see if Oracle can fix all the release issues and provide the nice and clean new major database release 12c that will greatly help enterprises in their consolidation strategies and enable them building Private Database Clouds.

With this I’ll continue my series of articles on Oracle 12c Pluggable Database (PDB) feature including SQL code.  I strongly recommend first reading my previous articles on this topic to understand the rest of the material:

Oracle 12c Pluggable Database is a fundamental architectural change
Oracle 12c Pluggable Database feature insights
Oracle 12c Pluggable Database (PDB) feature hands-on experience
Oracle 12c Pluggable Database – Plug Unplug and Clone
Oracle 12c Pluggable Database (PDB) – FAQ

This time I focus on a few interesting SQL code examples. I’ll show how to create lots of empty PDBs programmatically from scratch and from the Gold images, how to open all Pluggable Databases (PDBs) automatically after CDB startup as well as to drop all PDBs. Once again I’d like to mention that the below code should work on Oracle database 12.1 Beta2. So let’s move on. Read more »

Oracle 12c Pluggable Database (PDB) – FAQ

March 4, 2013 by 10 Comments 

Let’s continue my series of articles on Oracle 12c Pluggable Database feature including SQL code.  I strongly recommend first reading my previous articles on this topic to understand the rest of the material:
Oracle 12c Pluggable Database is a fundamental architectural change
Oracle 12c Pluggable Database feature insights
Oracle 12c Pluggable Database (PDB) feature hands-on experience
Oracle 12c Pluggable Database – Plug Unplug and Clone

Oracle 12c Pluggable Database Point-In-Time recovery

Oracle 12c Pluggable Database Point-In-Time recovery

There are several questions on Oracle 12c Pluggable Database feature came up on my presentation at the German Oracle User Group (DOAG) regional meeting and from other users. Some of them I’ll clarify in this article. Read more »

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