1- Evaluate the Database Server Hardware:

Evaluate the servers on which Oracle databases will be installed so that the best possible use of the resources available on the server is made. This includes evaluating the available storage spaces and the memory available for the Oracle Instances and processors.

2- Install the Oracle Database Software:

One of the tasks of the database administrator is to install the Oracle Database Software on the servers and sometimes install the Oracle Net Components on the clients to enable communication with the database servers and other tools that connect to the database.

3- Plan the Database:

As a database administrator, you must plan the logical storage structure and the general design of the database and develop a backup strategy.

It is important to plan how the logical storage structure of the database will be because it affects the performance of the system and the various database management processes. For example, before creating any Tablespaces in the database, you must know how many Data files will be in the Tablespace, what type of data should be stored in each Tablespace, and where the Data Files are created and stored physically. You must also consider the impact of storing data logically on the operation of the database system, as well as the impact of backup operations on the flow of operations in the database and servers. You must also plan during the design of databases and the relationships of the various objects on the databases and between storing them physically.

4- Create and Open the Database:

After completing the planning and design of the database, the database can be created and opened for use. It can be created during the installation of Oracle Software by performing Database Configuration Assistant (DBCA) or created manually via Script.

5- Backup the Database:

After creating the database, a backup copy of the database must be made based on the plan you have set to recover the database in the event of a problem.

6- Enroll System Users:

Creating users in the database and granting them the required permissions is one of the most important tasks of the database administrator.

7- Implement the Database Design:

After creating the database, creating users and granting them the required permissions, the database administrator can implement the logical database structure plan by creating the necessary Tablespaces and also creating Database Objects.

8- Tune Database Performance:

Improving database performance is one of the most important tasks of the database administrator, as the Oracle database provides the feature of managing database resources, which helps control the distribution of resources among different user groups.

9- Download and Install Release Updates and Patches:

After installing the database, the database administrator can download and install updates and Patches.

Starting with Oracle 18c, Oracle has started providing quarterly updates and no longer issues Patches. The database administrator can visit the Oracle support site and search for the required updates for the database.

10- Roll Out to Additional Hosts:

After installing the Oracle Software and creating and configuring the database, you can Clone the Oracle Database Installation to other servers without installing the Oracle Software again and without creating and configuring the database again, which saves you a lot of time and effort.

In many cases, you need to make a copy for development and testing according to the operational version, and you may also need to make several operational copies. Instead of repeating the installation of the Oracle software and creating the database several times, you can do one of the two options:

Cloning an Oracle home

Cloning a database