Oracle DBA Tasks and Tools

Back to: Oracle DBA Tutorials

Oracle DBA Tasks and Tools

In this article, I am going to discuss Oracle DBA Tasks and Tools. Please read our previous article where we discussed Oracle Multitenant Architecture 12c/18c.

Common Oracle DBA Tasks:

1. Installing Oracle software
2. Creating Oracle databases
3. Performing upgrades of the database and software to new release levels
4. Starting and shutting down the database instance
5. Managing the storage structures of the database
6. Managing users and security
7. Managing database objects, such as tables, indexes, and views
8. Backing up the database and performing recovery operations when necessary
9. Monitoring the state of the database
10. Monitoring and tuning database performance
11. Refreshing the data according to the client’s requirement
12. Adding users, data files, and indexes to the database.
13. Granting required roles to users in order to perform their tasks.
14. Backup the Archive logs in order to restore the database once crashed.
15. Reporting critical errors to Oracle Support Services

Whenever you faced an error that is very critical and couldn’t be fixed then you can raise a ticket to Oracle support describing the issue and error you have faced according to the license to the database

Tools for Administrating the Oracle Database:

Oracle Universal Installer:

It is a utility that installs Oracle software and other options. It automatically starts the oracle database configuration assistant to install the database.

Oracle Database Configuration Assistant:

DBCA is a utility that creates a database from the templates that are supplied by Oracle. There are multiple options present in this tool like configuring an existing database, managing a pluggable database, and deleting a database.

Oracle Database Upgrade Assistant:

From the name itself, it indicates upgrading. DUA is used to upgrade the database from one release to another release.

Net Configuration Assistant:

It is a utility that is used to configure listener and naming methods which are the most important components to manage the Oracle database network.

Oracle Enterprise Manager Data Express:

It is the primary product that manages the database. It is a web-based interface that is very simple to use. You can see the below image this is the login portal we need to give a username and password and then after login you will get a graphical user interface where you can create users, assign privileges, monitor the database, and add tablespaces in a simple manner. This tool is so popular most DBA use this tool to manage their databases. This is also called OEM.

SQL Developer:

SQL Developer provides another GUI for accessing your Oracle database. SQL Developer supports development in both the SQL and PL/SQL languages. Most people think SQL Developer is only for SQL developers but it is used by DBAs as well. We can find Database differences between two databases, ERD diagrams, and many more. We will discuss this further.

Installation Methods And Operating System

Now, we are going to discuss installation methods and operating systems. There are two types of installation methods.

1. Desktop Class: This installation class is most appropriate for laptop or desktop computers. It includes a starter database and requires minimal configuration.
2. Server Class: This installation class is for servers, such as you would find in a data center, or used to support enterprise-level applications. The server needs advanced configurations. Choose this installation class if you need access to advanced configuration options.

Note: The operating system on the server or desktop could be (Windows, Linux, Unix,…) But we will be using Linux to install the oracle database.

In this course:

1. We will install Oracle VirtualBox
2. We will install the Oracle Linux operating system on the virtual machine
3. We will install Oracle Database 12 or 18 as Server Class

Why Linux?

1. Free and Open Source (not all Linux free)
2. Stability and Reliability
3. Security
4. Flexibility
5. Hardware Support

From the above features, we could see that Linux is better than windows hosting oracle database.

In Conclusion: Linux has today become a strategic, efficient, and reliable platform for business systems at many small, medium to big companies. A larger percentage of servers powering the Internet run on a Linux-based operating system.

What is Linux Distribution?

It is an operating system made from Linux. Many companies take the Linux operating system and make changes according to the company and publish the software. Below are some examples.

1. Red hat
2. CentOS
3. Fedora
4. Oracle Linux (commonly used for running oracle DB)
5. Ubuntu
6. And many others

In the next article, I am going to discuss Oracle Installation Steps. Here, in this article, I try to explain Oracle DBA Tasks and Tools and I hope you enjoy this Oracle DBA Tasks and Tools article.