Blog Posts

Connect to Oracle database with Python

Python and Oracle

Why is Python important for Oracle DBAs these days? Traditionally, Bash and Perl are two most languages chosen by Oracle DBAs for scripting in operating systems. However, these days Python has changed the game. Python is flexible and there are many developed libraries available to work with.  All modern Unix and Linux systems come with Python on board; for example, Oracle Linux 6.1 ships with Python 2.6.6. Besides, since Oracle Autonomous came, DBAs’ roles have changed. Thus, learning Python and

Continue Reading

Configuring Oracle AFD After Installation

Configuring Oracle AFD after Installation

Configuring Oracle AFD after Installation   Purpose of this post is to investigate on configuring Oracle AFD after Installation. for more information regarding Oracle AFD fundamentals and migrating to Oracle ASMLIB From AFD please visit links below: Introducing  Oracle AFD Migrating to Oracle ASMLIB From AFD Let me show you how to configure Oracle AFD after Installation within a scenario: Existing setup: Before start configuring Oracle AFD after Installation we check existing setup: [crayon-662ddef653fd2064706532/] start configuring Oracle AFD As you saw in

Continue Reading

Migrating to Oracle ASMLIB from AFD

Migrating to Oracle ASMLIB from AFD

Migrating to Oracle ASMLIB from AFD Why if you do not like to use AFD? You could follow instructions below to come back to our old love, ASMLIB. Although it is possible to migrate to Oracle ASMLIB from AFD, as I mentioned in the Introducing Oracle AFD, Oracle AFD is the superset of the ASMLIB, and it is better to use Oracle AFD. Configuring Oracle AFD after Installation could reverse this migration. Let me show you how to migrate Oracle

Continue Reading

Oracle AFD

Oracle AFD

Introducing Oracle AFD Before Oracle grid infrastructure 12c, the only method to access ASM disks was ASLIB. With the start of GI 12c (12.1.0.2), Oracle Introduced Oracle AFD (ASM Filter Driver). Oracle AFD has been come to cover weaknesses of the ASMLIB. You could find some of the benefits using AFD (ASM Filter Driver) as below: Rejection of non-Oracle I/Os. Oracle Automatic Storage Management Filter Driver (Oracle AFD) rejects write I/O requests that are not issued by Oracle software. This filter

Continue Reading

How to unplug PDB, recover a XML description file and plug a PDB to another CDB

uplug_plug

Two of the best key features of the multitenant container databases are unplugging PDB from CDB and plugging PDB to the same or another CDB respectively. Let me explain how the unplugging actually works: There are two methods for unplugging PDB from CDB. The first and the older method which has been introduced in Oracle database 12.1 is unplugging PDB from the XML description file and the newer method that has been introduced in Oracle database 12.2 is unplugging PDB

Continue Reading

The simplest way to migrate Oracle database 11g to pluggable database 12c

11g to 12c

Hello guys I had many questions from my clients regarding ‘what is the simplest way to migrate Oracle database 11g to Pluggable database 12c’. I should say that this article is focused on the simplest way, not necessarily the best way or the lowest-cost way. so keep reading to show you within a scenario. Existing setup: [crayon-662ddef654e8f610172947/] migrate Oracle database 11g to pluggable database 12c: In the source host and database(11g): Let’s assume the business needs all objects belonging to

Continue Reading