top of page

Database Administration

Install Oracle 19c with ASM

In this article we would be looking at installing Oracle 19c with ASM on Linux. This will allow us to create 19c databases on ASM disks....

Oracle Flashback

Oracle flashback allows you to move database back in time. You can use flashback technology to move entire database or a particular table...

Oracle 12c Installation on Oracle Linux 7

In this article, we will be looking at Oracle 12cR2 installation on Oracle Linux 7.7 version. The steps are exactly same for OEL 6 and...

Oracle 12c Installation on Linux with ASM

In this article we will be looking at Oracle 12c release 2 installation on Oracle Linux 7.6 with ASM. If you already know, Oracle ASM...

Tablespace Administration

Administering Tablespace is one of the most important jobs of an Oracle DBA. It makes sure that database has enough space to accommodate...

Physical Oracle Database Limits

When you try to add data files or resize existing data files, you cannot go with any number in your mind. Oracle database has limitations...

Removing Deadlocks in Oracle

You locked row A, another session locked row B. Now, you want to lock row B but you are blocked by the other session. The other session...

Oracle 12c Multi-tenant Interview Questions

Interview questions specific to Oracle 12c Multi-tenant architecture. Enjoy! Q. What are the major changes in architecture for 12c? From...

Oracle 11g to 12c Rolling Upgrade

A rolling upgrade allows you to perform database upgrade without having any noticeable downtime to the end users. There are multiple ways...

Downloading Oracle 12c Using Linux wget

When you are working on a Linux server, you do not need to use tools like WINSCP or other file sharing software. You can simply use wget...

Oracle 11g Silent Install

In this article we will be looking at Oracle 11g silent mode installation (without using the GUI method). Create Response File...

Oracle 11g installation on OEL 6.5

Hi guys, in this article I will show you how to install Oracle 11g software on Oracle Enterprise Linux 6.5. Pre-Install Steps OS...

bottom of page