Database Administration

Oracle 21c Installation on Linux

Oracle 21c is an innovation release that provides early insights to latest developments and features.

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 allows you to move database back in time. You can use flashback technology to move entire database or a particular table...

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...

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...

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

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...

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...

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

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

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...

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